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