CLASSIFICACIÓ 10K: SÈNIOR 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="SEN F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 ESCUDERO BARBERÀ, CINTA 939310310393103930000 681 681
2 VIDIELLA PIÑOL, SANDRA 001151151151151150000 575 575
3 CABALLÉ FABRA, GEMMA 01030937593850000 449 449
4 FERRE GARCIA, NOELIA 0075737075790000 372 372
5 MESEGUER CARBÓ, LINA 008585717900000 320 320
6 SANCHO FERRÉ, ANDREA 103115000000000 218 218
7 GIMÉNEZ FERRERES, CLÀUDIA 0093079000000 172 172
8 ALIAU CLUA, SANDRA 0790007300000 152 152
9 DRAGO ROSA, HELENA 1150000000000 115 115
10 SUBIRATS ABELLA, ANNA 0000103000000 103 103
11 EVERINK, DEBBIE 0000001030000 103 103
12 MILLÁN LARA, SANDRA 000085000000 85 85
13 MARTI MARTI, BEA 000008500000 85 85
14 JORNET SABATÉ, MIRIAM 850000000000 85 85
15 SEGARRA MAYO, ANNA 085000000000 85 85
16 GARCIA HOMS, LORENA 007900000000 79 79
17 GONZALEZ LLOP, MARTA 000790000000 79 79
18 RUIZ SEVILLA, ÀNGELA 000750000000 75 75
19 SORBE CASORRAN, CAROLINA 000073000000 73 73
20 BOYER MARGALEF, ALBA 000710000000 71 71
21 GIL CONTRERAS, TANIA 000069000000 69 69




Amb el suport de: