1. Solamente vendemos por Internet.

  2. Si desea comprar más de una unidad debe consultarnos: 93 451 54 44

  3. Al formular un pedido el comprador deberá telefonearnos al 93 451 54 44.

  4. En el caso de que el comprador no nos haya telefoneado, si hay algún inconveniente, como pérdida de un paquete, quedará bajo la responsabilidad del comprador.

LIBANO

1021 Disk full (/tmp/#sql-temptable-44b-9339b7-3d90d.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
in:
[select p.products_image, pd.products_name, p.products_quantity, IF (LEFT(pd.products_name, 1)="<", RIGHT(pd.products_name, LENGTH( pd.products_name) - LOCATE(">", pd.products_name)), pd.products_name) AS products_name_stripped, p.products_id, p.products_type, p.master_categories_id, p.manufacturers_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status =1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '1036' order by p.products_sort_order, products_name_stripped]