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 AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 CASTELLS LOPEZ, SUSANA 1151151151150000 460 460
2 HERMANO, SORIA 7985858585000 419 419
3 BIARNÉS JORNET, MªDOLORS 931031030103000 402 402
4 BONET MONTAGUT, MARIA JOSÉ 6871707575000 359 359
5 GAUXACHS MARGALEF, NURIA 6267717073000 343 343
6 SÁNCHEZ FIGUERES , MIREIA 103930093000 289 289
7 FANDOS COLOMINES, ESTIBALIZ 75797900000 233 233
8 ZARAGOZA GRANELL, SUSANA 000103115000 218 218
9 MORALES TOMÀS, PATRICIA 67700790000 216 216
10 SOLE MONLLAO, NURIA 06673710000 210 210
11 VICO GIL, EVA MARIA 58630690000 190 190
12 DE LA IGLESIA TUDELA, OLYMPIA 7075000000 145 145
13 RODRIGUEZ, KRISTY RENEE 6573000000 138 138
14 FRANCH BONET, ROSANA 6669000000 69 135
15 CUGAT ADELL, GEMMA 6468000000 132 132
16 LEBRON QUEVEDO, PATRICIA 000930000 93 93
17 GABERNET DIAZ, NURIA 009300000 93 93
18 GIL MARTI, NEUS 850000000 85 85
19 FERNANDEZ DE GINZO SOTERAS, ERIKA 000079000 79 79
20 SANCHEZ IGLESIAS, MARI 007500000 75 75
21 MARTOS REDO , IOLANDA 000730000 73 73
22 LABORIA MARGALEF, JOANA 730000000 73 73
23 SALVADOR SUTTON, MARIA EUGENIA 710000000 71 71
24 BLANQUET BAYERRI, MONTSE 690000000 69 69
25 TULIESA GRANELL, MARIA MERCE 006900000 69 69
26 BORRAS MARGALEF, CRISTINA 065000000 65 65
27 DE COLSA LORENZO, ROSA 064000000 64 64
28 MESTRE GARCIA, ROSA MARIA 630000000 63 63
29 MONSÓ LAMELAS, NOEMI 610000000 61 61
30 GARRIGA BALAGUÉ, NOELIA 600000000 60 60
31 CECÍLIA GALLEGO , SUSANNA 590000000 59 59
32 BOSCH MONTAÑES, NURIA 570000000 57 57




Amb el suport de: