プラン名
2月
1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
2月Web限定平日プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/01/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
42
64 20180201 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/02/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
42
64 20180202 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/05/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)
42
64 20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/06/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
41
64 20180206 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/07/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
35
64 20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/08/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
42
64 20180208 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/09/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
42
64 20180209 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)
63
64 20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/13/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
41
64 20180213 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/14/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
42
64 20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/15/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
42
64 20180215 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/16/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
42
64 20180216 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/19/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)
42
64 20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/20/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
41
64 20180220 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/21/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
35
64 20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/22/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
42
64 20180222 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/23/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
42
64 20180223 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/26/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)
42
64 20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/27/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
41
64 20180227 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 70 AND TT.tee_date = "02/28/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
42
64 20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
2月Web限定土日祝プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
8,223
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/03/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
52
82 20180203 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/04/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
62
82 20180204 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/10/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
60
82 20180210 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/11/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
51
82 20180211 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/17/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
56
82 20180217 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/18/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
59
82 20180218 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/24/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
45
82 20180224 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND TT.tee_date = "02/25/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
20
82 20180225 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 71 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
2月Web限定早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/01/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
10
64 20180201 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/02/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
10
64 20180202 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/05/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)
10
64 20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/06/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
9
64 20180206 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/07/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
8
64 20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/08/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
10
64 20180208 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/09/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
10
64 20180209 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)
15
64 20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/13/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
9
64 20180213 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/14/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
10
64 20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/15/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
10
64 20180215 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/16/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
10
64 20180216 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/19/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)
10
64 20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/20/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
9
64 20180220 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/21/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
8
64 20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/22/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
10
64 20180222 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/23/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
10
64 20180223 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/26/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)
10
64 20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/27/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
10
64 20180227 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 72 AND TT.tee_date = "02/28/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
10
64 20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
2月Web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,481
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/01/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
6
74 20180201 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/02/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
6
74 20180202 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/05/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)
6
74 20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/06/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
6
74 20180206 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/07/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
6
74 20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/08/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
6
74 20180208 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/09/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
6
74 20180209 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)
9
74 20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/13/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
6
74 20180213 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/14/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
6
74 20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/15/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
6
74 20180215 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/16/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
6
74 20180216 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/19/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)
6
74 20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/20/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
6
74 20180220 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/21/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
6
74 20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/22/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
6
74 20180222 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/23/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
6
74 20180223 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/26/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)
6
74 20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/27/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
6
74 20180227 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 74 AND TT.tee_date = "02/28/2018" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
6
74 20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
3月Web限定平日プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,926
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)

20180201 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)

20180202 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)

20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)

20180206 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)

20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)

20180208 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)

20180209 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)

20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)

20180213 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)

20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)

20180215 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)

20180216 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)

20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)

20180220 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)

20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)

20180222 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)

20180223 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)

20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)

20180227 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 76 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)

20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
   
プラン名
2月
1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
3月Web限定土日祝プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
10,537
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)

20180203 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)

20180204 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)

20180210 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)

20180211 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)

20180217 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)

20180218 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)

20180224 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)

20180225 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 77 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
3月Web限定早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,926
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)

20180201 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)

20180202 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)

20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)

20180206 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)

20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)

20180208 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)

20180209 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)

20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)

20180213 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)

20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)

20180215 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)

20180216 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)

20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)

20180220 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)

20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)

20180222 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)

20180223 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)

20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)

20180227 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 79 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)

20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
3月Web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,759
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)

20180201 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)

20180202 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)

20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)

20180206 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)

20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)

20180208 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)

20180209 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)

20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)

20180213 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)

20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)

20180215 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)

20180216 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)

20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)

20180220 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)

20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)

20180222 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)

20180223 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)

20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)

20180227 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 81 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)

20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
3月Web限定土日祝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
10,537
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)

20180203 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)

20180204 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)

20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)

20180210 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)

20180211 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)

20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)

20180217 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)

20180218 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)

20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)

20180224 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)

20180225 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)

20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 82 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
3月Web限定土日祝1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
11,278
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)

20180203 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)

20180204 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)

20180205 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)

20180210 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)

20180211 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)

20180212 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)

20180217 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)

20180218 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)

20180219 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)

20180224 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)

20180225 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)

20180226 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 83 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)
   
プラン名
2月
1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
3月Web限定土日祝プラン 21日 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
10,537
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-07" AND T.tee_time IS NOT NULL)

20180207 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-14" AND T.tee_time IS NOT NULL)

20180214 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-21" AND T.tee_time IS NOT NULL)

20180221 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 84 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2018-02-28" AND T.tee_time IS NOT NULL)

20180228 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )