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 '-13' 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,-13 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)


Chicken adult – large - DISUGUAL DRY FOOD FOR DOGS – 12 KG

Chicken adult – large - DISUGUAL DRY FOOD FOR DOGS – 12 KG

ALIMENTO COMPLETO MONOPROTEICODISUGUAL - POLLO ADULT LARGEPezzature disponibili: 2 kg - 12 kgDESCRIZ..

39.80 CHF 49.80 CHF IVA escl.: 38.85 CHF

Chicken adult – small - DISUGUAL DRY FOOD FOR DOGS – 12 KG

Chicken adult – small - DISUGUAL DRY FOOD FOR DOGS – 12 KG

ALIMENTO COMPLETO MONOPROTEICODISUGUAL - POLLO ADULT SMALLPezzature disponibili: 2 kgDESCRIZIONEAlim..

39.80 CHF 49.80 CHF IVA escl.: 38.85 CHF

Chicken adult- medium - DISUGUAL DRY FOOD FOR DOGS – 12 KG

Chicken adult- medium - DISUGUAL DRY FOOD FOR DOGS – 12 KG

ALIMENTO COMPLETO MONOPROTEICODISUGUAL - POLLO ADULT MEDIUMPezzature disponibili: 2 kg - 12 kgDESCRI..

39.80 CHF 49.80 CHF IVA escl.: 38.85 CHF

Diamond Natural Dog Food Chicken 5 kg

Diamond Natural Dog Food Chicken 5 kg

DIAMOND Adult Pollo è un alimento completo con il 70 % di carne di pollo fresca, senza glutine.Grazi..

25.00 CHF 34.95 CHF IVA escl.: 24.35 CHF

Diamond Natural Dog Food Lamb & Rice 5 kg

Diamond Natural Dog Food Lamb & Rice 5 kg

DIAMOND Adult Agello è un alimento completo con il 70 % di carne d’agnello fresca, senza glutine.&nb..

25.00 CHF 34.95 CHF IVA escl.: 24.35 CHF

Iso-dog Balance Lamb & Rice 12.5 kg

Iso-dog Balance Lamb & Rice 12.5 kg

Iso-dog Balance Lamb & Rice All Breeds est un aliment complet recommandé pour les chiens sensibl..

55.65 CHF 79.50 CHF IVA escl.: 54.25 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. 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

Gambrinus extra large large : 100% di maxi gamberetti

Gambrinus extra large large : 100% di maxi gamberetti

Mangime semplice per tartarughe.Mangime semplice di origine animale per tartarughe acquatiche. Gambr..

3.00 CHF 9.05 CHF IVA escl.: 2.90 CHF

Risultati 1 a 12 di 885 Articoli (74 Pagine)