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 F001151151151151150000 575 575
2 BATALLA DOMINGUEZ, SITA VE2 F857969797579730000 539 539
3 GISBERT TORTA, VERÒNICA VE2 F717375757985750000 533 533
4 PELLICER MARTINEZ, SANDRA VE1 F73858509393850000 514 514
5 ESCUDERO BARBERÀ, CINTA SEN F707070737375710000 502 502
6 FORT RODRIGUEZ, ROSANA VE1 F75093930103790000 443 443
7 ALMEIDA JIMENEZ, MONICA VE2 F556357646266630000 430 430
8 FORÉS ESTRADA, IMMA MA1 F62666568680700000 399 399
9 SEGURA RIUS, ELENA VE2 F59058666470670000 384 384
10 CABALLÉ FABRA, GEMMA SEN F0710696973680000 350 350
11 CABALLÉ FABRA, RAQUEL VE1 F6100676668690000 331 331
12 MARQUEZ GARCIA, SILVIA VE1 F11510310300000000 321 321
13 FERRE GARCIA, NOELIA SEN F0052605863620000 295 295
14 TURTÓS PALOMA, NÚRIA VE2 F0008510301030000 291 291
15 MESEGUER CARBÓ, LINA SEN F006465636500000 257 257
16 REDO VIUDEZ, SUSANA VE1 F064510062660000 243 243
17 MARTÍNEZ ESQUERRÉ, MARIA TERESA VE2 F535905906000000 231 231
18 GONZALEZ SABATE, TRINI MA1 F005005356610000 220 220
19 PARRAMON SOLER, GEMMA VE2 F65650700000000 200 200
20 ALSO ROIGET, TERE VE1 F9393000000000 186 186
21 GIL CHARRAL, REMEI MA2 F00005464640000 182 182
22 MONSERRAT MONTAGUT, SÍLVIA VE2 F00550610650000 181 181
23 SANCHO FERRÉ, ANDREA SEN F7975000000000 154 154
24 GIMÉNEZ FERRERES, CLÀUDIA SEN F0068070000000 138 138
25 COMES I FORASTERO, PILI VE1 F6906700000000 136 136
26 ZARAGOZA GRANELL, SUSANA VE1 F0680065000000 133 133
27 SANCHEZ HURTADO, CARMEN VE2 F6605900000000 125 125
28 LLAMBRICH PARRA, MONICA VE2 F0061620000000 123 123
29 BROUGHTON, BETTINA MA1 F5762000000000 119 119
30 CUÑAT SIMÓN , ENCARNA VE2 F0115000000000 115 115
31 ALCAZAR GINER, AINHOA S23 F0605400000000 114 114
32 VALLS RIOS, PATRICIA VE1 F0056057000000 113 113
33 ALIAU CLUA, SANDRA SEN F0550005800000 113 113
34 DRAGO ROSA, HELENA SEN F1030000000000 103 103
35 MARTINEZ TORREGROSA, OLGA VE2 F0001030000000 103 103
36 EVERINK, DEBBIE SEN F000000930000 93 93
37 SUBIRATS ABELLA, ANNA SEN F000085000000 85 85
38 CALLARISA BEL, CELIA VE1 F007900000000 79 79
39 ROYO DELLA, JUDHIT VE1 F007300000000 73 73
40 MILLÁN LARA, SANDRA SEN F000071000000 71 71
41 VERGE ANDRES, SONIA VE2 F007100000000 71 71
42 ACOSTA DORADO, ZAMARA VE1 F000007100000 71 71
43 VINAIXA REY, MONTSERRAT VE1 F000710000000 71 71
44 CASANOVA CALLAU, OLGA S23 F069000000000 69 69
45 MARTI MARTI, BEA SEN F000006900000 69 69
46 ESTORACH ARASA, MIRIAM VE1 F680000000000 68 68
47 TORTA, CARME VE1 F670000000000 67 67
48 SORBE CASORRAN, CAROLINA SEN F000067000000 67 67
49 VALLS PEDRET, ISABEL VE1 F067000000000 67 67
50 CALVET PLA, MÒNICA VE1 F000006700000 67 67
51 NAVARRO AMADOR, IMMA VE2 F006600000000 66 66
52 FALCÓN TORMO, EVA VE1 F640000000000 64 64
53 JORNET SABATÉ, MIRIAM SEN F630000000000 63 63
54 BEL POCURULL, SONIA VE1 F006300000000 63 63
55 GONZALEZ LLOP, MARTA SEN F000630000000 63 63
56 GALVE CURTO, LUCI VE2 F006200000000 62 62
57 GARCIA FUENTES, ARACELI VE1 F061000000000 61 61
58 SANCHEZ IGLESIAS, MARI VE1 F000006100000 61 61
59 RUIZ SEVILLA, ÀNGELA SEN F000610000000 61 61
60 BERMEJO MULET, MONTSE VE2 F600000000000 60 60
61 RODICIO HERAS, ROSA VE2 F000060000000 60 60
62 GARCIA HOMS, LORENA SEN F006000000000 60 60
63 ABELLA CALDUCH, MARGA VE1 F000059000000 59 59
64 ARMENGOL CASAS, NÚRIA VE2 F000005900000 59 59
65 RUIZ MARTINEZ, VANESSA VE1 F580000000000 58 58
66 MONTENEGRO, LÍDIA VE1 F058000000000 58 58
67 BOYER MARGALEF, ALBA SEN F000580000000 58 58
68 SEGARRA MAYO, ANNA SEN F057000000000 57 57
69 VIALA FARRAS , SILVIA VE2 F000005700000 57 57
70 IRIGOYEN GARCIA, SILVIA VE1 F560000000000 56 56
71 FANDOS COLOMINES, ESTIBALITZ VE1 F000056000000 56 56
72 REVERTER VILLÁN, ARANTZA S23 F056000000000 56 56
73 GIL CONTRERAS, TANIA SEN F000055000000 55 55
74 IBAÑEZ ARTIGAS, TRINI VE1 F540000000000 54 54
75 DE LA IGLESIA TUDELA, OLYMPIA VE1 F005300000000 53 53
76 LARA, CLARISA VE1 F520000000000 52 52
77 BLESA RAMÍREZ, NATÀLIA S23 F000052000000 52 52
78 COMÍ CODINA , SÒNIA VE1 F510000000000 51 51
79 SORIANO, EVA VE1 F004900000000 49 49
80 GARCÍA SABATER, RUTH VE1 F004800000000 48 48
81 LLOPIS MONZO, MÓNICA VE1 F004700000000 47 47




Amb el suport de: