CLASSIFICACIÓ 10K: ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. CamarlesL'AmpollaLa GaleraL'AldeaAmpostaDeltebre Total Punts
1 COLOME ESTRADA, GEMMA SEN F11500000 115 115
2 TURTÓS PALOMA, NÚRIA VE2 F10300000 103 103
3 FERRÉ ESMEL, CLÀUDIA SEN F9300000 93 93
4 SEGURA RIUS, ELENA MA1 F8500000 85 85
5 BUTLER, JOANNA VE1 F7900000 79 79
6 ARJONA CABRERA, ANA VE2 F7500000 75 75
7 MARTOS REDO , IOLANDA VE2 F7300000 73 73
8 BUERA ALBALAT, ANDREA SEN F7100000 71 71
9 ESCUDE MIRALLES, IMMA VE2 F7000000 70 70
10 PAULINO ANDREU, MARTA SEN F6900000 69 69
11 BERTOMEU BELLÉS, ROMINA SEN F6800000 68 68
12 MESEGUER CARBÓ, LINA VE1 F6700000 67 67
13 BONET MONTAGUT, MARIA JOSÉ VE1 F6600000 66 66
14 GIL VICO, DOLORS VE2 F6500000 65 65
15 FERNÁNDEZ PAREJA, SARA SEN F6400000 64 64
16 ESTORACH SOL, ALBA SEN F6300000 63 63
17 BEDOS BELTRAN, MAIKA SEN F6200000 62 62




Amb el suport de: