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 F11511510311500 448 448
2 FERRÉ ESMEL, CLÀUDIA SEN F9379717900 322 322
3 CABALLÉ FABRA, GEMMA SEN F01038510300 291 291
4 BONET MONTAGUT, MARIA JOSÉ VE1 F6666626800 262 262
5 GIL VICO, DOLORS VE2 F6567616600 259 259
6 FERNÁNDEZ PAREJA, SARA SEN F6464606700 255 255
7 SEGURA RIUS, ELENA MA1 F857107100 227 227
8 PALLARES ALIAU, AIDA SEN F08509300 178 178
9 PAULINO ANDREU, MARTA SEN F69093000 162 162
10 GIMÉNEZ FERRERES, CLÀUDIA VE1 F00738500 158 158
11 ROYO VERGE, JULIA S23 F00797500 154 154
12 BUTLER, JOANNA VE1 F79070000 149 149
13 MESEGUER CARBÓ, LINA VE1 F67690000 136 136
14 FREIXA VALLS, MARINA S23 F00115000 115 115
15 TURTÓS PALOMA, NÚRIA VE2 F10300000 103 103
16 TALARN FERRANDO, CRISTINA SEN F0930000 93 93
17 CALLARISA BEL, CELIA VE1 F0075000 75 75
18 ARJONA CABRERA, ANA VE2 F7500000 75 75
19 LLAÓ BORRÀS, ELISABET SEN F0750000 75 75
20 MARTOS REDO , IOLANDA VE2 F7300000 73 73
21 ESTORACH ARASA, MIRIAM VE1 F0007300 73 73
22 LUQUE DAUDE , ARIADNA SEN F0730000 73 73
23 BUERA ALBALAT, ANDREA SEN F7100000 71 71
24 ESCUDE MIRALLES, IMMA VE2 F7000000 70 70
25 ROMANI GUART, MONTSE VE1 F0007000 70 70
26 SOLANDE GALINDO, GISELA SEN F0700000 70 70
27 PRINCEP COLOMÉ, ALEXANDRA VE1 F0069000 69 69
28 RUIZ MARTINEZ, VANESSA VE1 F0006900 69 69
29 SEGURA VILANOVA, MÒNICA S23 F0068000 68 68
30 BERTOMEU BELLÉS, ROMINA SEN F6800000 68 68
31 HERRERA GARCIA, MARIA VE2 F0680000 68 68
32 FUMADÓ PRIMÉ, INGRID SEN F0067000 67 67
33 TOMAS LORENZ, ROSA VE1 F0066000 66 66
34 CASANOVA FUMADÓ, LAURA SEN F0065000 65 65
35 PRATS SERRAT, ESTELA VE1 F0006500 65 65
36 ALIAU CLUA, SANDRA SEN F0650000 65 65
37 RALLO FABRA, AIDA SEN F0064000 64 64
38 BEL FERRÉ , INÉS SEN F0063000 63 63
39 ESTORACH SOL, ALBA SEN F6300000 63 63
40 BEDOS BELTRAN, MAIKA SEN F6200000 62 62
41 ALCANAR QUERALT, LORENA VE1 F0059000 59 59
42 BROUGHTON, BETTINA MA2 F0058000 58 58
43 BONIN I RALLO, LAISA S23 F0057000 57 57
44 BLASQUIZ LOPEZ, CRISTINA VE1 F0056000 56 56




Amb el suport de:

comunicar incidències sobre les classificacions.
Recorda que per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.