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