VETERÀ-1 FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntscat FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntscat FROM historic WHERE idcursa=131 AND dni=doc ),0) AS tres, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS dos, IFNULL((SELECT puntscat FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntscat FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntscat FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntscat FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntscat FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntscat FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntscat FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, SUM(puntscat) AS punts, SUM(empat) as desempat FROM historic WHERE categoria="VE1 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 PELLICER MARTINEZ, SANDRA 79857910379791031151150 837 758
2 GISBERT TORTA, VERÒNICA 01037593750931031030 645 645
3 REDO VIUDEZ, SUSANA 1030931157385858500 639 639
4 CABALLÉ FABRA, RAQUEL 687570796875071750 581 581
5 MONSERRAT MONTAGUT, SÍLVIA 6770717367707373730 637 570
6 VALLS RIOS, PATRICIA 6971697166737570710 635 569
7 BONET MONTAGUT, MARIA JOSÉ 6468677062677169690 607 545
8 MELICH CAÑADO, LARA 62636569066068660 459 459
9 GALVE CURTO, LUCI 757908570000930 402 402
10 COMES I FORASTERO, PILI 85930085930000 356 356
11 DRAGO CANES, ANDREA 01150001150000 230 230
12 ABELLA CALDUCH, MARGA 0000069797900 227 227
13 BEL POCURULL, SONIA 008507100000 156 156
14 ZARAGOZA GRANELL, SUSANA 000065000850 150 150
15 BLANCH VOLTES, TERE 737300000000 146 146
16 CÓRDOVA ANDINO , YESENIA S. 007306900000 142 142
17 RODRIGUEZ, ROSANA 000061000790 140 140
18 FALCÓN TORMO, EVA 706900000000 139 139
19 OBRADOS MURIA, MONTSE 065000710000 136 136
20 OCAÑA CABANES, MÒNICA 006600000670 133 133
21 BERTOMEU CASANOVA, RAQUEL 064680000000 132 132
22 CRISTEA PETECUTA, MARIA 630000680000 131 131
23 RUS GARCIA, PILAR 115000000000 115 115
24 LLUCH, MARTA 001150000000 115 115
25 PALAU CARULLA, LOLA 000011500000 115 115
26 GÉRALDINE LÓPEZ, SYLVIE 000000115000 115 115
27 GIRALDEZ ALVARO, EMI 001030000000 103 103
28 PONS JUAN, EVA 000001030000 103 103
29 WILLOX, NATACHA 000010300000 103 103
30 MARTINEZ MENDOZA, MARIA 93000000000 93 93
31 MARQUEZ GARCIA, SILVIA 00009300000 93 93
32 CASANOVA GARRIGÓS, GEORGINA 00000009300 93 93
33 ALSO ANDRADE, ROSA MARIA 00000007500 75 75
34 VALLS BORRELL, JOSEPA 00075000000 75 75
35 PONS CORTES, ROSA 71000000000 71 71
36 TEBAR ROCA, MERITXELL 00000000700 70 70
37 ALCANAR QUERALT, LORENA 00000000680 68 68
38 ESTRELLA ARQUIETA, VIVIANA 06700000000 67 67
39 VILANOVA RODRIGUEZ, SONIA 06600000000 66 66
40 VIDAL LOTO, PILI 66000000000 66 66
41 RUIZ MARTINEZ, VANESSA 65000000000 65 65
42 HUNAULT NICOLAU, LETICIA 00006400000 64 64
43 BARBERA FERRANDO, LAURA 00006300000 63 63
44 MORALES TOMÀS , PATRICIA 00006000000 60 60