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	115	115	0	0	345	345
2	REBULL DE LA VEGA, ANNA	S18 F	93	93	79	0	0	265	265
3	FUMADÓ PRIMÉ, INGRID	SEN F	69	75	93	0	0	237	237
4	RODRIGUEZ SALVADO, ANNA	SEN F	68	79	85	0	0	232	232
5	GALVE CURTO, LUCI	VE2 F	70	70	71	0	0	211	211
6	PRINCEP COLOMÉ, ALEXANDRA	VE1 F	0	103	103	0	0	206	206
7	PAGÀ FRANCH, MIREIA	SEN F	67	67	68	0	0	202	202
8	CASANOVA FUMADÓ, LAURA	SEN F	60	66	65	0	0	191	191
9	BROUGHTON, BETTINA	MA2 F	63	63	62	0	0	188	188
10	CHAVARRIA ALBIOL, NURIA	SEN F	0	85	73	0	0	158	158
11	HERNANDEZ HERRERO, MARTA	VE2 F	75	0	75	0	0	150	150
12	VALLESPI GORRITA, LAIA	S18 F	0	73	70	0	0	143	143
13	LLAMBRICH FERRÉ, LARA	S23 F	71	0	66	0	0	137	137
14	RIUS LLETÍ, JÚLIA	SEN F	103	0	0	0	0	103	103
15	GIMÉNEZ FERRERES, CLÀUDIA	VE1 F	85	0	0	0	0	85	85
16	ACOSTA DORADO, ZAMARA	VE1 F	79	0	0	0	0	79	79
17	QUERAL MARTI, PAULA	S18 F	73	0	0	0	0	73	73
18	SANCHEZ CALVO, LAURIE	SEN F	0	71	0	0	0	71	71
19	BERTOMEU BELLÉS, ROMINA	SEN F	0	69	0	0	0	69	69
20	FORNÉ ARASA, JUDIT	S18 F	0	0	69	0	0	69	69
21	ALMEIDA JIMENEZ, MONICA	VE2 F	0	68	0	0	0	68	68
22	BEL FERRÉ , INÉS	SEN F	0	0	67	0	0	67	67
23	MANZANARES TORRES, BEATRIZ	SEN F	66	0	0	0	0	66	66
24	CABRERA MORA, ESTHER	VE2 F	65	0	0	0	0	65	65
25	FERRÉ TOMÀS, SARAI	SEN F	0	65	0	0	0	65	65
26	PERREAU DE PINNINCK GAYNÉS , ANA	VE1 F	64	0	0	0	0	64	64
27	RUBIO RISCO, TOÑI	VE1 F	0	64	0	0	0	64	64
28	MULET MORENO, RAQUEL	VE1 F	0	0	64	0	0	64	64
29	GILABERT VIDIELLA, JENIFER	SEN F	0	0	63	0	0	63	63
30	MARCO, NÚRIA	SEN F	62	0	0	0	0	62	62
31	CARRETERO NECHES, BEGOÑA	VE1 F	0	62	0	0	0	62	62
32	BONFILL CERVERÓ, CARLA	SEN F	61	0	0	0	0	61	61
33	JUAN ALONSO, MARGARITA	MA2 F	0	61	0	0	0	61	61
34	SANZ MURCIA, ESTEFANIA	SEN F	0	0	61	0	0	61	61
35	UNITT, SUSAN	MA1 F	0	60	0	0	0	60	60
36	PONCE SANCHEZ, AIDA	SEN F	0	0	60	0	0	60	60
37	SANTANDREU, ALBA	SEN F	59	0	0	0	0	59	59
38	FERRER COT, MARIA JOSE	VE2 F	0	59	0	0	0	59	59
39	AGUILÀ CUBELLS, ANNA	SEN F	0	0	59	0	0	59	59
40	BELTRI ARMENGOL, IRENE	VE1 F	58	0	0	0	0	58	58
41	BLANCH RUBERT, NOELIA	SEN F	57	0	0	0	0	57	57
42	TOMAS ALVAREZ, ANDREA	S23 F	56	0	0	0	0	56	56
43	BELTRAN DESCARREGA, NÚRIA	VE1 F	55	0	0	0	0	55	55
44	CURTO QUERALT, NEUS	VE1 F	54	0	0	0	0	54	54

comunicar incidències sobre les classificacions.
Recorda que per a incidències i/o reclamacions sobre classificacions hi ha un període de 15 dies després de la primera publicació de les classificacions de cada cursa.