CLASSIFICACIÓ 5K: SÈNIOR FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic5 WHERE categoria="SEN F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaTivenysEl PerellóS.BàrbaraCamarlesBateaDeltebreJesúsL'Aldea Total Punts
1 GIMÉNEZ FERRERES, CLÀUDIA 11511500000000 230 230
2 FERRÉ ESMEL, CLÀUDIA 10310300000000 206 206
3 RODRIGUEZ SALVADO, ANNA 939300000000 186 186
4 SANCHEZ CALVO, LAURIE 797900000000 158 158
5 ESTRADA, REBECA 687300000000 141 141
6 GALLARDO GÜELL, SÒNIA 08500000000 85 85
7 JORNET SABATÉ, MIRIAM 85000000000 85 85
8 BLANCH RUBERT, NOELIA 07500000000 75 75
9 BONFILL CERVERO, AIDA 75000000000 75 75
10 BONFILL CERVERÓ, CARLA 73000000000 73 73
11 NAVARRO FRANCH, CARINA 07100000000 71 71
12 CASTELBLANQUE SOLER, AIDA 71000000000 71 71
13 BO CABRERA, MARTA 07000000000 70 70
14 GARRIGA BALAGUÉ , MARIA 70000000000 70 70
15 VILLARROYA LLUCH, NURIA 06900000000 69 69
16 FORTUÑO, OFRA 69000000000 69 69
17 AGUILÀ CUBELLS, ANNA 06800000000 68 68
18 ALTABA RABAZA, BELÉN 06700000000 67 67
19 COLOMINES GARCIA, LARA 06600000000 66 66




Amb el suport de: