ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="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 103850103000000 291 291
2 PELLICER MARTINEZ, SANDRA 70716875000000 284 284
3 CABALLÉ FABRA, RAQUEL 57665968000000 250 250
4 ESCUDERO BARBERÀ, CINTA 56616267000000 246 246
5 VALLS RIOS, PATRICIA 60625663000000 241 241
6 MONSERRAT MONTAGUT, SÍLVIA 55606064000000 239 239
7 REDO VIUDEZ, SUSANA 7907579000000 233 233
8 PAULINO ANDREU, MARTA 01151030000000 218 218
9 BONET MONTAGUT, MARIA JOSÉ 48575360000000 218 218
10 DOMINI VIDAL, SILVIA 7306973000000 215 215
11 GISBERT TORTA, VERÒNICA 0756571000000 211 211
12 ALIAU CLUA, SANDRA 44545259000000 209 209
13 LARROSA MUNUERA, YOLANDA 0930115000000 208 208
14 TURTÓS PALOMA, NÚRIA 6970069000000 208 208
15 GALVE CURTO, LUCI 6669070000000 205 205
16 ROCA BENAIGES, JÚLIA 5968640000000 191 191
17 BARÓN VILLALBA, ÀNGELA 930930000000 186 186
18 MELICH CAÑADO, LARA 42444357000000 186 186
19 BATALLA DOMINGUEZ, SITA 079085000000 164 164
20 SEGURA RIUS, ELENA 4546061000000 152 152
21 GONZALEZ SABATE, TRINI 4304658000000 147 147
22 AGUEYO BENITO, MILA 0474256000000 145 145
23 COMES I FORASTERO, PILI 717300000000 144 144
24 CABALLÉ FABRA, GEMMA 670710000000 138 138
25 PONS CARLES, NEUS 680670000000 135 135
26 BLANCH VOLTES, TERE 646500000000 129 129
27 FORÉS ESTRADA, IMMA 064610000000 125 125
28 LLAMBRICH PARRA, MONICA 005866000000 124 124
29 FALCÓN TORMO, EVA 625800000000 120 120
30 RUS GARCIA, PILAR 115000000000 115 115
31 GUARNER PIQUET, MIREIA 001150000000 115 115
32 BROUGHTON, BETTINA 004962000000 111 111
33 DRAGO CANES, ANDREA 010300000000 103 103
34 ALCAZAR GINER, AINHOA 520500000000 102 102
35 BERTOMEU CASANOVA, RAQUEL 045550000000 100 100
36 ROJAS PEREZ, CARMEN 048480000000 96 96
37 VIDIELLA PIÑOL, SANDRA 00093000000 93 93
38 DRAGO ROSA, HELENA 85000000000 85 85
39 LLUCH, MARTA 00850000000 85 85
40 GIL CHARRAL, REMEI 410400000000 81 81
41 GIRALDEZ ALVARO, EMI 00790000000 79 79
42 MARTINEZ MENDOZA, MARIA 75000000000 75 75
43 BEL POCURULL, SONIA 00730000000 73 73
44 GARCIA HOMS, LORENA 00700000000 70 70
45 VILLALOBOS MARTINEZ, MARCELA 06700000000 67 67
46 SABATER ROYO, RUTH 00660000000 66 66
47 TOMAS LORENZ, ROSA 65000000000 65 65
48 VALLS BORRELL, JOSEPA 00065000000 65 65
49 PONS CORTES, ROSA 63000000000 63 63
50 BIOSCA BRULL, JUDIT 06300000000 63 63
51 CÓRDOVA ANDINO , YESENIA S. 00630000000 63 63
52 LENDINES CORTES, CRISTINA 61000000000 61 61
53 BO CABRERA, MARTA 05900000000 59 59
54 SEGURA, EVA MARIA 58000000000 58 58
55 ALEMANY VALLS, DAYANA 00570000000 57 57
56 ESTRELLA ARQUIETA, VIVIANA 05600000000 56 56
57 VILANOVA RODRIGUEZ, SONIA 05500000000 55 55
58 VIDAL LOTO, PILI 54000000000 54 54
59 PONS ALEMÁN, BETLEM 00540000000 54 54
60 SANCHEZ HURTADO, CARMEN 53000000000 53 53
61 PUENTES AGUILÓ, AINOA 05300000000 53 53
62 COMES MARGALEF, CARME 05200000000 52 52
63 BERMEJO MULET, MONTSE 51000000000 51 51
64 OBRADOS MURIA, MONTSE 05100000000 51 51
65 MESEGUER CARBÓ, LINA 00510000000 51 51
66 PERPIÑA CUEVAS, MAR 50000000000 50 50
67 DRECKER, SABINE 05000000000 50 50
68 RUIZ MARTINEZ, VANESSA 49000000000 49 49
69 CODORNIU FRANCH, NURIA 04900000000 49 49
70 CRISTEA PETECUTA, MARIA 47000000000 47 47
71 CALVET ESCUIN, JÚLIA 00470000000 47 47
72 GARCIA ESTELLE, MARIA JOSÉ 46000000000 46 46
73 OCAÑA CABANES, MÒNICA 00450000000 45 45
74 POY, MONTSE 00440000000 44 44
75 RUIZ SEVILLA, ÀNGELA 00410000000 41 41
76 RECIO LLUCH, DAYANA 40000000000 40 40
77 CABANES BALANZA, SOFIA 39000000000 39 39
78 DEZA SEVA , RAQUEL 00390000000 39 39