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 0115103011511511510300 666 666
2 ESCUDERO BARBERÀ, CINTA 6973708571797385750 680 611
3 BARÓN VILLALBA, ÀNGELA 1030930001031151030 517 517
4 CABALLÉ FABRA, GEMMA 7908507985079710 478 478
5 VIDIELLA PIÑOL, SANDRA 0009393103930930 475 475
6 VILLAR SALDAÑA, OLGA 11593010375075000 461 461
7 ALIAU CLUA, SANDRA 6870687907307500 433 433
8 LARROSA MUNUERA, YOLANDA 0103011500093790 390 390
9 ROCA BENAIGES, JÚLIA 71857107300000 300 300
10 GUARNER PIQUET, MIREIA 00115000001150 230 230
11 TOMAS LORENZ, ROSA 7500070000730 218 218
12 SANCHO FERRÉ, ANDREA 000009379000 172 172
13 ALSO ROIGET, TERE 000000850850 170 170
14 PONS CARLES, NEUS 850750000000 160 160
15 JIMENEZ SANCHEZ, LAURA 000010300000 103 103
16 DRAGO ROSA, HELENA 93000000000 93 93
17 MARTI CARDONA, MÍRIAM 00008500000 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 RALLO FABRA, AIDA 00000000700 70 70
28 MERÍN PÉREZ, IVET 00000700000 70 70
29 COMES MARGALEF, CARME 06900000000 69 69
30 COYARD, VANINA 00000000690 69 69
31 PONS ALEMÁN, BETLEM 00690000000 69 69
32 VIÑAU CACHO, RAQUEL 00000690000 69 69
33 BLANCH RUBERT, NOELIA 00006900000 69 69
34 CODORNIU FRANCH, NURIA 06800000000 68 68
35 BALAGUE MOYA, IDOIA 00000680000 68 68
36 MESEGUER CARBÓ, LINA 00670000000 67 67
37 RECIO LLUCH, DAYANA 67000000000 67 67
38 CABANES BALANZA, SOFIA 66000000000 66 66
39 POY, MONTSE 00660000000 66 66
40 RUIZ SEVILLA, ÀNGELA 00650000000 65 65
41 DEZA SEVA , RAQUEL 00640000000 64 64