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 1031031031031150 527 527
2 SÁNCHEZ FIGUERES , MIREIA 66797175850 376 376
3 MONTEVERDE MICHAVILA, MONICA 65676262670 323 323
4 ZARAGOZA GRANELL, SUSANA 0857979790 322 322
5 FANDOS COLOMINES, ESTIBALIZ 58686065690 320 320
6 RIUS FABREGAT, ARANTXA 11511585000 315 315
7 CÓRDOVA ANDINO , YESENIA 0937573730 314 314
8 MARGALEF PALLARES, ANNA 57665864650 310 310
9 DEL CAMPO SANZ, PATRICIA 9300931030 289 289
10 AGUILÀ CUBELLS, ANNA 52645257570 282 282
11 MARTOS REDO , IOLANDA 6005760620 239 239
12 SANCHEZ ARESTÉ, JUDITH 009311500 208 208
13 BIARNÉS JORNET, MªDOLORS 006869700 207 207
14 RIBES MONTAÑA, AINA 697306300 205 205
15 GILABERT , JENIFER 005659590 174 174
16 GILABERT VIDIELLA , GEORGINA 005458600 172 172
17 LLAMBRICH FERRÉ, LARA 00690750 144 144
18 FORT RODRIGUEZ, ROSANA 00707100 141 141
19 ALABART ALCOBER, XUS 00640710 135 135
20 HERNANDEZ HERRERO, MARTA 68065000 133 133
21 OLLÉ BLASCO, LAURA 00630610 124 124
22 ALMEIDA JIMENEZ, MONICA 00616100 122 122
23 COMÍ CODINA , SÒNIA 55650000 120 120
24 MORALES TOMÀS , PATRICIA 59059000 118 118
25 HURTADO NUÑEZ, ANA 00115000 115 115
26 NAVARRO BERTOMEU, JUDIT 06350000 113 113
27 MAGRIÑA GONZALEZ, ROSA 53000580 111 111
28 GALVE CURTO, LUCI 0000930 93 93
29 CASTELLS LOPEZ, SUSANA 8500000 85 85
30 FAVÀ FERRÉ, IRIS 0008500 85 85
31 ALEMANY VALLS, DAYANA 7900000 79 79
32 VIVES, CRISTINA 7500000 75 75
33 FIGUERES PASTÓ, ARIADNA 0750000 75 75
34 ROCOFFORT DE VINNIERE, GRACE 0073000 73 73
35 GUTIERREZ GARCIA, CARLA 7300000 73 73
36 CASTELBLANQUE SOLER, AIDA 7100000 71 71
37 ROMEU CAPERA, MONTSE 0710000 71 71
38 ALCAZAR GINER, AINHOA 7000000 70 70
39 SABATE GIL, CINTA 0007000 70 70
40 RAMIREZ BALLESTEROS, ESTEFANIA 0700000 70 70
41 CASTELAR VENDRELK, CANDELA 0690000 69 69
42 SANCHEZ IGLESIAS, MARI 0000680 68 68
43 PUENTES AGUILÓ, AINOA 0006800 68 68
44 BAGES BANEGAS, SANDRA 0067000 67 67
45 SABATÉ BENET, ESTER 6700000 67 67
46 FATSINI YAGÜE, ERICA 0006700 67 67
47 ROSA PINEDA, NAGORE 0066000 66 66
48 SÁNCHEZ IGLESIAS, NOLI 0000660 66 66
49 SEGURA RIUS, ELENA 0006600 66 66
50 CABRERA ROCH, CARME 0000640 64 64
51 MONTAÑA VALLÉS, CARME 6400000 64 64
52 BLANQUET BAYERRI, MONTSE 0000630 63 63
53 VILANOVA BAIGES, SÍLVIA 6300000 63 63
54 MUÑOZ LÓPEZ, ISABEL 6200000 62 62
55 CURTO JUAN, ANNA 6100000 61 61
56 OBIOL ESPELTA, VALLIVANA 0000560 56 56
57 POQUET TARRAGO, NOEMI 5600000 56 56
58 MELERO PIÑOL, SONIA 0005600 56 56
59 CUGAT ADELL, GEMMA 0055000 55 55
60 LARA, CLARISA 5400000 54 54
61 GAUXACHS MARGALEF, NURIA 0053000 53 53
62 RODRÍGUEZ AUBÀ, EUGÈNIA 0051000 51 51
63 VILANOVA BAIGES, MERITXELL 5100000 51 51
64 LOPEZ LOPEZ, SABRINA 5000000 50 50
65 JUAN ALONSO, MARGARITA 4900000 49 49
66 HENDERSON, WENDY 4800000 48 48