ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom Cat. AmpostaAmpollaPerellóCamarlesTortosaJesúsDeltebreL'Aldea Total Punts
1 CASTELLS LOPEZ, SUSANA VE1 F11510310300000 321 321
2 SUBIRATS ABELLA, ANNA SEN F103859300000 281 281
3 MARTÍ SOLÉ, RUTH S18 F93738500000 251 251
4 BIARNÉS JORNET, MªDOLORS VE1 F73797300000 225 225
5 CÓRDOVA ANDINO , YESENIA VE2 F70757900000 224 224
6 GALVE CURTO, LUCI VE2 F75707500000 220 220
7 HERMANO, SORIA VE1 F69686700000 204 204
8 GONZÁLEZ TEJERO, ANA VE2 F65666800000 199 199
9 FANDOS COLOMINES, ESTIBALIZ VE1 F66656600000 197 197
10 GIMÉNEZ FERRERES, CLÀUDIA SEN F8593000000 178 178
11 BONET MONTAGUT, MARIA JOSÉ VE1 F59586000000 177 177
12 GAUXACHS MARGALEF, NURIA VE1 F50516100000 162 162
13 AGUILÀ CUBELLS, ANNA SEN F47545900000 160 160
14 SÁNCHEZ FIGUERES , MIREIA VE1 F7971000000 150 150
15 DE LA IGLESIA TUDELA, OLYMPIA VE1 F6161000000 122 122
16 EL AZZIOUI, HAJAR S23 F0115000000 115 115
17 BRULL ALBIOL, GINA SEN F0011500000 115 115
18 MORALES TOMÀS, PATRICIA VE1 F5857000000 115 115
19 RODRIGUEZ, KRISTY RENEE VE1 F5659000000 115 115
20 SALES SOLER, PILAR VE2 F5263000000 115 115
21 FRANCH BONET, ROSANA VE1 M5756000000 113 113
22 VALMAÑA CALBET, CINTA SEN F0555800000 113 113
23 SOLE MONLLAO, NURIA VE1 F0506200000 112 112
24 CUGAT ADELL, GEMMA VE1 F5353000000 106 106
25 VICO GIL, EVA MARIA VE1 F4345000000 88 88
26 GIL MARTI, NEUS VE1 F710000000 71 71
27 GABERNET DIAZ, NURIA VE1 F007100000 71 71
28 HOMEDES NADAL , ESMERALDA SEN F007000000 70 70
29 HERNANDEZ HERRERO, MARTA VE2 F069000000 69 69
30 STIRBA, RUSANDA S23 F006900000 69 69
31 CASANOVA REVERTÉ, JÚLIA S18 F680000000 68 68
32 CASTELBLANQUE SOLER, AIDA SEN F670000000 67 67
33 SAMARRA CAMPOY, SANDRA SEN F006500000 65 65
34 COTIANA MONTERO, ANNA S18 F064000000 64 64
35 GARCIA LLUIS, IRIS S23 F640000000 64 64
36 SANCHEZ IGLESIAS, MARI VE1 F006400000 64 64
37 LABORIA MARGALEF, JOANA VE1 F630000000 63 63
38 CAMPOY BENAIGES, SOL VE2 F006300000 63 63
39 SANCHEZ, JEANNE SEN F062000000 62 62
40 SALVADOR SUTTON, MARIA EUGENIA VE1 F620000000 62 62
41 RIBES MONTAÑA, AINA S18 F060000000 60 60
42 BLANQUET BAYERRI, MONTSE VE1 F600000000 60 60
43 ANTO ROMEU, ELI SEN F005700000 57 57
44 TULIESA GRANELL, MARIA MERCE VE1 F005600000 56 56
45 FORCADELL MONTSERRAT, JESSICA SEN F550000000 55 55
46 CUGAT ADELL, MAR VE2 F540000000 54 54
47 COTAINA GILABERT, ELISABET SEN F052000000 52 52
48 MESTRE GARCIA, ROSA MARIA VE1 F510000000 51 51
49 BORRAS MARGALEF, CRISTINA VE1 F049000000 49 49
50 MONSÓ LAMELAS, NOEMI VE1 F490000000 49 49
51 DE COLSA LORENZO, ROSA VE1 F048000000 48 48
52 VERNAT GARRIGA, GEMMA S23 F480000000 48 48
53 SCIORA, CORINNE VE2 F047000000 47 47
54 PÉREZ MÁRQUEZ, JÉSSICA SEN F046000000 46 46
55 GARRIGA BALAGUÉ, NOELIA VE1 F460000000 46 46
56 VILANOVA RODRIGUEZ, SONIA VE2 F450000000 45 45
57 JUAN ALONSO, MARGARITA MA2 F044000000 44 44
58 CECÍLIA GALLEGO , SUSANNA VE1 F440000000 44 44
59 BOSCH MONTAÑES, NURIA VE1 F420000000 42 42
60 CARTOIXÀ BENAIGES, CINTA SEN F410000000 41 41
61 GONZÀLEZ GARRIGA, ARIADNA SEN F400000000 40 40