CODE (SQL):
скопировать код в буфер обмена
скопировать код в буфер обмена
- SELECT
- t1.id,
- t1.user_id,
- nickname,
- imageurl,
- t1.title,
- competition_id,
- /*
- (
- SELECT COUNT(id)
- FROM cms_competition_work t6
- WHERE vote=(
- SELECT MAX(vote)
- FROM cms_competition_work t7
- WHERE t6.competition_id=t7.competition_id
- )
- ) winner
- */
- FROM cms_competition_work t1
- JOIN cms_users t3 ON t3.id = t1.user_id
- JOIN cms_user_profiles t4 ON t4.user_id = t1.user_id
- JOIN cms_competition t5 ON t5.id = t1.competition_id
- WHERE vote=(
- SELECT MAX(vote)
- FROM cms_competition_work t2
- WHERE t1.competition_id=t2.competition_id
- )
- LIMIT 6