Chouchoutes Cycling Club
L'émission 100% cyclisme féminin, 0% sérieux
with classement as ( select lower(player) as player, nullif(sum(classement = 1), 0) as first, nullif(sum(classement = 2), 0) as second, nullif(sum(classement = 3), 0) as third, nullif(sum(classement = 4), 0) as fourth from ccc_quiz where classement is not null group by 1 ), number_q as ( SELECT lower(quiz_author) as player, count(*) as quizes from ccc_episodes where quiz_name != '' group by 1 ) select classement.player, number_q.quizes, classement.first, classement.second, classement.third, classement.fourth from classement left join number_q on classement.player = number_q.player order by 3 desc, 4 desc, 5 desc
with episodes as ( select concat(type, numero) as id_episode, date, quiz_name as quiz, quiz_author as fait_par from ccc_episodes where quiz_name != '' ), results as ( select id_episode, min(case when lower(player) = 'macfly' then classement end) as macfly, min(case when lower(player) = '53x12' then classement end) as `53x12`, min(case when lower(player) = 'cactus' then classement end) as cactus, min(case when lower(player) = 'other' then classement end) as other from ccc_quiz where classement is not null group by 1 ) select * from episodes left join results using (id_episode) order by date desc
Classement
Résultats détaillés. Les quiz en bleu sont jouables en cliquant dessus.
