CLASSIFICACIÓ 5K: ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. AmpostaAmpollaTivenysEl PerellóS.BàrbaraCamarlesBateaDeltebreJesúsL'Aldea Total Punts
1 MARTÍ SOLÉ, RUTH S18 F11511500000000 230 230
2 GIMÉNEZ FERRERES, CLÀUDIA SEN F9310300000000 196 196
3 FERRÉ ESMEL, CLÀUDIA SEN F759300000000 168 168
4 RODRIGUEZ SALVADO, ANNA SEN F738500000000 158 158
5 GALVE CURTO, LUCI VE2 F677900000000 146 146
6 LLEIXÀ GISBERT, ARES. S18 F707300000000 143 143
7 GIL CHARRAL, REMEI MA2 F687100000000 139 139
8 SANCHEZ CALVO, LAURIE SEN F626900000000 131 131
9 SÁNCHEZ FIGUERES, MIREIA VE1 F636500000000 128 128
10 SALES SOLER, PILAR VE2 F596800000000 127 127
11 FERNANDEZ DE GINZO SOTERAS, ERIKA VE1 F556700000000 122 122
12 GAUXACHS MARGALEF, NURIA. VE1 F586200000000 120 120
13 GUZMAN MARCO, NEUS. MA1 F566100000000 117 117
14 SANCHEZ IGLESIAS, MARI VE1 F545700000000 111 111
15 ESTRADA, REBECA SEN F465900000000 105 105
16 BROUGHTON, BETTINA MA1 F515300000000 104 104
17 MARTINEZ TORREGROSA, OLGA VE2 F103000000000 103 103
18 FRANCH BONET, ROSANA VE1 F505000000000 100 100
19 LACALLE IGLESIAS, MAITANE S18 F455200000000 97 97
20 MARTI CARDONA, MÍRIAM VE1 F85000000000 85 85
21 OBIOL ESPELTA, VALLIVANA VE1 F414200000000 83 83
22 ALIFONSO SORRIBES, ESTEFANIA VE1 F404300000000 83 83
23 HERNANDEZ HERRERO, MARTA VE2 F79000000000 79 79
24 GALLARDO GÜELL, SÒNIA SEN F07500000000 75 75
25 LLUÍS GINOVART, LAURA S18 F71000000000 71 71
26 VIZCAINO ROMERO, YOLANDA. VE1 F07000000000 70 70
27 ARASA CID, CHLOE S18 F69000000000 69 69
28 DE MAS ARIZA, ANDREA S23 F06600000000 66 66
29 JORNET SABATÉ, MIRIAM SEN F66000000000 66 66
30 ALMEIDA JIMENEZ, MONICA VE2 F65000000000 65 65
31 MARTOS REDO , IOLANDA VE1 F06400000000 64 64
32 SANS CUCALA, MERCÈ VE1 F64000000000 64 64
33 SOLE MONLLAO, NURIA. VE1 F06300000000 63 63
34 BONFILL CERVERO, AIDA SEN F61000000000 61 61
35 BLANCH RUBERT, NOELIA SEN F06000000000 60 60
36 BONFILL CERVERÓ, CARLA SEN F60000000000 60 60
37 NAVARRO FRANCH, CARINA SEN F05800000000 58 58
38 JUAN GIL, MIREIA VE1 F57000000000 57 57
39 BO CABRERA, MARTA SEN F05600000000 56 56
40 PRADES, LAURA S23 F05500000000 55 55
41 LUNGU, STEFANIA S23 F05400000000 54 54
42 CASTELBLANQUE SOLER, AIDA SEN F53000000000 53 53
43 GARRIGA BALAGUÉ , MARIA SEN F52000000000 52 52
44 VILLARROYA LLUCH, NURIA SEN F05100000000 51 51
45 PULIDO MOLINA, REBECA VE1 F04900000000 49 49
46 GARRIGA BALAGUÉ, NOELIA VE1 F49000000000 49 49
47 AGUILÀ CUBELLS, ANNA SEN F04800000000 48 48
48 MORENO GARCÍA, SOFÍA VE2 F48000000000 48 48
49 ALTABA RABAZA, BELÉN SEN F04700000000 47 47
50 FORTUÑO, OFRA SEN F47000000000 47 47
51 ANDRES BRULL, MARINA VE1 F04600000000 46 46
52 JUAN ALONSO, MARGARITA MA2 F04500000000 45 45
53 UNITT, SUSAN MA1 F04400000000 44 44
54 GILABERT PITARCH, MARIA JOSE VE1 F44000000000 44 44
55 ROCA MICHIELS, ESTEFANIA VE1 F43000000000 43 43
56 MARTORELL LOPEZ, ELENA VE2 F42000000000 42 42
57 COLOMINES GARCIA, LARA SEN F04100000000 41 41




Amb el suport de: