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 F1150000000 115 115
2 SUBIRATS ABELLA, ANNA SEN F1030000000 103 103
3 MARTÍ SOLÉ, RUTH S18 F930000000 93 93
4 GIMÉNEZ FERRERES, CLÀUDIA SEN F850000000 85 85
5 SÁNCHEZ FIGUERES , MIREIA VE1 F790000000 79 79
6 GALVE CURTO, LUCI VE2 F750000000 75 75
7 BIARNÉS JORNET, MªDOLORS VE1 F730000000 73 73
8 GIL MARTI, NEUS VE1 F710000000 71 71
9 CÓRDOVA ANDINO , YESENIA VE2 F700000000 70 70
10 HERMANO, SORIA VE1 F690000000 69 69
11 CASANOVA REVERTÉ, JÚLIA S18 F680000000 68 68
12 CASTELBLANQUE SOLER, AIDA SEN F670000000 67 67
13 FANDOS COLOMINES, ESTIBALIZ VE1 F660000000 66 66
14 GONZÁLEZ TEJERO, ANA VE2 F650000000 65 65
15 GARCIA LLUIS, IRIS S23 F640000000 64 64
16 LABORIA MARGALEF, JOANA VE1 F630000000 63 63
17 SALVADOR SUTTON, MARIA EUGENIA VE1 F620000000 62 62
18 DE LA IGLESIA TUDELA, OLYMPIA VE1 F610000000 61 61
19 BLANQUET BAYERRI, MONTSE VE1 F600000000 60 60
20 BONET MONTAGUT, MARIA JOSÉ VE1 F590000000 59 59
21 MORALES TOMÀS, PATRICIA VE1 F580000000 58 58
22 FRANCH BONET, ROSANA VE1 M570000000 57 57
23 RODRIGUEZ, KRISTY RENEE VE1 F560000000 56 56
24 FORCADELL MONTSERRAT, JESSICA SEN F550000000 55 55
25 CUGAT ADELL, MAR VE2 F540000000 54 54
26 CUGAT ADELL, GEMMA VE1 F530000000 53 53
27 SALES SOLER, PILAR VE2 F520000000 52 52
28 MESTRE GARCIA, ROSA MARIA VE1 F510000000 51 51
29 GAUXACHS MARGALEF, NURIA VE1 F500000000 50 50
30 MONSÓ LAMELAS, NOEMI VE1 F490000000 49 49
31 VERNAT GARRIGA, GEMMA S23 F480000000 48 48
32 AGUILÀ CUBELLS, ANNA SEN F470000000 47 47
33 GARRIGA BALAGUÉ, NOELIA VE1 F460000000 46 46
34 VILANOVA RODRIGUEZ, SONIA VE2 F450000000 45 45
35 CECÍLIA GALLEGO , SUSANNA VE1 F440000000 44 44
36 VICO GIL, EVA MARIA VE1 F430000000 43 43
37 BOSCH MONTAÑES, NURIA VE1 F420000000 42 42
38 CARTOIXÀ BENAIGES, CINTA SEN F410000000 41 41
39 GONZÀLEZ GARRIGA, ARIADNA SEN F400000000 40 40