| SQL | SELECT a.attr_id, a.attr_name, a.attr_group, a.is_linked, a.attr_type, g.goods_attr_id, g.attr_value, g.attr_price FROM `lggemuterc`.`tww0ogj_goods_attr` AS g LEFT JOIN `lggemuterc`.`tww0ogj_attribute` AS a ON a.attr_id = g.attr_id WHERE g.goods_id = '24' ORDER BY g.goods_attr_id, a.sort_order, g.attr_price |