プラン名
6月
27
27
28
29
30
7月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
お得プランWithLunchTwosomeOK
基本料金 :
6,741
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)

20170627 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-28" AND T.tee_time IS NOT NULL)

20170628 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-29" AND T.tee_time IS NOT NULL)

20170629 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-30" AND T.tee_time IS NOT NULL)

20170630 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND TT.tee_date = "07/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-07-03" AND T.tee_time IS NOT NULL) 44
67 20170703 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 = 110 AND TT.tee_date = "07/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-07-04" AND T.tee_time IS NOT NULL) 23
67 20170704 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 = 110 AND TT.tee_date = "07/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-07-05" AND T.tee_time IS NOT NULL) 58
67 20170705 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 = 110 AND TT.tee_date = "07/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-07-06" AND T.tee_time IS NOT NULL) 31
67 20170706 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 = 110 AND TT.tee_date = "07/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-07-07" AND T.tee_time IS NOT NULL) 23
67 20170707 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND TT.tee_date = "07/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-07-10" AND T.tee_time IS NOT NULL) 66
67 20170710 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 = 110 AND TT.tee_date = "07/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-07-11" AND T.tee_time IS NOT NULL) 36
67 20170711 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 = 110 AND TT.tee_date = "07/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-07-12" AND T.tee_time IS NOT NULL) 60
67 20170712 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 = 110 AND TT.tee_date = "07/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-07-13" AND T.tee_time IS NOT NULL) 23
67 20170713 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 = 110 AND TT.tee_date = "07/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-07-14" AND T.tee_time IS NOT NULL) 65
67 20170714 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND TT.tee_date = "07/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-07-18" AND T.tee_time IS NOT NULL) 33
67 20170718 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 = 110 AND TT.tee_date = "07/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-07-19" AND T.tee_time IS NOT NULL) 44
67 20170719 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 = 110 AND TT.tee_date = "07/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-07-20" AND T.tee_time IS NOT NULL) 23
67 20170720 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 = 110 AND TT.tee_date = "07/21/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL) 62
67 20170721 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 110 AND TT.tee_date = "07/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-07-24" AND T.tee_time IS NOT NULL) 28
67 20170724 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 = 110 AND TT.tee_date = "07/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-07-25" AND T.tee_time IS NOT NULL) 11
67 20170725 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 = 110 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL) 69
67 20170726 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 )
7月Web限定土日祝プラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
11,000
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND TT.tee_date = "07/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-07-01" AND T.tee_time IS NOT NULL) 32
110 20170701 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 = 111 AND TT.tee_date = "07/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-07-02" AND T.tee_time IS NOT NULL) 24
110 20170702 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 = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND TT.tee_date = "07/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-07-08" AND T.tee_time IS NOT NULL) 32
110 20170708 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 = 111 AND TT.tee_date = "07/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-07-09" AND T.tee_time IS NOT NULL) 32
110 20170709 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 = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND TT.tee_date = "07/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-07-15" AND T.tee_time IS NOT NULL) 39
110 20170715 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 = 111 AND TT.tee_date = "07/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-07-16" AND T.tee_time IS NOT NULL) 17
110 20170716 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 = 111 AND TT.tee_date = "07/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-07-17" AND T.tee_time IS NOT NULL) 41
110 20170717 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 = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-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 = 111 AND TT.tee_date = "07/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-07-22" AND T.tee_time IS NOT NULL) 21
110 20170722 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 = 111 AND TT.tee_date = "07/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-07-23" AND T.tee_time IS NOT NULL) 16
110 20170723 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 = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 111 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL)
7月Web限定早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,741
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)

20170627 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-28" AND T.tee_time IS NOT NULL)

20170628 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-29" AND T.tee_time IS NOT NULL)

20170629 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-30" AND T.tee_time IS NOT NULL)

20170630 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND TT.tee_date = "07/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-07-03" AND T.tee_time IS NOT NULL) 5
67 20170703 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 = 112 AND TT.tee_date = "07/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-07-04" AND T.tee_time IS NOT NULL) 5
67 20170704 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 = 112 AND TT.tee_date = "07/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-07-05" AND T.tee_time IS NOT NULL) 2
67 20170705 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 = 112 AND TT.tee_date = "07/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-07-06" AND T.tee_time IS NOT NULL) 3
67 20170706 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 = 112 AND TT.tee_date = "07/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-07-07" AND T.tee_time IS NOT NULL) 4
67 20170707 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND TT.tee_date = "07/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-07-10" AND T.tee_time IS NOT NULL) 5
67 20170710 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 = 112 AND TT.tee_date = "07/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-07-11" AND T.tee_time IS NOT NULL) 5
67 20170711 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 = 112 AND TT.tee_date = "07/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-07-12" AND T.tee_time IS NOT NULL) 5
67 20170712 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 = 112 AND TT.tee_date = "07/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-07-13" AND T.tee_time IS NOT NULL) 6
67 20170713 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 = 112 AND TT.tee_date = "07/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-07-14" AND T.tee_time IS NOT NULL) 4
67 20170714 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND TT.tee_date = "07/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-07-18" AND T.tee_time IS NOT NULL) 6
67 20170718 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 = 112 AND TT.tee_date = "07/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-07-19" AND T.tee_time IS NOT NULL) 3
67 20170719 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 = 112 AND TT.tee_date = "07/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-07-20" AND T.tee_time IS NOT NULL) 5
67 20170720 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 = 112 AND TT.tee_date = "07/21/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL) 5
67 20170721 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 = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 112 AND TT.tee_date = "07/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-07-24" AND T.tee_time IS NOT NULL) 5
67 20170724 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 = 112 AND TT.tee_date = "07/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-07-25" AND T.tee_time IS NOT NULL) 2
67 20170725 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 = 112 AND TT.tee_date = "07/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-07-26" AND T.tee_time IS NOT NULL) 7
67 20170726 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 )
7月Web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,575
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)

20170627 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-28" AND T.tee_time IS NOT NULL)

20170628 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-29" AND T.tee_time IS NOT NULL)

20170629 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-30" AND T.tee_time IS NOT NULL)

20170630 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND TT.tee_date = "07/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-07-03" AND T.tee_time IS NOT NULL) 2
75 20170703 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 = 113 AND TT.tee_date = "07/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-07-04" AND T.tee_time IS NOT NULL) 3
75 20170704 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 = 113 AND TT.tee_date = "07/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-07-05" AND T.tee_time IS NOT NULL) 1
75 20170705 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 = 113 AND TT.tee_date = "07/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-07-06" AND T.tee_time IS NOT NULL) 1
75 20170706 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND TT.tee_date = "07/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-07-10" AND T.tee_time IS NOT NULL) 2
75 20170710 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 = 113 AND TT.tee_date = "07/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-07-11" AND T.tee_time IS NOT NULL) 2
75 20170711 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND TT.tee_date = "07/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-07-14" AND T.tee_time IS NOT NULL) 2
75 20170714 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND TT.tee_date = "07/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-07-18" AND T.tee_time IS NOT NULL) 3
75 20170718 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 = 113 AND TT.tee_date = "07/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-07-19" AND T.tee_time IS NOT NULL) 3
75 20170719 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 = 113 AND TT.tee_date = "07/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-07-20" AND T.tee_time IS NOT NULL) 5
75 20170720 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 = 113 AND TT.tee_date = "07/21/2017" AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_time_dates as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL) 2
75 20170721 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 113 AND TT.tee_date = "07/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-07-24" AND T.tee_time IS NOT NULL) 2
75 20170724 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 = 113 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-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 = 113 AND TT.tee_date = "07/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-07-26" AND T.tee_time IS NOT NULL) 2
75 20170726 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_time_dates as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND TT.tee_date = "06/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-06-27" AND T.tee_time IS NOT NULL)
35
67 20170627 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 = 102 AND TT.tee_date = "06/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-06-28" AND T.tee_time IS NOT NULL)
42
67 20170628 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 = 102 AND TT.tee_date = "06/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-06-29" AND T.tee_time IS NOT NULL)
39
67 20170629 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 = 102 AND TT.tee_date = "06/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-06-30" AND T.tee_time IS NOT NULL)
43
67 20170630 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-03" AND T.tee_time IS NOT NULL)
20170703 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-04" AND T.tee_time IS NOT NULL)
20170704 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-05" AND T.tee_time IS NOT NULL)
20170705 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-06" AND T.tee_time IS NOT NULL)
20170706 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
20170707 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-10" AND T.tee_time IS NOT NULL)
20170710 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-11" AND T.tee_time IS NOT NULL)
20170711 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
20170712 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
20170713 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-14" AND T.tee_time IS NOT NULL)
20170714 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-18" AND T.tee_time IS NOT NULL)
20170718 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-19" AND T.tee_time IS NOT NULL)
20170719 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-20" AND T.tee_time IS NOT NULL)
20170720 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL)
20170721 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-24" AND T.tee_time IS NOT NULL)
20170724 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-25" AND T.tee_time IS NOT NULL)
20170725 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 = 102 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL)
20170726 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 )
   
プラン名
6月
27
27
28
29
30
7月
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
6月Web限定早朝スループラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
6,741
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)
9
67 20170627 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 = 104 AND TT.tee_date = "06/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-06-28" AND T.tee_time IS NOT NULL)
2
67 20170628 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 = 104 AND TT.tee_date = "06/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-06-29" AND T.tee_time IS NOT NULL)
1
67 20170629 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 = 104 AND TT.tee_date = "06/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-06-30" AND T.tee_time IS NOT NULL)
3
67 20170630 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-03" AND T.tee_time IS NOT NULL)
20170703 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-04" AND T.tee_time IS NOT NULL)
20170704 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-05" AND T.tee_time IS NOT NULL)
20170705 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-06" AND T.tee_time IS NOT NULL)
20170706 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
20170707 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-10" AND T.tee_time IS NOT NULL)
20170710 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-11" AND T.tee_time IS NOT NULL)
20170711 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
20170712 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
20170713 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-14" AND T.tee_time IS NOT NULL)
20170714 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-18" AND T.tee_time IS NOT NULL)
20170718 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-19" AND T.tee_time IS NOT NULL)
20170719 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-20" AND T.tee_time IS NOT NULL)
20170720 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL)
20170721 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-24" AND T.tee_time IS NOT NULL)
20170724 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-25" AND T.tee_time IS NOT NULL)
20170725 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 = 104 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL)
20170726 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 )
6月Web限定平日1.5Rプラン 限定昼食付+2サム保証割増なし
お得プランWithLunchTwosomeOK
基本料金 :
7,575
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)
9
75 20170627 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 = 105 AND TT.tee_date = "06/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-06-28" AND T.tee_time IS NOT NULL)
2
75 20170628 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 = 105 AND TT.tee_date = "06/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-06-29" AND T.tee_time IS NOT NULL)
1
75 20170629 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 = 105 AND TT.tee_date = "06/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-06-30" AND T.tee_time IS NOT NULL)
3
75 20170630 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-03" AND T.tee_time IS NOT NULL)
20170703 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-04" AND T.tee_time IS NOT NULL)
20170704 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-05" AND T.tee_time IS NOT NULL)
20170705 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-06" AND T.tee_time IS NOT NULL)
20170706 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
20170707 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-10" AND T.tee_time IS NOT NULL)
20170710 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-11" AND T.tee_time IS NOT NULL)
20170711 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
20170712 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
20170713 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-14" AND T.tee_time IS NOT NULL)
20170714 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-18" AND T.tee_time IS NOT NULL)
20170718 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-19" AND T.tee_time IS NOT NULL)
20170719 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-20" AND T.tee_time IS NOT NULL)
20170720 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL)
20170721 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-24" AND T.tee_time IS NOT NULL)
20170724 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-25" AND T.tee_time IS NOT NULL)
20170725 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 = 105 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL)
20170726 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 )
お得プランTwosomeOK
基本料金 :
5,445
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 108 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL)
TwosomeOK
基本料金 :
8,686
総額 :
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-27" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-28" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-29" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-06-30" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-01" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-02" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-03" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-04" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-05" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-06" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-07" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-08" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-09" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-10" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-11" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-12" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-13" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-14" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-15" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-16" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-17" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-18" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-19" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-20" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-21" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-22" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-23" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-24" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-25" AND T.tee_time IS NOT NULL)
SELECT TT.* FROM wp_tee_times as TT WHERE TT.status = 1 AND TT.plan_id = 109 AND (TT.tee_time, TT.loc_id) NOT IN (SELECT T.tee_time, B.loc_id FROM wp_booking as B LEFT JOIN wp_tee_times as T ON B.tee_time_id = T.id WHERE B.status = 1 AND date_format(FROM_UNIXTIME(booking_date), "%Y-%m-%d") = "2017-07-26" AND T.tee_time IS NOT NULL)