SELECT A.gd_mst_pay_seq
     , A.gd_mst_seq
     , A.tour_day_st
     , A.tour_day_ed
     , A.seat_local
     , A.seat_agent
     , A.tour_sta_cd
     , A.night_cnt
     , A.day_cnt
     , A.tour_mst_amt
     , A.tour_mst_amt_nm
     , A.rows_nm
     , A.cols_nm
     , A.pay_arr
     , A.ins_dt
     , A.ins_id
     , A.ins_ip
     , A.upd_dt
     , A.upd_id
     , A.upd_ip
  FROM GD_MST_PAY A
 INNER JOIN GD_MST B ON A.gd_mst_seq = B.gd_mst_seq
 WHERE A.gd_mst_seq = :gd_mst_seq
   AND A.tour_day_st >= :tour_day_st
   AND A.tour_day_st >= DATE_FORMAT(NOW(),'%Y/%m/%d')
 ORDER BY A.tour_day_st ASC