CLASSIFICACIÓ 10K: ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 VIDIELLA PIÑOL, SANDRA SEN F0011511511511511501151150 805 805
2 PELLICER MARTINEZ, SANDRA VE1 F73858509393857993930 779 706
3 GISBERT TORTA, VERÒNICA VE2 F717375757985757085750 763 622
4 BATALLA DOMINGUEZ, SITA VE2 F8579697975797371000 610 610
5 TURTÓS PALOMA, NÚRIA VE2 F000851030103851031030 582 582
6 ESCUDERO BARBERÀ, CINTA SEN F70707073737571670710 640 573
7 CABALLÉ FABRA, GEMMA SEN F0710696973686975640 558 558
8 FORÉS ESTRADA, IMMA MA1 F62666568680706570690 603 541
9 CABALLÉ FABRA, RAQUEL VE1 F6100676668696673700 540 540
10 SEGURA RIUS, ELENA VE2 F59058666470676871670 590 532
11 FORT RODRIGUEZ, ROSANA VE1 F750939301037900680 511 511
12 ALMEIDA JIMENEZ, MONICA VE2 F5563576462666360000 490 490
13 FERRE GARCIA, NOELIA SEN F0052605863625867620 482 482
14 GONZALEZ SABATE, TRINI MA1 F00500535661570560 333 333
15 MARQUEZ GARCIA, SILVIA VE1 F11510310300000000 321 321
16 MESEGUER CARBÓ, LINA SEN F0064656365064000 321 321
17 GIL CHARRAL, REMEI MA2 F0000546464626600 310 310
18 REDO VIUDEZ, SUSANA VE1 F0645100626600660 309 309
19 PARRAMON SOLER, GEMMA VE2 F656507000006500 265 265
20 ALSO ROIGET, TERE VE1 F93930000075000 261 261
21 MARTÍNEZ ESQUERRÉ, MARIA TERESA VE2 F535905906000000 231 231
22 GIMÉNEZ FERRERES, CLÀUDIA SEN F00680700000790 217 217
23 MONSERRAT MONTAGUT, SÍLVIA VE2 F00550610650000 181 181
24 ALCAZAR GINER, AINHOA S23 F06054000056000 170 170
25 ALIAU CLUA, SANDRA SEN F05500058000530 166 166
26 SANCHO FERRÉ, ANDREA SEN F7975000000000 154 154
27 VINAIXA REY, MONTSERRAT VE1 F0007100000730 144 144
28 COMES I FORASTERO, PILI VE1 F6906700000000 136 136
29 ZARAGOZA GRANELL, SUSANA VE1 F0680065000000 133 133
30 GALVE CURTO, LUCI VE2 F0062000000650 127 127
31 SANCHEZ HURTADO, CARMEN VE2 F6605900000000 125 125
32 LLAMBRICH PARRA, MONICA VE2 F0061620000000 123 123
33 BROUGHTON, BETTINA MA1 F5762000000000 119 119
34 CUÑAT SIMÓN , ENCARNA VE2 F0115000000000 115 115
35 EL BOUHALI, IMANE S23 F0000000115000 115 115
36 GONZALEZ LLOP, MARTA SEN F0006300000520 115 115
37 VALLS RIOS, PATRICIA VE1 F0056057000000 113 113
38 FANDOS COLOMINES, ESTIBALITZ VE1 F0000560000570 113 113
39 DRAGO ROSA, HELENA SEN F1030000000000 103 103
40 GIL CODORNIU, JOANA SEN F0000000103000 103 103
41 MARTINEZ TORREGROSA, OLGA VE2 F0001030000000 103 103
42 BARÓN VILLALBA, ÀNGELA SEN F000000093000 93 93
43 EVERINK, DEBBIE SEN F000000930000 93 93
44 SUBIRATS ABELLA, ANNA SEN F000085000000 85 85
45 CAMAÑES DOMINGO, MARÍA JOSÉ VE2 F000000000850 85 85
46 CALLARISA BEL, CELIA VE1 F007900000000 79 79
47 VERA LUCENA, SUSANA VE2 F000000007900 79 79
48 ROYO DELLA, JUDHIT VE1 F007300000000 73 73
49 ESTEFANIA VAZQUEZ, ESTHER MA1 F000000073000 73 73
50 MILLÁN LARA, SANDRA SEN F000071000000 71 71
51 VERGE ANDRES, SONIA VE2 F007100000000 71 71
52 ACOSTA DORADO, ZAMARA VE1 F000007100000 71 71
53 CASANOVA CALLAU, OLGA S23 F069000000000 69 69
54 MARTI MARTI, BEA SEN F000006900000 69 69
55 FORTUÑO AGUILÓ, JOANA SEN F000000006900 69 69
56 ESTORACH ARASA, MIRIAM VE1 F680000000000 68 68
57 CASANOVA GARRIGÓS, GEORGINA VE1 F000000006800 68 68
58 TORTA, CARME VE1 F670000000000 67 67
59 SORBE CASORRAN, CAROLINA SEN F000067000000 67 67
60 VALLS PEDRET, ISABEL VE1 F067000000000 67 67
61 CALVET PLA, MÒNICA VE1 F000006700000 67 67
62 NAVARRO AMADOR, IMMA VE2 F006600000000 66 66
63 FALCÓN TORMO, EVA VE1 F640000000000 64 64
64 JORNET SABATÉ, MIRIAM SEN F630000000000 63 63
65 BEL POCURULL, SONIA VE1 F006300000000 63 63
66 BARBERA FERRANDO, LAURA VE1 F000000063000 63 63
67 GARCIA FUENTES, ARACELI VE1 F061000000000 61 61
68 SANCHEZ IGLESIAS, MARI VE1 F000006100000 61 61
69 CASES AMAT, MONTSERRAT VE1 F000000061000 61 61
70 ROYO VERGE, JULIA S18 F000000000610 61 61
71 RUIZ SEVILLA, ÀNGELA SEN F000610000000 61 61
72 BERMEJO MULET, MONTSE VE2 F600000000000 60 60
73 RODICIO HERAS, ROSA VE2 F000060000000 60 60
74 GARCIA HOMS, LORENA SEN F006000000000 60 60
75 FABRA DOMÈNECH, IRINA VE2 F000000000600 60 60
76 ABELLA CALDUCH, MARGA VE1 F000059000000 59 59
77 ARMENGOL CASAS, NÚRIA VE2 F000005900000 59 59
78 VILELA ATACHAO, JUDITH VE1 F000000059000 59 59
79 GASCÓ PALAU, SONIA S23 F000000000590 59 59
80 RUIZ MARTINEZ, VANESSA VE1 F580000000000 58 58
81 MONTENEGRO, LÍDIA VE1 F058000000000 58 58
82 ESTELLER BORT, NURIA VE1 F000000000580 58 58
83 BOYER MARGALEF, ALBA SEN F000580000000 58 58
84 SEGARRA MAYO, ANNA SEN F057000000000 57 57
85 VIALA FARRAS , SILVIA VE2 F000005700000 57 57
86 IRIGOYEN GARCIA, SILVIA VE1 F560000000000 56 56
87 REVERTER VILLÁN, ARANTZA S23 F056000000000 56 56
88 GIL CONTRERAS, TANIA SEN F000055000000 55 55
89 SOLER GISBERT, LUJAN VE2 F000000055000 55 55
90 ALCANAR QUERALT, LORENA VE1 F000000000550 55 55
91 IBAÑEZ ARTIGAS, TRINI VE1 F540000000000 54 54
92 BEZBRADICA, EMMA SEN F000000000540 54 54
93 DE LA IGLESIA TUDELA, OLYMPIA VE1 F005300000000 53 53
94 LARA, CLARISA VE1 F520000000000 52 52
95 BLESA RAMÍREZ, NATÀLIA S23 F000052000000 52 52
96 COMÍ CODINA , SÒNIA VE1 F510000000000 51 51
97 SORIANO, EVA VE1 F004900000000 49 49
98 GARCÍA SABATER, RUTH VE1 F004800000000 48 48
99 LLOPIS MONZO, MÓNICA VE1 F004700000000 47 47




Amb el suport de: