1064 - You have an error in your SQL syntax near 'order by c.sort_order,c.categories_id limit 0,1 ' at line 1

select distinct c.*,m.*,cd.* from products p, products_to_categories pc, categories c, manufacturers m, categories_description cd, products_description pd where p.products_id=pc.products_id and p.products_id=pd.products_id and p.manufacturers_id=m.manufacturers_id and p.products_status='1' and pc.categories_id=c.categories_id and c.categories_id=cd.categories_id and pd.language_id = '1' and m.manufacturers_id = order by c.sort_order,c.categories_id limit 0,1

[TEP STOP]