S╚NIOR FEMEN═

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic5 WHERE categoria="SEN F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpollaPerellˇCamarlesTortosaDeltebreJes˙s Total Punts
1 MARGALEF PALLARES, ANNA 738575931150 441 441
2 AGUIL└ CUBELLS, ANNA 70796975790 372 372
3 RIUS FABREGAT, ARANTXA 11511593000 323 323
4 GILABERT VIDIELLA , GEORGINA 0071791030 253 253
5 GILABERT , JENIFER 007385930 251 251
6 SANCHEZ AREST╔, JUDITH 0010311500 218 218
7 MAGRIĐA GONZALEZ, ROSA 71000850 156 156
8 NAVARRO BERTOMEU, JUDIT 07568000 143 143
9 HURTADO NUĐEZ, ANA 00115000 115 115
10 CASTELLS LOPEZ, SUSANA 10300000 103 103
11 FAV└ FERR╔, IRIS 00010300 103 103
12 ROMEU CAPERA, MONTSE 01030000 103 103
13 VIVES, CRISTINA 9300000 93 93
14 RAMIREZ BALLESTEROS, ESTEFANIA 0930000 93 93
15 ROCOFFORT DE VINNIERE, GRACE 0085000 85 85
16 CASTELBLANQUE SOLER, AIDA 8500000 85 85
17 ROSA PINEDA, NAGORE 0079000 79 79
18 SABAT╔ BENET, ESTER 7900000 79 79
19 CURTO JUAN, ANNA 7500000 75 75
20 MELERO PIĐOL, SONIA 0007300 73 73
21 GAUXACHS MARGALEF, NURIA 0070000 70 70