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. AmpostaL'AmpollaPerellóS.BàrbaraCamarlesBateaDeltebreJesúsLa GaleraL'Aldea Total Punts
1 ABELLA GUZMAN, AGNÈS SEN F11511500000000 230 230
2 FORT RODRIGUEZ, ROSANA VE1 F9310300000000 196 196
3 BARÓN VILLALBA, ÀNGELA SEN F856800000000 153 153
4 MESEGUER CARBÓ, LINA SEN F737300000000 146 146
5 SEGURA RIUS, ELENA MA1 F717100000000 142 142
6 FANDOS COLOMINES, ESTIBALITZ VE2 F666400000000 130 130
7 PORRES CABANES, MARTA VE1 F676300000000 130 130
8 MIRA MONTES, ANGELA VE1 F646200000000 126 126
9 MARQUEZ GARCIA, SILVIA VE1 F103000000000 103 103
10 SERRA PARELLA, ANNA VE1 F09300000000 93 93
11 ESCODA BALADA, TERE MA1 F08500000000 85 85
12 COMES I FORASTERO, PILI VE1 F79000000000 79 79
13 NAVARRO AMADOR, IMMA VE2 F07900000000 79 79
14 GISBERT TORTA, VERÒNICA VE2 F75000000000 75 75
15 CABALLÉ FABRA, GEMMA SEN F07500000000 75 75
16 MIGUEL GILABERT, ANNA M. VE1 F70000000000 70 70
17 GARCIA ALTADILL, ANGELS VE2 F07000000000 70 70
18 IRIGOYEN GARCIA, SILVIA VE1 F69000000000 69 69
19 GARCIA ALTADILL, NURIA VE2 F06900000000 69 69
20 VIDAL LOTO, PILI VE2 F68000000000 68 68
21 MADRID JARDÍ, ARIADNA SEN F06700000000 67 67
22 ALMEIDA JIMENEZ, MONICA VE2 F06600000000 66 66
23 GONZALEZ SIERRA, Mª CARME VE1 F65000000000 65 65
24 FUMADÓ PRIMÉ, INGRID SEN F06500000000 65 65




Amb el suport de: