SELECT E.TITLE
, (SELECT CATEGORY FROM p_entrie_fcate WHERE NO=E.PARENT_CATEGORY) AS CATEGORY
, M.GRADE
, C.CITY_NAME
, GROUP_CONCAT(I.P_NAME) as P_NAME
, E.RUN_YN
FROM p_entrie_map M
LEFT OUTER JOIN p_info I
ON I.NO = M.PLAYER_NO
LEFT OUTER JOIN p_new_entrie E
ON M.ENTRIE_NO = E.NO
LEFT OUTER JOIN p_city C
ON C.CITY_CODE = I.P_CITY
WHERE M.MEET_NO= '21'
AND E.PARENT_CATEGORY ='50'
AND GRADE IN('1','2','3')
AND RUN_YN NOT IN('CG')
GROUP BY M.CITY_CODE,M.TEAM_NO,E.CATEGORY,E.OBSTACLE,M.ENTRIE_NO
ORDER BY E.TITLE ASC,M.GRADE ASC,I.P_NAME ASC
LIMIT 0, 10
