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 PAULINO ANDREU, MARTA 01151030115115115000 563 563
2 ESCUDERO BARBERÀ, CINTA 69737085717973000 520 520
3 VILLAR SALDAÑA, OLGA 11593010375075000 461 461
4 VIDIELLA PIÑOL, SANDRA 000939310393000 382 382
5 ALIAU CLUA, SANDRA 687068790730000 358 358
6 CABALLÉ FABRA, GEMMA 79085079850000 328 328
7 ROCA BENAIGES, JÚLIA 71857107300000 300 300
8 BARÓN VILLALBA, ÀNGELA 103093000103000 299 299
9 LARROSA MUNUERA, YOLANDA 01030115000000 218 218
10 SANCHO FERRÉ, ANDREA 000009379000 172 172
11 PONS CARLES, NEUS 850750000000 160 160
12 TOMAS LORENZ, ROSA 750007000000 145 145
13 GUARNER PIQUET, MIREIA 001150000000 115 115
14 JIMENEZ SANCHEZ, LAURA 000010300000 103 103
15 DRAGO ROSA, HELENA 93000000000 93 93
16 MARTI CARDONA, MÍRIAM 00008500000 85 85
17 ALSO ROIGET, TERE 00000085000 85 85
18 GARCIA HOMS, LORENA 00790000000 79 79
19 VILLALOBOS MARTINEZ, MARCELA 07900000000 79 79
20 SUBIRATS ABELLA, ANNA 00000750000 75 75
21 BIOSCA BRULL, JUDIT 07500000000 75 75
22 SABATER ROYO, RUTH 00730000000 73 73
23 LENDINES CORTES, CRISTINA 73000000000 73 73
24 BO CABRERA, MARTA 07100000000 71 71
25 PORRES BARCELÓ, SARA 00000710000 71 71
26 SEGURA, EVA MARIA 70000000000 70 70
27 MERÍN PÉREZ, IVET 00000700000 70 70
28 COMES MARGALEF, CARME 06900000000 69 69
29 PONS ALEMÁN, BETLEM 00690000000 69 69
30 VIÑAU CACHO, RAQUEL 00000690000 69 69
31 BLANCH RUBERT, NOELIA 00006900000 69 69
32 CODORNIU FRANCH, NURIA 06800000000 68 68
33 BALAGUE MOYA, IDOIA 00000680000 68 68
34 MESEGUER CARBÓ, LINA 00670000000 67 67
35 RECIO LLUCH, DAYANA 67000000000 67 67
36 CABANES BALANZA, SOFIA 66000000000 66 66
37 POY, MONTSE 00660000000 66 66
38 RUIZ SEVILLA, ÀNGELA 00650000000 65 65
39 DEZA SEVA , RAQUEL 00640000000 64 64