삼성카드 여행은 통신판매중개자로서, 상품 및 서비스의 이행은 내일투어의 책임하에 운영되고 있으며, 내일투어의 약관을 따릅니다.
동남아
메인 > 자기야 허니문 > 동남아
select g1.good_nm,g1.good_cd, (g1.min_adult_price) as adult_price, (g1.max_adult_price) as normal_price, g1.remark, (g1.tour_city) as area_remark, ltrim(g1.web_type_cd) as web_type_cd, g1.day_cnt from go1100 g1 where g1.good_type_cd ='O2' and right(g1.area_cd,1) = 'A' and g1.area_detail_cd = '' and (g1.web_type_cd <> '99' or g1.web_type_cd is null) and g1.good_added in ('F','G','H') Group By g1.good_nm,g1.remark,g1.good_cd,g1.tour_city,ltrim(g1.web_type_cd), g1.good_type_cd ,g1.area_cd ,g1.good_seq, g1.min_adult_price, g1.max_adult_price, g1.sort_order, g1.day_cnt ORDER BY g1.area_cd, g1.sort_order
| 조건에 맞는 여행상품이 없습니다. |