Home > spanish teclado for ASUS Z96J Z62E Z62F Z84 Z96JS S96J (TW3),Benq R55,Advent 7111 04GNI51KSP00 k020662v1 SP 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 '%spanish%' or p.products_model like '%spanish%' or pd.products_head_keywords_tag like '%spanish%' ) and (pd.products_name like '%teclado%' or p.products_model like '%teclado%' or pd.products_head_keywords_tag like '%teclado%' ) and (pd.products_name like '%for%' or p.products_model like '%for%' or pd.products_head_keywords_tag like '%for%' ) and (pd.products_name like '%asus%' or p.products_model like '%asus%' or pd.products_head_keywords_tag like '%asus%' ) and (pd.products_name like '%z96j%' or p.products_model like '%z96j%' or pd.products_head_keywords_tag like '%z96j%' ) and (pd.products_name like '%z62e%' or p.products_model like '%z62e%' or pd.products_head_keywords_tag like '%z62e%' ) and (pd.products_name like '%z62f%' or p.products_model like '%z62f%' or pd.products_head_keywords_tag like '%z62f%' ) and (pd.products_name like '%z84%' or p.products_model like '%z84%' or pd.products_head_keywords_tag like '%z84%' ) and (pd.products_name like '%z96js%' or p.products_model like '%z96js%' or pd.products_head_keywords_tag like '%z96js%' ) and (pd.products_name like '%s96j%' or p.products_model like '%s96j%' or pd.products_head_keywords_tag like '%s96j%' ) and ( (pd.products_name like '%tw3),benq%' or p.products_model like '%tw3),benq%' or pd.products_head_keywords_tag like '%tw3),benq%' ) and (pd.products_name like '%r55,advent%' or p.products_model like '%r55,advent%' or pd.products_head_keywords_tag like '%r55,advent%' ) and (pd.products_name like '%7111%' or p.products_model like '%7111%' or pd.products_head_keywords_tag like '%7111%' ) and (pd.products_name like '%04gni51ksp00%' or p.products_model like '%04gni51ksp00%' or pd.products_head_keywords_tag like '%04gni51ksp00%' ) and (pd.products_name like '%k020662v1%' or p.products_model like '%k020662v1%' or pd.products_head_keywords_tag like '%k020662v1%' ) and (pd.products_name like '%sp%' or p.products_model like '%sp%' or pd.products_head_keywords_tag like '%sp%' ) 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 '%spanish%' or p.products_model like '%spanish%' or pd.products_head_keywords_tag like '%spanish%' ) and (pd.products_name like '%teclado%' or p.products_model like '%teclado%' or pd.products_head_keywords_tag like '%teclado%' ) and (pd.products_name like '%for%' or p.products_model like '%for%' or pd.products_head_keywords_tag like '%for%' ) and (pd.products_name like '%asus%' or p.products_model like '%asus%' or pd.products_head_keywords_tag like '%asus%' ) and (pd.products_name like '%z96j%' or p.products_model like '%z96j%' or pd.products_head_keywords_tag like '%z96j%' ) and (pd.products_name like '%z62e%' or p.products_model like '%z62e%' or pd.products_head_keywords_tag like '%z62e%' ) and (pd.products_name like '%z62f%' or p.products_model like '%z62f%' or pd.products_head_keywords_tag like '%z62f%' ) and (pd.products_name like '%z84%' or p.products_model like '%z84%' or pd.products_head_keywords_tag like '%z84%' ) and (pd.products_name like '%z96js%' or p.products_model like '%z96js%' or pd.products_head_keywords_tag like '%z96js%' ) and (pd.products_name like '%s96j%' or p.products_model like '%s96j%' or pd.products_head_keywords_tag like '%s96j%' ) and ( (pd.products_name like '%tw3),benq%' or p.products_model like '%tw3),benq%' or pd.products_head_keywords_tag like '%tw3),benq%' ) and (pd.products_name like '%r55,advent%' or p.products_model like '%r55,advent%' or pd.products_head_keywords_tag like '%r55,advent%' ) and (pd.products_name like '%7111%' or p.products_model like '%7111%' or pd.products_head_keywords_tag like '%7111%' ) and (pd.products_name like '%04gni51ksp00%' or p.products_model like '%04gni51ksp00%' or pd.products_head_keywords_tag like '%04gni51ksp00%' ) and (pd.products_name like '%k020662v1%' or p.products_model like '%k020662v1%' or pd.products_head_keywords_tag like '%k020662v1%' ) and (pd.products_name like '%sp%' or p.products_model like '%sp%' or pd.products_head_keywords_tag like '%sp%' ) 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]