Home > brazil keyboard HP COMPAQ CQ43 G4 G6 (Pink color)AER15600330 R15 V121046CR1 645893-201 647926-201 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 '%hp%' or p.products_model like '%hp%' or pd.products_head_keywords_tag like '%hp%' ) and (pd.products_name like '%compaq%' or p.products_model like '%compaq%' or pd.products_head_keywords_tag like '%compaq%' ) and (pd.products_name like '%cq43%' or p.products_model like '%cq43%' or pd.products_head_keywords_tag like '%cq43%' ) and (pd.products_name like '%g4%' or p.products_model like '%g4%' or pd.products_head_keywords_tag like '%g4%' ) and (pd.products_name like '%g6%' or p.products_model like '%g6%' or pd.products_head_keywords_tag like '%g6%' ) and ( (pd.products_name like '%pink%' or p.products_model like '%pink%' or pd.products_head_keywords_tag like '%pink%' ) and (pd.products_name like '%color)aer15600330%' or p.products_model like '%color)aer15600330%' or pd.products_head_keywords_tag like '%color)aer15600330%' ) and (pd.products_name like '%r15%' or p.products_model like '%r15%' or pd.products_head_keywords_tag like '%r15%' ) and (pd.products_name like '%v121046cr1%' or p.products_model like '%v121046cr1%' or pd.products_head_keywords_tag like '%v121046cr1%' ) and (pd.products_name like '%645893-201%' or p.products_model like '%645893-201%' or pd.products_head_keywords_tag like '%645893-201%' ) and (pd.products_name like '%647926-201%' or p.products_model like '%647926-201%' or pd.products_head_keywords_tag like '%647926-201%' ) 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]
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 '%hp%' or p.products_model like '%hp%' or pd.products_head_keywords_tag like '%hp%' ) and (pd.products_name like '%compaq%' or p.products_model like '%compaq%' or pd.products_head_keywords_tag like '%compaq%' ) and (pd.products_name like '%cq43%' or p.products_model like '%cq43%' or pd.products_head_keywords_tag like '%cq43%' ) and (pd.products_name like '%g4%' or p.products_model like '%g4%' or pd.products_head_keywords_tag like '%g4%' ) and (pd.products_name like '%g6%' or p.products_model like '%g6%' or pd.products_head_keywords_tag like '%g6%' ) and ( (pd.products_name like '%pink%' or p.products_model like '%pink%' or pd.products_head_keywords_tag like '%pink%' ) and (pd.products_name like '%color)aer15600330%' or p.products_model like '%color)aer15600330%' or pd.products_head_keywords_tag like '%color)aer15600330%' ) and (pd.products_name like '%r15%' or p.products_model like '%r15%' or pd.products_head_keywords_tag like '%r15%' ) and (pd.products_name like '%v121046cr1%' or p.products_model like '%v121046cr1%' or pd.products_head_keywords_tag like '%v121046cr1%' ) and (pd.products_name like '%645893-201%' or p.products_model like '%645893-201%' or pd.products_head_keywords_tag like '%645893-201%' ) and (pd.products_name like '%647926-201%' or p.products_model like '%647926-201%' or pd.products_head_keywords_tag like '%647926-201%' ) 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]