1054 - Unknown column 'final_price' in 'order clause'
select distinct p.products_id, pd.products_name,
pd.products_description,
p.products_price,
p.products_tax_class_id,
p.products_image,
s.specials_new_products_price,
s.status from products p
join products_description pd
on pd.products_id = p.products_id
left join specials s
on s.products_id = p.products_id
where p.products_status = '1' and p.products_ordered > 0 and p.products_id = pd.products_id and pd.language_id = '1' order by final_price , pd.products_name limit 0, 30