Àαâ°Ë»ö¾î :
  ÇöÀç¹®¼­ : HOME > Àý»è°ø±¸
 Àý»è°ø±¸ Àý´Ü¼®·ù | Ȧ¼Ò·ù | µå¸±·ù | ±â°èÅÇ·ù | Æ÷ÀÎÆ®ÅÇ | ¾Øµå¹Ð·ù | ºê·¯Ãëı´Ù·ù | ¹ÙÀÌÆ®·ù | Á¶ÁÙ·ù | ÁÙ·ù | ¸®¸Ó·ù | Ä«¿îÅͽÌÅ©·ù | ıŸ·ù
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,3)='003' 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
¼±Åà À̹ÌÁö »óǰ¸í ±Ô°Ý °¡°Ý Àû¸³±Ý Àå¹Ù±¸´Ï
·ÕȦ¼Ò21 12,110¿ø  0¿ø
·ÕȦ¼Ò22 12,110¿ø  0¿ø
·ÕȦ¼Ò23 12,110¿ø  0¿ø
·ÕȦ¼Ò24 13,840¿ø  0¿ø
·ÕȦ¼Ò25 13,840¿ø  0¿ø
·ÕȦ¼Ò26 13,840¿ø  0¿ø
·ÕȦ¼Ò27 15,570¿ø  0¿ø
·ÕȦ¼Ò28 15,570¿ø  0¿ø
·ÕȦ¼Ò29 15,570¿ø  0¿ø
·ÕȦ¼Ò30 15,570¿ø  0¿ø
·ÕȦ¼Ò31 17,300¿ø  0¿ø
·ÕȦ¼Ò33 17,300¿ø  0¿ø
·ÕȦ¼Ò34 25,764¿ø  0¿ø
·ÕȦ¼Ò35 25,764¿ø  0¿ø
·ÕȦ¼Ò36 25,764¿ø  0¿ø
      
ȸ»ç¼Ò°³   l   ÀÌ¿ë¾à°ü   l   °³ÀÎÁ¤º¸º¸È£Á¤Ã¥   l   °ü¸®ÀÚ¿¡°Ô ¸ÞÀϺ¸³»±â
»óÈ£¸í: (ÁÖ)ÁøÇ³±â¾÷ | ´ëÇ¥ÀÌ»ç: À±¼®Ã¤ | °³ÀÎÁ¤º¸°ü¸® Ã¥ÀÓÀÚ: À±¹Ì¿µ
»ç¾÷ÀÚ¹øÈ£: 504-81-52877 | Åë½ÅÆÇ¸Å¾÷½Å°í¹øÈ£: Á¦2009-´ë±¸ºÏ±¸-0519È£

´ë±¸ ºÏ±¸ »ê°Ý2µ¿ À¯Åë´ÜÁö»ê¾÷¿ëÀç°ü25µ¿ 1È£ | ´ëÇ¥ÀüÈ­ 053-604-5566 | ÆÑ½º 053-604-5050
Copyrigth(C) 2009 JPTOOL All right reserved.