JavaScript seems to be disabled in your browser.

You must have JavaScript enabled in your browser to utilize the functionality of this website. Click here for instructions on enabling javascript in your browser.

1054 - Unknown column 'final_price' in 'order clause'

select distinct p.products_id, p.products_weight, p.products_quantity, p.products_model, pd.products_name, pd.products_description, ifnull(nullif(p.products_image, ''), pa.pa_image) as products_image, pov.products_options_values_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, p.products_date_added, m.manufacturers_name from products p left join manufacturers m on ( p.manufacturers_id = m.manufacturers_id ) left join products_description pd on ( p.products_id = pd.products_id ) left join products_attributes pa on p.products_id = pa.products_id left join specials s on ( p.products_id = s.products_id ) inner join products_to_categories p2c on p.products_id = p2c.products_id inner join categories c on p2c.categories_id = c.categories_id, products_options po, products_options_values pov WHERE p.products_status in ('1', '0') and pd.language_id = po.language_id and po.language_id = pov.language_id and pa.options_values_id = pov.products_options_values_id and upper(po.products_options_name) = 'COLOR' and po.products_options_id = pa.options_id and pa.options_isdefault = 1 and pd.language_id = '1' order by final_price , p.products_id desc, pd.products_name limit 300, 60