Query: SELECT cat_mod.product_id ,cat_mod.sort_order FROM cat_mod LEFT JOIN products ON cat_mod.product_id=products.product_id LEFT JOIN tags_related ON products.product_id=tags_related.product_id WHERE cat_mod.category_id='1' && tags_related.tag_id IN (39) GROUP BY cat_mod.product_id ORDER BY products.base_price_mode DESC,cat_mod.tag_order ASC,products.base_sell_price DESC
MySQL Error: Unknown column 'cat_mod.tag_order' in 'order clause'