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 8593930115103115115115115115 1064 886
2 CABALLÉ FABRA, RAQUEL 7000931038593931039393 826 756
3 FORT RODRIGUEZ, ROSANA 93010311501151030085103 717 717
4 REDO VIUDEZ, SUSANA 07569007585007979 462 462
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 ROMANI GUART, MONTSE 000000000085 85 85
16 ABELLA CALDUCH, MARGA 000085000000 85 85
17 BARBERA FERRANDO, LAURA 000000085000 85 85
18 ROYO DELLA, JUDHIT 007900000000 79 79
19 VALLS PEDRET, ISABEL 079000000000 79 79
20 CALVET PLA, MÒNICA 000007900000 79 79
21 CASES AMAT, MONTSERRAT 000000079000 79 79
22 ESTORACH ARASA, MIRIAM 750000000000 75 75
23 CABALLÉ PERTEGAZ, SILVIA 000000000075 75 75
24 VILELA ATACHAO, JUDITH 000000075000 75 75
25 ESTELLER BORT, NURIA 000000000750 75 75
26 TORTA, CARME 730000000000 73 73
27 BEL POCURULL, SONIA 007300000000 73 73
28 GARCIA FUENTES, ARACELI 073000000000 73 73
29 SANCHEZ IGLESIAS, MARI 000007300000 73 73
30 FALCÓN TORMO, EVA 710000000000 71 71
31 MONTENEGRO, LÍDIA 071000000000 71 71
32 ALCANAR QUERALT, LORENA 000000000710 71 71
33 DE LA IGLESIA TUDELA, OLYMPIA 007000000000 70 70
34 RUIZ MARTINEZ, VANESSA 690000000000 69 69
35 IRIGOYEN GARCIA, SILVIA 680000000000 68 68
36 SORIANO, EVA 006800000000 68 68
37 IBAÑEZ ARTIGAS, TRINI 670000000000 67 67
38 GARCÍA SABATER, RUTH 006700000000 67 67
39 LARA, CLARISA 660000000000 66 66
40 LLOPIS MONZO, MÓNICA 006600000000 66 66
41 COMÍ CODINA , SÒNIA 650000000000 65 65




Amb el suport de: