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 7985791037979103000 607 607
2 REDO VIUDEZ, SUSANA 103093115738585000 554 554
3 VALLS RIOS, PATRICIA 69716971667375000 494 494
4 MONSERRAT MONTAGUT, SÍLVIA 67707173677073000 491 491
5 BONET MONTAGUT, MARIA JOSÉ 64686770626771000 469 469
6 GISBERT TORTA, VERÒNICA 0103759375093000 439 439
7 CABALLÉ FABRA, RAQUEL 6875707968750000 435 435
8 COMES I FORASTERO, PILI 85930085930000 356 356
9 MELICH CAÑADO, LARA 626365690660000 325 325
10 GALVE CURTO, LUCI 75790857000000 309 309
11 DRAGO CANES, ANDREA 01150001150000 230 230
12 BEL POCURULL, SONIA 008507100000 156 156
13 ABELLA CALDUCH, MARGA 000006979000 148 148
14 BLANCH VOLTES, TERE 737300000000 146 146
15 CÓRDOVA ANDINO , YESENIA S. 007306900000 142 142
16 FALCÓN TORMO, EVA 706900000000 139 139
17 OBRADOS MURIA, MONTSE 065000710000 136 136
18 BERTOMEU CASANOVA, RAQUEL 064680000000 132 132
19 CRISTEA PETECUTA, MARIA 630000680000 131 131
20 RUS GARCIA, PILAR 115000000000 115 115
21 LLUCH, MARTA 001150000000 115 115
22 PALAU CARULLA, LOLA 000011500000 115 115
23 GÉRALDINE LÓPEZ, SYLVIE 000000115000 115 115
24 GIRALDEZ ALVARO, EMI 001030000000 103 103
25 PONS JUAN, EVA 000001030000 103 103
26 WILLOX, NATACHA 000010300000 103 103
27 MARTINEZ MENDOZA, MARIA 93000000000 93 93
28 MARQUEZ GARCIA, SILVIA 00009300000 93 93
29 VALLS BORRELL, JOSEPA 00075000000 75 75
30 PONS CORTES, ROSA 71000000000 71 71
31 ESTRELLA ARQUIETA, VIVIANA 06700000000 67 67
32 VILANOVA RODRIGUEZ, SONIA 06600000000 66 66
33 VIDAL LOTO, PILI 66000000000 66 66
34 OCAÑA CABANES, MÒNICA 00660000000 66 66
35 RUIZ MARTINEZ, VANESSA 65000000000 65 65
36 ZARAGOZA GRANELL, SUSANA 00006500000 65 65
37 HUNAULT NICOLAU, LETICIA 00006400000 64 64
38 BARBERA FERRANDO, LAURA 00006300000 63 63
39 RODRIGUEZ, ROSANA 00006100000 61 61
40 MORALES TOMÀS , PATRICIA 00006000000 60 60