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 MARQUEZ GARCIA, SILVIA VE1 F11510310300000000 321 321
2 BATALLA DOMINGUEZ, SITA VE2 F857969790000000 312 312
3 GISBERT TORTA, VERÒNICA VE2 F717375750000000 294 294
4 ESCUDERO BARBERÀ, CINTA SEN F707070730000000 283 283
5 FORT RODRIGUEZ, ROSANA VE1 F75093930000000 261 261
6 FORÉS ESTRADA, IMMA MA1 F626665680000000 261 261
7 PELLICER MARTINEZ, SANDRA VE1 F73858500000000 243 243
8 ALMEIDA JIMENEZ, MONICA VE2 F556357640000000 239 239
9 VIDIELLA PIÑOL, SANDRA SEN F001151150000000 230 230
10 PARRAMON SOLER, GEMMA VE2 F65650700000000 200 200
11 ALSO ROIGET, TERE VE1 F9393000000000 186 186
12 SEGURA RIUS, ELENA VE2 F59058660000000 183 183
13 MARTÍNEZ ESQUERRÉ, MARIA TERESA VE2 F53590590000000 171 171
14 SANCHO FERRÉ, ANDREA SEN F7975000000000 154 154
15 CABALLÉ FABRA, GEMMA SEN F0710690000000 140 140
16 COMES I FORASTERO, PILI VE1 F6906700000000 136 136
17 MESEGUER CARBÓ, LINA SEN F0064650000000 129 129
18 CABALLÉ FABRA, RAQUEL VE1 F6100670000000 128 128
19 SANCHEZ HURTADO, CARMEN VE2 F6605900000000 125 125
20 LLAMBRICH PARRA, MONICA VE2 F0061620000000 123 123
21 BROUGHTON, BETTINA MA1 F5762000000000 119 119
22 CUÑAT SIMÓN , ENCARNA VE2 F0115000000000 115 115
23 REDO VIUDEZ, SUSANA VE1 F0645100000000 115 115
24 ALCAZAR GINER, AINHOA S23 F0605400000000 114 114
25 FERRE GARCIA, NOELIA SEN F0052600000000 112 112
26 DRAGO ROSA, HELENA SEN F1030000000000 103 103
27 MARTINEZ TORREGROSA, OLGA VE2 F0001030000000 103 103
28 TURTÓS PALOMA, NÚRIA VE2 F000850000000 85 85
29 CALLARISA BEL, CELIA VE1 F007900000000 79 79
30 ROYO DELLA, JUDHIT VE1 F007300000000 73 73
31 VERGE ANDRES, SONIA VE2 F007100000000 71 71
32 VINAIXA REY, MONTSERRAT VE1 F000710000000 71 71
33 CASANOVA CALLAU, OLGA S23 F069000000000 69 69
34 ESTORACH ARASA, MIRIAM VE1 F680000000000 68 68
35 ZARAGOZA GRANELL, SUSANA VE1 F068000000000 68 68
36 GIMÉNEZ FERRERES, CLÀUDIA SEN F006800000000 68 68
37 TORTA, CARME VE1 F670000000000 67 67
38 VALLS PEDRET, ISABEL VE1 F067000000000 67 67
39 NAVARRO AMADOR, IMMA VE2 F006600000000 66 66
40 FALCÓN TORMO, EVA VE1 F640000000000 64 64
41 JORNET SABATÉ, MIRIAM SEN F630000000000 63 63
42 BEL POCURULL, SONIA VE1 F006300000000 63 63
43 GONZALEZ LLOP, MARTA SEN F000630000000 63 63
44 GALVE CURTO, LUCI VE2 F006200000000 62 62
45 GARCIA FUENTES, ARACELI VE1 F061000000000 61 61
46 RUIZ SEVILLA, ÀNGELA SEN F000610000000 61 61
47 BERMEJO MULET, MONTSE VE2 F600000000000 60 60
48 GARCIA HOMS, LORENA SEN F006000000000 60 60
49 RUIZ MARTINEZ, VANESSA VE1 F580000000000 58 58
50 MONTENEGRO, LÍDIA VE1 F058000000000 58 58
51 BOYER MARGALEF, ALBA SEN F000580000000 58 58
52 SEGARRA MAYO, ANNA SEN F057000000000 57 57
53 IRIGOYEN GARCIA, SILVIA VE1 F560000000000 56 56
54 REVERTER VILLÁN, ARANTZA S23 F056000000000 56 56
55 VALLS RIOS, PATRICIA VE1 F005600000000 56 56
56 ALIAU CLUA, SANDRA SEN F055000000000 55 55
57 MONSERRAT MONTAGUT, SÍLVIA VE2 F005500000000 55 55
58 IBAÑEZ ARTIGAS, TRINI VE1 F540000000000 54 54
59 DE LA IGLESIA TUDELA, OLYMPIA VE1 F005300000000 53 53
60 LARA, CLARISA VE1 F520000000000 52 52
61 COMÍ CODINA , SÒNIA VE1 F510000000000 51 51
62 GONZALEZ SABATE, TRINI MA1 F005000000000 50 50
63 SORIANO, EVA VE1 F004900000000 49 49
64 GARCÍA SABATER, RUTH VE1 F004800000000 48 48
65 LLOPIS MONZO, MÓNICA VE1 F004700000000 47 47