CLASSIFICACIÓ 5K: SÈNIOR FEMENÍ

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

Pos	Nom	Amposta	Ampolla	Total	Punts
1	GIMÉNEZ FERRERES, CLÀUDIA	115	115	230	230
2	FERRÉ ESMEL, CLÀUDIA	103	103	206	206
3	RODRIGUEZ SALVADO, ANNA	93	93	186	186
4	SANCHEZ CALVO, LAURIE	79	79	158	158
5	ESTRADA, REBECA	68	73	141	141
6	GALLARDO GÜELL, SÒNIA	0	85	85	85
7	JORNET SABATÉ, MIRIAM	85	0	85	85
8	BLANCH RUBERT, NOELIA	0	75	75	75
9	BONFILL CERVERO, AIDA	75	0	75	75
10	BONFILL CERVERÓ, CARLA	73	0	73	73
11	NAVARRO FRANCH, CARINA	0	71	71	71
12	CASTELBLANQUE SOLER, AIDA	71	0	71	71
13	BO CABRERA, MARTA	0	70	70	70
14	GARRIGA BALAGUÉ , MARIA	70	0	70	70
15	VILLARROYA LLUCH, NURIA	0	69	69	69
16	FORTUÑO, OFRA	69	0	69	69
17	AGUILÀ CUBELLS, ANNA	0	68	68	68
18	ALTABA RABAZA, BELÉN	0	67	67	67
19	COLOMINES GARCIA, LARA	0	66	66	66

Amb el suport de: