다른메뉴보기
-
select product.* , fi.wm_filename, fi.wm_file_width, fi.wm_file_height from
sp_product as product
left join sp_board_file as fi
on product.wm_id = fi.wm_bid and fi.wm_num = 0
and fi.wm_table = 'sp_product'
where wm_ca_id1='4' and wm_use='Y' and product.wm_id != '100'
order by wm_sort, wm_id desc
-
제주한라봉소다Jeju Hanrabong Soda
-
메론소다Melon Soda
-
아메리카노Americano (Iced/Hot)
-
홍차Black Tea (Iced/Hot)
-
모스소프트크림MOS Soft Cream
-
코카콜라Coca cola
-
코카콜라 제로Coca Cola Zero
-
환타 오렌지Fanta Orange
-
환타 포도Fanta Grape
-
스프라이트Sprite
-
피크닉 사과쥬스Picnic Apple Juice