1064 - syntax error, unexpected $end
select count(distinct p.products_id) as total from products p left join manufacturers m using(manufacturers_id) left join specials s on p.products_id = s.products_id left join products_aplicaciones pa on p.products_id = pa.products_id, products_description pd, categories c, products_to_categories p2c where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '3' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((MATCH(pd.products_name, pd.products_description) AGAINST('47.55555,*' IN BOOLEAN MODE) or MATCH(pa.products_aplicaciones_aplicaciones) AGAINST('47.55555,*' IN BOOLEAN MODE) or p.products_model like '%47.55555,%' or p.products_model_clear like '%4755555%' or p.products_takora_code like '%47.55555,%' or p.products_model like '%4755555%' or MATCH(pd.products_name, pd.products_description) AGAINST('4755555*' IN BOOLEAN MODE) or MATCH(pd.products_name, pd.products_description) AGAINST('+47 +55555 +' IN BOOLEAN MODE)) and (MATCH(pd.products_name, pd.products_description) AGAINST('-122.55555*' IN BOOLEAN MODE) or MATCH(pa.products_aplicaciones_aplicaciones) AGAINST('-122.55555*' IN BOOLEAN MODE) or p.products_model like '%-122.55555%' or p.products_model_clear like '%12255555%' or p.products_takora_code like '%-122.55555%' or p.products_model like '%12255555%' or MATCH(pd.products_name, pd.products_description) AGAINST('12255555*' IN BOOLEAN MODE) or MATCH(pd.products_name, pd.products_description) AGAINST('+122 +55555' IN BOOLEAN MODE)) )
[TEP STOP]
|
