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