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 RIUS FABREGAT, ARANTXA 1151150000 230 230
2 MARTÍ SOLÉ, RUTH 1031030000 206 206
3 SÁNCHEZ FIGUERES , MIREIA 66790000 145 145
4 RIBES MONTAÑA, AINA 69730000 142 142
5 MONTEVERDE MICHAVILA, MONICA 65670000 132 132
6 FANDOS COLOMINES, ESTIBALIZ 58680000 126 126
7 MARGALEF PALLARES, ANNA 57660000 123 123
8 COMÍ CODINA , SÒNIA 55650000 120 120
9 AGUILÀ CUBELLS, ANNA 52640000 116 116
10 DEL CAMPO SANZ, PATRICIA 9300000 93 93
11 CÓRDOVA ANDINO , YESENIA 0930000 93 93
12 CASTELLS LOPEZ, SUSANA 8500000 85 85
13 ZARAGOZA GRANELL, SUSANA 0850000 85 85
14 ALEMANY VALLS, DAYANA 7900000 79 79
15 VIVES, CRISTINA 7500000 75 75
16 FIGUERES PASTÓ, ARIADNA 0750000 75 75
17 GUTIERREZ GARCIA, CARLA 7300000 73 73
18 CASTELBLANQUE SOLER, AIDA 7100000 71 71
19 ROMEU CAPERA, MONTSE 0710000 71 71
20 ALCAZAR GINER, AINHOA 7000000 70 70
21 RAMIREZ BALLESTEROS, ESTEFANIA 0700000 70 70
22 CASTELAR VENDRELK, CANDELA 0690000 69 69
23 HERNANDEZ HERRERO, MARTA 6800000 68 68
24 SABATÉ BENET, ESTER 6700000 67 67
25 MONTAÑA VALLÉS, CARME 6400000 64 64
26 VILANOVA BAIGES, SÍLVIA 6300000 63 63
27 NAVARRO BERTOMEU, JUDIT 0630000 63 63
28 MUÑOZ LÓPEZ, ISABEL 6200000 62 62
29 CURTO JUAN, ANNA 6100000 61 61
30 MARTOS REDO , IOLANDA 6000000 60 60
31 MORALES TOMÀS , PATRICIA 5900000 59 59
32 POQUET TARRAGO, NOEMI 5600000 56 56
33 LARA, CLARISA 5400000 54 54
34 MAGRIÑA GONZALEZ, ROSA 5300000 53 53
35 VILANOVA BAIGES, MERITXELL 5100000 51 51
36 LOPEZ LOPEZ, SABRINA 5000000 50 50
37 JUAN ALONSO, MARGARITA 4900000 49 49
38 HENDERSON, WENDY 4800000 48 48