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 RIUS FABREGAT, ARANTXA 11511593000 323 323
2 MARGALEF PALLARES, ANNA 738575000 233 233
3 AGUIL└ CUBELLS, ANNA 707969000 218 218
4 NAVARRO BERTOMEU, JUDIT 07568000 143 143
5 HURTADO NUĐEZ, ANA 00115000 115 115
6 SANCHEZ AREST╔, JUDITH 00103000 103 103
7 CASTELLS LOPEZ, SUSANA 10300000 103 103
8 ROMEU CAPERA, MONTSE 01030000 103 103
9 VIVES, CRISTINA 9300000 93 93
10 RAMIREZ BALLESTEROS, ESTEFANIA 0930000 93 93
11 ROCOFFORT DE VINNIERE, GRACE 0085000 85 85
12 CASTELBLANQUE SOLER, AIDA 8500000 85 85
13 ROSA PINEDA, NAGORE 0079000 79 79
14 SABAT╔ BENET, ESTER 7900000 79 79
15 CURTO JUAN, ANNA 7500000 75 75
16 GILABERT , JENIFER 0073000 73 73
17 GILABERT VIDIELLA , GEORGINA 0071000 71 71
18 MAGRIĐA GONZALEZ, ROSA 7100000 71 71
19 GAUXACHS MARGALEF, NURIA 0070000 70 70