25,989
社区成员




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