Note: GB 214 6mm acorn nuts must be used on the bottom of the sump plate to protect the studs from damage and seals the plate and stud to the copper (stock) sealing washers.
1054 - Unknown column 'final_price' in 'order clause'
select DISTINCT p.products_image, p.products_model, products_description.products_name, p.products_id, products_description.products_description, products_to_categories.categories_id, p.products_price, p.products_price_msrp, p.products_price_cash from products_description INNER JOIN products p ON products_description.products_id = p.products_id INNER JOIN products_to_categories ON products_to_categories.products_id = p.products_id where p.products_status = '1' and products_to_categories.categories_id = '2727' order by final_price , pd.products_name limit 0, 1000