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 1151151151150115115115 805 575
2 BIARNÉS JORNET, MªDOLORS 93103103010385103103 693 515
3 HERMANO, SORIA 7985858585757585 654 440
4 SÁNCHEZ FIGUERES , MIREIA 1039300939300 382 382
5 GAUXACHS MARGALEF, NURIA 62677170730079 422 360
6 BONET MONTAGUT, MARIA JOSÉ 6871707575000 359 359
7 SOLE MONLLAO, NURIA 066737100093 303 303
8 FANDOS COLOMINES, ESTIBALIZ 75797900000 233 233
9 ZARAGOZA GRANELL, SUSANA 000103115000 218 218
10 MORALES TOMÀS, PATRICIA 67700790000 216 216
11 VICO GIL, EVA MARIA 58630690000 190 190
12 CALVO CODORNIU, NÚRIA 0000079850 164 164
13 DE LA IGLESIA TUDELA, OLYMPIA 7075000000 145 145
14 NAVARRO CURTO, TERE 0000068730 141 141
15 RODRIGUEZ, KRISTY RENEE 6573000000 138 138
16 FRANCH BONET, ROSANA 6669000000 69 135
17 CUGAT ADELL, GEMMA 6468000000 132 132
18 ANFRUNS GUTIÉRREZ, NÚRIA 0000010300 103 103
19 LEBRON QUEVEDO, PATRICIA 000930000 93 93
20 GABERNET DIAZ, NURIA 009300000 93 93
21 BELTRAN ROIG, NÚRIA 000000930 93 93
22 GIL MARTI, NEUS 850000000 85 85
23 ALSO ANDRADE, ROSA MARIA 000000790 79 79
24 FERNANDEZ DE GINZO SOTERAS, ERIKA 000079000 79 79
25 SANCHEZ IGLESIAS, MARI 007500000 75 75
26 DIEGO BOSCH, CINTA 000007300 73 73
27 MARTOS REDO , IOLANDA 000730000 73 73
28 LABORIA MARGALEF, JOANA 730000000 73 73
29 GIL VICO, DOLORS 000007100 71 71
30 SALVADOR SUTTON, MARIA EUGENIA 710000000 71 71
31 PULIDO MOLINA, REBECA 000000710 71 71
32 RODRÍGUEZ BOTELLA, VANESA 000007000 70 70
33 BLANQUET BAYERRI, MONTSE 690000000 69 69
34 MAYOR ROIG, ZORAIDA 000006900 69 69
35 TULIESA GRANELL, MARIA MERCE 006900000 69 69
36 SUBIRATS BERMUDEZ, NEUS 000006700 67 67
37 BORRAS MARGALEF, CRISTINA 065000000 65 65
38 DE COLSA LORENZO, ROSA 064000000 64 64
39 MESTRE GARCIA, ROSA MARIA 630000000 63 63
40 MONSÓ LAMELAS, NOEMI 610000000 61 61
41 GARRIGA BALAGUÉ, NOELIA 600000000 60 60
42 CECÍLIA GALLEGO , SUSANNA 590000000 59 59
43 BOSCH MONTAÑES, NURIA 570000000 57 57




Amb el suport de: