Laptops We R: GATEWAY W730-K8X, M520, 7000 & MX7000

1054: Unknown column 'final_price' in 'order clause'; select distinct p.products_id from osc_products p left join osc_product_attributes pa on (p.products_id = pa.products_id) left join osc_templates_boxes tb on (pa.id = tb.id and tb.code = "manufacturers"), osc_products_description pd, osc_categories c, osc_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 p2c.products_id = p.products_id and p2c.products_id = pd.products_id and p2c.categories_id in (76,77,78,134,135,136,137,138,139,140,141,142,143,144,145,87,146,147,148,149,150,151,152,153,154,155,79) order by final_price , pd.products_name limit 0, 20

GATEWAY W730-K8X, M520, 7000 & MX7000