"""
SQLSTATE[42000]: Syntax error or access violation: 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 ') AND t1.id = t3.productid AND t3.country_code = t4.code AND t7.productid = t1.i' at line 2 (SQL: SELECT COUNT(DISTINCT(t1.code)) as total FROM fa.product t1, fa.country_product t3,\n
    fa.country t4, fa.category t5, fa.category t6, fa.product_category t7, fa.country_category t8  WHERE LOWER(t4.code) LIKE %us% AND t3.isactive = 1 AND t1.isaddon = 0 AND t1.id IN () AND t1.id = t3.productid AND t3.country_code = t4.code AND t7.productid = t1.id AND t7.categoryid = t5.id AND t5.parentid = t6.id AND t8.categoryid = t7.categoryid AND t8.country_code = t3.country_code AND t1.isactive = 1 AND t1.code NOT IN ('IV429', 'FA99999')  )
"""