select item.ai_id,item.ai_name,item.ai_name_search,price.ai_sub_name,price.ai_barcode, item.ai_connection, price.ai_coupon_price, item.ai_rank, max( price.ai_rank ) AS rank_price_top, sum(price.sale_su_klfs) as sum_sale_su , price.ai_defult_price as min_ai_defult_price, CONCAT( IF ( price.ai_sub_item_num = min( price.ai_sub_item_num ) , price.ai_defult_price, min( price.ai_defult_price ) ) ) AS sort_ai_defult_price,item.ai_end_now as to_ai_end_now,item.ai_view_end,abs(item.ai_rank) AS score from shop_total_item_new as item,shop_total_price as price where item.ai_id = price.ai_id and item.ai_view = '1' and item.ai_view_end !='1' and item.ai_sale_end !='1' and item.ai_view_site like '%1%' and price.view_item='1' and item.ai_rank>0 and item.ac_id_kl ='727' and (item.ai_name like '%EFBFBDEFBFBDEFBFBDE4B8AEEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDC6AE%' or ai_name_search like '%EFBFBDEFBFBDEFBFBDE4B8AEEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDC6AE%' or price.ai_sub_name like '%EFBFBDEFBFBDEFBFBDE4B8AEEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDC6AE%') group by item.ai_id order by score desc,item.ai_rank desc, item.ai_id desc limit 0, 40
ÇöÀçÀ§Ä¡ ·ÎÄÉÀ̼Ç
Ȩ »óÇ°°Ë»ö EFBFBDEFBFBDEFBFBDE4B8AEEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDC6AE
SEARCH ÄÚ·¯³¬½ÃÀÇ »óÇ°À» °Ë»öÀ» ÅëÇØ Æí¸®ÇÏ°Ô Ã£¾Æº¸¼¼¿ä.
' EFBFBDEFBFBDEFBFBDE4B8AEEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDEFBFBDC6AE ' °Ë»ö¾î°¡ ¾ø½À´Ï´Ù.
´Ù½Ã Çѹø °Ë»öÇØ ÁÖ¼¼¿ä :)
  • ãÀ¸½Ã´Â Á¦Ç°ÀÌ ¾ø´Ù¸é ´Ü¾îÀÇ Ã¶ÀÚ ¹× ¶ç¾î¾²±â¸¦ È®ÀÎ ÇØ ÁÖ¼¼¿ä.
  • ãÀ¸½Ã´Â »óÇ°ÀÇ Å°¿öµå¸¦ °£·«ÇÏ°Ô °Ë»öÇϽô °ÍÀÌ ÁÁ½À´Ï´Ù.
  • - ¿¹¸¦µé¾î ¹Ù´Ù °¹¹ÙÀ§³¬½Ã¸¦ °Ë»ö ÇÏ½Ç °æ¿ì¿¡´Â ¹Ù´Ù¸¦ °Ë»öÇÏ½Ã°í ³¬½Ã´ë¸¦ Àç°Ë»ö ÇÏ½Ã°í °¹¹ÙÀ§¸¦ Àç°Ë»öÇغ¸¼¼¿ä.
  • ¶ç¾î¾²±â¸¦ ´Ù¸£°Ô ÇØ º¸½Ã°Å³ª,¿µ¹®À» Çѱ۷Î,ÇѱÛÀº ¿µ¹®À¸·Î º¯°æÇؼ­ °Ë»öÇØ º¸¼¼¿ä.
  • ÇØ´ç Á¦Ç°ÀÌ Ç°Àý µÇ¾úÀ» °æ¿ì³ª,Ư¼ö¹®ÀÚ°¡ Æ÷ÇԵǾî ÀÖÀ» °æ¿ì °Ë»öµÇÁö ¾Ê½À´Ï´Ù.
  • ¸¸¾à, °Ë»ö¿¡ ¾î·Á¿òÀÌ ÀÖ´Ù¸é °í°´¼¾ÅÍ·Î ¿¬¶ôÁÖ½Ã¸é ¿øÇϽô »óÇ°À» ã¾Æ µå¸®°Ú½À´Ï´Ù. ( ÄÚ·¯³¬½Ã ´ëÇ¥ÀüÈ­ 1588-6366 )
ÀԱݰèÁ¾ȳ» ¿¹±ÝÁÖ : (ÁÖ)ÄÚ·¯ ¿ì¸®ÀºÇà 1005-703-822332
±¹¹ÎÀºÇà 682801-04-213094
³óÇù 301-0984-8271-91
¸ÅÀå ¿î¿µ½Ã°£ (¼³³¯ ¹× Ãß¼®´çÀϸ¸ ÈÞ¹«) Am 09:30 ~ Pm 20:00 ÀÎÅÍ³Ý »ó´ã ÆòÀÏ : Am 09:30 ~ Pm 17:00 Åä¿äÀÏ : Am 09:30 ~ Pm 12:00 Á¡½É½Ã°£ : Pm 12:00 ~ Pm 13:00
(ÁÖ)ÄÚ·¯³¬½Ã [41055]´ë±¸½Ã µ¿±¸ ºÎµ¿ 633-1 (µ¿±¸ ¿Ì°ñ·Î 59) ´ëÇ¥ : ÃÖ¼ºµµ / »ç¾÷ÀÚ ¹øÈ£ : 502-86-29225»ç¾÷ÀÚÁ¤º¸È®ÀÎ Åë½ÅÆǸž÷½Å°í : 2017-´ë±¸µ¿±¸ - 0158È£ °í°´¼¾ÅÍ ´ëÇ¥ÀüÈ­ : 1588-6366 Fax : 053-981-6189 À̸ÞÀÏ : bunny556@naver.com °³ÀÎÁ¤º¸°ü¸®ÀÚ : ¹æ°æÅ LG U+ ±¸¸Å¾ÈÀü ¼­ºñ½º °í°´´ÔÀº ¾ÈÀü°Å·¡¸¦ À§ÇØ Çö±ÝµîÀ¸·Î 5¸¸¿øÀÌ»ó °áÁ¦½Ã ÀúÈñ ¼îÇθô¿¡¼­ °¡ÀÔÇÑ ±¸¸Å¾ÈÀü¼­ºñ½º,¼ÒºñÀÚÇÇÇغ¸»óº¸Çè ¼­ºñ½º¸¦ ÀÌ¿ëÇÏ½Ç ¼ö ÀÖ½À´Ï´Ù.