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. AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 BRULL ALBIOL, GINA SEN F001151151151151150 575 575
2 CASTELLS LOPEZ, SUSANA VE1 F115103103103093103115 735 539
3 SUBIRATS ABELLA, ANNA SEN F103859393103859393 748 500
4 MARTÍ SOLÉ, RUTH S18 F9373857593697585 648 446
5 GIMÉNEZ FERRERES, CLÀUDIA SEN F859307907985103 524 445
6 CÓRDOVA ANDINO , YESENIA VE2 F7075797385707979 610 412
7 BIARNÉS JORNET, MªDOLORS VE1 F737973073666971 504 369
8 GALVE CURTO, LUCI VE2 F757075687107173 503 365
9 HERMANO, SORIA VE1 F6968676567636266 527 352
10 JULVE CORNELLES, RAQUEL SEN F0006770687068 343 343
11 GONZÁLEZ TEJERO, ANA VE2 F6566680660069 334 334
12 BONET MONTAGUT, MARIA JOSÉ VE1 F5958606160000 298 298
13 GAUXACHS MARGALEF, NURIA VE1 F50516157590064 342 292
14 SÁNCHEZ FIGUERES , MIREIA VE1 F797100686700 285 285
15 HERNANDEZ HERRERO, MARTA VE2 F069006906675 279 279
16 AGUILÀ CUBELLS, ANNA SEN F4754590585000 268 268
17 SOLE MONLLAO, NURIA VE1 F050625800067 237 237
18 FANDOS COLOMINES, ESTIBALIZ VE1 F66656600000 197 197
19 BUERA ALBALAT, ANDREA SEN F00063065630 191 191
20 MORALES TOMÀS, PATRICIA VE1 F58570620000 177 177
21 VALMAÑA CALBET, CINTA SEN F05558560000 169 169
22 ZARAGOZA GRANELL, SUSANA VE1 F0007179000 150 150
23 VICO GIL, EVA MARIA VE1 F43450510000 139 139
24 CALVO CODORNIU, NÚRIA VE1 F0000064670 131 131
25 DE LA IGLESIA TUDELA, OLYMPIA VE1 F6161000000 122 122
26 EL AZZIOUI, HAJAR S23 F0115000000 115 115
27 RODRIGUEZ, KRISTY RENEE VE1 F5659000000 115 115
28 SALES SOLER, PILAR VE2 F5263000000 115 115
29 FRANCH BONET, ROSANA VE1 M5756000000 113 113
30 NAVARRO CURTO, TERE VE1 F0000047600 107 107
31 CUGAT ADELL, GEMMA VE1 F5353000000 106 106
32 NOGALES FORTUM, TERE VE2 F0004957000 106 106
33 EL AZZIOUI, HAJAR S23 F0000010300 103 103
34 POUS CID, SANDRA SEN F0004600570 103 103
35 ROSA PINEDA, NAGORE SEN F000850000 85 85
36 MAURI GINOVART, NEUS SEN F000007500 75 75
37 MELLOR, TRISH MA1 F000075000 75 75
38 CRUZ TOMÀS, HERENIA SEN F000007300 73 73
39 MASIA ADELL, ALBA SEN F000000730 73 73
40 ANFRUNS GUTIÉRREZ, NÚRIA VE1 F000007100 71 71
41 GIL MARTI, NEUS VE1 F710000000 71 71
42 GABERNET DIAZ, NURIA VE1 F007100000 71 71
43 LLAMBRICH FERRÉ, LARA S23 F000700000 70 70
44 HOMEDES NADAL , ESMERALDA SEN F007000000 70 70
45 RODRIGUEZ SALVADO, ANNA SEN F000000070 70 70
46 VILLAR SALDAÑA, OLGA SEN F000690000 69 69
47 STIRBA, RUSANDA S23 F006900000 69 69
48 CASANOVA REVERTÉ, JÚLIA S18 F680000000 68 68
49 BELTRAN ROIG, NÚRIA VE1 F000000680 68 68
50 CASTELBLANQUE SOLER, AIDA SEN F670000000 67 67
51 LEBRON QUEVEDO, PATRICIA VE1 F000660000 66 66
52 ALSO ANDRADE, ROSA MARIA VE1 F000000650 65 65
53 FERNANDEZ DE GINZO SOTERAS, ERIKA VE1 F000065000 65 65
54 SAMARRA CAMPOY, SANDRA SEN F006500000 65 65
55 MONTOYA CUGAT, MINERVA SEN F000000065 65 65
56 BAGES BANEGAS, SANDRA VE2 F000640000 64 64
57 COTIANA MONTERO, ANNA S18 F064000000 64 64
58 GARCIA LLUIS, IRIS S23 F640000000 64 64
59 VIUDEZ SORIA, NEREA SEN F000000640 64 64
60 AGUEYO BENITO, MILA VE2 F000064000 64 64
61 SANCHEZ IGLESIAS, MARI VE1 F006400000 64 64
62 LABORIA MARGALEF, JOANA VE1 F630000000 63 63
63 SEGURA ESTUPIÑÁ , ESTER VE2 F000063000 63 63
64 CAMPOY BENAIGES, SOL VE2 F006300000 63 63
65 BROUGHTON, BETTINA MA1 F000000063 63 63
66 LÓPEZ MATA, MONTSERRAT SEN F000006200 62 62
67 SANCHEZ, JEANNE SEN F062000000 62 62
68 SALVADOR SUTTON, MARIA EUGENIA VE1 F620000000 62 62
69 FUSTER MONTERDE, ELVIRA VE2 F000062000 62 62
70 DIEGO BOSCH, CINTA VE1 F000006100 61 61
71 CARLES BERTOMEU, RAQUEL SEN F000000610 61 61
72 GARCIA AMELA, BELEN VE2 F000061000 61 61
73 MARTOS REDO , IOLANDA VE1 F000600000 60 60
74 GIL VICO, DOLORS VE1 F000006000 60 60
75 RIBES MONTAÑA, AINA S18 F060000000 60 60
76 BLANQUET BAYERRI, MONTSE VE1 F600000000 60 60
77 HARBUZ, ANCUTA SEN F000590000 59 59
78 MARTÍN GALLEGO, MARIA S23 F000005900 59 59
79 AGRAMUNT FABRA, SANDRA VE2 F000000590 59 59
80 RODRÍGUEZ BOTELLA, VANESA VE1 F000005800 58 58
81 PULIDO MOLINA, REBECA VE1 F000000580 58 58
82 BLANCH RUBERT, NOELIA SEN F000005700 57 57
83 ANTO ROMEU, ELI SEN F005700000 57 57
84 ESCURRIOLA RODRIGEZ, JOANA S23 F000005600 56 56
85 CURTO QUERAL, NEUS SEN F000000560 56 56
86 SEGURA CASTELLÀ, LIDIA MA1 F000056000 56 56
87 TULIESA GRANELL, MARIA MERCE VE1 F005600000 56 56
88 FERRET MIRALLES, NURIA VE2 F000550000 55 55
89 GAMBIN CARRANDE, ELISABET SEN F000005500 55 55
90 FORCADELL MONTSERRAT, JESSICA SEN F550000000 55 55
91 CASANOVA FUMADÓ, LAURA SEN F000540000 54 54
92 MAYOR ROIG, ZORAIDA VE1 F000005400 54 54
93 CUGAT ADELL, MAR VE2 F540000000 54 54
94 MARTÍNEZ METZMEIER, CLOE SEN F000530000 53 53
95 BONFILL VIÑA, JOSEFA VE2 F000005300 53 53
96 RAMIREZ TORTOSA, NURI VE2 F000520000 52 52
97 MONCADA SANZ, SONIA SEN F000005200 52 52
98 COTAINA GILABERT, ELISABET SEN F052000000 52 52
99 MASIP SABATÉ, MAITE VE2 F000005100 51 51
100 MESTRE GARCIA, ROSA MARIA VE1 F510000000 51 51
101 ARASA CID, EUGÈNIA VE2 F000500000 50 50
102 RECIO PRIETO, EMILIA RECIO PRIETO VE2 F000004900 49 49
103 BORRAS MARGALEF, CRISTINA VE1 F049000000 49 49
104 MONSÓ LAMELAS, NOEMI VE1 F490000000 49 49
105 GASHI, MIRJETA SEN F000480000 48 48
106 VILELA CHONG, VALERIA S23 F000004800 48 48
107 DE COLSA LORENZO, ROSA VE1 F048000000 48 48
108 VERNAT GARRIGA, GEMMA S23 F480000000 48 48
109 TOMAS ALVAREZ, ANDREA S18 F000470000 47 47
110 SCIORA, CORINNE VE2 F047000000 47 47
111 ARCE RECATALA, CRISTINA SEN F000004600 46 46
112 PÉREZ MÁRQUEZ, JÉSSICA SEN F046000000 46 46
113 GARRIGA BALAGUÉ, NOELIA VE1 F460000000 46 46
114 CURTO QUERALT, NEUS SEN F000450000 45 45
115 TRIGO ALEIXENDRI, ANA SEN F000004500 45 45
116 VILANOVA RODRIGUEZ, SONIA VE2 F450000000 45 45
117 SUBIRATS BERMUDEZ, NEUS VE1 F000004400 44 44
118 JUAN ALONSO, MARGARITA MA2 F044000000 44 44
119 CECÍLIA GALLEGO , SUSANNA VE1 F440000000 44 44
120 BOSCH MONTAÑES, NURIA VE1 F420000000 42 42
121 CARTOIXÀ BENAIGES, CINTA SEN F410000000 41 41
122 GONZÀLEZ GARRIGA, ARIADNA SEN F400000000 40 40




Amb el suport de: