Database error: Invalid SQL: SELECT count(distinct lynx_product.product_id) as num_rows FROM lynx_product_category_xref, lynx_category, lynx_webshop_publish, lynx_webshop_publish_cat,lynx_product left join lynx_product_trans on lynx_product.product_id = lynx_product_trans.prod_id and lynx_product_trans.lang = 'fr' WHERE lynx_product.product_id=lynx_product_category_xref.product_id AND lynx_category.category_id=lynx_product_category_xref.category_id AND lynx_product.product_id=lynx_webshop_publish.product_id AND lynx_webshop_publish.shop_id='1' AND lynx_product.product_parent_id='0' AND lynx_category.category_publish = 'Y' AND lynx_category.category_id=lynx_webshop_publish_cat.category_id AND lynx_webshop_publish_cat.shop_id = 1 AND lynx_product.product_id not in ('-999','867','1815','1939','2201','2530','2531','3093','4057','4058','4328','4555','4556','4776','4778','4880','6275','6273','6248','6323','6878') AND lynx_product.product_publish = 'Y' AND (lynx_product.product_id in (-999) or lynx_category.category_id in ())
MySQL Error: 1064 (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 '))' at line 1)
|
