| 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 `lggemuterc`.`tww0ogj_brand`AS b, `lggemuterc`.`tww0ogj_goods` AS g WHERE g.brand_id = b.brand_id AND g.cat_id IN ('13','638','695','705','702','699','696','693','706','703','700','697','694','707','704','701','698','635','686','683','687','684','685','682','632','663','660','657','654','664','661','658','655','665','662','659','656','666','629','711','708','709','710','642','636','689','690','688','633','676','673','670','667','674','671','668','675','672','669','630','644','645','646','643','637','692','691','634','679','680','677','681','678','631','647','651','648','652','649','653','650') 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 |