Voir les chouchoutes de: Cactus | 53x12 | MacFly
Les chouchoutes de Cactus
with riders as ( select rider_cactus as rider, synced_at, episode from ccc_results ), name_fixed as ( select case when rider = 'Agua Maria Espinola' then 'Agua Marina Espinola' when rider = 'Alicia Gonzalez Blanco' then 'Alicia Gonzalez' when rider = 'Charlotte Broughton' then 'Charlotte Broughton Kulset' when rider = 'Chacha Broughton' then 'Charlotte Broughton Kulset' when rider = 'Kiw Cadzow' then 'Kim Cadzow' when rider = 'Kimmy Cadzow' then 'Kim Cadzow' when rider = 'Juju Labous' then 'Juliette Labous' when rider = 'Anto Niedermaier' then 'Antonia Niedermaier' when rider = 'Puckyy' then 'Puck Pieterse' when rider = 'Pucky Pieterse' then 'Puck Pieterse' when rider = 'RieRie Markus' then 'Riejanne Markus' when rider = 'Rierie Markus' then 'Riejanne Markus' when rider = 'Riri Nieuwenhuis' then 'Rianne Nieuwenhuis' when rider = 'Maumau Trégouët' then 'Maurène Trégouët' when rider = 'Momo Trégouët' then 'Maurène Trégouët' when rider = 'Sabri Stultiens' then 'Sabrina Stultiens' else rider end as rider, synced_at, episode from riders where rider != '' and rider != '' ) select rider, count(*) as total_used, max(synced_at) as latest_date, max(ccc_episodes.date) as latest_episode from name_fixed left join ccc_episodes on name_fixed.episode = ccc_episodes.id group by 1
with riders as ( select rider_53 as rider, synced_at, episode from ccc_results ), name_fixed as ( select case when rider = 'Agua Maria Espinola' then 'Agua Marina Espinola' when rider = 'Alicia Gonzalez Blanco' then 'Alicia Gonzalez' when rider = 'Charlotte Broughton' then 'Charlotte Broughton Kulset' when rider = 'Chacha Broughton' then 'Charlotte Broughton Kulset' when rider = 'Kiw Cadzow' then 'Kim Cadzow' when rider = 'Kimmy Cadzow' then 'Kim Cadzow' when rider = 'Juju Labous' then 'Juliette Labous' when rider = 'Anto Niedermaier' then 'Antonia Niedermaier' when rider = 'Puckyy' then 'Puck Pieterse' when rider = 'Pucky Pieterse' then 'Puck Pieterse' when rider = 'RieRie Markus' then 'Riejanne Markus' when rider = 'Rierie Markus' then 'Riejanne Markus' when rider = 'Riri Nieuwenhuis' then 'Rianne Nieuwenhuis' when rider = 'Maumau Trégouët' then 'Maurène Trégouët' when rider = 'Momo Trégouët' then 'Maurène Trégouët' when rider = 'Sabri Stultiens' then 'Sabrina Stultiens' else rider end as rider, synced_at, episode from riders where rider != '' and rider != '' ) select rider, count(*) as total_used, max(synced_at) as latest_date, max(ccc_episodes.date) as latest_episode from name_fixed left join ccc_episodes on name_fixed.episode = ccc_episodes.id group by 1
with riders as ( select rider_macfly as rider, synced_at, episode from ccc_results ), name_fixed as ( select case when rider = 'Agua Maria Espinola' then 'Agua Marina Espinola' when rider = 'Alicia Gonzalez Blanco' then 'Alicia Gonzalez' when rider = 'Charlotte Broughton' then 'Charlotte Broughton Kulset' when rider = 'Chacha Broughton' then 'Charlotte Broughton Kulset' when rider = 'Kiw Cadzow' then 'Kim Cadzow' when rider = 'Kimmy Cadzow' then 'Kim Cadzow' when rider = 'Juju Labous' then 'Juliette Labous' when rider = 'Anto Niedermaier' then 'Antonia Niedermaier' when rider = 'Puckyy' then 'Puck Pieterse' when rider = 'Pucky Pieterse' then 'Puck Pieterse' when rider = 'RieRie Markus' then 'Riejanne Markus' when rider = 'Rierie Markus' then 'Riejanne Markus' when rider = 'Riri Nieuwenhuis' then 'Rianne Nieuwenhuis' when rider = 'Maumau Trégouët' then 'Maurène Trégouët' when rider = 'Momo Trégouët' then 'Maurène Trégouët' when rider = 'Sabri Stultiens' then 'Sabrina Stultiens' else rider end as rider, synced_at, episode from riders where rider != '' and rider != '' ) select rider, count(*) as total_used, max(synced_at) as latest_date, max(ccc_episodes.date) as latest_episode from name_fixed left join ccc_episodes on name_fixed.episode = ccc_episodes.id group by 1