Time : 17:48:31 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:46:45 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:45:31 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:44:57 SQLSTATE[HY000]: General error: 2031 Raw SQL : SELECT *, count(k.gseq) as booking_cnt, count(t.seq) as time_cnt FROM totalweb_golf_bookingday d LEFT OUTER JOIN totalweb_golf_booking k ON d.bookingday_dt = k.game_dt AND k.game_type = '3' AND k.state IN (1,10) LEFT OUTER JOIN totalweb_golf_time t ON d.bookingday_dt = t.date WHERE d.month = :month GROUP BY d.bookingday_dt Time : 17:44:34 SQLSTATE[HY000]: General error: 2031 Raw SQL : SELECT *, count(k.gseq) as booking_cnt, count(t.seq) as time_cnt FROM totalweb_golf_bookingday d LEFT OUTER JOIN totalweb_golf_booking k ON d.bookingday_dt = k.game_dt AND k.game_type = '3' AND k.state IN (1,10) LEFT OUTER JOIN totalweb_golf_time t ON d.bookingday_dt = t.date WHERE month = :month GROUP BY d.bookingday_dt Time : 17:44:11 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:42:32 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:37:16 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:36:46 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM totalweb_golf_bookingday d LEFT OUTER JOIN totalweb_golf_bookin' at line 1 Raw SQL : SELECT *, count(k.*) FROM totalweb_golf_bookingday d LEFT OUTER JOIN totalweb_golf_booking k ON d.bookingday_dt = k.game_dt LEFT OUTER JOIN totalweb_golf_time t ON d.bookingday_dt = t.date GROUP BY d.bookingday_dt Time : 17:36:29 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '*) FROM totalweb_golf_bookingday d LEFT OUTER JOIN totalweb_golf_bookin' at line 1 Raw SQL : SELECT *, k.count(*) FROM totalweb_golf_bookingday d LEFT OUTER JOIN totalweb_golf_booking k ON d.bookingday_dt = k.game_dt LEFT OUTER JOIN totalweb_golf_time t ON d.bookingday_dt = t.date GROUP BY d.bookingday_dt Time : 17:34:47 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:30:52 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND c' at line 1 Raw SQL : SELECT * FROM totalweb_category CONCAT(SUBSTR(code, 1, 6),'000000') = '001004000000' AND code NOT LIKE '%000000' AND category_options = '1' Time : 17:30:31 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'b.game_dt' in 'where clause' Raw SQL : SELECT *, (SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalweb_golf_booking b ON a.bookingday_dt = b.game_dt WHERE b.game_type = '3' AND b.state IN (1,10)) as booking_cnt, (SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalweb_golf_time c ON a.bookingday_dt = c.date) as time_cnt FROM totalweb_golf_bookingday d WHERE d.bookingday_dt = b.game_dt Time : 17:27:37 SQLSTATE[HY000]: General error: 1096 No tables used Raw SQL : SELECT *, (SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalweb_golf_booking b ON a.bookingday_dt = b.game_dt WHERE b.game_type = '3' AND b.state IN (1,10) GROUP BY b.game_dt) as booking_cnt, (SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalweb_golf_time c ON a.bookingday_dt = c.date GROUP BY c.date) as time_cnt Time : 17:26:28 SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalw' at line 2 Raw SQL : SELECT * (SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalweb_golf_booking b ON a.bookingday_dt = b.game_dt WHERE b.game_type = '3' AND b.state IN (1,10) GROUP BY b.game_dt) as booking_cnt, (SELECT count(*) FROM totalweb_golf_bookingday a LEFT OUTER JOIN totalweb_golf_time c ON a.bookingday_dt = c.date GROUP BY c.date) as time_cnt FROM totalweb_golf_bookingday GROUP BY bookingday_dt Time : 16:41:31 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 16:40:03 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 16:39:58 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 16:39:50 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty