Chybová zpráva: 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 ')
AND p.is_visible=1 AND p.year='2007'
OR' at line 8
Soubor: /data/web/virtuals/cykloprag.cz/www/skripty/products.php
Řádek: 136
Kód chyby: 1064
Chybný SQL doatz:
SELECT DISTINCT pb.product_id, p.*, pl.file, pc.title AS categ_title, pc.text, ps.title AS supp_title, pi.ending FROM products_subtitutes pb
JOIN products p ON p.product_id=pb.product_id
JOIN products_category pc ON pc.category_id=p.category_id
JOIN products_suppliers_set pss ON pss.product_id=p.product_id
JOIN products_suppliers ps ON ps.supplier_id=pss.supplier_id
LEFT JOIN products_images pi ON pi.product_id=p.product_id
LEFT JOIN products_labels pl ON pl.label_id=p.label_id
WHERE pb.category_id IN ()
AND p.is_visible=1 AND p.year='2007'
ORDER BY year DESC
Soubor: /data/web/virtuals/cykloprag.cz/www/skripty/products.php
Řádek: 136
Kód chyby: 1064
Chybný SQL doatz:
SELECT DISTINCT pb.product_id, p.*, pl.file, pc.title AS categ_title, pc.text, ps.title AS supp_title, pi.ending FROM products_subtitutes pb
JOIN products p ON p.product_id=pb.product_id
JOIN products_category pc ON pc.category_id=p.category_id
JOIN products_suppliers_set pss ON pss.product_id=p.product_id
JOIN products_suppliers ps ON ps.supplier_id=pss.supplier_id
LEFT JOIN products_images pi ON pi.product_id=p.product_id
LEFT JOIN products_labels pl ON pl.label_id=p.label_id
WHERE pb.category_id IN ()
AND p.is_visible=1 AND p.year='2007'
ORDER BY year DESC