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 '%model%' OR    LOWER(product_code) LIKE '%model%' OR    LOWER(mas_id) LIKE '%model%' OR    LOWER(nametype) LIKE '%model%' OR    LOWER(comp) LIKE '%model%' OR    LOWER(contry) LIKE '%model%' OR    LOWER(productID) LIKE '%model%' )  AND  ( LOWER(name) LIKE '%a1332%' OR    LOWER(product_code) LIKE '%a1332%' OR    LOWER(mas_id) LIKE '%a1332%' OR    LOWER(nametype) LIKE '%a1332%' OR    LOWER(comp) LIKE '%a1332%' OR    LOWER(contry) LIKE '%a1332%' OR    LOWER(productID) LIKE '%a1332%' )  AND  ( LOWER(name) LIKE '%emc%' OR    LOWER(product_code) LIKE '%emc%' OR    LOWER(mas_id) LIKE '%emc%' OR    LOWER(nametype) LIKE '%emc%' OR    LOWER(comp) LIKE '%emc%' OR    LOWER(contry) LIKE '%emc%' OR    LOWER(productID) LIKE '%emc%' )  AND  ( LOWER(name) LIKE '%380a%' OR    LOWER(product_code) LIKE '%380a%' OR    LOWER(mas_id) LIKE '%380a%' OR    LOWER(nametype) LIKE '%380a%' OR    LOWER(comp) LIKE '%380a%' OR    LOWER(contry) LIKE '%380a%' OR    LOWER(productID) LIKE '%380a%' )  AND  ( LOWER(name) LIKE '%fcc%' OR    LOWER(product_code) LIKE '%fcc%' OR    LOWER(mas_id) LIKE '%fcc%' OR    LOWER(nametype) LIKE '%fcc%' OR    LOWER(comp) LIKE '%fcc%' OR    LOWER(contry) LIKE '%fcc%' OR    LOWER(productID) LIKE '%fcc%' )  AND  ( LOWER(name) LIKE '%id%' OR    LOWER(product_code) LIKE '%id%' OR    LOWER(mas_id) LIKE '%id%' OR    LOWER(nametype) LIKE '%id%' OR    LOWER(comp) LIKE '%id%' OR    LOWER(contry) LIKE '%id%' OR    LOWER(productID) LIKE '%id%' )  AND  ( LOWER(name) LIKE '%bcg-e2380a%' OR    LOWER(product_code) LIKE '%bcg-e2380a%' OR    LOWER(mas_id) LIKE '%bcg-e2380a%' OR    LOWER(nametype) LIKE '%bcg-e2380a%' OR    LOWER(comp) LIKE '%bcg-e2380a%' OR    LOWER(contry) LIKE '%bcg-e2380a%' OR    LOWER(productID) LIKE '%bcg-e2380a%' )  AND  ( LOWER(name) LIKE '%ic%' OR    LOWER(product_code) LIKE '%ic%' OR    LOWER(mas_id) LIKE '%ic%' OR    LOWER(nametype) LIKE '%ic%' OR    LOWER(comp) LIKE '%ic%' OR    LOWER(contry) LIKE '%ic%' OR    LOWER(productID) LIKE '%ic%' )  AND  ( LOWER(name) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_0\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' OR    LOWER(product_code) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_1\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' OR    LOWER(mas_id) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_2\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' OR    LOWER(nametype) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_3\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' OR    LOWER(comp) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_4\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' OR    LOWER(contry) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_5\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' OR    LOWER(productID) LIKE '%579c-e2380UNKNOWN_PLACEHOLDER_6\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\''a=0%' )