[gdoc key= »wordpress » class= »FixedHeader » datatables_ordering= »true » datatables_paging= »false » query= »select CONCAT(‘%3Ca href= participants/’,U.user_nicename,’%3E’,U.display_name,’%3C/a%3E’) as Participant, G.name as Equipe, user_age as Age, STATS.user_level as Niveau, CASE WHEN STATS.user_level=’Cycliste novice’ AND STATS.day_count %3E= 2 OR STATS.user_level=’Cycliste occasionnel’ AND STATS.day_count %3E= 4 OR STATS.user_level=’Cycliste régulier’ AND STATS.day_count %3E= 6 THEN ‘Défi relevé!’ ELSE ‘Encore un effort’ END AS ‘Défi’, coalesce(STATS.day_count, 0) as nb_jours from quimper_users U left join quimper_bp_groups_members GM on GM.user_id = U.ID left join quimper_bp_groups G on G.id = GM.group_id left join qpr_stats_tirage1_20 STATS on STATS.user_id = U.ID where STATS.user_level=’Cycliste novice’ AND STATS.day_count %3E= 2 OR STATS.user_level=’Cycliste occasionnel’ AND STATS.day_count %3E= 4 OR STATS.user_level=’Cycliste régulier’ AND STATS.day_count %3E= 6″]