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 'ERROR: SELECT COUNT(DISTINCT p.productID) FROM ?#PRODUCTS_TABLE p where catego' at line 1 SQL query : ERROR: SELECT COUNT(DISTINCT p.productID) FROM ?#PRODUCTS_TABLE p where categoryID>1 and enabled=1 and ( LOWER(name) LIKE '%prestigio%' OR LOWER(product_code) LIKE '%prestigio%' OR LOWER(mas_id) LIKE '%prestigio%' OR LOWER(nametype) LIKE '%prestigio%' OR LOWER(comp) LIKE '%prestigio%' OR LOWER(contry) LIKE '%prestigio%' OR LOWER(productID) LIKE '%prestigio%' ) AND ( LOWER(name) LIKE '%multipad%' OR LOWER(product_code) LIKE '%multipad%' OR LOWER(mas_id) LIKE '%multipad%' OR LOWER(nametype) LIKE '%multipad%' OR LOWER(comp) LIKE '%multipad%' OR LOWER(contry) LIKE '%multipad%' OR LOWER(productID) LIKE '%multipad%' ) AND ( LOWER(name) LIKE '%visconte%' OR LOWER(product_code) LIKE '%visconte%' OR LOWER(mas_id) LIKE '%visconte%' OR LOWER(nametype) LIKE '%visconte%' OR LOWER(comp) LIKE '%visconte%' OR LOWER(contry) LIKE '%visconte%' OR LOWER(productID) LIKE '%visconte%' ) AND ( LOWER(name) LIKE '%quad%' OR LOWER(product_code) LIKE '%quad%' OR LOWER(mas_id) LIKE '%quad%' OR LOWER(nametype) LIKE '%quad%' OR LOWER(comp) LIKE '%quad%' OR LOWER(contry) LIKE '%quad%' OR LOWER(productID) LIKE '%quad%' ) AND ( LOWER(name) LIKE '%3g%' OR LOWER(product_code) LIKE '%3g%' OR LOWER(mas_id) LIKE '%3g%' OR LOWER(nametype) LIKE '%3g%' OR LOWER(comp) LIKE '%3g%' OR LOWER(contry) LIKE '%3g%' OR LOWER(productID) LIKE '%3g%' ) AND ( LOWER(name) LIKE '%pmp881td%' OR LOWER(product_code) LIKE '%pmp881td%' OR LOWER(mas_id) LIKE '%pmp881td%' OR LOWER(nametype) LIKE '%pmp881td%' OR LOWER(comp) LIKE '%pmp881td%' OR LOWER(contry) LIKE '%pmp881td%' OR LOWER(productID) LIKE '%pmp881td%' ) AND ( LOWER(name) LIKE '%UNKNOWN_PLACEHOLDER_0''"%' OR LOWER(product_code) LIKE '%UNKNOWN_PLACEHOLDER_1''"%' OR LOWER(mas_id) LIKE '%UNKNOWN_PLACEHOLDER_2''"%' OR LOWER(nametype) LIKE '%UNKNOWN_PLACEHOLDER_3''"%' OR LOWER(comp) LIKE '%UNKNOWN_PLACEHOLDER_4''"%' OR LOWER(contry) LIKE '%UNKNOWN_PLACEHOLDER_5''"%' OR LOWER(productID) LIKE '%UNKNOWN_PLACEHOLDER_6''"%' )