CLASSIFICACIÓ 5K: ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=221 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=222 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=223 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=224 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=225 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=226 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=227 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=228 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic5 WHERE idcursa=229 AND dni=doc ),0) AS nou, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic5 WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..

Pos	Nom	Cat.	Camarles	L'Ampolla	L'Aldea	Amposta	Deltebre	Total	Punts
1	MARTÍ SOLÉ, RUTH	S18 F	115	0	0	0	0	115	115
2	RIUS LLETÍ, JÚLIA	SEN F	103	0	0	0	0	103	103
3	REBULL DE LA VEGA, ANNA	S18 F	93	0	0	0	0	93	93
4	GIMÉNEZ FERRERES, CLÀUDIA	VE1 F	85	0	0	0	0	85	85
5	ACOSTA DORADO, ZAMARA	VE1 F	79	0	0	0	0	79	79
6	HERNANDEZ HERRERO, MARTA	VE2 F	75	0	0	0	0	75	75
7	QUERAL MARTI, PAULA	S18 F	73	0	0	0	0	73	73
8	LLAMBRICH FERRÉ, LARA	S23 F	71	0	0	0	0	71	71
9	GALVE CURTO, LUCI	VE2 F	70	0	0	0	0	70	70
10	FUMADÓ PRIMÉ, INGRID	SEN F	69	0	0	0	0	69	69
11	RODRIGUEZ SALVADO, ANNA	SEN F	68	0	0	0	0	68	68
12	PAGÀ FRANCH, MIREIA	SEN F	67	0	0	0	0	67	67
13	MANZANARES TORRES, BEATRIZ	SEN F	66	0	0	0	0	66	66
14	CABRERA MORA, ESTHER	VE2 F	65	0	0	0	0	65	65
15	PERREAU DE PINNINCK GAYNÉS , ANA	VE1 F	64	0	0	0	0	64	64
16	BROUGHTON, BETTINA	MA2 F	63	0	0	0	0	63	63
17	MARCO, NÚRIA	SEN F	62	0	0	0	0	62	62
18	BONFILL CERVERÓ, CARLA	SEN F	61	0	0	0	0	61	61
19	CASANOVA FUMADÓ, LAURA	SEN F	60	0	0	0	0	60	60
20	SANTANDREU, ALBA	SEN F	59	0	0	0	0	59	59
21	BELTRI ARMENGOL, IRENE	VE1 F	58	0	0	0	0	58	58
22	BLANCH RUBERT, NOELIA	SEN F	57	0	0	0	0	57	57
23	TOMAS ALVAREZ, ANDREA	S23 F	56	0	0	0	0	56	56
24	BELTRAN DESCARREGA, NÚRIA	VE1 F	55	0	0	0	0	55	55
25	CURTO QUERALT, NEUS	VE1 F	54	0	0	0	0	54	54