Image | Code | Name | Price |
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