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


BHN French Bulldog 9kg

BHN French Bulldog 9kg

French Bulldog AdultAlimento completo per cani Bouledogue francese adulti e maturi - Oltre 12 mesi d..

49.00 CHF 83.80 CHF IVA escl.: 47.80 CHF

BHN German Shepherd 11kg

BHN German Shepherd 11kg

German Shepherd AdultAlimento completo per cani Pastore Tedesco adulti e maturi - Oltre 15 mesi di e..

53.00 CHF 89.90 CHF IVA escl.: 51.70 CHF

BHN Golden Retriever 12kg

BHN Golden Retriever 12kg

Golden Retriever AdultAlimento completo per cani Golden Retriever adulti e maturi - Oltre 15 mesi di..

58.00 CHF 98.40 CHF IVA escl.: 56.55 CHF

BHN Labrador 12kg

BHN Labrador 12kg

Labrador Retriever AdultAlimento completo per cani Labrador Retriever adulti - Oltre 15 mesi di etàI..

48.00 CHF 98.40 CHF IVA escl.: 46.80 CHF

FBN Maine Coon 10kg

FBN Maine Coon 10kg

Maine CoonAlimento completo ed equilibrato per gatti adulti - Speciale gatti Maine Coon - Oltre 15 m..

68.00 CHF 114.80 CHF IVA escl.: 66.30 CHF

FHN Ageing 12+ 4kg

FHN Ageing 12+ 4kg

Ageing +12Balanced and complete feedFor senior cats over 12 years oldHEALTHY AGEING COMPLEXSupports ..

36.00 CHF 60.50 CHF IVA escl.: 35.10 CHF

FHN Fit 4kg

FHN Fit 4kg

Fit 32Balanced and complete feed for adult cats over 1 year oldModerate activity, access to the outd..

29.00 CHF 49.85 CHF IVA escl.: 28.25 CHF

FHN Outdoor 4kg

FHN Outdoor 4kg

Outdoor.For active outdoor cats (aged 1-7 years old) that may need a higher calorie intake to mainta..

32.00 CHF 54.10 CHF IVA escl.: 31.20 CHF

FHN Sensible 10kg

FHN Sensible 10kg

Sensible 33Balanced and complete feed for adult cats over 1 year oldDigestive sensitivityOPTIMAL DIG..

56.00 CHF 96.45 CHF IVA escl.: 54.60 CHF

FHN Sensible 4kg

FHN Sensible 4kg

Sensible 33Balanced and complete feed for adult cats over 1 year oldDigestive sensitivityOPTIMAL DIG..

31.00 CHF 53.25 CHF IVA escl.: 30.20 CHF

FHN Steril. Appetite Ctrl. 4kg

FHN Steril. Appetite Ctrl. 4kg

FHSterilised AppetiteAlimento completo ed equilibrato per gatti adulti sterilizzati (da 1 a 7 anni d..

32.00 CHF 54.60 CHF IVA escl.: 31.20 CHF

FHN Sterilised 4kg

FHN Sterilised 4kg

Sterilised 37Alimento completo ed equilibrato per gatti adulti sterilizzati di oltre 1 anno di età, ..

32.00 CHF 54.60 CHF IVA escl.: 31.20 CHF

Risultati 1 a 12 di 462 Articoli (39 Pagine)