Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-10' at line 1
Error No: 1064
SELECT p.product_id as product_id, p.sort_order as sort_order, LCASE(pd.name) as name, p.model as model, (SELECT AVG(rating) FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM oc_category_discount dm LEFT JOIN oc_product_to_category ptc ON (ptc.category_id = dm.category_id) LEFT JOIN oc_product p ON (ptc.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id) WHERE p.status = '1' AND dm.status = '1' AND p.date_available <= NOW() AND ps.product_id IS NULL AND dm.qty <= '1' AND p2s.store_id = '0' AND dm.customer_group_id = '1' AND ((dm.date_start = '0000-00-00' OR dm.date_start < NOW()) AND (dm.date_end = '0000-00-00' OR dm.date_end > NOW())) GROUP BY p.product_id UNION SELECT p.product_id as product_id, p.sort_order as sort_order, LCASE(pd.name) as name, p.model as model, (SELECT AVG(rating) FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM oc_manufacturer_discount dm LEFT JOIN oc_product p ON (dm.manufacturer_id = p.manufacturer_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_special ps ON (p.product_id = ps.product_id) WHERE p.status = '1' AND dm.status = '1' AND p.date_available <= NOW() AND ps.product_id IS NULL AND dm.qty <= '1' AND p2s.store_id = '0' AND dm.customer_group_id = '1' AND ((dm.date_start = '0000-00-00' OR dm.date_start < NOW()) AND (dm.date_end = '0000-00-00' OR dm.date_end > NOW())) GROUP BY p.product_id ORDER BY sort_order ASC, name ASC LIMIT 0,-10 in /home/h6281744/public_html/system/library/db/mysqli.php on line 41Notice: Trying to get property of non-object in /home/h6281744/public_html/catalog/model/catalog/discount.php on line 133Warning: Invalid argument supplied for foreach() in /home/h6281744/public_html/catalog/model/catalog/discount.php on line 133 Offerte Speciali

Offerte Speciali

Comparazione prodotto (0)


Lamb adult – medium - DISUGUAL DRY FOOD FOR DOGS – 2 KG

Lamb adult – medium - DISUGUAL DRY FOOD FOR DOGS – 2 KG

ALIMENTO COMPLETO MONOPROTEICODISUGUAL - AGNELLO ADULT MEDIUMPezzature disponibili: 2 kg - 12 kgDESC..

8.40 CHF 13.95 CHF IVA escl.: 8.15 CHF

Ochsen-Sticks 15 cm, 1 kg

Ochsen-Sticks 15 cm, 1 kg

Cette délicatesse très appréciée nettoie les dents et renforce les muscles masticateurs. Très peu de..

42.00 CHF 52.45 CHF IVA escl.: 40.95 CHF

Ochsen-Sticks 15 cm, 500 g

Ochsen-Sticks 15 cm, 500 g

Cette délicatesse très appréciée nettoie les dents et renforce les muscles masticateurs. Très peu de..

19.90 CHF 24.90 CHF IVA escl.: 19.40 CHF

Ochsen-Sticks 30 cm, 1 kg

Ochsen-Sticks 30 cm, 1 kg

Cette délicatesse très appréciée nettoie les dents et renforce les muscles masticateurs. Très peu de..

42.00 CHF 52.45 CHF IVA escl.: 40.95 CHF

Rifi-Sticks 500 g

Rifi-Sticks 500 g

Délicatesse de viande de boeuf. Apprécié par les grands et petits chiens ! Compositio..

23.90 CHF 29.85 CHF IVA escl.: 23.30 CHF

CAR BOX ALU TRANSP. CAR BOX GRIGIO CM 100x60x65

CAR BOX ALU TRANSP. CAR BOX GRIGIO CM 100x60x65

Il trasportino CAR BOX è stato studiato per offrire il massimo confort al cane e trovare il proprio ..

126.65 CHF 159.95 CHF IVA escl.: 117.60 CHF

CAR BOX ALU TRANSP. Trixie T39342, 63x65x90cm

CAR BOX ALU TRANSP. Trixie T39342, 63x65x90cm

con struttura in alluminiomolto resistente, sicuro e silenziosoi pannelli alti e compatti assicurano..

244.25 CHF 349.00 CHF IVA escl.: 226.80 CHF

Life Dog  Chicken with duck in orange 95 gr

Life Dog Chicken with duck in orange 95 gr

Bocconcini fatti con vera carne magra di anatra e petto di pollo, con aggiunta di: succo di aranc..

1.65 CHF 2.10 CHF IVA escl.: 1.60 CHF

Life Dog  Livers with vegetables 95 gr

Life Dog Livers with vegetables 95 gr

Fegatini di pollo preparati secondo una ricetta ricca di&nbs..

1.65 CHF 2.10 CHF IVA escl.: 1.60 CHF

Life Dog beef chunks with vegetables 95 gr.

Life Dog beef chunks with vegetables 95 gr.

Bocconcini di vera carne di manzo, con aggiunta di carote&nb..

1.65 CHF 2.10 CHF IVA escl.: 1.60 CHF

Life Dog Chicken primavera 95 gr

Life Dog Chicken primavera 95 gr

Vero petto di pollo preparato in stile «primavera», con aggiunta ..

1.65 CHF 2.10 CHF IVA escl.: 1.60 CHF

Life Dog Chicken provencale 95 gr

Life Dog Chicken provencale 95 gr

Petto di pollo preparato in vero stile provenzale, con aggiu..

1.65 CHF 2.10 CHF IVA escl.: 1.60 CHF

Risultati 1 a 12 di 551 Articoli (46 Pagine)