| 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 `shlgqdwjwcom`.`tww0ogj_brand`AS b, `shlgqdwjwcom`.`tww0ogj_goods` AS g WHERE g.brand_id = b.brand_id AND g.cat_id IN ('7','22','63','473','60','470','57','467','64','61','471','58','468','465','65','62','472','59','469','466','66','19','38','39','36','40','37','474','477','478','479','20','47','457','44','41','51','48','458','45','456','42','49','459','46','43','455','50','460','17','28','452','25','29','26','23','30','454','27','24','475','505','489','502','486','483','499','480','496','493','506','490','503','487','500','484','481','497','494','507','491','504','488','501','485','482','498','495','492','21','54','55','52','56','53','18','31','464','35','461','32','462','33','463','34') 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 3 |