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 7079697579103 475 421
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 GAUXACHS MARGALEF, NURIA 00700093 163 163
8 MAGRIĐA GONZALEZ, ROSA 71000850 156 156
9 NAVARRO BERTOMEU, JUDIT 07568000 143 143
10 HURTADO NUĐEZ, ANA 00115000 115 115
11 BLANCH RUBERT, NOELIA 00000115 115 115
12 CASTELLS LOPEZ, SUSANA 10300000 103 103
13 FAV└ FERR╔, IRIS 00010300 103 103
14 ROMEU CAPERA, MONTSE 01030000 103 103
15 VIVES, CRISTINA 9300000 93 93
16 RAMIREZ BALLESTEROS, ESTEFANIA 0930000 93 93
17 ROCOFFORT DE VINNIERE, GRACE 0085000 85 85
18 CASTELBLANQUE SOLER, AIDA 8500000 85 85
19 ROSA PINEDA, NAGORE 0079000 79 79
20 SABAT╔ BENET, ESTER 7900000 79 79
21 CURTO JUAN, ANNA 7500000 75 75
22 MELERO PIĐOL, SONIA 0007300 73 73