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 '%()%' OR    LOWER(product_code) LIKE '%()%' OR    LOWER(mas_id) LIKE '%()%' OR    LOWER(nametype) LIKE '%()%' OR    LOWER(comp) LIKE '%()%' OR    LOWER(contry) LIKE '%()%' OR    LOWER(productID) LIKE '%()%' )  AND  ( LOWER(name) LIKE '%china-tablet%' OR    LOWER(product_code) LIKE '%china-tablet%' OR    LOWER(mas_id) LIKE '%china-tablet%' OR    LOWER(nametype) LIKE '%china-tablet%' OR    LOWER(comp) LIKE '%china-tablet%' OR    LOWER(contry) LIKE '%china-tablet%' OR    LOWER(productID) LIKE '%china-tablet%' )  AND  ( LOWER(name) LIKE '%pc%' OR    LOWER(product_code) LIKE '%pc%' OR    LOWER(mas_id) LIKE '%pc%' OR    LOWER(nametype) LIKE '%pc%' OR    LOWER(comp) LIKE '%pc%' OR    LOWER(contry) LIKE '%pc%' OR    LOWER(productID) LIKE '%pc%' )  AND  ( LOWER(name) LIKE '%7\\",%' OR    LOWER(product_code) LIKE '%7\\",%' OR    LOWER(mas_id) LIKE '%7\\",%' OR    LOWER(nametype) LIKE '%7\\",%' OR    LOWER(comp) LIKE '%7\\",%' OR    LOWER(contry) LIKE '%7\\",%' OR    LOWER(productID) LIKE '%7\\",%' )  AND  ( LOWER(name) LIKE '% ,%')  AND  ( LOWER(name) LIKE '% ,%')  AND  ( LOWER(name) LIKE '%30%' OR    LOWER(product_code) LIKE '%30%' OR    LOWER(mas_id) LIKE '%30%' OR    LOWER(nametype) LIKE '%30%' OR    LOWER(comp) LIKE '%30%' OR    LOWER(contry) LIKE '%30%' OR    LOWER(productID) LIKE '%30%' )  AND  ( LOWER(name) LIKE '%pin,%' OR    LOWER(product_code) LIKE '%pin,%' OR    LOWER(mas_id) LIKE '%pin,%' OR    LOWER(nametype) LIKE '%pin,%' OR    LOWER(comp) LIKE '%pin,%' OR    LOWER(contry) LIKE '%pin,%' OR    LOWER(productID) LIKE '%pin,%' )  AND  ( LOWER(name) LIKE '%(186*111%' OR    LOWER(product_code) LIKE '%(186*111%' OR    LOWER(mas_id) LIKE '%(186*111%' OR    LOWER(nametype) LIKE '%(186*111%' OR    LOWER(comp) LIKE '%(186*111%' OR    LOWER(contry) LIKE '%(186*111%' OR    LOWER(productID) LIKE '%(186*111%' )  AND  ( LOWER(name) LIKE '%),%' OR    LOWER(product_code) LIKE '%),%' OR    LOWER(mas_id) LIKE '%),%' OR    LOWER(nametype) LIKE '%),%' OR    LOWER(comp) LIKE '%),%' OR    LOWER(contry) LIKE '%),%' OR    LOWER(productID) LIKE '%),%' )  AND  ( LOWER(name) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' OR    LOWER(product_code) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' OR    LOWER(mas_id) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' OR    LOWER(nametype) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' OR    LOWER(comp) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' OR    LOWER(contry) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' OR    LOWER(productID) LIKE '%#dh-0703a1-fpc04/l20130705/hk70dr2009%' )  AND  ( LOWER(name) LIKE '% UNKNOWN_PLACEHOLDER_0')