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 where _deleted_at is null ), 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 != '' ), episodes as ( select id as episode_id, date as episode_date from ccc_episodes where _deleted_at is null ) select name_fixed.rider, count(name_fixed.rider) as total_used, max(name_fixed.synced_at) as latest_date, max(episodes.episode_date) as latest_episode from name_fixed left join episodes on name_fixed.episode = episodes.episode_id group by 1
with riders as ( select rider_53 as rider, synced_at, episode from ccc_results where _deleted_at is null ), 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 != '' ), episodes as ( select id as episode_id, date as episode_date from ccc_episodes where _deleted_at is null ) select name_fixed.rider, count(name_fixed.rider) as total_used, max(name_fixed.synced_at) as latest_date, max(episodes.episode_date) as latest_episode from name_fixed left join episodes on name_fixed.episode = episodes.episode_id group by 1
with riders as ( select rider_macfly as rider, synced_at, episode from ccc_results where _deleted_at is null ), 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 != '' ), episodes as ( select id as episode_id, date as episode_date from ccc_episodes where _deleted_at is null ) select name_fixed.rider, count(name_fixed.rider) as total_used, max(name_fixed.synced_at) as latest_date, max(episodes.episode_date) as latest_episode from name_fixed left join episodes on name_fixed.episode = episodes.episode_id group by 1