CLASSIFICACIÓ 10K: VETERÀ-2 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="VE2 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 GISBERT TORTA, VERÒNICA 10393115851031151030000 717 717
2 BATALLA DOMINGUEZ, SITA 115103939393103930000 693 693
3 ALMEIDA JIMENEZ, MONICA 737970737985750000 534 534
4 SEGURA RIUS, ELENA 75071758593850000 484 484
5 TURTÓS PALOMA, NÚRIA 00010311501150000 333 333
6 MARTÍNEZ ESQUERRÉ, MARIA TERESA 717507007900000 295 295
7 PARRAMON SOLER, GEMMA 85850790000000 249 249
8 MONSERRAT MONTAGUT, SÍLVIA 00690750790000 223 223
9 SANCHEZ HURTADO, CARMEN 9307300000000 166 166
10 LLAMBRICH PARRA, MONICA 0075710000000 146 146
11 CUÑAT SIMÓN , ENCARNA 0115000000000 115 115
12 MARTINEZ TORREGROSA, OLGA 0001150000000 115 115
13 VERGE ANDRES, SONIA 0010300000000 103 103
14 NAVARRO AMADOR, IMMA 008500000000 85 85
15 GALVE CURTO, LUCI 007900000000 79 79
16 BERMEJO MULET, MONTSE 790000000000 79 79
17 ARMENGOL CASAS, NÚRIA 000007500000 75 75
18 RODICIO HERAS, ROSA 000073000000 73 73
19 VIALA FARRAS , SILVIA 000007300000 73 73




Amb el suport de: