1054 - Unknown column 'p.products_sort' in 'order clause'
select p.products_id, pd.products_name from products_to_categories p left join products_description pd on p.products_id=pd.products_id left join products pro on pd.products_id=pro.products_id where p.categories_id = (select categories_id from products_to_categories where products_id in ( select products_id from products where products_id='647' and products_status=1)) and p.products_id!='647' and pd.language_id='1' and pro.products_status=1 order by p.products_sort
[TEP STOP]
select p.products_id, pd.products_name from products_to_categories p left join products_description pd on p.products_id=pd.products_id left join products pro on pd.products_id=pro.products_id where p.categories_id = (select categories_id from products_to_categories where products_id in ( select products_id from products where products_id='647' and products_status=1)) and p.products_id!='647' and pd.language_id='1' and pro.products_status=1 order by p.products_sort
[TEP STOP]