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

Estrella San Agustín

Temporada 2022/2023

TEMPORADA 2022/2023

4ª ANDALUZA SEVILLA JUVENIL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Viso	22	70	23	58
2	Cantera	22	106	28	56
3	Club	22	69	30	51
4	CD Pablo VI	22	64	57	34
5	Ciudad	22	51	48	32
6	Barrera	22	51	52	28
7	Utrera	22	33	38	23
8	Cd Coronil	22	45	71	23
9	Tinte Utrera	22	44	75	20
10	Montellano	22	37	56	19
11	CD Mairena	22	37	56	18
12	Estrella	22	36	109	9
13	Paradas	0	0	0	0

TEMPORADA 2021/2022

2ª ANDALUZA SEVILLA JUVENIL
Equipo		PJ	GF	GC	Puntos
1	Utrera	34	97	40	72
2	Tomares	34	75	36	72
3	Cabecense	34	73	37	71
4	Caminantes	34	73	47	64
5	Mosquito	34	77	58	61
6	Roque	34	60	42	58
7	Castilleja	34	79	59	50
8	Bellavista	34	63	56	50
9	Coria CF B	34	59	52	47
10	Lora CF	34	62	61	47
11	Torreblanca	34	48	61	42
12	Andalucía	34	38	55	41
13	Juan Juvenil	34	41	63	38
14	Estrella	34	44	76	36
15	U.D. Moron.	34	52	69	34
16	Asoc. Dva..	34	57	76	33
17	Palacios	34	45	86	30
18	Atletico	34	31	100	11

TEMPORADA 2020/2021

4ª ANDALUZA SEVILLA JUVENIL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Vista	24	84	20	63
2	Mosquito	24	106	33	56
3	CD Alcala	24	106	47	52
4	CD Pablo VI	24	85	50	42
5	Estrella	24	77	47	42
6	Diablos	24	83	52	38
7	Roque	24	45	42	38
8	Alcosa	23	69	61	35
9	Polideportiv	24	60	62	30
10	Padre	23	50	41	29
11	Doctor	24	44	68	26
12	David	24	43	102	22
13	Isbiliya	24	33	100	7
14	Peña Betica	22	12	172	0

TEMPORADA 2019/2020

3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	UD Moron CF	23	89	30	57
2	Andalucia	23	71	25	55
3	Solea	24	57	23	50
4	Roque	23	79	37	47
5	Marchena	24	46	30	45
6	Osuna Bote	23	53	29	43
7	Arahal	24	55	58	35
8	Jorge Juan.	23	43	37	34
9	Portaceli	23	37	37	32
10	Estrella	23	51	47	30
11	Calavera	23	36	48	29
12	Amigos Cerro	24	45	55	25
13	Viso	24	38	56	24
14	Tinte Utrera	23	34	69	23
15	Oromana	23	28	50	16
16	CD Mairena	24	28	75	15
17	Circulo	23	20	104	8
18	Ecija	1	0	0	1

TEMPORADA 2018/2019

3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Torreblanca	33	97	41	78
2	Bellavista	34	93	40	74
3	U.D. Moron.	33	80	55	64
4	C.D. Mairena	33	64	44	64
5	Portaceli	34	71	58	55
6	Estrella	33	84	64	54
7	Triana C.F.	34	65	62	51
8	Viso	34	83	82	48
9	Ecija	33	79	70	46
10	Cd Coronil	33	56	79	45
11	Club Jorge.	34	59	67	41
12	Rociera B	33	72	68	39
13	Osuna Bote	34	51	59	39
14	Amigos Cerro	33	67	72	38
15	Campana	34	63	105	33
16	Diablos	33	40	76	28
17	CD Ventippo	24	35	59	23
18	Puebla	33	37	95	19

TEMPORADA 2017/2018

3ª ANDALUZA SEVILLA JUVENIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Rociera	33	153	42	82
2	Caminantes	33	91	44	69
3	Bellavista	33	101	41	65
4	Estrella	34	91	51	61
5	CD Alcala	33	89	51	60
6	C.D. Mairena	34	81	66	59
7	C.D. Utrera	33	78	59	57
8	Cd Coronil	34	74	66	54
9	U.D. Moron.	33	75	73	44
10	Campana	34	64	67	43
11	Osuna Bote	33	75	75	41
12	Amigos Cerro	33	77	120	41
13	Ecija	33	77	71	39
14	San Jose A	33	67	81	39
15	Vistahermosa	22	49	43	35
16	Arahal	33	67	100	34
17	Montequinto	34	63	135	13
18	Amigos	33	44	231	1

TEMPORADA 2016/2017

4ª ANDALUZA SEVILLA JUVENIL GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Cd Coronil	24	71	22	61
2	Estrella	24	71	22	56
3	Gilena CF	24	41	31	40
4	Corrales	25	53	41	39
5	CD Ventippo	24	51	40	39
6	Marinaleda	25	56	68	38
7	Fuentes	20	48	35	36
8	Atletico	25	60	39	33
9	Barrera	24	44	34	33
10	Lantejuela	24	40	51	28
11	EFB La Roda	25	38	67	25
12	CDF Herrera	24	40	64	24
13	Astigitana	25	21	84	7
14	CD Pruna	11	12	48	6

TEMPORADA 2015/2016

4ª ANDALUZA SEVILLA JUVENIL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	U.B.	31	106	37	70
2	Motilla	31	92	39	69
3	Ibarburu CF	31	87	55	61
4	Cd Coronil	31	87	61	59
5	Palmar	31	65	35	58
6	Hermanas	31	98	58	57
7	Rociera	31	79	55	52
8	Tinte Utrera	32	85	89	47
9	Tabladilla	32	66	84	44
10	AD Mosqueo	31	76	63	43
11	UD Cuervo	31	74	65	41
12	Cantera	31	69	66	40
13	Palacios	31	47	69	33
14	Vistazul	31	58	108	22
15	Racing	32	44	115	19
16	Atlético	19	19	42	15
17	Estrella	31	49	160	10

TEMPORADA 2014/2015

4ª ANDALUZA SEVILLA JUVENIL GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Campana	25	74	34	55
2	Marinaleda	25	47	27	52
3	Ecija CF	24	51	28	51
4	Arahelense	25	56	39	48
5	Gilena CF	26	43	44	39
6	Cd Coronil	26	58	43	38
7	Fuentes	25	56	48	33
8	Corrales	25	45	49	32
9	CDF Herrera	24	42	47	32
10	Estrella	25	62	54	31
11	Lantejuela	24	62	69	28
12	CD Ventippo	16	29	30	21
13	CD Pruna	25	33	113	13
14	Estepa	21	20	53	10

Competiciones que juega

RIVALES EN 3ª Andaluza Sevi.

RIVALES EN 4ª Andaluza Sevi.

USO DE MEMORIA

5,779,928 bytes

BENCHMARKS

Loading Time Base Classes	0.0016
Controller Execution Time ( Home / Category )	0.1752
Total Execution Time	0.1768

CADENA URL

/historico/Estrella-San-Agustin-Juvenil

GET DATOS

$_GET['/historico/Estrella-San-Agustin-Juvenil']

POST DATOS

No hay datos POST existentes

CONSULTAS (47)

0.0082	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 = 'Estrella-San-Agustin-Juvenil' 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.0031	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 = 'Estrella-San-Agustin-Juvenil' 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.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=19678 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=19678 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=19678 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=19678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=19678 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=19678 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=19678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045	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=19678 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=19678 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=19678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020	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=19678 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=19678 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027	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 = 69745
0.0025	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 = 69886
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19678 AND type_rel = 2
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=441 AND type_rel = 3
0.0022	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 441 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0022	SELECT /53 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 (185377,76000,36578) ORDER BY n.cover_points DESC, update_date DESC
0.0027	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 = '19678' ORDER BY l.year DESC,cat.coefficient DESC
0.0021	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 = '19678' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0020	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 = '19678' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033	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 = 69745 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	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 = 69886 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0028	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=19678 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0019	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 (69886,69745,64947) 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.0020	SELECT count(id) as num_players from rel_players_base WHERE league_id = 64947 AND teamId = 19678
0.0018	SELECT count(id) as num_players from rel_players_base WHERE league_id = 69745 AND teamId = 19678
0.0020	SELECT count(id) as num_players from rel_players_base WHERE league_id = 69886 AND teamId = 19678
0.0019	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 69745 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019	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 = '19678' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '19678' and rp.type = 4
0.0019	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 = '19678' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022	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 = 19678 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0029	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_base` 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 = 69745 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.0024	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_base` 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 = 69886 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030	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_base` 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 = 64711 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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_base` 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 = 64947 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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_base` 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 = 60423 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0085	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_base` 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 = 53864 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0104	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_base` 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 = 45803 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0029	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_base` 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 = 39989 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034	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_base` 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 = 34586 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026	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_base` 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 = 17060 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0025	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 = 4286 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019	SELECT dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 69745 ORDER BY nameShow LIMIT 100


	¿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

Estrella San Agustín

Estrella San Agustín

Selecciona un equipo

Competiciones que juega

RIVALES EN 3ª Andaluza Sevi.

RIVALES EN 4ª Andaluza Sevi.