CLASSIFICACIÓ 10K: ABSOLUT FEMENÍ

SELECT nom as sujeto, dni as doc, sexe as sex1, categoria as cate, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=130 AND dni=doc ),0) AS una, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=131 AND dni=doc ),0) AS dos, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=132 AND dni=doc ),0) AS tres, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=133 AND dni=doc ),0) AS quatre, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=134 AND dni=doc ),0) AS cinc, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=135 AND dni=doc ),0) AS sis, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=136 AND dni=doc ),0) AS siet, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=137 AND dni=doc ),0) AS vuit, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=138 AND dni=doc ),0) AS nou, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=139 AND dni=doc ),0) AS deu, IFNULL((SELECT puntsgen FROM historic WHERE idcursa=140 AND dni=doc ),0) AS once, SUM(puntsgen) AS punts, SUM(empat) as desempat FROM historic WHERE sexe="F" GROUP BY dni ORDER BY punts DESC, desempat ASC..

Pos	Nom	Cat.	Camarles	L'Ampolla	La Galera	L'Aldea	Amposta	Deltebre	Total	Punts
1	COLOME ESTRADA, GEMMA	SEN F	115	115	103	115	0	0	448	448
2	FERRÉ ESMEL, CLÀUDIA	SEN F	93	79	71	79	0	0	322	322
3	CABALLÉ FABRA, GEMMA	SEN F	0	103	85	103	0	0	291	291
4	BONET MONTAGUT, MARIA JOSÉ	VE1 F	66	66	62	68	0	0	262	262
5	GIL VICO, DOLORS	VE2 F	65	67	61	66	0	0	259	259
6	FERNÁNDEZ PAREJA, SARA	SEN F	64	64	60	67	0	0	255	255
7	SEGURA RIUS, ELENA	MA1 F	85	71	0	71	0	0	227	227
8	PALLARES ALIAU, AIDA	SEN F	0	85	0	93	0	0	178	178
9	PAULINO ANDREU, MARTA	SEN F	69	0	93	0	0	0	162	162
10	GIMÉNEZ FERRERES, CLÀUDIA	VE1 F	0	0	73	85	0	0	158	158
11	ROYO VERGE, JULIA	S23 F	0	0	79	75	0	0	154	154
12	BUTLER, JOANNA	VE1 F	79	0	70	0	0	0	149	149
13	MESEGUER CARBÓ, LINA	VE1 F	67	69	0	0	0	0	136	136
14	FREIXA VALLS, MARINA	S23 F	0	0	115	0	0	0	115	115
15	TURTÓS PALOMA, NÚRIA	VE2 F	103	0	0	0	0	0	103	103
16	TALARN FERRANDO, CRISTINA	SEN F	0	93	0	0	0	0	93	93
17	CALLARISA BEL, CELIA	VE1 F	0	0	75	0	0	0	75	75
18	ARJONA CABRERA, ANA	VE2 F	75	0	0	0	0	0	75	75
19	LLAÓ BORRÀS, ELISABET	SEN F	0	75	0	0	0	0	75	75
20	MARTOS REDO , IOLANDA	VE2 F	73	0	0	0	0	0	73	73
21	ESTORACH ARASA, MIRIAM	VE1 F	0	0	0	73	0	0	73	73
22	LUQUE DAUDE , ARIADNA	SEN F	0	73	0	0	0	0	73	73
23	BUERA ALBALAT, ANDREA	SEN F	71	0	0	0	0	0	71	71
24	ESCUDE MIRALLES, IMMA	VE2 F	70	0	0	0	0	0	70	70
25	ROMANI GUART, MONTSE	VE1 F	0	0	0	70	0	0	70	70
26	SOLANDE GALINDO, GISELA	SEN F	0	70	0	0	0	0	70	70
27	PRINCEP COLOMÉ, ALEXANDRA	VE1 F	0	0	69	0	0	0	69	69
28	RUIZ MARTINEZ, VANESSA	VE1 F	0	0	0	69	0	0	69	69
29	SEGURA VILANOVA, MÒNICA	S23 F	0	0	68	0	0	0	68	68
30	BERTOMEU BELLÉS, ROMINA	SEN F	68	0	0	0	0	0	68	68
31	HERRERA GARCIA, MARIA	VE2 F	0	68	0	0	0	0	68	68
32	FUMADÓ PRIMÉ, INGRID	SEN F	0	0	67	0	0	0	67	67
33	TOMAS LORENZ, ROSA	VE1 F	0	0	66	0	0	0	66	66
34	CASANOVA FUMADÓ, LAURA	SEN F	0	0	65	0	0	0	65	65
35	PRATS SERRAT, ESTELA	VE1 F	0	0	0	65	0	0	65	65
36	ALIAU CLUA, SANDRA	SEN F	0	65	0	0	0	0	65	65
37	RALLO FABRA, AIDA	SEN F	0	0	64	0	0	0	64	64
38	BEL FERRÉ , INÉS	SEN F	0	0	63	0	0	0	63	63
39	ESTORACH SOL, ALBA	SEN F	63	0	0	0	0	0	63	63
40	BEDOS BELTRAN, MAIKA	SEN F	62	0	0	0	0	0	62	62
41	ALCANAR QUERALT, LORENA	VE1 F	0	0	59	0	0	0	59	59
42	BROUGHTON, BETTINA	MA2 F	0	0	58	0	0	0	58	58
43	BONIN I RALLO, LAISA	S23 F	0	0	57	0	0	0	57	57
44	BLASQUIZ LOPEZ, CRISTINA	VE1 F	0	0	56	0	0	0	56	56

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.