CLASSIFICACIÓ 5K: VETERÀ-1 FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic5 WHERE categoria="VE1 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaAmpollaTivenysEl PerellóS.BàrbaraCamarlesBateaDeltebreJesúsL'Aldea Total Punts
1 SÁNCHEZ FIGUERES, MIREIA 939300000000 186 186
2 FERNANDEZ DE GINZO SOTERAS, ERIKA 7510300000000 178 178
3 GAUXACHS MARGALEF, NURIA. 857500000000 160 160
4 SANCHEZ IGLESIAS, MARI 737300000000 146 146
5 FRANCH BONET, ROSANA 717100000000 142 142
6 OBIOL ESPELTA, VALLIVANA 676700000000 134 134
7 ALIFONSO SORRIBES, ESTEFANIA 666800000000 134 134
8 MARTI CARDONA, MÍRIAM 115000000000 115 115
9 VIZCAINO ROMERO, YOLANDA. 011500000000 115 115
10 SANS CUCALA, MERCÈ 103000000000 103 103
11 MARTOS REDO , IOLANDA 08500000000 85 85
12 SOLE MONLLAO, NURIA. 07900000000 79 79
13 JUAN GIL, MIREIA 79000000000 79 79
14 PULIDO MOLINA, REBECA 07000000000 70 70
15 GARRIGA BALAGUÉ, NOELIA 70000000000 70 70
16 ANDRES BRULL, MARINA 06900000000 69 69
17 GILABERT PITARCH, MARIA JOSE 69000000000 69 69
18 ROCA MICHIELS, ESTEFANIA 68000000000 68 68




Amb el suport de: