View as: View View View
Unknown column 'price_calculated' in 'order clause'

SELECT gallery.code AS code , gallery.image AS image , gallery.part_no AS part_no , gallery.short_description AS short_description , gallery.distr_id AS distr_id, gallery.category AS category , gallery.date_import AS date_import, gallery.id AS id , gallery.loyalty_points AS loyalty_points , gallery.vat AS vat , gallery.top_product as top_product, gallery.color_chart_id AS color_chart_id , gallery.type_variant_1 AS type_variant_1 , gallery.type_variant_2 AS type_variant_2 , gallery.color_id AS color_id , gallery.price AS price, gallery.store AS store , gallery.status AS status , gallery.manufacturer as manufacturer_id , gallery.model as model , gallery.type_product_id as type_product_id , gallery.m_unit AS m_unit , gallery.action_price AS action_price, gallery.eu_price > 0 * (1 + ( vat_rate.value / 100 )) as price_calculated_vat , COUNT(*) as no_goods, gallery.eu_price AS eu_price, gallery.d1_price AS d1_price, gallery.d2_price AS d2_price, gallery.d3_price AS d3_price, gallery.name_item AS name, gallery.accesible AS accesible, vat_rate.code_vat as vat_rate_code, vat_rate.value as vat_rate_value , manufacturers.id as man_id, manufacturers.name as manufacturer FROM gallery INNER JOIN vat_rate ON gallery.vat=vat_rate.code_vat left JOIN manufacturers ON gallery.manufacturer = manufacturers.id and status < '9' GROUP BY id ORDER BY price_calculated ASC LIMIT 0, 21
ImageCodeNamePrice