Time : 09:13:33 SQLSTATE[42S22]: Column not found: 1054 Unknown column 't.gseq' in 'on clause' 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) AND k.gseq = t.gseq LEFT OUTER JOIN totalweb_golf_time t ON d.bookingday_dt = t.date WHERE month = :month GROUP BY d.bookingday_dt Time : 09:04:20 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 'totalweb_golf_booking k FROM LEFT OUTER JOIN totalweb_golf_bookingday ' at line 1 Raw SQL : SELECT *, count(k.gseq) as booking_cnt, count(t.seq) as time_cnt totalweb_golf_booking k FROM LEFT OUTER JOIN totalweb_golf_bookingday d ON d.bookingday_dt = k.game_dt AND k.game_type = '3' LEFT OUTER JOIN totalweb_golf_time t ON d.bookingday_dt = t.date WHERE month = :month AND k.state IN (1,10) GROUP BY d.bookingday_dt