Àαâ°Ë»ö¾î :
  ÇöÀç¹®¼­ : 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 GD_CAT='003004005' 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
¼±Åà À̹ÌÁö »óÇ°¸í ±Ô°Ý °¡°Ý Àû¸³±Ý Àå¹Ù±¸´Ï
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M10X1.25 10,470¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M10X1.5 10,470¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M12X1.75 14,460¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M2.5X0.45 9,270¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M2X0.4 9,360¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M3X0.5 5,450¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M4X0.7 5,205¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M5X0.8 5,370¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M6X1.0 5,790¿ø  0¿ø
¾Ë¹Ì´½SFÅÇ(YG1)¾Ë¹Ì´½¿ë½ºÆÄÀÌ·²ÅÇ M8X1.25 7,750¿ø  0¿ø
      
ȸ»ç¼Ò°³   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.