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 tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS dos, 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, 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àrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 VILLAR SALDAÑA, OLGA 115930103000000 311 311
2 ESCUDERO BARBERÀ, CINTA 69737085000000 297 297
3 ALIAU CLUA, SANDRA 68706879000000 285 285
4 ROCA BENAIGES, JÚLIA 7185710000000 227 227
5 PAULINO ANDREU, MARTA 01151030000000 218 218
6 LARROSA MUNUERA, YOLANDA 01030115000000 218 218
7 BARÓN VILLALBA, ÀNGELA 1030930000000 196 196
8 CABALLÉ FABRA, GEMMA 790850000000 164 164
9 PONS CARLES, NEUS 850750000000 160 160
10 GUARNER PIQUET, MIREIA 001150000000 115 115
11 DRAGO ROSA, HELENA 93000000000 93 93
12 VIDIELLA PIÑOL, SANDRA 00093000000 93 93
13 GARCIA HOMS, LORENA 00790000000 79 79
14 VILLALOBOS MARTINEZ, MARCELA 07900000000 79 79
15 TOMAS LORENZ, ROSA 75000000000 75 75
16 BIOSCA BRULL, JUDIT 07500000000 75 75
17 SABATER ROYO, RUTH 00730000000 73 73
18 LENDINES CORTES, CRISTINA 73000000000 73 73
19 BO CABRERA, MARTA 07100000000 71 71
20 SEGURA, EVA MARIA 70000000000 70 70
21 COMES MARGALEF, CARME 06900000000 69 69
22 PONS ALEMÁN, BETLEM 00690000000 69 69
23 CODORNIU FRANCH, NURIA 06800000000 68 68
24 MESEGUER CARBÓ, LINA 00670000000 67 67
25 RECIO LLUCH, DAYANA 67000000000 67 67
26 CABANES BALANZA, SOFIA 66000000000 66 66
27 POY, MONTSE 00660000000 66 66
28 RUIZ SEVILLA, ÀNGELA 00650000000 65 65
29 DEZA SEVA , RAQUEL 00640000000 64 64