SELECT a.attr_name FROM `gjmm`.`ecs_attribute` AS a, ecs_goods_attr_2 AS ga, `gjmm`.`ecs_goods` AS g WHERE (g.cat_id IN ('2','129','130','36','37','131','132','33','104','35','34','164') ) AND a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='506'SELECT a.attr_name FROM `gjmm`.`ecs_attribute` AS a, ecs_goods_attr_2 AS ga, `gjmm`.`ecs_goods` AS g WHERE (g.cat_id IN ('2','129','130','36','37','131','132','33','104','35','34','164') ) AND a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='508'SELECT a.attr_name FROM `gjmm`.`ecs_attribute` AS a, ecs_goods_attr_2 AS ga, `gjmm`.`ecs_goods` AS g WHERE (g.cat_id IN ('2','129','130','36','37','131','132','33','104','35','34','164') ) AND a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='511'SELECT a.attr_name FROM `gjmm`.`ecs_attribute` AS a, ecs_goods_attr_2 AS ga, `gjmm`.`ecs_goods` AS g WHERE (g.cat_id IN ('2','129','130','36','37','131','132','33','104','35','34','164') ) AND a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='507'SELECT a.attr_name FROM `gjmm`.`ecs_attribute` AS a, ecs_goods_attr_2 AS ga, `gjmm`.`ecs_goods` AS g WHERE (g.cat_id IN ('2','129','130','36','37','131','132','33','104','35','34','164') ) AND a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='580'