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 dos, IFNULL((SELECT puntscat FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, 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, IFNULL((SELECT puntscat FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, 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àrbaraCamarlesTortosaJesúsDeltebreLa GaleraL'Aldea Total Punts
1 MARQUEZ GARCIA, SILVIA 1150000000000 115 115
2 ALSO ROIGET, TERE 1030000000000 103 103
3 FORT RODRIGUEZ, ROSANA 930000000000 93 93
4 PELLICER MARTINEZ, SANDRA 850000000000 85 85
5 COMES I FORASTERO, PILI 790000000000 79 79
6 ESTORACH ARASA, MIRIAM 750000000000 75 75
7 TORTA, CARME 730000000000 73 73
8 FALCÓN TORMO, EVA 710000000000 71 71
9 CABALLÉ FABRA, RAQUEL 700000000000 70 70
10 RUIZ MARTINEZ, VANESSA 690000000000 69 69
11 IRIGOYEN GARCIA, SILVIA 680000000000 68 68
12 IBAÑEZ ARTIGAS, TRINI 670000000000 67 67
13 LARA, CLARISA 660000000000 66 66
14 COMÍ CODINA , SÒNIA 650000000000 65 65