• 님의 자랑 곡

[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 'GROUP BY C.CONTEST_NUM ORDER BY C.CONTEST_CREATETIME DESC LIMIT 0, 4' at line 9
[QUERY] SELECT C.CONTEST_NUM, C.CONTEST_TITLE, C.CONTEST_HIT, C.CONTEST_RECOMMEND, C.CONTEST_CREATETIME, C.EVENT_NUM,
				S.SONG_TITLE, S.SONG_PLAYTIME, SC.CREATOR_NAME, P.PURPOSE_NUM,P.PURPOSE_TITLE, 
				COUNT(CMT.COMMENT_NUM) AS COMMENT_CNT, I.SONG_RECORD, S.SONG_NUM, SC.USER_NUM, A.USER_GROUP FROM CONTEST AS C
					LEFT JOIN CONTEST_COMMENT AS CMT ON CMT.CONTEST_NUM = C.CONTEST_NUM
					LEFT JOIN SONGS AS S ON C.SONG_NUM = S.SONG_NUM
					LEFT JOIN SONG_CREATOR AS SC ON S.SONG_NUM = SC.SONG_NUM
					LEFT JOIN USER_ACCOUNT AS A ON SC.USER_NUM = A.USER_NUM
					LEFT JOIN PURPOSE AS P ON C.PURPOSE_NUM = P.PURPOSE_NUM
					LEFT JOIN SONG_INFORMATION AS I ON S.SONG_NUM = I.SONG_NUM WHERE SC.USER_NUM =  GROUP BY C.CONTEST_NUM ORDER BY C.CONTEST_CREATETIME DESC LIMIT 0, 4