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 SUBIRATS ABELLA, ANNA SEN F103859393103000 477 477
2 CASTELLS LOPEZ, SUSANA VE1 F1151031031030000 424 424
3 MARTÍ SOLÉ, RUTH S18 F9373857593000 419 419
4 CÓRDOVA ANDINO , YESENIA VE2 F7075797385000 382 382
5 GALVE CURTO, LUCI VE2 F7570756871000 359 359
6 BRULL ALBIOL, GINA SEN F00115115115000 345 345
7 HERMANO, SORIA VE1 F6968676567000 336 336
8 BIARNÉS JORNET, MªDOLORS VE1 F737973073000 298 298
9 BONET MONTAGUT, MARIA JOSÉ VE1 F5958606160000 298 298
10 GAUXACHS MARGALEF, NURIA VE1 F5051615759000 278 278
11 GONZÁLEZ TEJERO, ANA VE2 F656668066000 265 265
12 GIMÉNEZ FERRERES, CLÀUDIA SEN F85930790000 257 257
13 SÁNCHEZ FIGUERES , MIREIA VE1 F79710068000 218 218
14 AGUILÀ CUBELLS, ANNA SEN F475459058000 218 218
15 FANDOS COLOMINES, ESTIBALIZ VE1 F66656600000 197 197
16 MORALES TOMÀS, PATRICIA VE1 F58570620000 177 177
17 SOLE MONLLAO, NURIA VE1 F05062580000 170 170
18 VALMAÑA CALBET, CINTA SEN F05558560000 169 169
19 ZARAGOZA GRANELL, SUSANA VE1 F0007179000 150 150
20 VICO GIL, EVA MARIA VE1 F43450510000 139 139
21 HERNANDEZ HERRERO, MARTA VE2 F0690069000 138 138
22 JULVE CORNELLES, RAQUEL SEN F0006770000 137 137
23 DE LA IGLESIA TUDELA, OLYMPIA VE1 F6161000000 122 122
24 EL AZZIOUI, HAJAR S23 F0115000000 115 115
25 RODRIGUEZ, KRISTY RENEE VE1 F5659000000 115 115
26 SALES SOLER, PILAR VE2 F5263000000 115 115
27 FRANCH BONET, ROSANA VE1 M5756000000 113 113
28 CUGAT ADELL, GEMMA VE1 F5353000000 106 106
29 NOGALES FORTUM, TERE VE2 F0004957000 106 106
30 ROSA PINEDA, NAGORE SEN F000850000 85 85
31 MELLOR, TRISH MA1 F000075000 75 75
32 GIL MARTI, NEUS VE1 F710000000 71 71
33 GABERNET DIAZ, NURIA VE1 F007100000 71 71
34 LLAMBRICH FERRÉ, LARA S23 F000700000 70 70
35 HOMEDES NADAL , ESMERALDA SEN F007000000 70 70
36 VILLAR SALDAÑA, OLGA SEN F000690000 69 69
37 STIRBA, RUSANDA S23 F006900000 69 69
38 CASANOVA REVERTÉ, JÚLIA S18 F680000000 68 68
39 CASTELBLANQUE SOLER, AIDA SEN F670000000 67 67
40 LEBRON QUEVEDO, PATRICIA VE1 F000660000 66 66
41 FERNANDEZ DE GINZO SOTERAS, ERIKA VE1 F000065000 65 65
42 SAMARRA CAMPOY, SANDRA SEN F006500000 65 65
43 BAGES BANEGAS, SANDRA VE2 F000640000 64 64
44 COTIANA MONTERO, ANNA S18 F064000000 64 64
45 GARCIA LLUIS, IRIS S23 F640000000 64 64
46 AGUEYO BENITO, MILA VE2 F000064000 64 64
47 SANCHEZ IGLESIAS, MARI VE1 F006400000 64 64
48 BUERA, ANDREA SEN F000630000 63 63
49 LABORIA MARGALEF, JOANA VE1 F630000000 63 63
50 SEGURA ESTUPIÑÁ , ESTER VE2 F000063000 63 63
51 CAMPOY BENAIGES, SOL VE2 F006300000 63 63
52 SANCHEZ, JEANNE SEN F062000000 62 62
53 SALVADOR SUTTON, MARIA EUGENIA VE1 F620000000 62 62
54 FUSTER MONTERDE, ELVIRA VE2 F000062000 62 62
55 GARCIA AMELA, BELEN VE2 F000061000 61 61
56 MARTOS REDO , IOLANDA VE1 F000600000 60 60
57 RIBES MONTAÑA, AINA S18 F060000000 60 60
58 BLANQUET BAYERRI, MONTSE VE1 F600000000 60 60
59 HARBUZ, ANCUTA SEN F000590000 59 59
60 ANTO ROMEU, ELI SEN F005700000 57 57
61 SEGURA CASTELLÀ, LIDIA MA1 F000056000 56 56
62 TULIESA GRANELL, MARIA MERCE VE1 F005600000 56 56
63 FERRET MIRALLES, NURIA VE2 F000550000 55 55
64 FORCADELL MONTSERRAT, JESSICA SEN F550000000 55 55
65 CASANOVA FUMADÓ, LAURA SEN F000540000 54 54
66 CUGAT ADELL, MAR VE2 F540000000 54 54
67 MARTÍNEZ METZMEIER, CLOE SEN F000530000 53 53
68 RAMIREZ TORTOSA, NURI VE2 F000520000 52 52
69 COTAINA GILABERT, ELISABET SEN F052000000 52 52
70 MESTRE GARCIA, ROSA MARIA VE1 F510000000 51 51
71 ARASA CID, EUGÈNIA VE2 F000500000 50 50
72 BORRAS MARGALEF, CRISTINA VE1 F049000000 49 49
73 MONSÓ LAMELAS, NOEMI VE1 F490000000 49 49
74 GASHI, MIRJETA SEN F000480000 48 48
75 DE COLSA LORENZO, ROSA VE1 F048000000 48 48
76 VERNAT GARRIGA, GEMMA S23 F480000000 48 48
77 TOMAS ALVAREZ, ANDREA S18 F000470000 47 47
78 SCIORA, CORINNE VE2 F047000000 47 47
79 POUS CID, SANDRA SEN F000460000 46 46
80 PÉREZ MÁRQUEZ, JÉSSICA SEN F046000000 46 46
81 GARRIGA BALAGUÉ, NOELIA VE1 F460000000 46 46
82 CURTO QUERALT, NEUS SEN F000450000 45 45
83 VILANOVA RODRIGUEZ, SONIA VE2 F450000000 45 45
84 JUAN ALONSO, MARGARITA MA2 F044000000 44 44
85 CECÍLIA GALLEGO , SUSANNA VE1 F440000000 44 44
86 BOSCH MONTAÑES, NURIA VE1 F420000000 42 42
87 CARTOIXÀ BENAIGES, CINTA SEN F410000000 41 41
88 GONZÀLEZ GARRIGA, ARIADNA SEN F400000000 40 40




Amb el suport de: