Time : 17:45:30 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 17:06:18 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 17:06:08 SQLSTATE[42000]: Syntax error or access violation: 1065 Query was empty Time : 16:39:58 SQLSTATE[HY000]: General error: 1364 Field 'seq' doesn't have a default value Raw SQL : INSERT INTO golf_test (gseq,check_num,state,dt_type,_condition,game_dt,game_time,game_place,game_type,booker_nm,booker_phone,guest1_nm,guest1_phone,guest2_nm,guest2_phone,guest3_nm,guest3_phone,booker_etc,guest1_etc,guest2_etc,guest3_etc,mid,wip,reg_date) VALUES ('230','80282592','1','1','1','2022-04-22','6','1','1','1234','111','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','NULL','34','118.131.90.70','2022-03-28 16:39:58') Time : 10:32:57 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE(`reg_date`) AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2021-12-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY `date` desc LIMIT 5 Time : 10:31:01 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE_FORMAT(`reg_date`, '%Y-%m') AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY date desc LIMIT 5 Time : 10:31:01 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE_FORMAT(DATE_SUB(`reg_date`, INTERVAL (DAYOFWEEK(`reg_date`)-1) DAY), '%Y-%m-%d') as start, DATE_FORMAT(DATE_SUB(`reg_date`, INTERVAL (DAYOFWEEK(`reg_date`)-7) DAY), '%Y-%m-%d') as end, DATE_FORMAT(`reg_date`, '%Y년 %u주') AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY date desc LIMIT 5 Time : 10:31:01 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE(`reg_date`) AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY `date` desc LIMIT 5 Time : 10:30:18 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE_FORMAT(`reg_date`, '%Y-%m') AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY date desc LIMIT 5 Time : 10:30:18 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE_FORMAT(DATE_SUB(`reg_date`, INTERVAL (DAYOFWEEK(`reg_date`)-1) DAY), '%Y-%m-%d') as start, DATE_FORMAT(DATE_SUB(`reg_date`, INTERVAL (DAYOFWEEK(`reg_date`)-7) DAY), '%Y-%m-%d') as end, DATE_FORMAT(`reg_date`, '%Y년 %u주') AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY date desc LIMIT 5 Time : 10:30:18 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE(`reg_date`) AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2022-02-26' GROUP BY `date` desc LIMIT 5 Time : 10:30:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE_FORMAT(`reg_date`, '%Y-%m') AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2021-11-04' GROUP BY date desc LIMIT 5 Time : 10:30:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE_FORMAT(DATE_SUB(`reg_date`, INTERVAL (DAYOFWEEK(`reg_date`)-1) DAY), '%Y-%m-%d') as start, DATE_FORMAT(DATE_SUB(`reg_date`, INTERVAL (DAYOFWEEK(`reg_date`)-7) DAY), '%Y-%m-%d') as end, DATE_FORMAT(`reg_date`, '%Y년 %u주') AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2021-11-04' GROUP BY date desc LIMIT 5 Time : 10:30:03 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'wdate' in 'where clause' Raw SQL : SELECT DATE(`reg_date`) AS `date`, count(CASE WHEN game_type=1 THEN 1 END) as cnt1, count(CASE WHEN game_type=3 THEN 1 END) as cnt2 FROM totalweb_golf_booking WHERE DATE_FORMAT(wdate, '%Y-%m-%d') >= '2022-01-01' AND DATE_FORMAT(reg_date, '%Y-%m-%d') <= '2021-11-04' GROUP BY `date` desc LIMIT 5 Time : 10:26:44 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 'AND DATE_FORMAT(wdate, '%Y-%m-%d') <= '2022-03-04' GROUP BY `date` desc LIMIT 5' at line 1 Raw SQL : SELECT DATE(`wdate`) AS `date`, count(*) as cnt FROM totalweb_member AND DATE_FORMAT(wdate, '%Y-%m-%d') <= '2022-03-04' GROUP BY `date` desc LIMIT 5 Time : 10:24:48 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'date' in 'where clause' Raw SQL : SELECT DATE(`wdate`) AS `date`, count(*) as cnt FROM totalweb_member WHERE DATE_FORMAT(date, '%Y-%m-%d') >= '2022-03-01' AND DATE_FORMAT(date, '%Y-%m-%d') <= '2022-03-04' GROUP BY `date` desc LIMIT 5 Time : 09:05:48 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '<' 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 : 09:05:14 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '<' 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 : 09:04:51 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '<' 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 : 09:03:21 SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (utf8mb4_general_ci,COERCIBLE) and (latin1_swedish_ci,NUMERIC) for operation '<' 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()