プラン名
8月
18
18
19
20
21
22
23
24
25
26
27
28
29
30
31
9月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
お得プランWithLunchTwosomeOK
基本料金 :
6,648
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/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-08-18" AND T.tee_time IS NOT NULL)
24
66 20170818 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/22/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
32
66 20170822 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/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-08-23" AND T.tee_time IS NOT NULL)
47
66 20170823 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/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-08-24" AND T.tee_time IS NOT NULL)
39
66 20170824 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/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-08-25" AND T.tee_time IS NOT NULL)
22
66 20170825 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/28/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
37
66 20170828 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/29/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-08-29" AND T.tee_time IS NOT NULL)
38
66 20170829 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/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-08-30" AND T.tee_time IS NOT NULL)
56
66 20170830 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND TT.tee_date = "08/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-08-31" AND T.tee_time IS NOT NULL)
40
66 20170831 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
20170901 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
20170904 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
20170905 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
20170906 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
20170907 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
20170908 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
20170911 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
20170912 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
20170913 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
20170914 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
20170915 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 119 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
お得プランWithLunchTwosomeOK
基本料金 :
10,075
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND TT.tee_date = "08/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-08-19" AND T.tee_time IS NOT NULL)
9
100 20170819 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND TT.tee_date = "08/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-08-20" AND T.tee_time IS NOT NULL)
15
100 20170820 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND TT.tee_date = "08/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-08-26" AND T.tee_time IS NOT NULL)
41
100 20170826 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND TT.tee_date = "08/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-08-27" AND T.tee_time IS NOT NULL)
19
100 20170827 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
20170902 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
20170903 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
20170909 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
20170910 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
20170916 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 120 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
20170917 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
お得プランWithLunchTwosomeOK
基本料金 :
7,759
総額 :
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/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-08-18" AND T.tee_time IS NOT NULL)
3
77 20170818 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/22/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
1
77 20170822 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/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-08-23" AND T.tee_time IS NOT NULL)
4
77 20170823 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/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-08-24" AND T.tee_time IS NOT NULL)
3
77 20170824 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/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-08-25" AND T.tee_time IS NOT NULL)
3
77 20170825 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/28/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
1
77 20170828 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/29/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-08-29" AND T.tee_time IS NOT NULL)
2
77 20170829 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/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-08-30" AND T.tee_time IS NOT NULL)
3
77 20170830 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND TT.tee_date = "08/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-08-31" AND T.tee_time IS NOT NULL)
4
77 20170831 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
20170901 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
20170904 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
20170905 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
20170906 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
20170907 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
20170908 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
20170911 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
20170912 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
20170913 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
20170914 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
20170915 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 122 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
お得プランWithLunchTwosomeOK
基本料金 :
9,611
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
12
96 20170819 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
12
96 20170820 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
12
96 20170826 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
12
96 20170827 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
20170902 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
20170903 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
20170909 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
20170910 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
20170916 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 123 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
20170917 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
お得プランWithLunchTwosomeOK
基本料金 :
11,278
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
12
112 20170819 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
12
112 20170820 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
12
112 20170826 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
12
112 20170827 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
20170902 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
20170903 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
20170909 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
20170910 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
20170916 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 124 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
20170917 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
   
プラン名
8月
18
18
19
20
21
22
23
24
25
26
27
28
29
30
31
9月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
TwosomeOK
基本料金 :
6,000
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 125 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
TwosomeOK
基本料金 :
9,611
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 126 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
9月Web限定早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,741
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)

20170818 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)

20170821 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)

20170822 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)

20170823 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)

20170824 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)

20170825 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)

20170828 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)

20170829 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)

20170830 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)

20170831 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-01" AND T.tee_time IS NOT NULL) 5
67 20170901 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-04" AND T.tee_time IS NOT NULL) 6
67 20170904 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-05" AND T.tee_time IS NOT NULL) 4
67 20170905 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-06" AND T.tee_time IS NOT NULL) 6
67 20170906 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-07" AND T.tee_time IS NOT NULL) 6
67 20170907 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-08" AND T.tee_time IS NOT NULL) 6
67 20170908 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/11/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-09-11" AND T.tee_time IS NOT NULL) 6
67 20170911 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/12/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-09-12" AND T.tee_time IS NOT NULL) 5
67 20170912 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-13" AND T.tee_time IS NOT NULL) 7
67 20170913 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-14" AND T.tee_time IS NOT NULL) 6
67 20170914 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND TT.tee_date = "09/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-09-15" AND T.tee_time IS NOT NULL) 6
67 20170915 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 129 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
9月Web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,759
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)

20170818 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)

20170821 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)

20170822 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)

20170823 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)

20170824 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)

20170825 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)

20170828 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)

20170829 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)

20170830 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)

20170831 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-01" AND T.tee_time IS NOT NULL) 5
77 20170901 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-04" AND T.tee_time IS NOT NULL) 5
77 20170904 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-05" AND T.tee_time IS NOT NULL) 4
77 20170905 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-06" AND T.tee_time IS NOT NULL) 5
77 20170906 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-07" AND T.tee_time IS NOT NULL) 6
77 20170907 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-08" AND T.tee_time IS NOT NULL) 6
77 20170908 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/11/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-09-11" AND T.tee_time IS NOT NULL) 6
77 20170911 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/12/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-09-12" AND T.tee_time IS NOT NULL) 5
77 20170912 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-13" AND T.tee_time IS NOT NULL) 8
77 20170913 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-14" AND T.tee_time IS NOT NULL) 6
77 20170914 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND TT.tee_date = "09/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-09-15" AND T.tee_time IS NOT NULL) 6
77 20170915 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 130 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
9月Web限定土日祝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
10,074
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)

20170819 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)

20170820 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)

20170826 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)

20170827 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND TT.tee_date = "09/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-09-02" AND T.tee_time IS NOT NULL) 3
100 20170902 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL) 9
100 20170903 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL) 9
100 20170909 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND TT.tee_date = "09/10/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-09-10" AND T.tee_time IS NOT NULL) 1
100 20170910 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL) 9
100 20170916 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 131 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL) 9
100 20170917 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
   
プラン名
8月
18
18
19
20
21
22
23
24
25
26
27
28
29
30
31
9月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
9月Web限定土日祝1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
11,463
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)

20170819 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)

20170820 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)

20170826 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)

20170827 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND TT.tee_date = "09/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-09-02" AND T.tee_time IS NOT NULL) 3
114 20170902 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL) 9
114 20170903 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL) 9
114 20170909 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND TT.tee_date = "09/10/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-09-10" AND T.tee_time IS NOT NULL) 1
114 20170910 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND TT.tee_date = "09/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-09-16" AND T.tee_time IS NOT NULL) 0
114 20170916 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 132 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL) 9
114 20170917 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
お得プランWithLunchTwosomeOK
基本料金 :
6,741
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)

20170818 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)

20170821 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)

20170822 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)

20170823 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)

20170824 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)

20170825 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)

20170828 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)

20170829 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)

20170830 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)

20170831 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-01" AND T.tee_time IS NOT NULL) 45
67 20170901 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-04" AND T.tee_time IS NOT NULL) 44
67 20170904 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-05" AND T.tee_time IS NOT NULL) 43
67 20170905 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-06" AND T.tee_time IS NOT NULL) 46
67 20170906 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-07" AND T.tee_time IS NOT NULL) 46
67 20170907 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-08" AND T.tee_time IS NOT NULL) 44
67 20170908 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/11/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-09-11" AND T.tee_time IS NOT NULL) 46
67 20170911 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/12/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-09-12" AND T.tee_time IS NOT NULL) 41
67 20170912 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-13" AND T.tee_time IS NOT NULL) 45
67 20170913 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-14" AND T.tee_time IS NOT NULL) 45
67 20170914 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND TT.tee_date = "09/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-09-15" AND T.tee_time IS NOT NULL) 42
67 20170915 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 127 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
9月Web限定土日祝プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
10,074
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)

20170819 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)

20170820 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)

20170826 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)

20170827 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND TT.tee_date = "09/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-09-02" AND T.tee_time IS NOT NULL) 25
100 20170902 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND TT.tee_date = "09/03/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-09-03" AND T.tee_time IS NOT NULL) 25
100 20170903 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND TT.tee_date = "09/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-09-09" AND T.tee_time IS NOT NULL) 17
100 20170909 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND TT.tee_date = "09/10/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-09-10" AND T.tee_time IS NOT NULL) 32
100 20170910 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND TT.tee_date = "09/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-09-16" AND T.tee_time IS NOT NULL) 44
100 20170916 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 128 AND TT.tee_date = "09/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-09-17" AND T.tee_time IS NOT NULL) 26
100 20170917 Array ( [0] => 20161223 [1] => 20170109 [2] => 20170211 [3] => 20170320 [4] => 20170429 [5] => 20170503 [6] => 20170504 [7] => 20170505 [8] => 20170717 [9] => 20170811 [10] => 20170918 [11] => 20170923 [12] => 20171009 [13] => 20171103 [14] => 20171123 [15] => 20171223 )
お得プランWithLunchTwosomeOK
基本料金 :
6,185
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 133 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)
お得プランWithLunchTwosomeOK
基本料金 :
9,611
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-26" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-08-31" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 134 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-09-17" AND T.tee_time IS NOT NULL)