Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.game_type' in 'on clause' Raw SQL : SELECT dt AS getday, COUNT(DISTINCT seq) AS cnt FROM (SELECT SUBSTRING(DATE_ADD(NOW(),INTERVAL -i DAY),1,10) AS dt FROM seq WHERE i < 7) d LEFT OUTER JOIN totalweb_golf_booking o ON o.reg_date LIKE CONCAT(d.dt,'%') AND o.game_type = '3' GROUP BY dt ORDER BY dt Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.game_type' in 'on clause' Raw SQL : SELECT dt AS getday, COUNT(DISTINCT seq) AS cnt FROM (SELECT SUBSTRING(DATE_ADD(NOW(),INTERVAL -i DAY),1,10) AS dt FROM seq WHERE i < 7) d LEFT OUTER JOIN totalweb_golf_booking o ON o.reg_date LIKE CONCAT(d.dt,'%') AND o.game_type = '1' GROUP BY dt ORDER BY dt Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT * FROM totalweb_golf_booking WHERE game_type = '3' ORDER BY seq DESC LIMIT 5 Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT * FROM totalweb_golf_booking WHERE game_type = '1' ORDER BY seq DESC LIMIT 5 Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '3' AND DATE_FORMAT(reg_date, '%Y-%m-%d') = CURDATE() Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '3' Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '1' AND DATE_FORMAT(reg_date, '%Y-%m-%d') = CURDATE() Time : 11:32:41 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '1' Time : 11:30:52 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'a.game_type' in 'on clause' Raw SQL : SELECT a.*, b.majr, b.minr, b.name as place FROM totalweb_golf_booking a LEFT OUTER JOIN totalweb_code b ON b.majr = a.game_type AND a.game_place = b.minr ORDER BY seq DESC LIMIT 0, 10 Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.game_type' in 'on clause' Raw SQL : SELECT dt AS getday, COUNT(DISTINCT seq) AS cnt FROM (SELECT SUBSTRING(DATE_ADD(NOW(),INTERVAL -i DAY),1,10) AS dt FROM seq WHERE i < 7) d LEFT OUTER JOIN totalweb_golf_booking o ON o.reg_date LIKE CONCAT(d.dt,'%') AND o.game_type = '3' GROUP BY dt ORDER BY dt Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'o.game_type' in 'on clause' Raw SQL : SELECT dt AS getday, COUNT(DISTINCT seq) AS cnt FROM (SELECT SUBSTRING(DATE_ADD(NOW(),INTERVAL -i DAY),1,10) AS dt FROM seq WHERE i < 7) d LEFT OUTER JOIN totalweb_golf_booking o ON o.reg_date LIKE CONCAT(d.dt,'%') AND o.game_type = '1' GROUP BY dt ORDER BY dt Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT * FROM totalweb_golf_booking WHERE game_type = '3' ORDER BY seq DESC LIMIT 5 Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT * FROM totalweb_golf_booking WHERE game_type = '1' ORDER BY seq DESC LIMIT 5 Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '3' AND DATE_FORMAT(reg_date, '%Y-%m-%d') = CURDATE() Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '3' Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '1' AND DATE_FORMAT(reg_date, '%Y-%m-%d') = CURDATE() Time : 11:30:46 SQLSTATE[42S22]: Column not found: 1054 Unknown column 'game_type' in 'where clause' Raw SQL : SELECT count(*) FROM totalweb_golf_booking WHERE game_type = '1'