Àαâ°Ë»ö¾î :
  ÇöÀç¹®¼­ : HOME > ±¹»êÀÛ¾÷
 ±¹»êÀÛ¾÷ ıŸ·ù | ÆÄÀÌÇÁ·»Ä¡·ù | ±â¾îÇ®·¯·ù | ÇöóÀ̾î·ù | µå¶óÀ̹ö·ù | º¹½º¾Ë·ù | ·Õº¹½º¾Ë·ù | ½½¸µ¹ëÆ®·ù | ¿ÀÀÏÀÛ±â | ½ºÆijª·ù | ¶ó÷»Ä¡·ù | ¸ùÅ°·ù | ¹ÙÀ̽ºÅ©¸³·ù | ¿¬°á´ë·ù | ¶ó÷ù | Á¶ÀÎÆ®·ù | ±â¾î·»Ä¡·ù | ¸ÁÄ¡·ù | L·»Ä¡·ù | ¿­¼è·ù | Àü¼±¹ÙÀ̽º | Ÿ¹Ì³¯¾ÐÂø±â | ıŸĮ³¯·ù | °¡À§·ù | ÈíÀÔ±â·ù | Àεαâ·ù | ·¦Çαâ·ù | ½ºÆ®¸³¹Ù·ù | Å×½ºÅ¸±â·ù | ¿­Ç³±â·ù | ÀεÎÆÁ·ù | ÀειÞħ´ë·ù | Å°ÆǹÞħ´ë·ù | ¿ÀÀÏÆнºÆ®·ù | ÀüÀÚ´Õ¹Ù·ù | ÇÖ¸áÆ®°Ç·ù | ¾Ð¼Ò¹Ù·ù | ¾ÐÂø±â·ù | Æû°Ç·ù | »ç¹«¿ëÇ°·ù | È®°ü±â·ù | »«Ä¡·ù | DTõ°ø±â·ù | ÇÏÁ¶±â·ù
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)='001' 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
¼±Åà À̹ÌÁö »óÇ°¸í ±Ô°Ý °¡°Ý Àû¸³±Ý Àå¹Ù±¸´Ï
±¹»êÀÛ¾÷ ¸ÅÀå¿¡´Â µî·ÏµÈ »óÇ°ÀÌ ¾ø½À´Ï´Ù.
      
ȸ»ç¼Ò°³   l   ÀÌ¿ë¾à°ü   l   °³ÀÎÁ¤º¸º¸È£Á¤Ã¥   l   °ü¸®ÀÚ¿¡°Ô ¸ÞÀϺ¸³»±â
»óÈ£¸í: (ÁÖ)Áødz±â¾÷ | ´ëÇ¥ÀÌ»ç: À±¼®Ã¤ | °³ÀÎÁ¤º¸°ü¸® Ã¥ÀÓÀÚ: À±¹Ì¿µ
»ç¾÷ÀÚ¹øÈ£: 504-81-52877 | Åë½ÅÆǸž÷½Å°í¹øÈ£: Á¦2009-´ë±¸ºÏ±¸-0519È£

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