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 PAULINO ANDREU, MARTA 01151030115115115000 563 563
2 PELLICER MARTINEZ, SANDRA 70716875666871000 489 489
3 ESCUDERO BARBERÀ, CINTA 56616267586667000 437 437
4 REDO VIUDEZ, SUSANA 7907579647065000 432 432
5 VILLAR SALDAÑA, OLGA 10385010360069000 420 420
6 VALLS RIOS, PATRICIA 60625663526261000 416 416
7 MONSERRAT MONTAGUT, SÍLVIA 55606064535960000 411 411
8 TURTÓS PALOMA, NÚRIA 6970069596770000 404 404
9 BONET MONTAGUT, MARIA JOSÉ 48575360474859000 372 372
10 CABALLÉ FABRA, RAQUEL 5766596855630000 368 368
11 DOMINI VIDAL, SILVIA 730697363068000 346 346
12 VIDIELLA PIÑOL, SANDRA 00093857985000 342 342
13 GISBERT TORTA, VERÒNICA 075657165066000 342 342
14 BATALLA DOMINGUEZ, SITA 07908575850000 324 324
15 COMES I FORASTERO, PILI 71730069730000 286 286
16 BARÓN VILLALBA, ÀNGELA 9309300093000 279 279
17 BROUGHTON, BETTINA 004962446063000 278 278
18 CABALLÉ FABRA, GEMMA 67071068690000 275 275
19 GALVE CURTO, LUCI 66690706100000 266 266
20 ALIAU CLUA, SANDRA 445452590560000 265 265
21 ROCA BENAIGES, JÚLIA 59686405700000 248 248
22 GONZALEZ SABATE, TRINI 430465841470000 235 235
23 MELICH CAÑADO, LARA 424443570450000 231 231
24 ALCAZAR GINER, AINHOA 52050004962000 213 213
25 LARROSA MUNUERA, YOLANDA 0930115000000 208 208
26 DRAGO CANES, ANDREA 01030001030000 206 206
27 SEGURA RIUS, ELENA 45460610530000 205 205
28 SANCHO FERRÉ, ANDREA 000007175000 146 146
29 AGUEYO BENITO, MILA 0474256000000 145 145
30 PONS CARLES, NEUS 680670000000 135 135
31 BEL POCURULL, SONIA 007306200000 135 135
32 BLANCH VOLTES, TERE 646500000000 129 129
33 FORÉS ESTRADA, IMMA 064610000000 125 125
34 LLAMBRICH PARRA, MONICA 005866000000 124 124
35 ABELLA CALDUCH, MARGA 000005864000 122 122
36 FALCÓN TORMO, EVA 625800000000 120 120
37 TOMAS LORENZ, ROSA 650005400000 119 119
38 CÓRDOVA ANDINO , YESENIA S. 006305600000 119 119
39 RUS GARCIA, PILAR 115000000000 115 115
40 GUARNER PIQUET, MIREIA 001150000000 115 115
41 OBRADOS MURIA, MONTSE 051000610000 112 112
42 ROIG CASTELL, EVA 000010300000 103 103
43 PERALES DOMINI, NEREA 000000103000 103 103
44 BERTOMEU CASANOVA, RAQUEL 045550000000 100 100
45 CRISTEA PETECUTA, MARIA 470000520000 99 99
46 ROJAS PEREZ, CARMEN 048480000000 96 96
47 JIMENEZ SANCHEZ, LAURA 00009300000 93 93
48 MENDOU, KHADIJA 00000930000 93 93
49 DRAGO ROSA, HELENA 85000000000 85 85
50 LLUCH, MARTA 00850000000 85 85
51 GIL CHARRAL, REMEI 410400000000 81 81
52 MARTI CARDONA, MÍRIAM 00007900000 79 79
53 GIRALDEZ ALVARO, EMI 00790000000 79 79
54 ALSO ROIGET, TERE 00000079000 79 79
55 MARTINEZ MENDOZA, MARIA 75000000000 75 75
56 PONS JUAN, EVA 00000750000 75 75
57 PALAU CARULLA, LOLA 00007300000 73 73
58 GÉRALDINE LÓPEZ, SYLVIE 00000073000 73 73
59 WILLOX, NATACHA 00007100000 71 71
60 MARQUEZ GARCIA, SILVIA 00007000000 70 70
61 GARCIA HOMS, LORENA 00700000000 70 70
62 VILLALOBOS MARTINEZ, MARCELA 06700000000 67 67
63 ARASA SUBIRATS, MARISIN 00006700000 67 67
64 SABATER ROYO, RUTH 00660000000 66 66
65 SUBIRATS ABELLA, ANNA 00000650000 65 65
66 VALLS BORRELL, JOSEPA 00065000000 65 65
67 QUERAL MOLINÉ, EVELIN 00000640000 64 64
68 PONS CORTES, ROSA 63000000000 63 63
69 BIOSCA BRULL, JUDIT 06300000000 63 63
70 LENDINES CORTES, CRISTINA 61000000000 61 61
71 BO CABRERA, MARTA 05900000000 59 59
72 SEGURA, EVA MARIA 58000000000 58 58
73 CLUA I GAYA, MARISA 00000570000 57 57
74 ALEMANY VALLS, DAYANA 00570000000 57 57
75 ESTRELLA ARQUIETA, VIVIANA 05600000000 56 56
76 VILANOVA RODRIGUEZ, SONIA 05500000000 55 55
77 PORRES BARCELÓ, SARA 00000550000 55 55
78 VIDAL LOTO, PILI 54000000000 54 54
79 MERÍN PÉREZ, IVET 00000540000 54 54
80 PONS ALEMÁN, BETLEM 00540000000 54 54
81 SANCHEZ HURTADO, CARMEN 53000000000 53 53
82 PUENTES AGUILÓ, AINOA 05300000000 53 53
83 COMES MARGALEF, CARME 05200000000 52 52
84 BERMEJO MULET, MONTSE 51000000000 51 51
85 ZARAGOZA GRANELL, SUSANA 00005100000 51 51
86 MESEGUER CARBÓ, LINA 00510000000 51 51
87 VIÑAU CACHO, RAQUEL 00000510000 51 51
88 PERPIÑA CUEVAS, MAR 50000000000 50 50
89 DRECKER, SABINE 05000000000 50 50
90 HUNAULT NICOLAU, LETICIA 00005000000 50 50
91 BALAGUE MOYA, IDOIA 00000500000 50 50
92 RUIZ MARTINEZ, VANESSA 49000000000 49 49
93 CODORNIU FRANCH, NURIA 04900000000 49 49
94 CERDÀ GARCIA, MONTSE 00004900000 49 49
95 BARBERA FERRANDO, LAURA 00004800000 48 48
96 CALVET ESCUIN, JÚLIA 00470000000 47 47
97 GARCIA ESTELLE, MARIA JOSÉ 46000000000 46 46
98 RODRIGUEZ, ROSANA 00004600000 46 46
99 MORA GRATACOS, IRENE 00000460000 46 46
100 BLANCH RUBERT, NOELIA 00004500000 45 45
101 OCAÑA CABANES, MÒNICA 00450000000 45 45
102 POY, MONTSE 00440000000 44 44
103 ALMEIDA JIMENEZ, MONICA 00004300000 43 43
104 MORALES TOMÀS , PATRICIA 00004200000 42 42
105 RUIZ SEVILLA, ÀNGELA 00410000000 41 41
106 RECIO LLUCH, DAYANA 40000000000 40 40
107 CABANES BALANZA, SOFIA 39000000000 39 39
108 DEZA SEVA , RAQUEL 00390000000 39 39