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 10393115851031151039310393115 1121 865
2 BATALLA DOMINGUEZ, SITA 11510393939310393103000 796 796
3 SEGURA RIUS, ELENA 750717585938585858593 832 686
4 TURTÓS PALOMA, NÚRIA 00010311501151151151150 678 678
5 ALMEIDA JIMENEZ, MONICA 73797073798575790079 692 622
6 PARRAMON SOLER, GEMMA 858507900007900 328 328
7 MARTÍNEZ ESQUERRÉ, MARIA TERESA 717507007900000 295 295
8 SANCHEZ HURTADO, CARMEN 93073000000085 251 251
9 MONSERRAT MONTAGUT, SÍLVIA 00690750790000 223 223
10 NAVARRO AMADOR, IMMA 00850000000103 188 188
11 GALVE CURTO, LUCI 0079000000790 158 158
12 LLAMBRICH PARRA, MONICA 0075710000000 146 146
13 CUÑAT SIMÓN , ENCARNA 0115000000000 115 115
14 MARTINEZ TORREGROSA, OLGA 0001150000000 115 115
15 CAMAÑES DOMINGO, MARÍA JOSÉ 0000000001030 103 103
16 VERGE ANDRES, SONIA 0010300000000 103 103
17 VERA LUCENA, SUSANA 000000009300 93 93
18 BERMEJO MULET, MONTSE 790000000000 79 79
19 ARMENGOL CASAS, NÚRIA 000007500000 75 75
20 FABRA DOMÈNECH, IRINA 000000000750 75 75
21 SOLER GISBERT, LUJAN 000000075000 75 75
22 RODICIO HERAS, ROSA 000073000000 73 73
23 VIALA FARRAS , SILVIA 000007300000 73 73




Amb el suport de: