25,984
社区成员
![](https://csdnimg.cn/release/cmsfe/public/img/topic.427195d5.png)
![](https://csdnimg.cn/release/cmsfe/public/img/me.40a70ab0.png)
![](https://csdnimg.cn/release/cmsfe/public/img/task.87b52881.png)
![](https://csdnimg.cn/release/cmsfe/public/img/share-circle.3e0b7822.png)
SELECT
CONCAT(
'[',
GROUP_CONCAT(
CONCAT('{"ContestSubject":"', cn.ContestSubject, '",'),
CONCAT('"ContestMoney":"', cn.ContestMoney, '",'),
CONCAT('"ContestId":"', cn.ContestiD, '"}')
),
']'
) AS BriefContest ,
cp.CompetitionId,
cp.CompetitionName,
cp.CompetitionSession,
cp.CompetitionPicture,
cp.CompetitionObjectDescribe,
cp.CompetitionEnrollStartTime,
cp.CompetitionEnrollEndTime,
cp.CompetitionState
FROM
competition as cp,
contest as cn
WHERE
cn.CompetitionId = cp.CompetitionId AND
cp.competitionState in (1, 2, 5)
GROUP BY cp.competitionId;
END