Participants 2014 - Participants 2015 - Participants 2019

Participants inscrit au Marathon Blainville 2015

Inscriptions pour le triathlon roller / vélo / course

 select m.ville as ville_membre, p.*,FLOOR(DATEDIFF(CURDATE(),p.date_naissance) / 365)  as age, a.nom_fr as nom_cat
						from patineur as p,  item as i, groupe_age as a, membre as m, commande, epreuve as e
						where p.supprimer = 'non'
						and m.id = p.id_membre
						and e.id = i.id_epreuve
						and a.id = p.id_groupe_age
						and p.id = i.id_patineur
						and commande.id = i.id_commande
						and commande.id_competition = '5'
						
						 and e.distance_tri = 'oui' 
						
						
						order by p.date_naissance desc