CLASSIFICACIÓ 10K: VETERÀ-1 FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntscat FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntscat FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic WHERE categoria="VE1 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 PELLICER MARTINEZ, SANDRA 85939301151031151151151150 949 864
2 CABALLÉ FABRA, RAQUEL 700093103859393103930 733 733
3 FORT RODRIGUEZ, ROSANA 930103115011510300850 614 614
4 REDO VIUDEZ, SUSANA 0756900758500790 383 383
5 MARQUEZ GARCIA, SILVIA 11511511500000000 345 345
6 ALSO ROIGET, TERE 10310300000103000 309 309
7 VINAIXA REY, MONTSERRAT 000103000001030 206 206
8 ZARAGOZA GRANELL, SUSANA 0850093000000 178 178
9 COMES I FORASTERO, PILI 7907500000000 154 154
10 VALLS RIOS, PATRICIA 0071079000000 150 150
11 FANDOS COLOMINES, ESTIBALITZ 0000750000730 148 148
12 ACOSTA DORADO, ZAMARA 000009300000 93 93
13 CASANOVA GARRIGÓS, GEORGINA 000000009300 93 93
14 CALLARISA BEL, CELIA 008500000000 85 85
15 ABELLA CALDUCH, MARGA 000085000000 85 85
16 BARBERA FERRANDO, LAURA 000000085000 85 85
17 ROYO DELLA, JUDHIT 007900000000 79 79
18 VALLS PEDRET, ISABEL 079000000000 79 79
19 CALVET PLA, MÒNICA 000007900000 79 79
20 CASES AMAT, MONTSERRAT 000000079000 79 79
21 ESTORACH ARASA, MIRIAM 750000000000 75 75
22 VILELA ATACHAO, JUDITH 000000075000 75 75
23 ESTELLER BORT, NURIA 000000000750 75 75
24 TORTA, CARME 730000000000 73 73
25 BEL POCURULL, SONIA 007300000000 73 73
26 GARCIA FUENTES, ARACELI 073000000000 73 73
27 SANCHEZ IGLESIAS, MARI 000007300000 73 73
28 FALCÓN TORMO, EVA 710000000000 71 71
29 MONTENEGRO, LÍDIA 071000000000 71 71
30 ALCANAR QUERALT, LORENA 000000000710 71 71
31 DE LA IGLESIA TUDELA, OLYMPIA 007000000000 70 70
32 RUIZ MARTINEZ, VANESSA 690000000000 69 69
33 IRIGOYEN GARCIA, SILVIA 680000000000 68 68
34 SORIANO, EVA 006800000000 68 68
35 IBAÑEZ ARTIGAS, TRINI 670000000000 67 67
36 GARCÍA SABATER, RUTH 006700000000 67 67
37 LARA, CLARISA 660000000000 66 66
38 LLOPIS MONZO, MÓNICA 006600000000 66 66
39 COMÍ CODINA , SÒNIA 650000000000 65 65




Amb el suport de: