SELECT M.GD_MAKER, M.MAKER_CODE, COUNT(M.GD_MAKER) FLAG FROM kimsmall7_malldata M, kimsmall7_maker K WHERE GD_SHOW<>2 AND LEFT(GD_CAT,6)='011015' AND M.MAKER_CODE = K.MAKER_CODE AND K.MAKER_DISPLAY = 'O' AND LENGTH(GD_MAKER)>0 GROUP BY GD_MAKER ORDER BY GD_HIT DESC, FLAG DESC