VETERÀ-2 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="VE2 F" GROUP BY dni ORDER BY punts DESC, desempat ASC..
Pos Nom AmpostaL'AmpollaUlldeconaPerellóS.BàrbaraCamarlesTortosaDeltebreLa GaleraJesús Total Punts
1 DOMINI VIDAL, SILVIA 1150115103000000 333 333
2 TURTÓS PALOMA, NÚRIA 103103093000000 299 299
3 BATALLA DOMINGUEZ, SITA 01150115000000 230 230
4 SEGURA RIUS, ELENA 7375079000000 227 227
5 AGUEYO BENITO, MILA 0797573000000 227 227
6 GONZALEZ SABATE, TRINI 7107975000000 225 225
7 LLAMBRICH PARRA, MONICA 0010385000000 188 188
8 ROJAS PEREZ, CARMEN 085930000000 178 178
9 SANCHEZ HURTADO, CARMEN 93000000000 93 93
10 DRECKER, SABINE 09300000000 93 93
11 BERMEJO MULET, MONTSE 85000000000 85 85
12 CALVET ESCUIN, JÚLIA 00850000000 85 85
13 PERPIÑA CUEVAS, MAR 79000000000 79 79
14 GARCIA ESTELLE, MARIA JOSÉ 75000000000 75 75