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 dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS una, 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, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpollaPerellóCamarlesTortosaDeltebreJesús Total Punts
1 MARTÍ SOLÉ, RUTH 10310310310300 412 412
2 RIUS FABREGAT, ARANTXA 11511585000 315 315
3 SÁNCHEZ FIGUERES , MIREIA 6679717500 291 291
4 MONTEVERDE MICHAVILA, MONICA 6567626200 256 256
5 FANDOS COLOMINES, ESTIBALIZ 5868606500 251 251
6 MARGALEF PALLARES, ANNA 5766586400 245 245
7 ZARAGOZA GRANELL, SUSANA 085797900 243 243
8 CÓRDOVA ANDINO , YESENIA 093757300 241 241
9 AGUILÀ CUBELLS, ANNA 5264525700 225 225
10 SANCHEZ ARESTÉ, JUDITH 009311500 208 208
11 RIBES MONTAÑA, AINA 697306300 205 205
12 DEL CAMPO SANZ, PATRICIA 93009300 186 186
13 MARTOS REDO , IOLANDA 600576000 177 177
14 FORT RODRIGUEZ, ROSANA 00707100 141 141
15 BIARNÉS JORNET, MªDOLORS 00686900 137 137
16 HERNANDEZ HERRERO, MARTA 68065000 133 133
17 ALMEIDA JIMENEZ, MONICA 00616100 122 122
18 COMÍ CODINA , SÒNIA 55650000 120 120
19 MORALES TOMÀS , PATRICIA 59059000 118 118
20 HURTADO NUÑEZ, ANA 00115000 115 115
21 GILABERT , JENIFER 00565900 115 115
22 NAVARRO BERTOMEU, JUDIT 06350000 113 113
23 GILABERT VIDIELLA , GEORGINA 00545800 112 112
24 CASTELLS LOPEZ, SUSANA 8500000 85 85
25 FAVÀ FERRÉ, IRIS 0008500 85 85
26 ALEMANY VALLS, DAYANA 7900000 79 79
27 VIVES, CRISTINA 7500000 75 75
28 FIGUERES PASTÓ, ARIADNA 0750000 75 75
29 ROCOFFORT DE VINNIERE, GRACE 0073000 73 73
30 GUTIERREZ GARCIA, CARLA 7300000 73 73
31 CASTELBLANQUE SOLER, AIDA 7100000 71 71
32 ROMEU CAPERA, MONTSE 0710000 71 71
33 ALCAZAR GINER, AINHOA 7000000 70 70
34 SABATE GIL, CINTA 0007000 70 70
35 RAMIREZ BALLESTEROS, ESTEFANIA 0700000 70 70
36 LLAMBRICH FERRÉ, LARA 0069000 69 69
37 CASTELAR VENDRELK, CANDELA 0690000 69 69
38 PUENTES AGUILÓ, AINOA 0006800 68 68
39 BAGES BANEGAS, SANDRA 0067000 67 67
40 SABATÉ BENET, ESTER 6700000 67 67
41 FATSINI YAGÜE, ERICA 0006700 67 67
42 ROSA PINEDA, NAGORE 0066000 66 66
43 SEGURA RIUS, ELENA 0006600 66 66
44 ALABART ALCOBER, XUS 0064000 64 64
45 MONTAÑA VALLÉS, CARME 6400000 64 64
46 OLLÉ BLASCO, LAURA 0063000 63 63
47 VILANOVA BAIGES, SÍLVIA 6300000 63 63
48 MUÑOZ LÓPEZ, ISABEL 6200000 62 62
49 CURTO JUAN, ANNA 6100000 61 61
50 POQUET TARRAGO, NOEMI 5600000 56 56
51 MELERO PIÑOL, SONIA 0005600 56 56
52 CUGAT ADELL, GEMMA 0055000 55 55
53 LARA, CLARISA 5400000 54 54
54 GAUXACHS MARGALEF, NURIA 0053000 53 53
55 MAGRIÑA GONZALEZ, ROSA 5300000 53 53
56 RODRÍGUEZ AUBÀ, EUGÈNIA 0051000 51 51
57 VILANOVA BAIGES, MERITXELL 5100000 51 51
58 LOPEZ LOPEZ, SABRINA 5000000 50 50
59 JUAN ALONSO, MARGARITA 4900000 49 49
60 HENDERSON, WENDY 4800000 48 48