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 '%shoto%' OR pd.products_description like '%shoto%' OR pd.products_para1 like '%shoto%' OR pd.products_para2 like '%shoto%' OR pd.products_para3 like '%shoto%' OR pd.products_para4 like '%shoto%' OR pd.products_para5 like '%shoto%' OR pd.products_para6 like '%shoto%' OR pd.products_para7 like '%shoto%' OR pd.products_para8 like '%shoto%' OR pd.products_para9 like '%shoto%' OR pd.products_para10 like '%shoto%' OR pd.products_para11 like '%shoto%' OR pd.products_para12 like '%shoto%' OR pd.products_para13 like '%shoto%' OR pd.products_para14 like '%shoto%' OR pd.products_para15 like '%shoto%' OR pd.products_para16 like '%shoto%' OR pd.products_para17 like '%shoto%' OR pd.products_para18 like '%shoto%' OR pd.products_para19 like '%shoto%' OR pd.products_para20 like '%shoto%' OR p.products_model LIKE '%shoto%' OR p.products_var_name LIKE '%shoto%' OR f.metatags_title like '%shoto%' OR f.metatags_keywords like '%shoto%' OR f.metatags_description like '%shoto%' OR f.metatags_tags like '%shoto%' )( 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 '%lithium%' OR pd.products_description like '%lithium%' OR pd.products_para1 like '%lithium%' OR pd.products_para2 like '%lithium%' OR pd.products_para3 like '%lithium%' OR pd.products_para4 like '%lithium%' OR pd.products_para5 like '%lithium%' OR pd.products_para6 like '%lithium%' OR pd.products_para7 like '%lithium%' OR pd.products_para8 like '%lithium%' OR pd.products_para9 like '%lithium%' OR pd.products_para10 like '%lithium%' OR pd.products_para11 like '%lithium%' OR pd.products_para12 like '%lithium%' OR pd.products_para13 like '%lithium%' OR pd.products_para14 like '%lithium%' OR pd.products_para15 like '%lithium%' OR pd.products_para16 like '%lithium%' OR pd.products_para17 like '%lithium%' OR pd.products_para18 like '%lithium%' OR pd.products_para19 like '%lithium%' OR pd.products_para20 like '%lithium%' OR p.products_model LIKE '%lithium%' OR p.products_var_name LIKE '%lithium%' OR f.metatags_title like '%lithium%' OR f.metatags_keywords like '%lithium%' OR f.metatags_description like '%lithium%' OR f.metatags_tags like '%lithium%' )( 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 '%battery%' OR pd.products_description like '%battery%' OR pd.products_para1 like '%battery%' OR pd.products_para2 like '%battery%' OR pd.products_para3 like '%battery%' OR pd.products_para4 like '%battery%' OR pd.products_para5 like '%battery%' OR pd.products_para6 like '%battery%' OR pd.products_para7 like '%battery%' OR pd.products_para8 like '%battery%' OR pd.products_para9 like '%battery%' OR pd.products_para10 like '%battery%' OR pd.products_para11 like '%battery%' OR pd.products_para12 like '%battery%' OR pd.products_para13 like '%battery%' OR pd.products_para14 like '%battery%' OR pd.products_para15 like '%battery%' OR pd.products_para16 like '%battery%' OR pd.products_para17 like '%battery%' OR pd.products_para18 like '%battery%' OR pd.products_para19 like '%battery%' OR pd.products_para20 like '%battery%' OR p.products_model LIKE '%battery%' OR p.products_var_name LIKE '%battery%' OR f.metatags_title like '%battery%' OR f.metatags_keywords like '%battery%' OR f.metatags_description like '%battery%' OR f.metatags_tags like '%battery%' ) )]
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 '%shoto%' OR pd.products_description like '%shoto%' OR pd.products_para1 like '%shoto%' OR pd.products_para2 like '%shoto%' OR pd.products_para3 like '%shoto%' OR pd.products_para4 like '%shoto%' OR pd.products_para5 like '%shoto%' OR pd.products_para6 like '%shoto%' OR pd.products_para7 like '%shoto%' OR pd.products_para8 like '%shoto%' OR pd.products_para9 like '%shoto%' OR pd.products_para10 like '%shoto%' OR pd.products_para11 like '%shoto%' OR pd.products_para12 like '%shoto%' OR pd.products_para13 like '%shoto%' OR pd.products_para14 like '%shoto%' OR pd.products_para15 like '%shoto%' OR pd.products_para16 like '%shoto%' OR pd.products_para17 like '%shoto%' OR pd.products_para18 like '%shoto%' OR pd.products_para19 like '%shoto%' OR pd.products_para20 like '%shoto%' OR p.products_model LIKE '%shoto%' OR p.products_var_name LIKE '%shoto%' OR f.metatags_title like '%shoto%' OR f.metatags_keywords like '%shoto%' OR f.metatags_description like '%shoto%' OR f.metatags_tags like '%shoto%' )( 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 '%lithium%' OR pd.products_description like '%lithium%' OR pd.products_para1 like '%lithium%' OR pd.products_para2 like '%lithium%' OR pd.products_para3 like '%lithium%' OR pd.products_para4 like '%lithium%' OR pd.products_para5 like '%lithium%' OR pd.products_para6 like '%lithium%' OR pd.products_para7 like '%lithium%' OR pd.products_para8 like '%lithium%' OR pd.products_para9 like '%lithium%' OR pd.products_para10 like '%lithium%' OR pd.products_para11 like '%lithium%' OR pd.products_para12 like '%lithium%' OR pd.products_para13 like '%lithium%' OR pd.products_para14 like '%lithium%' OR pd.products_para15 like '%lithium%' OR pd.products_para16 like '%lithium%' OR pd.products_para17 like '%lithium%' OR pd.products_para18 like '%lithium%' OR pd.products_para19 like '%lithium%' OR pd.products_para20 like '%lithium%' OR p.products_model LIKE '%lithium%' OR p.products_var_name LIKE '%lithium%' OR f.metatags_title like '%lithium%' OR f.metatags_keywords like '%lithium%' OR f.metatags_description like '%lithium%' OR f.metatags_tags like '%lithium%' )( 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 '%battery%' OR pd.products_description like '%battery%' OR pd.products_para1 like '%battery%' OR pd.products_para2 like '%battery%' OR pd.products_para3 like '%battery%' OR pd.products_para4 like '%battery%' OR pd.products_para5 like '%battery%' OR pd.products_para6 like '%battery%' OR pd.products_para7 like '%battery%' OR pd.products_para8 like '%battery%' OR pd.products_para9 like '%battery%' OR pd.products_para10 like '%battery%' OR pd.products_para11 like '%battery%' OR pd.products_para12 like '%battery%' OR pd.products_para13 like '%battery%' OR pd.products_para14 like '%battery%' OR pd.products_para15 like '%battery%' OR pd.products_para16 like '%battery%' OR pd.products_para17 like '%battery%' OR pd.products_para18 like '%battery%' OR pd.products_para19 like '%battery%' OR pd.products_para20 like '%battery%' OR p.products_model LIKE '%battery%' OR p.products_var_name LIKE '%battery%' OR f.metatags_title like '%battery%' OR f.metatags_keywords like '%battery%' OR f.metatags_description like '%battery%' OR f.metatags_tags like '%battery%' ) )]