Home > brazil keyboard STI IS1412 1413 1413G 1422(blue prints) MP-07G38PA-36061 71GR42414-00 new

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 ')order by products_quantity desc' at line 1

select count(distinct p.products_id) as total from ((products p) , products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%brazil%' or p.products_model like '%brazil%' or pd.products_head_keywords_tag like '%brazil%' ) and (pd.products_name like '%keyboard%' or p.products_model like '%keyboard%' or pd.products_head_keywords_tag like '%keyboard%' ) and (pd.products_name like '%sti%' or p.products_model like '%sti%' or pd.products_head_keywords_tag like '%sti%' ) and (pd.products_name like '%is1412%' or p.products_model like '%is1412%' or pd.products_head_keywords_tag like '%is1412%' ) and (pd.products_name like '%1413%' or p.products_model like '%1413%' or pd.products_head_keywords_tag like '%1413%' ) and (pd.products_name like '%1413g%' or p.products_model like '%1413g%' or pd.products_head_keywords_tag like '%1413g%' ) and (pd.products_name like '%1422(blue%' or p.products_model like '%1422(blue%' or pd.products_head_keywords_tag like '%1422(blue%' ) and (pd.products_name like '%prints%' or p.products_model like '%prints%' or pd.products_head_keywords_tag like '%prints%' ) ) and (pd.products_name like '%mp-07g38pa-36061%' or p.products_model like '%mp-07g38pa-36061%' or pd.products_head_keywords_tag like '%mp-07g38pa-36061%' ) and (pd.products_name like '%71gr42414-00%' or p.products_model like '%71gr42414-00%' or pd.products_head_keywords_tag like '%71gr42414-00%' ) and (pd.products_name like '%new%' or p.products_model like '%new%' or pd.products_head_keywords_tag like '%new%' ) )order by products_quantity desc

[TEP STOP]