Time : 16:22:27 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 '< NOW() AND g.receipt_edt >= CURDATE()' at line 1 Raw SQL : SELECT gseq, receipt_sdt, receipt_edt, game1_sdt, game1_edt, game2_sdt, game2_edt, weekday_state, holiday_state, (SELECT COUNT(*) FROM totalweb_golf_booking b WHERE b.dt_type = 1 AND state IN (1, 10) AND b.gseq = g.gseq) AS weekday_cnt, (SELECT COUNT(*) FROM totalweb_golf_booking b WHERE b.dt_type IN (2, 3) AND state IN (1, 10) AND b.gseq = g.gseq) AS holiday_cnt, (SELECT GROUP_CONCAT(p.place SEPARATOR ',') FROM totalweb_golf_place p WHERE p.type = 1 AND p.gseq = g.gseq) AS place1, (SELECT GROUP_CONCAT(p.place SEPARATOR ',') FROM totalweb_golf_place p WHERE p.type = 2 AND p.gseq = g.gseq) AS place2 FROM totalweb_golf g WHERE < NOW() AND g.receipt_edt >= CURDATE() Time : 16:22:19 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 '< NOW() AND >= CURDATE()' at line 1 Raw SQL : SELECT gseq, receipt_sdt, receipt_edt, game1_sdt, game1_edt, game2_sdt, game2_edt, weekday_state, holiday_state, (SELECT COUNT(*) FROM totalweb_golf_booking b WHERE b.dt_type = 1 AND state IN (1, 10) AND b.gseq = g.gseq) AS weekday_cnt, (SELECT COUNT(*) FROM totalweb_golf_booking b WHERE b.dt_type IN (2, 3) AND state IN (1, 10) AND b.gseq = g.gseq) AS holiday_cnt, (SELECT GROUP_CONCAT(p.place SEPARATOR ',') FROM totalweb_golf_place p WHERE p.type = 1 AND p.gseq = g.gseq) AS place1, (SELECT GROUP_CONCAT(p.place SEPARATOR ',') FROM totalweb_golf_place p WHERE p.type = 2 AND p.gseq = g.gseq) AS place2 FROM totalweb_golf g WHERE < NOW() AND >= CURDATE() Time : 16:21:59 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 '< NOW() AND >= CURDATE()' at line 1 Raw SQL : SELECT gseq, receipt_sdt, receipt_edt, game1_sdt, game1_edt, game2_sdt, game2_edt, weekday_state, holiday_state, (SELECT COUNT(*) FROM totalweb_golf_booking b WHERE b.dt_type = 1 AND state IN (1, 10) AND b.gseq = g.gseq) AS weekday_cnt, (SELECT COUNT(*) FROM totalweb_golf_booking b WHERE b.dt_type IN (2, 3) AND state IN (1, 10) AND b.gseq = g.gseq) AS holiday_cnt, (SELECT GROUP_CONCAT(p.place SEPARATOR ',') FROM totalweb_golf_place p WHERE p.type = 1 AND p.gseq = g.gseq) AS place1, (SELECT GROUP_CONCAT(p.place SEPARATOR ',') FROM totalweb_golf_place p WHERE p.type = 2 AND p.gseq = g.gseq) AS place2 FROM totalweb_golf g WHERE < NOW() AND >= CURDATE()