| 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 `shuhua47846777`.`ecs_goods_attr` AS g LEFT JOIN `shuhua47846777`.`ecs_attribute` AS a ON a.attr_id = g.attr_id WHERE g.goods_id = '408' ORDER BY a.sort_order, g.attr_price, g.goods_attr_id |