プラン名
10月
22
22
23
24
25
26
27
28
29
30
31
11月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
12月web限定平日プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
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-10-22" 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-10-23" AND T.tee_time IS NOT NULL)

20171023 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-10-24" AND T.tee_time IS NOT NULL)

20171024 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-10-25" AND T.tee_time IS NOT NULL)

20171025 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-10-26" AND T.tee_time IS NOT NULL)

20171026 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-10-27" AND T.tee_time IS NOT NULL)

20171027 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-10-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-10-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-10-30" AND T.tee_time IS NOT NULL)

20171030 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-10-31" AND T.tee_time IS NOT NULL)

20171031 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-11-01" AND T.tee_time IS NOT NULL)
20171101 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-11-02" AND T.tee_time IS NOT NULL)
20171102 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-11-03" 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-11-04" 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-11-05" 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-11-06" AND T.tee_time IS NOT NULL)
20171106 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-11-07" AND T.tee_time IS NOT NULL)
20171107 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-11-08" AND T.tee_time IS NOT NULL)
20171108 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-11-09" AND T.tee_time IS NOT NULL)
20171109 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-11-10" AND T.tee_time IS NOT NULL)
20171110 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-11-11" 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-11-12" 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-11-13" AND T.tee_time IS NOT NULL)
20171113 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-11-14" AND T.tee_time IS NOT NULL)
20171114 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-11-15" AND T.tee_time IS NOT NULL)
20171115 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-11-16" AND T.tee_time IS NOT NULL)
20171116 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-11-17" AND T.tee_time IS NOT NULL)
20171117 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-11-18" 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-11-19" 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-11-20" AND T.tee_time IS NOT NULL)
20171120 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-11-21" AND T.tee_time IS NOT NULL)
20171121 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
10月web限定平日プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,204
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-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 = 58 AND TT.tee_date = "10/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-10-23" AND T.tee_time IS NOT NULL)
37
72 20171023 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 = 58 AND TT.tee_date = "10/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-10-24" AND T.tee_time IS NOT NULL)
35
72 20171024 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 = 58 AND TT.tee_date = "10/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-10-25" AND T.tee_time IS NOT NULL)
46
72 20171025 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 = 58 AND TT.tee_date = "10/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-10-26" AND T.tee_time IS NOT NULL)
33
72 20171026 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 = 58 AND TT.tee_date = "10/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-10-27" AND T.tee_time IS NOT NULL)
28
72 20171027 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-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 = 58 AND TT.tee_date = "10/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-10-30" AND T.tee_time IS NOT NULL)
34
72 20171030 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 = 58 AND TT.tee_date = "10/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-10-31" AND T.tee_time IS NOT NULL)
42
72 20171031 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-01" AND T.tee_time IS NOT NULL)
20171101 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-02" AND T.tee_time IS NOT NULL)
20171102 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-06" AND T.tee_time IS NOT NULL)
20171106 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL)
20171107 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-08" AND T.tee_time IS NOT NULL)
20171108 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-09" AND T.tee_time IS NOT NULL)
20171109 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL)
20171110 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-13" AND T.tee_time IS NOT NULL)
20171113 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-14" AND T.tee_time IS NOT NULL)
20171114 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-15" AND T.tee_time IS NOT NULL)
20171115 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-16" AND T.tee_time IS NOT NULL)
20171116 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-17" AND T.tee_time IS NOT NULL)
20171117 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-20" AND T.tee_time IS NOT NULL)
20171120 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 = 58 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-21" AND T.tee_time IS NOT NULL)
20171121 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-10-22" 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-10-23" AND T.tee_time IS NOT NULL)

20171023 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-10-24" AND T.tee_time IS NOT NULL)

20171024 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-10-25" AND T.tee_time IS NOT NULL)

20171025 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-10-26" AND T.tee_time IS NOT NULL)

20171026 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-10-27" AND T.tee_time IS NOT NULL)

20171027 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-10-28" 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-10-29" 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-10-30" AND T.tee_time IS NOT NULL)

20171030 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-10-31" AND T.tee_time IS NOT NULL)

20171031 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-11-01" AND T.tee_time IS NOT NULL)
20171101 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-11-02" AND T.tee_time IS NOT NULL)
20171102 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-11-03" 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-11-04" 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-11-05" 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-11-06" AND T.tee_time IS NOT NULL)
20171106 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-11-07" AND T.tee_time IS NOT NULL)
20171107 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-11-08" AND T.tee_time IS NOT NULL)
20171108 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-11-09" AND T.tee_time IS NOT NULL)
20171109 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-11-10" AND T.tee_time IS NOT NULL)
20171110 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-11-11" 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-11-12" 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-11-13" AND T.tee_time IS NOT NULL)
20171113 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-11-14" AND T.tee_time IS NOT NULL)
20171114 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-11-15" AND T.tee_time IS NOT NULL)
20171115 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-11-16" AND T.tee_time IS NOT NULL)
20171116 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-11-17" AND T.tee_time IS NOT NULL)
20171117 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-11-18" 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-11-19" 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-11-20" AND T.tee_time IS NOT NULL)
20171120 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-11-21" AND T.tee_time IS NOT NULL)
20171121 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-10-22" AND T.tee_time IS NOT NULL)

20171022 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-10-23" 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-10-24" 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-10-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-10-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-10-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-10-28" AND T.tee_time IS NOT NULL)

20171028 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-10-29" AND T.tee_time IS NOT NULL)

20171029 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-10-30" 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-10-31" 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-11-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") = "2017-11-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") = "2017-11-03" AND T.tee_time IS NOT NULL)
20171103 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-11-04" AND T.tee_time IS NOT NULL)
20171104 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-11-05" AND T.tee_time IS NOT NULL)
20171105 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-11-06" 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-11-07" 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-11-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") = "2017-11-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") = "2017-11-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") = "2017-11-11" AND T.tee_time IS NOT NULL)
20171111 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-11-12" AND T.tee_time IS NOT NULL)
20171112 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-11-13" 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-11-14" 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-11-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") = "2017-11-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") = "2017-11-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") = "2017-11-18" AND T.tee_time IS NOT NULL)
20171118 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-11-19" AND T.tee_time IS NOT NULL)
20171119 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-11-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-11-21" AND T.tee_time IS NOT NULL)
10月web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK1.5R
基本料金 :
7,759
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-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 = 30 AND TT.tee_date = "10/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-10-23" AND T.tee_time IS NOT NULL)
1
77 20171023 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)
0
77 20171024 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)
0
77 20171025 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)
0
77 20171026 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)
0
77 20171027 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-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 = 30 AND TT.tee_date = "10/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-10-30" AND T.tee_time IS NOT NULL)
2
77 20171030 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 = 30 AND TT.tee_date = "10/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-10-31" AND T.tee_time IS NOT NULL)
3
77 20171031 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-01" AND T.tee_time IS NOT NULL)
20171101 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-02" AND T.tee_time IS NOT NULL)
20171102 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-06" AND T.tee_time IS NOT NULL)
20171106 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL)
20171107 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-08" AND T.tee_time IS NOT NULL)
20171108 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-09" AND T.tee_time IS NOT NULL)
20171109 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL)
20171110 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-13" AND T.tee_time IS NOT NULL)
20171113 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-14" AND T.tee_time IS NOT NULL)
20171114 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-15" AND T.tee_time IS NOT NULL)
20171115 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-16" AND T.tee_time IS NOT NULL)
20171116 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-17" AND T.tee_time IS NOT NULL)
20171117 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-20" AND T.tee_time IS NOT NULL)
20171120 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 = 30 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-21" AND T.tee_time IS NOT NULL)
20171121 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
   
プラン名
10月
22
22
23
24
25
26
27
28
29
30
31
11月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
10月web限定土日祝1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK1.5R
基本料金 :
11,463
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)
0
114 20171022 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)
0
114 20171028 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)
0
114 20171029 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL)
20171103 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-04" AND T.tee_time IS NOT NULL)
20171104 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL)
20171105 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL)
20171111 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL)
20171112 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL)
20171118 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL)
20171119 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 = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 32 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-21" AND T.tee_time IS NOT NULL)
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)

20171023 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)

20171024 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)

20171025 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)

20171026 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)

20171027 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)

20171030 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)

20171031 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 = 35 AND TT.tee_date = "11/01/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-11-01" AND T.tee_time IS NOT NULL) 25
64 20171101 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 = 35 AND TT.tee_date = "11/02/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-11-02" AND T.tee_time IS NOT NULL) 42
64 20171102 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND TT.tee_date = "11/06/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-11-06" AND T.tee_time IS NOT NULL) 27
64 20171106 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL) 0
64 20171107 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 = 35 AND TT.tee_date = "11/08/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-11-08" AND T.tee_time IS NOT NULL) 36
64 20171108 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 = 35 AND TT.tee_date = "11/09/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-11-09" AND T.tee_time IS NOT NULL) 36
64 20171109 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL) 0
64 20171110 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND TT.tee_date = "11/13/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-11-13" AND T.tee_time IS NOT NULL) 21
64 20171113 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 = 35 AND TT.tee_date = "11/14/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-11-14" AND T.tee_time IS NOT NULL) 37
64 20171114 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 = 35 AND TT.tee_date = "11/15/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-11-15" AND T.tee_time IS NOT NULL) 37
64 20171115 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 = 35 AND TT.tee_date = "11/16/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-11-16" AND T.tee_time IS NOT NULL) 42
64 20171116 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 = 35 AND TT.tee_date = "11/17/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-11-17" AND T.tee_time IS NOT NULL) 43
64 20171117 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 = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 35 AND TT.tee_date = "11/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-11-20" AND T.tee_time IS NOT NULL) 41
64 20171120 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 = 35 AND TT.tee_date = "11/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-11-21" AND T.tee_time IS NOT NULL) 45
64 20171121 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
11月web限定土日祝プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
11,185
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)

20171022 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)

20171028 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)

20171029 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL) 0
111 20171103 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 = 36 AND TT.tee_date = "11/04/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-11-04" AND T.tee_time IS NOT NULL) 27
111 20171104 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 = 36 AND TT.tee_date = "11/05/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-11-05" AND T.tee_time IS NOT NULL) 8
111 20171105 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL) 0
111 20171111 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL) 0
111 20171112 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL) 0
111 20171118 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 = 36 AND TT.tee_date = "11/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-11-19" AND T.tee_time IS NOT NULL) 4
111 20171119 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 = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 36 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-21" AND T.tee_time IS NOT NULL)
11月Web限定早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,463
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)

20171023 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)

20171024 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)

20171025 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)

20171026 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)

20171027 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)

20171030 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)

20171031 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 = 37 AND TT.tee_date = "11/01/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-11-01" AND T.tee_time IS NOT NULL) 3
64 20171101 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 = 37 AND TT.tee_date = "11/02/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-11-02" AND T.tee_time IS NOT NULL) 2
64 20171102 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND TT.tee_date = "11/06/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-11-06" AND T.tee_time IS NOT NULL) 5
64 20171106 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 = 37 AND TT.tee_date = "11/07/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-11-07" AND T.tee_time IS NOT NULL) 4
64 20171107 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 = 37 AND TT.tee_date = "11/08/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-11-08" AND T.tee_time IS NOT NULL) 4
64 20171108 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 = 37 AND TT.tee_date = "11/09/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-11-09" AND T.tee_time IS NOT NULL) 2
64 20171109 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL) 0
64 20171110 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND TT.tee_date = "11/13/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-11-13" AND T.tee_time IS NOT NULL) 5
64 20171113 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 = 37 AND TT.tee_date = "11/14/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-11-14" AND T.tee_time IS NOT NULL) 5
64 20171114 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 = 37 AND TT.tee_date = "11/15/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-11-15" AND T.tee_time IS NOT NULL) 6
64 20171115 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 = 37 AND TT.tee_date = "11/16/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-11-16" AND T.tee_time IS NOT NULL) 6
64 20171116 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 = 37 AND TT.tee_date = "11/17/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-11-17" AND T.tee_time IS NOT NULL) 6
64 20171117 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 = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 37 AND TT.tee_date = "11/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-11-20" AND T.tee_time IS NOT NULL) 5
64 20171120 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 = 37 AND TT.tee_date = "11/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-11-21" AND T.tee_time IS NOT NULL) 6
64 20171121 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
11月web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK1.5R
基本料金 :
7,648
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)

20171023 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)

20171024 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)

20171025 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)

20171026 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)

20171027 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)

20171030 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)

20171031 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 = 38 AND TT.tee_date = "11/01/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-11-01" AND T.tee_time IS NOT NULL) 3
76 20171101 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 = 38 AND TT.tee_date = "11/02/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-11-02" AND T.tee_time IS NOT NULL) 2
76 20171102 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND TT.tee_date = "11/06/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-11-06" AND T.tee_time IS NOT NULL) 5
76 20171106 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 = 38 AND TT.tee_date = "11/07/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-11-07" AND T.tee_time IS NOT NULL) 4
76 20171107 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 = 38 AND TT.tee_date = "11/08/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-11-08" AND T.tee_time IS NOT NULL) 4
76 20171108 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 = 38 AND TT.tee_date = "11/09/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-11-09" AND T.tee_time IS NOT NULL) 2
76 20171109 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL) 0
76 20171110 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND TT.tee_date = "11/13/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-11-13" AND T.tee_time IS NOT NULL) 5
76 20171113 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 = 38 AND TT.tee_date = "11/14/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-11-14" AND T.tee_time IS NOT NULL) 5
76 20171114 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 = 38 AND TT.tee_date = "11/15/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-11-15" AND T.tee_time IS NOT NULL) 6
76 20171115 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 = 38 AND TT.tee_date = "11/16/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-11-16" AND T.tee_time IS NOT NULL) 6
76 20171116 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 = 38 AND TT.tee_date = "11/17/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-11-17" AND T.tee_time IS NOT NULL) 6
76 20171117 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 = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 38 AND TT.tee_date = "11/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-11-20" AND T.tee_time IS NOT NULL) 5
76 20171120 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 = 38 AND TT.tee_date = "11/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-11-21" AND T.tee_time IS NOT NULL) 6
76 20171121 Array ( [0] => 20170923 [1] => 20171009 [2] => 20171103 [3] => 20171123 [4] => 20171223 )
   
プラン名
10月
22
22
23
24
25
26
27
28
29
30
31
11月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
11月web限定土日祝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
11,185
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)

20171022 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)

20171028 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)

20171029 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL) 0
111 20171103 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 = 39 AND TT.tee_date = "11/04/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-11-04" AND T.tee_time IS NOT NULL) 3
111 20171104 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL) 0
111 20171105 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL) 0
111 20171111 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL) 0
111 20171112 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-18" AND T.tee_time IS NOT NULL) 0
111 20171118 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL) 0
111 20171119 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 = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 39 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-21" AND T.tee_time IS NOT NULL)
11月web限定土日祝1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK1.5R
基本料金 :
13,176
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-22" AND T.tee_time IS NOT NULL)

20171022 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-28" AND T.tee_time IS NOT NULL)

20171028 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-29" AND T.tee_time IS NOT NULL)

20171029 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-10-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-03" AND T.tee_time IS NOT NULL) 0
131 20171103 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 = 40 AND TT.tee_date = "11/04/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-11-04" AND T.tee_time IS NOT NULL) 3
131 20171104 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-05" AND T.tee_time IS NOT NULL) 0
131 20171105 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-11" AND T.tee_time IS NOT NULL) 0
131 20171111 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-12" AND T.tee_time IS NOT NULL) 0
131 20171112 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND TT.tee_date = "11/18/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-11-18" AND T.tee_time IS NOT NULL) 1
131 20171118 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-19" AND T.tee_time IS NOT NULL) 0
131 20171119 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 = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 40 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_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-11-21" AND T.tee_time IS NOT NULL)