Error

Error



Database reported: 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 ') LEFT JOIN osc_specials s on p.products_id = s.products_id and s.status = 1 JOI' at line 3 (Errno: 1064)

Failed query: select count(p.products_id) as total from osc_products p JOIN osc_products_to_products_extra_fields f6 ON f6.products_id = p.products_id AND f6.products_extra_fields_id = '6' AND f6.products_extra_fields_value IN () LEFT JOIN osc_specials s on p.products_id = s.products_id and s.status = 1 JOIN osc_products_to_products_extra_fields field ON field.products_id = p.products_id AND field.products_extra_fields_value = '327' AND field.products_extra_fields_id = '9' where p.exclude_from_main_nav='0' and p.products_inline='1'