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 '( pd.products_name like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR ' at line 34
in:
[select count(*) as total from products p LEFT JOIN meta_tags_products_description f on p.products_id = f.products_id LEFT JOIN manufacturers m ON (p.manufacturers_id = m.manufacturers_id), products_description pd left join featured d on pd.products_id = d.products_id left join specials s on s.products_id = d.products_id WHERE p.products_status = 1 AND p.products_id = pd.products_id AND pd.language_id = 1 AND (( pd.products_name like '%esare%' OR pd.products_description like '%esare%' OR pd.products_para1 like '%esare%' OR pd.products_para2 like '%esare%' OR pd.products_para3 like '%esare%' OR pd.products_para4 like '%esare%' OR pd.products_para5 like '%esare%' OR pd.products_para6 like '%esare%' OR pd.products_para7 like '%esare%' OR pd.products_para8 like '%esare%' OR pd.products_para9 like '%esare%' OR pd.products_para10 like '%esare%' OR pd.products_para11 like '%esare%' OR pd.products_para12 like '%esare%' OR pd.products_para13 like '%esare%' OR pd.products_para14 like '%esare%' OR pd.products_para15 like '%esare%' OR pd.products_para16 like '%esare%' OR pd.products_para17 like '%esare%' OR pd.products_para18 like '%esare%' OR pd.products_para19 like '%esare%' OR pd.products_para20 like '%esare%' OR p.products_model LIKE '%esare%' OR p.products_var_name LIKE '%esare%' OR f.metatags_title like '%esare%' OR f.metatags_keywords like '%esare%' OR f.metatags_description like '%esare%' OR f.metatags_tags like '%esare%' )( pd.products_name like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_description like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para1 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para2 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para3 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para4 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para5 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para6 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para7 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para8 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para9 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para10 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para11 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para12 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para13 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para14 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para15 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para16 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para17 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para18 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para19 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR pd.products_para20 like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR p.products_model LIKE '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR p.products_var_name LIKE '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR f.metatags_title like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR f.metatags_keywords like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR f.metatags_description like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' OR f.metatags_tags like '%ADVANCED_SEARCH_DEFAULT_OPERATOR%' )( pd.products_name like '%lifepo4%' OR pd.products_description like '%lifepo4%' OR pd.products_para1 like '%lifepo4%' OR pd.products_para2 like '%lifepo4%' OR pd.products_para3 like '%lifepo4%' OR pd.products_para4 like '%lifepo4%' OR pd.products_para5 like '%lifepo4%' OR pd.products_para6 like '%lifepo4%' OR pd.products_para7 like '%lifepo4%' OR pd.products_para8 like '%lifepo4%' OR pd.products_para9 like '%lifepo4%' OR pd.products_para10 like '%lifepo4%' OR pd.products_para11 like '%lifepo4%' OR pd.products_para12 like '%lifepo4%' OR pd.products_para13 like '%lifepo4%' OR pd.products_para14 like '%lifepo4%' OR pd.products_para15 like '%lifepo4%' OR pd.products_para16 like '%lifepo4%' OR pd.products_para17 like '%lifepo4%' OR pd.products_para18 like '%lifepo4%' OR pd.products_para19 like '%lifepo4%' OR pd.products_para20 like '%lifepo4%' OR p.products_model LIKE '%lifepo4%' OR p.products_var_name LIKE '%lifepo4%' OR f.metatags_title like '%lifepo4%' OR f.metatags_keywords like '%lifepo4%' OR f.metatags_description like '%lifepo4%' OR f.metatags_tags like '%lifepo4%' ) )]