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,3335,3087,3088,2560,2561,922,3220,3257,3572,195,42,2294,44,664,1092,573,2762,3282,3364,3303,924,1091,98,398,877,497,923,1849,690,669,757,168,423,880,927,1063,150,581,370,1068,1066,1873,2015,250,1144,362,3093,1035,93,445,399,496,894,230,3643,80,879,3390,670,878,1537,1442,584,110,378,1458,1459,1142,1033,385,3092,406,340,761,881,207,676,2818,127,1457,499,692,691,500,1064,405,1062,577,382,455,1163,3591,3593,1067,3528,3392,2421,1065,1847,3581,2598,3552) 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)
|
