select g.b_uid, g.m_uid, g.s_uid,g.g_image1,g.map_x,g.map_y, d_start,g.admin_id,g.admin_nm,d.guide_id,/*[yoon] guide_id 추가*/ 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,g.g_price_type, d.d_uid, d.dtid, d.g_uid,d_code, date_format(d_start,'%Y.%m.%d') as d_start2,d.admin_id,d.admin_nm,d.guide_id,/*[yoon] guide_id 추가*/ 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_endtime2,'~',d_endtime),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','익일','') as d_starttime2_nx2,if(d.d_endtime2_nx='Y','익일','') as d_endtime2_nx2, if(d.d_starttime_see='A','한국기준','현지기준') as d_starttime_see2,if(d.d_starttime2_see='A','한국기준','현지기준') as d_starttime2_see2, if(d.d_endtime_see='A','한국기준','현지기준') as d_endtime_see2,if(d.d_endtime2_see='A','한국기준','현지기준') 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_inclusion,d.d_g_noinclusion,d.d_g_rule,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, if(d.d_endtime2_nx='Y',date_add(d.d_end,interval 1 day),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, d_end, date_format(d.d_end,'%Y.%m.%d') as d_end2, case date_format(d.d_end, '%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_end_yo, 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 , 999999 ) as d_min_inwon, d_ok,d_tax,tax_money1,tax_money2,tax_money3,tax_money4, if(d_tax='Y','TAX포함','TAX불포함') as d_tax_str, if(d_oil='Y','유류할증료포함','유류할증료불포함') as d_oil_str, d_oil,oil_money1,oil_money2,oil_money3,oil_money4, d_cost1,d_cost2,d_cost3,d_cost4, d_money1,d_money2,d_money3,d_money7,d_money4,d_money5,d_money6,d_money8, 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.d_booter, d.d_plusair, d.d_regular1, d.d_regular2, d.d_regular3, d.d_regular4,d.point_type,d.point_price /*푸른추가*/ from date d LEFT JOIN ( SELECT * FROM good where 1 and g_uid='1370' ) 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='1370' order by order_num ) dt ON dt.dt_id=d.dtid where 1 and d_uid='' and d_start >= curdate() and d.g_uid='1370' order by d_start ,order_num
1030 : Got error 28 from storage engine
error file : /good/info_main.html
예약확인
문의하기
즐거워지는
탑여행사