プラン名
12月
19
19
20
21
22
23
24
25
26
27
28
29
30
31
12月web限定平日プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND TT.tee_date = "12/19/2017" AND (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") = "2017-12-19" AND T.tee_time IS NOT NULL)
36
64 20171219 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 = 43 AND TT.tee_date = "12/20/2017" AND (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") = "2017-12-20" AND T.tee_time IS NOT NULL)
26
64 20171220 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 = 43 AND TT.tee_date = "12/21/2017" AND (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") = "2017-12-21" AND T.tee_time IS NOT NULL)
36
64 20171221 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 = 43 AND TT.tee_date = "12/22/2017" AND (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") = "2017-12-22" AND T.tee_time IS NOT NULL)
36
64 20171222 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 = 43 AND (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") = "2017-12-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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") = "2017-12-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND TT.tee_date = "12/25/2017" AND (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") = "2017-12-25" AND T.tee_time IS NOT NULL)
40
64 20171225 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 = 43 AND TT.tee_date = "12/26/2017" AND (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") = "2017-12-26" AND T.tee_time IS NOT NULL)
37
64 20171226 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 = 43 AND TT.tee_date = "12/27/2017" AND (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") = "2017-12-27" AND T.tee_time IS NOT NULL)
39
64 20171227 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 = 43 AND (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") = "2017-12-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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") = "2017-12-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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") = "2017-12-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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") = "2017-12-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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-01-01" AND T.tee_time IS NOT NULL)
20180101 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 = 43 AND (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-01-02" AND T.tee_time IS NOT NULL)
20180102 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 = 43 AND (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-01-03" AND T.tee_time IS NOT NULL)
20180103 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 = 43 AND (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-01-04" AND T.tee_time IS NOT NULL)
20180104 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 = 43 AND (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-01-05" AND T.tee_time IS NOT NULL)
20180105 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 = 43 AND (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-01-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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-01-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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-01-08" AND T.tee_time IS NOT NULL)
20180108 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 = 43 AND (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-01-09" AND T.tee_time IS NOT NULL)
20180109 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 = 43 AND (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-01-10" AND T.tee_time IS NOT NULL)
20180110 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 = 43 AND (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-01-11" AND T.tee_time IS NOT NULL)
20180111 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 = 43 AND (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-01-12" AND T.tee_time IS NOT NULL)
20180112 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 = 43 AND (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-01-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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-01-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 43 AND (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-01-15" AND T.tee_time IS NOT NULL)
20180115 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 = 43 AND (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-01-16" AND T.tee_time IS NOT NULL)
20180116 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 = 43 AND (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-01-17" AND T.tee_time IS NOT NULL)
20180117 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 = 43 AND (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-01-18" AND T.tee_time IS NOT NULL)
20180118 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
12月web限定土日祝プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
8,574
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND TT.tee_date = "12/23/2017" AND (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") = "2017-12-23" AND T.tee_time IS NOT NULL)
6
85 20171223 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 = 44 AND TT.tee_date = "12/24/2017" AND (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") = "2017-12-24" AND T.tee_time IS NOT NULL)
17
85 20171224 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 = 44 AND (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") = "2017-12-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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") = "2017-12-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND TT.tee_date = "12/30/2017" AND (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") = "2017-12-30" AND T.tee_time IS NOT NULL)
0
85 20171230 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 = 44 AND (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") = "2017-12-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-06" AND T.tee_time IS NOT NULL)
20180106 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 = 44 AND (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-01-07" AND T.tee_time IS NOT NULL)
20180107 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 = 44 AND (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-01-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-13" AND T.tee_time IS NOT NULL)
20180113 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 = 44 AND (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-01-14" AND T.tee_time IS NOT NULL)
20180114 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 = 44 AND (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-01-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 44 AND (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-01-18" AND T.tee_time IS NOT NULL)
12月web限定平日早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND TT.tee_date = "12/19/2017" AND (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") = "2017-12-19" AND T.tee_time IS NOT NULL)
1
64 20171219 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 = 45 AND (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") = "2017-12-20" AND T.tee_time IS NOT NULL)
15
64 20171220 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 = 45 AND TT.tee_date = "12/21/2017" AND (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") = "2017-12-21" AND T.tee_time IS NOT NULL)
1
64 20171221 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 = 45 AND TT.tee_date = "12/22/2017" AND (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") = "2017-12-22" AND T.tee_time IS NOT NULL)
4
64 20171222 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 = 45 AND (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") = "2017-12-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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") = "2017-12-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND TT.tee_date = "12/25/2017" AND (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") = "2017-12-25" AND T.tee_time IS NOT NULL)
4
64 20171225 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 = 45 AND TT.tee_date = "12/26/2017" AND (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") = "2017-12-26" AND T.tee_time IS NOT NULL)
2
64 20171226 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 = 45 AND TT.tee_date = "12/27/2017" AND (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") = "2017-12-27" AND T.tee_time IS NOT NULL)
4
64 20171227 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 = 45 AND (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") = "2017-12-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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") = "2017-12-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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") = "2017-12-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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") = "2017-12-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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-01-01" AND T.tee_time IS NOT NULL)
20180101 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 = 45 AND (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-01-02" AND T.tee_time IS NOT NULL)
20180102 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 = 45 AND (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-01-03" AND T.tee_time IS NOT NULL)
20180103 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 = 45 AND (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-01-04" AND T.tee_time IS NOT NULL)
20180104 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 = 45 AND (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-01-05" AND T.tee_time IS NOT NULL)
20180105 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 = 45 AND (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-01-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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-01-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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-01-08" AND T.tee_time IS NOT NULL)
20180108 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 = 45 AND (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-01-09" AND T.tee_time IS NOT NULL)
20180109 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 = 45 AND (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-01-10" AND T.tee_time IS NOT NULL)
20180110 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 = 45 AND (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-01-11" AND T.tee_time IS NOT NULL)
20180111 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 = 45 AND (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-01-12" AND T.tee_time IS NOT NULL)
20180112 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 = 45 AND (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-01-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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-01-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 45 AND (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-01-15" AND T.tee_time IS NOT NULL)
20180115 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 = 45 AND (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-01-16" AND T.tee_time IS NOT NULL)
20180116 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 = 45 AND (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-01-17" AND T.tee_time IS NOT NULL)
20180117 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 = 45 AND (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-01-18" AND T.tee_time IS NOT NULL)
20180118 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
12月web限定平日プラン 28日・29日 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,648
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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") = "2017-12-19" AND T.tee_time IS NOT NULL)

20171219 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 = 60 AND (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") = "2017-12-20" AND T.tee_time IS NOT NULL)

20171220 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 = 60 AND (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") = "2017-12-21" AND T.tee_time IS NOT NULL)

20171221 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 = 60 AND (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") = "2017-12-22" AND T.tee_time IS NOT NULL)

20171222 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 = 60 AND (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") = "2017-12-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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") = "2017-12-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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") = "2017-12-25" AND T.tee_time IS NOT NULL)

20171225 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 = 60 AND (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") = "2017-12-26" AND T.tee_time IS NOT NULL)

20171226 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 = 60 AND (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") = "2017-12-27" AND T.tee_time IS NOT NULL)

20171227 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 = 60 AND TT.tee_date = "12/28/2017" AND (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") = "2017-12-28" AND T.tee_time IS NOT NULL)
55
76 20171228 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 = 60 AND (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") = "2017-12-29" AND T.tee_time IS NOT NULL)
62
76 20171229 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 = 60 AND (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") = "2017-12-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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") = "2017-12-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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-01-01" AND T.tee_time IS NOT NULL)
20180101 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 = 60 AND (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-01-02" AND T.tee_time IS NOT NULL)
20180102 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 = 60 AND (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-01-03" AND T.tee_time IS NOT NULL)
20180103 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 = 60 AND (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-01-04" AND T.tee_time IS NOT NULL)
20180104 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 = 60 AND (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-01-05" AND T.tee_time IS NOT NULL)
20180105 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 = 60 AND (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-01-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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-01-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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-01-08" AND T.tee_time IS NOT NULL)
20180108 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 = 60 AND (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-01-09" AND T.tee_time IS NOT NULL)
20180109 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 = 60 AND (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-01-10" AND T.tee_time IS NOT NULL)
20180110 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 = 60 AND (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-01-11" AND T.tee_time IS NOT NULL)
20180111 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 = 60 AND (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-01-12" AND T.tee_time IS NOT NULL)
20180112 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 = 60 AND (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-01-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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-01-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 60 AND (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-01-15" AND T.tee_time IS NOT NULL)
20180115 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 = 60 AND (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-01-16" AND T.tee_time IS NOT NULL)
20180116 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 = 60 AND (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-01-17" AND T.tee_time IS NOT NULL)
20180117 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 = 60 AND (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-01-18" AND T.tee_time IS NOT NULL)
20180118 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
12月web限定土日祝プラン 31日 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-23" AND T.tee_time IS NOT NULL)

20171223 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 = 61 AND (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") = "2017-12-24" AND T.tee_time IS NOT NULL)

20171224 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 = 61 AND (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") = "2017-12-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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") = "2017-12-30" AND T.tee_time IS NOT NULL)

20171230 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 = 61 AND TT.tee_date = "12/31/2017" AND (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") = "2017-12-31" AND T.tee_time IS NOT NULL)
39
64 20171231 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 = 61 AND (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-01-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-06" AND T.tee_time IS NOT NULL)
20180106 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 = 61 AND (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-01-07" AND T.tee_time IS NOT NULL)
20180107 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 = 61 AND (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-01-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-13" AND T.tee_time IS NOT NULL)
20180113 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 = 61 AND (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-01-14" AND T.tee_time IS NOT NULL)
20180114 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 = 61 AND (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-01-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 61 AND (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-01-18" AND T.tee_time IS NOT NULL)