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 VIDIELLA PIÑOL, SANDRA 001151151151151150115115115 920 920
2 ESCUDERO BARBERÀ, CINTA 93931031039310393850930 859 774
3 CABALLÉ FABRA, GEMMA 0103093759385931038593 823 748
4 FERRE GARCIA, NOELIA 0075737075797585790 611 611
5 MESEGUER CARBÓ, LINA 0085857179079000 399 399
6 ALIAU CLUA, SANDRA 079000730007385 310 310
7 GIMÉNEZ FERRERES, CLÀUDIA 009307900001030 275 275
8 GIL CODORNIU, JOANA 000000011500103 218 218
9 SANCHO FERRÉ, ANDREA 103115000000000 218 218
10 GONZALEZ LLOP, MARTA 0007900000710 150 150
11 DRAGO ROSA, HELENA 1150000000000 115 115
12 BARÓN VILLALBA, ÀNGELA 0000000103000 103 103
13 SUBIRATS ABELLA, ANNA 0000103000000 103 103
14 EVERINK, DEBBIE 0000001030000 103 103
15 FORTUÑO AGUILÓ, JOANA 000000009300 93 93
16 MILLÁN LARA, SANDRA 000085000000 85 85
17 MARTI MARTI, BEA 000008500000 85 85
18 JORNET SABATÉ, MIRIAM 850000000000 85 85
19 SEGARRA MAYO, ANNA 085000000000 85 85
20 GARCIA HOMS, LORENA 007900000000 79 79
21 RUIZ SEVILLA, ÀNGELA 000750000000 75 75
22 BEZBRADICA, EMMA 000000000750 75 75
23 SORBE CASORRAN, CAROLINA 000073000000 73 73
24 BOYER MARGALEF, ALBA 000710000000 71 71
25 GIL CONTRERAS, TANIA 000069000000 69 69




Amb el suport de: