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 F1151031031030931030 620 527
3 SUBIRATS ABELLA, ANNA SEN F10385939310385930 655 485
4 GIMÉNEZ FERRERES, CLÀUDIA SEN F8593079079850 421 421
5 MARTÍ SOLÉ, RUTH S18 F937385759369750 563 421
6 CÓRDOVA ANDINO , YESENIA VE2 F707579738570790 531 391
7 BIARNÉS JORNET, MªDOLORS VE1 F73797307366690 433 367
8 GALVE CURTO, LUCI VE2 F75707568710710 430 362
9 HERMANO, SORIA VE1 F696867656763620 461 336
10 BONET MONTAGUT, MARIA JOSÉ VE1 F5958606160000 298 298
11 SÁNCHEZ FIGUERES , MIREIA VE1 F797100686700 285 285
12 GAUXACHS MARGALEF, NURIA VE1 F5051615759000 278 278
13 JULVE CORNELLES, RAQUEL SEN F000677068700 275 275
14 AGUILÀ CUBELLS, ANNA SEN F4754590585000 268 268
15 GONZÁLEZ TEJERO, ANA VE2 F656668066000 265 265
16 HERNANDEZ HERRERO, MARTA VE2 F06900690660 204 204
17 FANDOS COLOMINES, ESTIBALIZ VE1 F66656600000 197 197
18 BUERA ALBALAT, ANDREA SEN F00063065630 191 191
19 MORALES TOMÀS, PATRICIA VE1 F58570620000 177 177
20 SOLE MONLLAO, NURIA VE1 F05062580000 170 170
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 VILLAR SALDAÑA, OLGA SEN F000690000 69 69
46 STIRBA, RUSANDA S23 F006900000 69 69
47 CASANOVA REVERTÉ, JÚLIA S18 F680000000 68 68
48 BELTRAN ROIG, NÚRIA VE1 F000000680 68 68
49 CASTELBLANQUE SOLER, AIDA SEN F670000000 67 67
50 LEBRON QUEVEDO, PATRICIA VE1 F000660000 66 66
51 ALSO ANDRADE, ROSA MARIA VE1 F000000650 65 65
52 FERNANDEZ DE GINZO SOTERAS, ERIKA VE1 F000065000 65 65
53 SAMARRA CAMPOY, SANDRA SEN F006500000 65 65
54 BAGES BANEGAS, SANDRA VE2 F000640000 64 64
55 COTIANA MONTERO, ANNA S18 F064000000 64 64
56 GARCIA LLUIS, IRIS S23 F640000000 64 64
57 VIUDEZ SORIA, NEREA SEN F000000640 64 64
58 AGUEYO BENITO, MILA VE2 F000064000 64 64
59 SANCHEZ IGLESIAS, MARI VE1 F006400000 64 64
60 LABORIA MARGALEF, JOANA VE1 F630000000 63 63
61 SEGURA ESTUPIÑÁ , ESTER VE2 F000063000 63 63
62 CAMPOY BENAIGES, SOL VE2 F006300000 63 63
63 LÓPEZ MATA, MONTSERRAT SEN F000006200 62 62
64 SANCHEZ, JEANNE SEN F062000000 62 62
65 SALVADOR SUTTON, MARIA EUGENIA VE1 F620000000 62 62
66 FUSTER MONTERDE, ELVIRA VE2 F000062000 62 62
67 DIEGO BOSCH, CINTA VE1 F000006100 61 61
68 CARLES BERTOMEU, RAQUEL SEN F000000610 61 61
69 GARCIA AMELA, BELEN VE2 F000061000 61 61
70 MARTOS REDO , IOLANDA VE1 F000600000 60 60
71 GIL VICO, DOLORS VE1 F000006000 60 60
72 RIBES MONTAÑA, AINA S18 F060000000 60 60
73 BLANQUET BAYERRI, MONTSE VE1 F600000000 60 60
74 HARBUZ, ANCUTA SEN F000590000 59 59
75 MARTÍN GALLEGO, MARIA S23 F000005900 59 59
76 AGRAMUNT FABRA, SANDRA VE2 F000000590 59 59
77 RODRÍGUEZ BOTELLA, VANESA VE1 F000005800 58 58
78 PULIDO MOLINA, REBECA VE1 F000000580 58 58
79 BLANCH RUBERT, NOELIA SEN F000005700 57 57
80 ANTO ROMEU, ELI SEN F005700000 57 57
81 ESCURRIOLA RODRIGEZ, JOANA S23 F000005600 56 56
82 CURTO QUERAL, NEUS SEN F000000560 56 56
83 SEGURA CASTELLÀ, LIDIA MA1 F000056000 56 56
84 TULIESA GRANELL, MARIA MERCE VE1 F005600000 56 56
85 FERRET MIRALLES, NURIA VE2 F000550000 55 55
86 GAMBIN CARRANDE, ELISABET SEN F000005500 55 55
87 FORCADELL MONTSERRAT, JESSICA SEN F550000000 55 55
88 CASANOVA FUMADÓ, LAURA SEN F000540000 54 54
89 MAYOR ROIG, ZORAIDA VE1 F000005400 54 54
90 CUGAT ADELL, MAR VE2 F540000000 54 54
91 MARTÍNEZ METZMEIER, CLOE SEN F000530000 53 53
92 BONFILL VIÑA, JOSEFA VE2 F000005300 53 53
93 RAMIREZ TORTOSA, NURI VE2 F000520000 52 52
94 MONCADA SANZ, SONIA SEN F000005200 52 52
95 COTAINA GILABERT, ELISABET SEN F052000000 52 52
96 MASIP SABATÉ, MAITE VE2 F000005100 51 51
97 MESTRE GARCIA, ROSA MARIA VE1 F510000000 51 51
98 ARASA CID, EUGÈNIA VE2 F000500000 50 50
99 RECIO PRIETO, EMILIA RECIO PRIETO VE2 F000004900 49 49
100 BORRAS MARGALEF, CRISTINA VE1 F049000000 49 49
101 MONSÓ LAMELAS, NOEMI VE1 F490000000 49 49
102 GASHI, MIRJETA SEN F000480000 48 48
103 VILELA CHONG, VALERIA S23 F000004800 48 48
104 DE COLSA LORENZO, ROSA VE1 F048000000 48 48
105 VERNAT GARRIGA, GEMMA S23 F480000000 48 48
106 TOMAS ALVAREZ, ANDREA S18 F000470000 47 47
107 SCIORA, CORINNE VE2 F047000000 47 47
108 ARCE RECATALA, CRISTINA SEN F000004600 46 46
109 PÉREZ MÁRQUEZ, JÉSSICA SEN F046000000 46 46
110 GARRIGA BALAGUÉ, NOELIA VE1 F460000000 46 46
111 CURTO QUERALT, NEUS SEN F000450000 45 45
112 TRIGO ALEIXENDRI, ANA SEN F000004500 45 45
113 VILANOVA RODRIGUEZ, SONIA VE2 F450000000 45 45
114 SUBIRATS BERMUDEZ, NEUS VE1 F000004400 44 44
115 JUAN ALONSO, MARGARITA MA2 F044000000 44 44
116 CECÍLIA GALLEGO , SUSANNA VE1 F440000000 44 44
117 BOSCH MONTAÑES, NURIA VE1 F420000000 42 42
118 CARTOIXÀ BENAIGES, CINTA SEN F410000000 41 41
119 GONZÀLEZ GARRIGA, ARIADNA SEN F400000000 40 40




Amb el suport de: