Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

Granada CF Fem

Entrenador: Roger Lamesa

Temporada 2023/2024

TEMPORADA 2023/2024

PRIMERA DIVISIÓN FEMENINA
Equipo		PJ	GF	GC	Puntos
1	Barcelona	24	106	8	70
2	Real Madrid	24	62	27	58
3	Levante Fem	25	46	23	47
4	Madrid	24	53	38	46
5	Atlético	24	42	18	45
6	Athletic	25	31	27	44
7	Sevilla	25	47	49	39
8	Costa Adeje	25	33	40	31
9	Real	24	30	43	29
10	Valencia	25	31	49	26
11	Eibar Fem	25	18	40	26
12	Granada	25	27	46	24
13	Real Betis	25	25	61	22
14	Villarreal	25	22	47	21
15	Levante	24	28	49	20
16	Sporting	25	16	52	6

TEMPORADA 2022/2023

PRIMERA FEDERACIÓN FEMENINA GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	58	31	59
2	Eibar Fem	30	31	18	53
3	Deportivo	30	52	29	53
4	Osasuna Fem	30	42	23	52
5	Granada	30	40	28	50
6	Cacereño	30	34	28	48
7	AEM Fem	30	35	30	47
8	Logroño	30	42	38	43
9	Espanyol	30	38	35	40
10	Alba	30	32	32	37
11	Athletic	30	34	51	36
12	Rayo	30	31	45	35
13	Tenerife	30	24	37	34
14	Real Oviedo	30	28	45	27
15	Córdoba	30	27	48	24
16	Juan Grande	30	24	54	19

TEMPORADA 2021/2022

PRIMERA DIVISIÓN B FEMENINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Alhama	30	65	33	62
2	Cacereño	30	53	39	53
3	Granada	30	46	31	53
4	Juan Grande	30	41	32	51
5	Tenerife	30	36	33	47
6	Alba	30	62	51	47
7	Madrid	30	54	46	46
8	Córdoba	30	42	34	45
9	Santa Teresa	30	38	30	44
10	Spar Gran C.	30	48	49	37
11	Real Union.	30	35	41	36
12	Pozoalbense	30	40	57	33
13	Solana	30	32	37	28
14	Real Betis	30	33	55	28
15	Elche	30	37	54	28
16	Castellón	30	26	66	23

TEMPORADA 2020/2021

PRIMERA DIVISIÓN B FEMENINA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Villarreal	24	56	19	55
2	Alba	24	49	27	49
3	Granada	22	37	23	43
4	Pozoalbense	22	35	29	37
5	Alhama	24	35	22	40
6	Real Union.	24	32	27	36
7	Cacereño	22	24	42	25
8	Tenerife	22	20	25	22

TEMPORADA 2019/2020

PRIMERA DIVISIÓN B FEMENINA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Santa Teresa	22	43	15	51
2	Granada	22	43	15	50
3	Albacete	22	48	16	47
4	Villarreal	22	37	24	42
5	Málaga	22	28	21	36
6	Alhama	22	40	31	35
7	Pozoalbense	22	36	39	32
8	Córdoba	22	21	21	31
9	Cacereño	22	36	36	30
10	Tenerife	22	27	36	28
11	Spar Gran C.	22	34	36	27
12	Levante	22	31	33	24
13	Valencia	22	24	34	21
14	Juan Grande	22	28	39	16
15	Real Union.	22	18	57	12
16	Collerense	22	31	72	9

TEMPORADA 2018/2019

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Santa Teresa	26	100	8	72
2	Granada	26	129	4	71
3	Cacereño	26	66	24	56
4	Córdoba	26	72	26	55
5	Pozoalbense	26	65	45	44
6	Málaga	26	64	33	43
7	Sporting	26	65	35	43
8	Extremadura	26	46	47	36
9	Híspalis	26	35	61	29
10	Rambla	26	34	77	23
11	Miguel	26	24	64	17
12	Castuera	26	23	70	17
13	CD Camoens	26	16	114	8
14	Peña Valle	26	7	138	4

TEMPORADA 2017/2018

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Málaga	26	129	6	71
2	Granada	26	111	12	68
3	Sporting	26	72	30	61
4	Extremadura	26	75	35	54
5	Cacereño	26	55	28	43
6	Naranjo	26	58	46	38
7	Santa Teresa	26	46	52	35
8	Híspalis	26	30	60	26
9	Rambla	26	31	62	25
10	Pozoalbense	26	48	86	24
11	Miguel	26	20	56	23
12	Puerto Torre	26	38	73	23
13	Daimiel	26	24	108	13
14	Club	26	14	97	9

TEMPORADA 2016/2017

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sevilla	26	121	16	73
2	Granada	26	126	18	70
3	Málaga	26	101	22	63
4	Solana	26	61	23	48
5	Extremadura	26	74	51	42
6	Naranjo	26	72	49	42
7	Cacereño	26	56	41	36
8	Santa Teresa	26	34	42	34
9	Sporting	26	52	70	34
10	Rambla	26	33	88	26
11	Híspalis	26	28	69	23
12	Monachil	26	31	96	17
13	CD Camoens	26	9	103	9
14	Peña Valle	26	9	119	5

TEMPORADA 2015/2016

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real Betis	26	132	5	72
2	Granada	26	116	19	65
3	Sevilla	26	108	17	63
4	Málaga	26	89	24	58
5	Sporting	26	60	65	45
6	Cacereño	26	52	53	39
7	Naranjo	26	55	71	34
8	Llanos	26	43	50	31
9	Extremadura	26	48	48	30
10	Híspalis	26	41	63	28
11	Rambla	26	36	89	21
12	Ciconia	26	25	95	17
13	Algaidas	26	19	113	10
14	Cruz	26	31	143	8

TEMPORADA 2014/2015

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real Betis	26	116	13	71
2	Llanos	26	80	21	69
3	Granada	26	97	23	62
4	Málaga	26	60	35	43
5	Cacereño	26	60	46	40
6	Extremadura	26	43	48	39
7	Rambla	26	52	55	38
8	Algaidas	26	65	66	34
9	Naranjo	26	62	79	32
10	Cruz	26	47	73	31
11	Híspalis	26	42	53	28
12	Monachil	26	27	97	13
13	Carmelitas	26	23	92	10
14	Nervión	26	30	103	10

TEMPORADA 2013/2014

PRIMERA DIVISIÓN FEMENINA
Equipo		PJ	GF	GC	Puntos
1	Barcelona	30	82	12	79
2	Athletic	30	80	22	69
3	Rayo	30	44	28	51
4	Levante Fem	30	38	29	51
5	Valencia	30	45	27	51
6	Atlético	30	66	37	50
7	Sporting	30	43	37	43
8	Real	30	35	34	38
9	Collerense	30	44	61	35
10	Sant Gabriel	30	38	55	34
11	Real Oviedo	30	30	40	32
12	Espanyol	30	37	51	32
13	Zaragoza	30	29	55	31
14	Sevilla	30	23	60	26
15	Granada	30	41	82	22
16	Levante	30	28	73	22

TEMPORADA 2012/2013

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Granada	26	91	27	66
2	Sevilla	26	46	27	53
3	Santa Teresa	26	71	28	53
4	Rambla	26	50	26	51
5	Real Betis	26	41	33	43
6	Málaga	26	61	51	42
7	Cacereño	26	46	29	38
8	Extremadura	26	45	37	36
9	Algaidas	26	50	67	33
10	Triana	26	29	42	26
11	Carmelitas	26	29	44	26
12	Naranjo	26	50	72	25
13	Badajoz	26	36	76	25
14	Mezquita	26	15	101	5

TEMPORADA 2011/2012

TERCERA FEDERACIÓN FEMENINA GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Sevilla	26	121	12	68
2	Cacereño	26	92	25	57
3	Granada	26	77	27	50
4	Extremadura	26	68	41	49
5	Rambla	26	52	30	46
6	Santa Teresa	26	48	41	42
7	Carmelitas	26	43	37	39
8	Algaidas	26	61	45	38
9	Taraguilla	26	54	63	32
10	Triana	26	47	54	31
11	Mezquita	26	38	65	25
12	Monachil	26	27	71	20
13	Híspalis	26	34	87	16
14	Séneca Cf	26	5	169	2

Competiciones que juega

Grupo 2

Primera División Femenina

Pos	Equipos		Pts
1		Barcelona Fem	70
2		Real Madrid Fem	58
3		Levante Fem	47
4		Madrid CFF Fem	46
5		Atlético Fem	45
6		Athletic Fem	44
7		Sevilla FC Fem	39
8		Costa Adeje Tenerife Fem	31
9		Real Sociedad Fem	29
10		Valencia Fem	26
11		Eibar Fem	26
12		Granada CF Fem	24
13		Real Betis Fem	22
14		Villarreal Fem	21
15		Levante Las Planas Fem	20
16		Sporting Huelva Fem	6

	Champions League : Barcelona Fem
	Previa de Champions : Real Madrid Fem, Levante Fem
	Descenso : Levante Las Planas Fem, Sporting Huelva Fem

RIVALES EN Copa Andalucía F.

RIVALES EN Copa de la Reina

RIVALES EN Primera División.

USO DE MEMORIA

6,709,576 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.8461
Total Execution Time	0.8481

CADENA URL

/historico/Granada-Cf-Femenino

GET DATOS

$_GET['/historico/Granada-Cf-Femenino']

POST DATOS

No hay datos POST existentes

CONSULTAS (43)

0.0294	SELECT dt.,c.active_year,l.year,l.table_suffix, c.ctype, l.id as league_id,t.id as id,t.manager,t.name as nameOriginal,dt.id as teamId,cou.Name as cou_name,cou.Continent,cou.Region FROM* `leagues_webci` as l INNER JOIN `teams` as t ON l.id = t.league_id INNER JOIN `datateams` as dt ON dt.id = t.teamId INNER JOIN `categories_webci` as c ON c.id = l.categoryId LEFT JOIN country cou ON LOWER(cou.Code2) = dt.CountryCode WHERE dt.basealias = 'Granada-Cf-Femenino' AND l.year = 2024 ORDER BY c.top DESC, c.ctype != 12 DESC, c.troncal DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, c.coefficient DESC, l.id ASC
0.0021	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=8909 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0037	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 74006
0.0033	SELECT c., l., cou.name as namec, ct.table_sufix FROM (leagues l INNER JOIN categories c ON c.id = l.categoryId INNER JOIN categories_types ct ON c.ctype=ct.id LEFT JOIN country cou ON cou.Code2 = c.CountryCode) WHERE l.id = 73660
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8909 AND type_rel = 2
0.0244	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 8909 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0117	SELECT /35 bs_news_model/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (299713,368803,729290,734096,737680) ORDER BY n.cover_points DESC, update_date DESC
0.0188	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '8909' ORDER BY l.year DESC,cat.coefficient DESC
0.0147	SELECT cat.logo,cat.official,cat.location,dt.nameShow,dt.basealias,t.teamId,l.year,t.qod,cat.coefficient,cat.active_year,cat.name,l.group_code,l.total_group,cat.alias,l.categoryId,l.year,l.id as league_id FROM datateams dt INNER JOIN teams t ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories cat ON cat.id = l.categoryId WHERE dt.id = '8909' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0307	SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '8909' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0026	SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 73660 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0405	SELECT t.id as team_id, ct.id, l.id as idLeague, l.year, ct.name, l.start_date, l.end_date FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId=8909 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126	SELECT ct.id, ct.alias, ct.name AS name, ct.active_year, ct.coefficient AS coefficient, l.id AS league_id, l.year, l.total_group FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId WHERE l.id IN (74006,73660,73659,72467,71748) ORDER BY ct.ctype != 12 DESC, ct.troncal DESC, ct.coefficient DESC, l.end_date >= NOW() DESC, l.start_date <= NOW() DESC, l.year DESC, ct.coefficient DESC, l.group_code ASC
0.0467	SELECT count(id) as num_players from rel_players WHERE league_id = 72467 AND teamId = 8909
0.0140	SELECT count(id) as num_players from rel_players WHERE league_id = 71748 AND teamId = 8909
0.0334	SELECT count(id) as num_players from rel_players WHERE league_id = 74006 AND teamId = 8909
0.0416	SELECT count(id) as num_players from rel_players WHERE league_id = 73659 AND teamId = 8909
0.0162	SELECT count(id) as num_players from rel_players WHERE league_id = 73660 AND teamId = 8909
0.0074	SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '8909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8909' and rp.type = 4
0.0041	SELECT p.* FROM `rel_videos` as rp INNER JOIN `videos` as p ON p.id = rp.id_video INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '8909' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0545	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 8909 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0720	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 8909 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0379	SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2024 e ON e.player_id = p.id AND e.league_id = 72467 WHERE rp.league_id = 72467 AND rp.teamId = 8909 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0192	SELECT l.id,t.league_id,l.legend,l.year,c.name,l.total_teams,c.alias,l.group_code,l.total_group,l.current_round, l.table_suffix FROM teams t INNER JOIN leagues l ON t.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId WHERE c.troncal = 1 AND t.teamId = 8909 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0187	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2024` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 72467 AND t.round = 25 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 68104 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2022` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 63313 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0197	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 58766 AND t.round = 18 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0101	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2021` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 61736 AND t.round = 8 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2020` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 49901 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0190	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 44732 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0263	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2018` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 39301 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0095	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2017` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 35131 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0087	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2016` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 16654 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0200	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2015` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 4404 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0210	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2747 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0218	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2013` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2118 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0223	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 1851 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


	¿Has detectado algún error en la web? x Tipo de incidencia ¿Qué ocurre? Deja tu correo si quieres que te contactemos

Resultados de Fútbol

Granada CF Fem

Granada CF Fem

Selecciona un equipo

Competiciones que juega

Primera División Femenina

RIVALES EN Copa Andalucía F.

RIVALES EN Copa de la Reina

RIVALES EN Primera División.