• English USD

• HKD
• SGD
• TWD
• MYR
• USD
• PHP
• CNY
• THB

• Log in
• |
• My Reservation
• |
• My Page
• |
• Sign up
• |
• Group
• |
• CS Center
• |
• Tour
• Instant vehicle

select g.b_uid, g.g_api, g.m_uid, g.s_uid,g.g_image1,g.g_title,g.map_x,g.map_y, d_start,g.admin_id,g.admin_nm,g.today_reserve,g.today_reserve_time, IF(d_title <> '', d_title, g.g_title) AS d_title,d.tab as tab,g.gdt as gdt,if(g.gdt='gr','조인투어','단독투어') as gdt_nm , if(g.gdt='pe',d.d_pe_people_inwon,1) as gdt_people_inwon ,g.g_sch as g_sch,exchange_fg,exid, g.g_inclusion, g.g_noinclusion, g.g_cautions, g.g_rule, d.d_uid, d.dtid, d.g_uid,d_code, date_format(d_start,'%Y.%m.%d') as d_start2,d_start,d.admin_id,d.admin_nm,d.admin_brench,d.admin_depart, d.d_agent1 as adult_agent, d.d_agent2 as child_agent, d.d_agent3 as baby_agent, day(d_start) as d_start_day, DATE_FORMAT(d_start, '%m.%d') AS d_start_str, d_starttime,d_starttime2,if(d_starttime2<>'',concat(d_starttime,'~',d_starttime2),d_starttime) as d_starttime3, d_endtime,d_endtime2,if(d_endtime2<>'',concat(d_endtime,'~',d_endtime2),d_endtime) as d_endtime3, d.d_starttime2_nx,d.d_starttime_see,d.d_starttime2_see,d.d_endtime2_nx,d.d_endtime_see,d.d_endtime2_see,d.d_kor_sch,d.d_agent_ga, if(d.d_starttime2_nx='Y','the next day','') as d_starttime2_nx2,if(d.d_endtime2_nx='Y','the next day','') as d_endtime2_nx2, if(d.d_starttime_see='A','TIME','TIME') as d_starttime_see2,if(d.d_starttime2_see='A','TIME','TIME') as d_starttime2_see2, if(d.d_endtime_see='A','TIME','TIME') as d_endtime_see2,if(d.d_endtime2_see='A','TIME','TIME') as d_endtime2_see2, d_plane2, d.d_good_option,d.d_good_hotel,d.d_good_place,d.d_good_map, d.d_g_special,d.d_g_special_mo,d.d_g_inclusion,d.d_g_noinclusion,d.d_g_rule,d.d_g_rule_mo,d.d_content, d.d_disp_adult,d.d_disp_child,d.d_disp_baby,d.d_disp_infant,tour_cond,d_kor_sch, if(d.d_starttime2_nx='Y',date_add(d.d_start,interval 1 day),d.d_start) as d_start_d, /*(한국출발~)현지도착*/ d.d_end as d_end_d,/*(현지출발~)한국도착*/ case date_format(d.d_start, '%w') when 0 then '일' when 1 then '월' when 2 then '화' when 3 then '수' when 4 then '목' when 5 then '금' when 6 then '토' else '' end as d_start_yo, if(d.d_endtime2_nx='Y' and d.d_endtime_see='B',date_add(d.d_end,interval -1 day),d.d_end) as d_end,/*현지출발(~한국도착)*/ d.d_route, d_plane1_cd,d_plane1, d_plane2_cd,d_plane2, periodStr, period, d_people1, d_people2,d_people3,/*예약인원,정원,최소출발인원*/ IF(d_people2 - d_people1 <= 0, 0, d_people2 - d_people1) AS d_seat, IF(d_people1 > 0 AND d_people3 > 0,d_people1 - d_people3 , IF(d.tab='D' AND d.gdt='gr',d_people1 - d_gr_people_min,999999) ) as d_min_inwon, d_ok,d_tax,tax_money1,tax_money2,tax_money3,tax_money4, if(d_tax='Y','TAX Included','Without TAX') as d_tax_str, if(d_oil='Y','Airfare included','Airfare not included') as d_oil_str, d_oil,oil_money1,oil_money2,oil_money3,oil_money4, d_cost1,d_cost2,d_cost3,d_cost4, d_buy1,d_buy2,d_buy3,d_buy4, d_agent1,d_agent2,d_agent3,d_agent4, d_money1,d_money2,d_money3,d_money7,d_money4,d_money5,d_money6,d_money8, d_money4p,d_money5p,d_money6p,d_money8p, d.d_type , d_endtime, (select count(SiDX) from TB_Schedule where d_uid=d.d_uid and Sort='1') as schdule_count, d.d_gr_people_min,d.d_pe_people_unit,d.d_pe_people_inwon , d.acct_final , d.point_yn, d.point_buy1, d.point_buy2 from date d LEFT JOIN ( SELECT * FROM good where 1 and g_uid='3107' ) g ON g.g_uid=d.g_uid LEFT JOIN ( SELECT dtid as dt_id,order_num,del_flag,disp_yn FROM TB_GOOD_DATE_TYPE WHERE 1 and g_uid='3107' and disp_yn='Y' order by order_num ) dt ON dt.dt_id=d.dtid where 1 and d_uid='' and d_start >= curdate() and d.g_uid='3107' order by d_start ,order_num select g.b_uid, g.g_api, g.m_uid, g.s_uid,g.g_image1,g.g_title,g.map_x,g.map_y, d_start,g.admin_id,g.admin_nm,g.today_reserve,g.today_reserve_time, IF(d_title <> '', d_title, g.g_title) AS d_title,d.tab as tab,g.gdt as gdt,if(g.gdt='gr','조인투어','단독투어') as gdt_nm , if(g.gdt='pe',d.d_pe_people_inwon,1) as gdt_people_inwon ,g.g_sch as g_sch,exchange_fg,exid, g.g_inclusion, g.g_noinclusion, g.g_cautions, g.g_rule, d.d_uid, d.dtid, d.g_uid,d_code, date_format(d_start,'%Y.%m.%d') as d_start2,d_start,d.admin_id,d.admin_nm,d.admin_brench,d.admin_depart, d.d_agent1 as adult_agent, d.d_agent2 as child_agent, d.d_agent3 as baby_agent, day(d_start) as d_start_day, DATE_FORMAT(d_start, '%m.%d') AS d_start_str, d_starttime,d_starttime2,if(d_starttime2<>'',concat(d_starttime,'~',d_starttime2),d_starttime) as d_starttime3, d_endtime,d_endtime2,if(d_endtime2<>'',concat(d_endtime,'~',d_endtime2),d_endtime) as d_endtime3, d.d_starttime2_nx,d.d_starttime_see,d.d_starttime2_see,d.d_endtime2_nx,d.d_endtime_see,d.d_endtime2_see,d.d_kor_sch,d.d_agent_ga, if(d.d_starttime2_nx='Y','the next day','') as d_starttime2_nx2,if(d.d_endtime2_nx='Y','the next day','') as d_endtime2_nx2, if(d.d_starttime_see='A','TIME','TIME') as d_starttime_see2,if(d.d_starttime2_see='A','TIME','TIME') as d_starttime2_see2, if(d.d_endtime_see='A','TIME','TIME') as d_endtime_see2,if(d.d_endtime2_see='A','TIME','TIME') as d_endtime2_see2, d_plane2, d.d_good_option,d.d_good_hotel,d.d_good_place,d.d_good_map, d.d_g_special,d.d_g_special_mo,d.d_g_inclusion,d.d_g_noinclusion,d.d_g_rule,d.d_g_rule_mo,d.d_content, d.d_disp_adult,d.d_disp_child,d.d_disp_baby,d.d_disp_infant,tour_cond,d_kor_sch, if(d.d_starttime2_nx='Y',date_add(d.d_start,interval 1 day),d.d_start) as d_start_d, /*(한국출발~)현지도착*/ d.d_end as d_end_d,/*(현지출발~)한국도착*/ case date_format(d.d_start, '%w') when 0 then '일' when 1 then '월' when 2 then '화' when 3 then '수' when 4 then '목' when 5 then '금' when 6 then '토' else '' end as d_start_yo, if(d.d_endtime2_nx='Y' and d.d_endtime_see='B',date_add(d.d_end,interval -1 day),d.d_end) as d_end,/*현지출발(~한국도착)*/ d.d_route, d_plane1_cd,d_plane1, d_plane2_cd,d_plane2, periodStr, period, d_people1, d_people2,d_people3,/*예약인원,정원,최소출발인원*/ IF(d_people2 - d_people1 <= 0, 0, d_people2 - d_people1) AS d_seat, IF(d_people1 > 0 AND d_people3 > 0,d_people1 - d_people3 , IF(d.tab='D' AND d.gdt='gr',d_people1 - d_gr_people_min,999999) ) as d_min_inwon, d_ok,d_tax,tax_money1,tax_money2,tax_money3,tax_money4, if(d_tax='Y','TAX Included','Without TAX') as d_tax_str, if(d_oil='Y','Airfare included','Airfare not included') as d_oil_str, d_oil,oil_money1,oil_money2,oil_money3,oil_money4, d_cost1,d_cost2,d_cost3,d_cost4, d_buy1,d_buy2,d_buy3,d_buy4, d_agent1,d_agent2,d_agent3,d_agent4, d_money1,d_money2,d_money3,d_money7,d_money4,d_money5,d_money6,d_money8, d_money4p,d_money5p,d_money6p,d_money8p, d.d_type , d_endtime, (select count(SiDX) from TB_Schedule where d_uid=d.d_uid and Sort='1') as schdule_count, d.d_gr_people_min,d.d_pe_people_unit,d.d_pe_people_inwon , d.acct_final , d.point_yn, d.point_buy1, d.point_buy2 from date d LEFT JOIN ( SELECT * FROM good where 1 and g_uid='3107' ) g ON g.g_uid=d.g_uid LEFT JOIN ( SELECT dtid as dt_id,order_num,del_flag,disp_yn FROM TB_GOOD_DATE_TYPE WHERE 1 and g_uid='3107' and disp_yn='Y' order by order_num ) dt ON dt.dt_id=d.dtid where 1 and d_uid in ('xxxxxxxxxxxxxx') and d_start >= curdate() and d.g_uid='3107' order by order_num ,order_num