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 85939301151031150000 604 604
2 FORT RODRIGUEZ, ROSANA 93010311501151030000 529 529
3 CABALLÉ FABRA, RAQUEL 70009310385930000 444 444
4 MARQUEZ GARCIA, SILVIA 11511511500000000 345 345
5 REDO VIUDEZ, SUSANA 075690075850000 304 304
6 ALSO ROIGET, TERE 103103000000000 206 206
7 ZARAGOZA GRANELL, SUSANA 0850093000000 178 178
8 COMES I FORASTERO, PILI 7907500000000 154 154
9 VALLS RIOS, PATRICIA 0071079000000 150 150
10 VINAIXA REY, MONTSERRAT 0001030000000 103 103
11 ACOSTA DORADO, ZAMARA 000009300000 93 93
12 CALLARISA BEL, CELIA 008500000000 85 85
13 ABELLA CALDUCH, MARGA 000085000000 85 85
14 ROYO DELLA, JUDHIT 007900000000 79 79
15 VALLS PEDRET, ISABEL 079000000000 79 79
16 CALVET PLA, MÒNICA 000007900000 79 79
17 ESTORACH ARASA, MIRIAM 750000000000 75 75
18 FANDOS COLOMINES, ESTIBALITZ 000075000000 75 75
19 TORTA, CARME 730000000000 73 73
20 BEL POCURULL, SONIA 007300000000 73 73
21 GARCIA FUENTES, ARACELI 073000000000 73 73
22 SANCHEZ IGLESIAS, MARI 000007300000 73 73
23 FALCÓN TORMO, EVA 710000000000 71 71
24 MONTENEGRO, LÍDIA 071000000000 71 71
25 DE LA IGLESIA TUDELA, OLYMPIA 007000000000 70 70
26 RUIZ MARTINEZ, VANESSA 690000000000 69 69
27 IRIGOYEN GARCIA, SILVIA 680000000000 68 68
28 SORIANO, EVA 006800000000 68 68
29 IBAÑEZ ARTIGAS, TRINI 670000000000 67 67
30 GARCÍA SABATER, RUTH 006700000000 67 67
31 LARA, CLARISA 660000000000 66 66
32 LLOPIS MONZO, MÓNICA 006600000000 66 66
33 COMÍ CODINA , SÒNIA 650000000000 65 65




Amb el suport de: