상품안내 버튼

Incorrect syntax near the keyword 'group'.

sql error : SELECT A.OT_SEQ, A.CP_UID, A.OT_TYPE, A.OT_YEAR, A.OT_CAPITAL, A.OT_PERSONS, A.OT_SALES, A.OT_SUBJECT, A.OT_LOGO_PIC, A.OT_INTRO, A.RDATE, A.MDATE, A.STATUS, B.CP_NAME, B.CP_TYPE, B.CP_ADDR1, B.CEO_NAME, B.CP_TEL, B.CP_BIZ_NAME, C.SV_CNT FROM OUTED A LEFT JOIN MEM_CP B ON A.CP_UID = B.CP_UID LEFT JOIN ( select cp_uid, count(*) sv_cnt from use_service a left join service b on a.sv_code = b.sv_code where 1=1 and b.sv_type in ('P','R','H','C') and a.rdate > dateadd(day,-30,getdate() group by cp_uid ) C ON A.CP_UID = C.CP_UID WHERE 1=1 AND A.SERVICE_ON = 'Y' AND A.STATUS = 9 ORDER BY C.SV_CNT desc, A.RDATE desc