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 F001151151151151150115115115 920 920
2 PELLICER MARTINEZ, SANDRA VE1 F738585093938579939393 872 720
3 GISBERT TORTA, VERÒNICA VE2 F7173757579857570857585 848 649
4 BATALLA DOMINGUEZ, SITA VE2 F8579697975797371000 610 610
5 FORT RODRIGUEZ, ROSANA VE1 F7509393010379006879 590 590
6 TURTÓS PALOMA, NÚRIA VE2 F000851030103851031030 582 582
7 ESCUDERO BARBERÀ, CINTA SEN F70707073737571670710 640 573
8 CABALLÉ FABRA, GEMMA SEN F07106969736869756475 633 569
9 CABALLÉ FABRA, RAQUEL VE1 F61006766686966737073 613 552
10 FORÉS ESTRADA, IMMA MA1 F626665686807065706968 671 544
11 SEGURA RIUS, ELENA VE2 F590586664706768716770 660 543
12 ALMEIDA JIMENEZ, MONICA VE2 F55635764626663600065 555 500
13 FERRE GARCIA, NOELIA SEN F0052605863625867620 482 482
14 GIL CHARRAL, REMEI MA2 F000054646462666362 435 435
15 REDO VIUDEZ, SUSANA VE1 F06451006266006666 375 375
16 GONZALEZ SABATE, TRINI MA1 F00500535661570560 333 333
17 MARQUEZ GARCIA, SILVIA VE1 F11510310300000000 321 321
18 MESEGUER CARBÓ, LINA SEN F0064656365064000 321 321
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 ALIAU CLUA, SANDRA SEN F055000580005364 230 230
23 GIMÉNEZ FERRERES, CLÀUDIA SEN F00680700000790 217 217
24 GIL CODORNIU, JOANA SEN F000000010300103 206 206
25 SANCHEZ HURTADO, CARMEN VE2 F66059000000067 192 192
26 MONSERRAT MONTAGUT, SÍLVIA VE2 F00550610650000 181 181
27 ALCAZAR GINER, AINHOA S23 F06054000056000 170 170
28 SANCHO FERRÉ, ANDREA SEN F7975000000000 154 154
29 VINAIXA REY, MONTSERRAT VE1 F0007100000730 144 144
30 NAVARRO AMADOR, IMMA VE2 F0066000000071 137 137
31 COMES I FORASTERO, PILI VE1 F6906700000000 136 136
32 ZARAGOZA GRANELL, SUSANA VE1 F0680065000000 133 133
33 GALVE CURTO, LUCI VE2 F0062000000650 127 127
34 LLAMBRICH PARRA, MONICA VE2 F0061620000000 123 123
35 BROUGHTON, BETTINA MA1 F5762000000000 119 119
36 CUÑAT SIMÓN , ENCARNA VE2 F0115000000000 115 115
37 EL BOUHALI, IMANE S23 F0000000115000 115 115
38 GONZALEZ LLOP, MARTA SEN F0006300000520 115 115
39 VALLS RIOS, PATRICIA VE1 F0056057000000 113 113
40 FANDOS COLOMINES, ESTIBALITZ VE1 F0000560000570 113 113
41 DRAGO ROSA, HELENA SEN F1030000000000 103 103
42 MARTINEZ TORREGROSA, OLGA VE2 F0001030000000 103 103
43 BARÓN VILLALBA, ÀNGELA SEN F000000093000 93 93
44 EVERINK, DEBBIE SEN F000000930000 93 93
45 SUBIRATS ABELLA, ANNA SEN F000085000000 85 85
46 CAMAÑES DOMINGO, MARÍA JOSÉ VE2 F000000000850 85 85
47 CALLARISA BEL, CELIA VE1 F007900000000 79 79
48 VERA LUCENA, SUSANA VE2 F000000007900 79 79
49 ROYO DELLA, JUDHIT VE1 F007300000000 73 73
50 ESTEFANIA VAZQUEZ, ESTHER MA1 F000000073000 73 73
51 MILLÁN LARA, SANDRA SEN F000071000000 71 71
52 VERGE ANDRES, SONIA VE2 F007100000000 71 71
53 ACOSTA DORADO, ZAMARA VE1 F000007100000 71 71
54 CASANOVA CALLAU, OLGA S23 F069000000000 69 69
55 MARTI MARTI, BEA SEN F000006900000 69 69
56 ROMANI GUART, MONTSE VE1 F000000000069 69 69
57 FORTUÑO AGUILÓ, JOANA SEN F000000006900 69 69
58 ESTORACH ARASA, MIRIAM VE1 F680000000000 68 68
59 CASANOVA GARRIGÓS, GEORGINA VE1 F000000006800 68 68
60 TORTA, CARME VE1 F670000000000 67 67
61 SORBE CASORRAN, CAROLINA SEN F000067000000 67 67
62 VALLS PEDRET, ISABEL VE1 F067000000000 67 67
63 CALVET PLA, MÒNICA VE1 F000006700000 67 67
64 FALCÓN TORMO, EVA VE1 F640000000000 64 64
65 JORNET SABATÉ, MIRIAM SEN F630000000000 63 63
66 BEL POCURULL, SONIA VE1 F006300000000 63 63
67 BARBERA FERRANDO, LAURA VE1 F000000063000 63 63
68 CABALLÉ PERTEGAZ, SILVIA VE1 F000000000063 63 63
69 GARCIA FUENTES, ARACELI VE1 F061000000000 61 61
70 SANCHEZ IGLESIAS, MARI VE1 F000006100000 61 61
71 CASES AMAT, MONTSERRAT VE1 F000000061000 61 61
72 ROYO VERGE, JULIA S18 F000000000610 61 61
73 RUIZ SEVILLA, ÀNGELA SEN F000610000000 61 61
74 BERMEJO MULET, MONTSE VE2 F600000000000 60 60
75 RODICIO HERAS, ROSA VE2 F000060000000 60 60
76 GARCIA HOMS, LORENA SEN F006000000000 60 60
77 FABRA DOMÈNECH, IRINA VE2 F000000000600 60 60
78 ABELLA CALDUCH, MARGA VE1 F000059000000 59 59
79 ARMENGOL CASAS, NÚRIA VE2 F000005900000 59 59
80 VILELA ATACHAO, JUDITH VE1 F000000059000 59 59
81 GASCÓ PALAU, SONIA S23 F000000000590 59 59
82 RUIZ MARTINEZ, VANESSA VE1 F580000000000 58 58
83 MONTENEGRO, LÍDIA VE1 F058000000000 58 58
84 ESTELLER BORT, NURIA VE1 F000000000580 58 58
85 BOYER MARGALEF, ALBA SEN F000580000000 58 58
86 SEGARRA MAYO, ANNA SEN F057000000000 57 57
87 VIALA FARRAS , SILVIA VE2 F000005700000 57 57
88 IRIGOYEN GARCIA, SILVIA VE1 F560000000000 56 56
89 REVERTER VILLÁN, ARANTZA S23 F056000000000 56 56
90 GIL CONTRERAS, TANIA SEN F000055000000 55 55
91 SOLER GISBERT, LUJAN VE2 F000000055000 55 55
92 ALCANAR QUERALT, LORENA VE1 F000000000550 55 55
93 IBAÑEZ ARTIGAS, TRINI VE1 F540000000000 54 54
94 BEZBRADICA, EMMA SEN F000000000540 54 54
95 DE LA IGLESIA TUDELA, OLYMPIA VE1 F005300000000 53 53
96 LARA, CLARISA VE1 F520000000000 52 52
97 BLESA RAMÍREZ, NATÀLIA S23 F000052000000 52 52
98 COMÍ CODINA , SÒNIA VE1 F510000000000 51 51
99 SORIANO, EVA VE1 F004900000000 49 49
100 GARCÍA SABATER, RUTH VE1 F004800000000 48 48
101 LLOPIS MONZO, MÓNICA VE1 F004700000000 47 47




Amb el suport de: