Products meeting the search criteria Products meeting the search criteria
Displaying 1 to 2 (of 2 products)  

How to add a product in the shopping cart: Choose an article and click on this icon

 
Another way of shopping more than one item is to indicate the number of copies of each product that you want to purchase.in the box located over the basket icon.and click on the icon Add to the cart located at the bottom of the page
Add to Cart

Warning: mssql_query(): message: El prefijo de columna 'fts' no coincide con un nombre de tabla o con un alias usado en la consulta. (severity 16) in c:\inetpub\wwwroot\components\com_commerce\catalog\includes\functions\database.php on line 55

Warning: mssql_query(): Query failed in c:\inetpub\wwwroot\components\com_commerce\catalog\includes\functions\database.php on line 55
El prefijo de columna 'fts' no coincide con un nombre de tabla o con un alias usado en la consulta. - El prefijo de columna 'fts' no coincide con un nombre de tabla o con un alias usado en la consulta.

select top 10 p.nidtipo,p.products_isbn, p.products_authors, p.products_year, p.products_edition, p.products_pages, p.products_format, m.manufacturers_name, p.products_model, p.products_name, p.products_quantity, p.products_image, p.products_weight, p.products_idiomadescripcion, p.products_soportedescripcion, p.products_ean, p.nidoferta, p.fpreciooriginal, p.cisbnbase10, p.cisbnbase, p.cisbn10, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id from products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id inner join cat_autores_libros at (nolock) on at.nidlibro = p.products_id where p.products_status = '1' and (at.nidautor = 120631) group by isnull(fts.nidtabla, 10),p.nidtipo,p.products_isbn, p.products_authors, p.products_year, p.products_edition, p.products_pages, p.products_format, m.manufacturers_name, p.products_model, p.products_name, p.products_quantity, p.products_image, p.products_weight, p.products_idiomadescripcion, p.products_soportedescripcion, p.products_ean, p.nidoferta, p.fpreciooriginal, p.cisbnbase10, p.cisbnbase, p.cisbn10, p.products_id, p.manufacturers_id, p.products_price, p.products_tax_class_id order by p.products_price , p.products_name

[TEP STOP]