CLASSIFICACIÓ 5K: ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. CamarlesL'AmpollaL'AldeaAmpostaDeltebre Total Punts
1 MARTÍ SOLÉ, RUTH S18 F1150000 115 115
2 RIUS LLETÍ, JÚLIA SEN F1030000 103 103
3 REBULL DE LA VEGA, ANNA S18 F930000 93 93
4 GIMÉNEZ FERRERES, CLÀUDIA VE1 F850000 85 85
5 ACOSTA DORADO, ZAMARA VE1 F790000 79 79
6 HERNANDEZ HERRERO, MARTA VE2 F750000 75 75
7 QUERAL MARTI, PAULA S18 F730000 73 73
8 LLAMBRICH FERRÉ, LARA S23 F710000 71 71
9 GALVE CURTO, LUCI VE2 F700000 70 70
10 FUMADÓ PRIMÉ, INGRID SEN F690000 69 69
11 RODRIGUEZ SALVADO, ANNA SEN F680000 68 68
12 PAGÀ FRANCH, MIREIA SEN F670000 67 67
13 MANZANARES TORRES, BEATRIZ SEN F660000 66 66
14 CABRERA MORA, ESTHER VE2 F650000 65 65
15 PERREAU DE PINNINCK GAYNÉS , ANA VE1 F640000 64 64
16 BROUGHTON, BETTINA MA2 F630000 63 63
17 MARCO, NÚRIA SEN F620000 62 62
18 BONFILL CERVERÓ, CARLA SEN F610000 61 61
19 CASANOVA FUMADÓ, LAURA SEN F600000 60 60
20 SANTANDREU, ALBA SEN F590000 59 59
21 BELTRI ARMENGOL, IRENE VE1 F580000 58 58
22 BLANCH RUBERT, NOELIA SEN F570000 57 57
23 TOMAS ALVAREZ, ANDREA S23 F560000 56 56
24 BELTRAN DESCARREGA, NÚRIA VE1 F550000 55 55
25 CURTO QUERALT, NEUS VE1 F540000 54 54




Amb el suport de: