| SQL | SELECT b.brand_id, b.brand_name, b.brand_logo, b.brand_desc, COUNT(*) AS goods_num, IF(b.brand_logo > '', '1', '0') AS tag FROM `www_ttoa`.`ecs_brand`AS b, `www_ttoa`.`ecs_goods` AS g WHERE g.brand_id = b.brand_id AND g.cat_id IN ('545','559','578','582','579','580','581','556','1208','589','586','1133','1108','590','1060','1092','1162','587','583','1067','1128','1210','1043','1125','1144','588','1184','584','1009','1049','557','879','895','911','876','892','908','889','905','873','886','902','918','870','883','899','915','867','880','896','912','877','893','909','1194','890','906','874','887','903','919','871','884','900','916','868','881','897','913','865','878','894','910','891','907','875','888','904','872','885','901','917','869','882','898','914','866','1065','1081','575','1123','572','576','1124','1146','573','1121','1086','577','1190','574','1087','1100','554','546','553','550','547','551','548','552','549','620','647','644','1117','641','648','1057','645','642','1153','649','646','1072','1160','643','1132','1207','558','1094','1120','569','1033','1088','566','570','1102','567','564','1093','571','568','565','920','942','958','974','990','1006','939','924','955','971','987','1003','936','921','952','968','984','1000','933','949','965','997','930','946','962','978','994','927','943','959','975','991','1007','940','925','956','972','988','1004','937','922','953','969','985','1001','934','950','966','982','998','931','947','963','979','995','928','944','960','976','992','1008','941','926','957','973','989','1005','938','923','954','970','986','1002','935','951','967','983','999','932','948','964','980','996','929','945','961','977','993','1148','1037','1059','1091','981','1098','1105','1165','1118','1134','1099','1115','1131','1064','1147','1058','1119','1116','555','1151','562','1097','563','560','1089','561','1096','1090','1071') AND is_show = 1 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND g.is_delete = 0 GROUP BY b.brand_id HAVING goods_num > 0 ORDER BY tag DESC, b.sort_order ASC limit 40 |