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 0115103011511511510300 666 666
2 PELLICER MARTINEZ, SANDRA 7071687566687393750 659 593
3 TURTÓS PALOMA, NÚRIA 697006959677170710 546 546
4 ESCUDERO BARBERÀ, CINTA 5661626758666873680 579 523
5 BARÓN VILLALBA, ÀNGELA 930930001031151030 507 507
6 REDO VIUDEZ, SUSANA 79075796470666800 501 501
7 GISBERT TORTA, VERÒNICA 07565716506779690 491 491
8 CABALLÉ FABRA, RAQUEL 576659685563064590 491 491
9 VALLS RIOS, PATRICIA 6062566352626263550 535 483
10 MONSERRAT MONTAGUT, SÍLVIA 5560606453596165560 533 480
11 VIDIELLA PIÑOL, SANDRA 000938579930930 443 443
12 BONET MONTAGUT, MARIA JOSÉ 4857536047486058510 482 435
13 DOMINI VIDAL, SILVIA 7306973630698500 432 432
14 VILLAR SALDAÑA, OLGA 10385010360070000 421 421
15 CABALLÉ FABRA, GEMMA 6707106869071640 410 410
16 BATALLA DOMINGUEZ, SITA 079085758500730 397 397
17 BROUGHTON, BETTINA 00496244606460580 397 397
18 LARROSA MUNUERA, YOLANDA 093011500075790 362 362
19 GONZALEZ SABATE, TRINI 43046584147057500 342 342
20 MELICH CAÑADO, LARA 42444357045056470 334 334
21 GALVE CURTO, LUCI 666907061000670 333 333
22 ALIAU CLUA, SANDRA 4454525905606100 326 326
23 COMES I FORASTERO, PILI 71730069730000 286 286
24 ROCA BENAIGES, JÚLIA 59686405700000 248 248
25 LLAMBRICH PARRA, MONICA 00586600062610 247 247
26 GUARNER PIQUET, MIREIA 00115000001150 230 230
27 ALCAZAR GINER, AINHOA 52050004963000 214 214
28 DRAGO CANES, ANDREA 01030001030000 206 206
29 SEGURA RIUS, ELENA 45460610530000 205 205
30 ABELLA CALDUCH, MARGA 0000058656700 190 190
31 TOMAS LORENZ, ROSA 6500054000660 185 185
32 ALSO ROIGET, TERE 000000850850 170 170
33 SANCHO FERRÉ, ANDREA 000007179000 150 150
34 AGUEYO BENITO, MILA 0474256000000 145 145
35 PONS CARLES, NEUS 680670000000 135 135
36 BEL POCURULL, SONIA 007306200000 135 135
37 BLANCH VOLTES, TERE 646500000000 129 129
38 ALEMANY VALLS, DAYANA 005700000700 127 127
39 FORÉS ESTRADA, IMMA 064610000000 125 125
40 FALCÓN TORMO, EVA 625800000000 120 120
41 CÓRDOVA ANDINO , YESENIA S. 006305600000 119 119
42 CLUA I GAYA, MARISA 000005705900 116 116
43 RUS GARCIA, PILAR 115000000000 115 115
44 ZARAGOZA GRANELL, SUSANA 000051000630 114 114
45 OBRADOS MURIA, MONTSE 051000610000 112 112
46 RODRIGUEZ, ROSANA 000046000600 106 106
47 ROIG CASTELL, EVA 000010300000 103 103
48 BERTOMEU CASANOVA, RAQUEL 045550000000 100 100
49 CRISTEA PETECUTA, MARIA 470000520000 99 99
50 ROJAS PEREZ, CARMEN 048480000000 96 96
51 ALMEIDA JIMENEZ, MONICA 000043000530 96 96
52 JIMENEZ SANCHEZ, LAURA 00009300000 93 93
53 MENDOU, KHADIJA 00000930000 93 93
54 OCAÑA CABANES, MÒNICA 004500000480 93 93
55 DRAGO ROSA, HELENA 85000000000 85 85
56 LLUCH, MARTA 00850000000 85 85
57 GIL CHARRAL, REMEI 410400000000 81 81
58 MARTI CARDONA, MÍRIAM 00007900000 79 79
59 GIRALDEZ ALVARO, EMI 00790000000 79 79
60 MARTINEZ MENDOZA, MARIA 75000000000 75 75
61 PONS JUAN, EVA 00000750000 75 75
62 GÉRALDINE LÓPEZ, SYLVIE 00000075000 75 75
63 PALAU CARULLA, LOLA 00007300000 73 73
64 WILLOX, NATACHA 00007100000 71 71
65 MARQUEZ GARCIA, SILVIA 00007000000 70 70
66 GARCIA HOMS, LORENA 00700000000 70 70
67 CASANOVA GARRIGÓS, GEORGINA 00000006900 69 69
68 VILLALOBOS MARTINEZ, MARCELA 06700000000 67 67
69 ARASA SUBIRATS, MARISIN 00006700000 67 67
70 SABATER ROYO, RUTH 00660000000 66 66
71 ALSO ANDRADE, ROSA MARIA 00000006600 66 66
72 RIBOT VALLÉS, MAITE 00000000650 65 65
73 SUBIRATS ABELLA, ANNA 00000650000 65 65
74 VALLS BORRELL, JOSEPA 00065000000 65 65
75 QUERAL MOLINÉ, EVELIN 00000640000 64 64
76 PONS CORTES, ROSA 63000000000 63 63
77 BIOSCA BRULL, JUDIT 06300000000 63 63
78 RUIZ FERNANDEZ, MERCHE 00000000620 62 62
79 LENDINES CORTES, CRISTINA 61000000000 61 61
80 BO CABRERA, MARTA 05900000000 59 59
81 SEGURA, EVA MARIA 58000000000 58 58
82 RALLO FABRA, AIDA 00000000570 57 57
83 ESTRELLA ARQUIETA, VIVIANA 05600000000 56 56
84 VILANOVA RODRIGUEZ, SONIA 05500000000 55 55
85 PORRES BARCELÓ, SARA 00000550000 55 55
86 VIDAL LOTO, PILI 54000000000 54 54
87 COYARD, VANINA 00000000540 54 54
88 PONS ALEMÁN, BETLEM 00540000000 54 54
89 MERÍN PÉREZ, IVET 00000540000 54 54
90 SANCHEZ HURTADO, CARMEN 53000000000 53 53
91 PUENTES AGUILÓ, AINOA 05300000000 53 53
92 COMES MARGALEF, CARME 05200000000 52 52
93 TEBAR ROCA, MERITXELL 00000000520 52 52
94 BERMEJO MULET, MONTSE 51000000000 51 51
95 MESEGUER CARBÓ, LINA 00510000000 51 51
96 VIÑAU CACHO, RAQUEL 00000510000 51 51
97 PERPIÑA CUEVAS, MAR 50000000000 50 50
98 DRECKER, SABINE 05000000000 50 50
99 HUNAULT NICOLAU, LETICIA 00005000000 50 50
100 BALAGUE MOYA, IDOIA 00000500000 50 50
101 RUIZ MARTINEZ, VANESSA 49000000000 49 49
102 CODORNIU FRANCH, NURIA 04900000000 49 49
103 CERDÀ GARCIA, MONTSE 00004900000 49 49
104 ALCANAR QUERALT, LORENA 00000000490 49 49
105 BARBERA FERRANDO, LAURA 00004800000 48 48
106 CALVET ESCUIN, JÚLIA 00470000000 47 47
107 GARCIA ESTELLE, MARIA JOSÉ 46000000000 46 46
108 MORA GRATACOS, IRENE 00000460000 46 46
109 BLANCH RUBERT, NOELIA 00004500000 45 45
110 POY, MONTSE 00440000000 44 44
111 MORALES TOMÀS , PATRICIA 00004200000 42 42
112 RUIZ SEVILLA, ÀNGELA 00410000000 41 41
113 RECIO LLUCH, DAYANA 40000000000 40 40
114 CABANES BALANZA, SOFIA 39000000000 39 39
115 DEZA SEVA , RAQUEL 00390000000 39 39