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

« Temporada Anterior

Temporada 2023

Temporada Siguiente »

2022/2023

Fase 1

Serie A - Primera Etapa 2023

Serie A - Primera Etapa

Serie A - Segunda Etapa

Ver

TEMPORADA 2022/2023

Equipo		PJ	GF	GC	Puntos
1	Independient	15	31	15	34
2	Nacional	15	32	25	30
3	Liga Quito	15	29	17	26
4	Barcelona	15	30	20	26
5	Aucas	15	17	19	24
6	Universidad	15	22	25	24
7	Delfín	15	18	23	24
8	Deportivo	15	24	21	21
9	Orense	15	17	21	21
10	Técnico	15	21	15	18
11	Gualaceo	15	17	23	18
12	Cumbayá	15	10	13	17
13	CS Emelec	15	18	20	14
14	Libertad FC	15	20	26	13
15	Mushuc Runa	15	14	25	13
16	Guayaquil	15	17	29	12

Ver

TEMPORADA 2021/2022

Equipo		PJ	GF	GC	Puntos
1	Barcelona	15	24	11	30
2	Universidad	15	31	17	29
3	Liga Quito	15	26	22	29
4	Independient	15	16	12	27
5	Aucas	15	23	17	26
6	CS Emelec	15	23	15	23
7	Delfín	15	16	18	22
8	Deportivo	15	12	14	21
9	Gualaceo	15	18	23	20
10	Mushuc Runa	15	19	21	19
11	Guayaquil	15	22	20	18
12	Orense	15	14	13	18
13	Macará	15	12	19	13
14	Cumbayá	15	12	23	13
15	Técnico	15	12	24	10
16	Octubre	15	15	26	9

Ver

TEMPORADA 2020/2021

Equipo		PJ	GF	GC	Puntos
1	CS Emelec	15	29	14	34
2	Barcelona	15	31	13	31
3	Independient	15	27	18	27
4	Universidad	15	29	18	25
5	Mushuc Runa	15	29	21	25
6	Liga Quito	15	22	19	25
7	Macará	15	17	17	23
8	Octubre	15	22	21	20
9	Aucas	15	27	26	19
10	Delfín	15	19	25	18
11	Deportivo	15	14	18	16
12	Manta	15	18	25	16
13	Técnico	15	11	17	13
14	Orense	15	14	24	12
15	CD Olmedo	15	13	27	12
16	Guayaquil	15	11	30	10

Ver

TEMPORADA 2019/2020

Equipo		PJ	GF	GC	Puntos
1	Liga Quito	15	29	13	35
2	Independient	15	36	22	32
3	Universidad	15	32	14	31
4	Barcelona	15	23	13	29
5	Macará	15	22	17	24
6	Aucas	15	26	23	23
7	Técnico	15	17	16	22
8	Delfín	15	17	22	18
9	Guayaquil	15	17	23	18
10	Mushuc Runa	15	16	22	18
11	CD Olmedo	15	26	29	17
12	CS Emelec	15	20	22	16
13	Nacional	15	16	24	14
14	Portoviejo	15	19	30	13
15	Orense	15	15	27	10
16	Deportivo	15	16	30	8

Ver

TEMPORADA 2017/2018

Equipo		PJ	GF	GC	Puntos
1	Liga Quito	22	32	18	46
2	Barcelona	22	41	21	45
3	Universidad	22	40	28	38
4	CS Emelec	22	34	27	37
5	Delfín	22	35	34	33
6	Independient	22	30	27	31
7	Aucas	22	25	18	29
8	Macará	22	25	29	27
9	Nacional	22	24	35	23
10	Deportivo	22	21	33	22
11	Guayaquil	22	15	28	16
12	Técnico	22	15	39	15

Ver

TEMPORADA 2016/2017

Equipo		PJ	GF	GC	Puntos
1	Delfín	22	35	14	47
2	Barcelona	22	36	21	41
3	CS Emelec	22	32	21	38
4	Independient	22	27	19	37
5	Macará	22	29	30	33
6	Deportivo	22	24	23	30
7	Universidad	22	33	26	28
8	Guayaquil	22	20	25	26
9	Nacional	22	27	36	23
10	Liga Quito	22	25	32	19
11	Fuerza	22	17	31	14
12	Clan Juvenil	22	19	46	12

Ver

TEMPORADA 2015/2016

Equipo		PJ	GF	GC	Puntos
1	Barcelona	22	51	19	47
2	CS Emelec	22	37	23	43
3	Nacional	22	32	28	36
4	Deportivo	22	29	25	34
5	Independient	22	28	28	34
6	Liga Quito	22	20	23	31
7	Universidad	22	27	27	28
8	Guayaquil	22	29	35	27
9	Fuerza	22	22	28	24
10	Delfín	22	23	30	23
11	Aucas	22	21	34	19
12	Mushuc Runa	22	19	38	15

Ver

TEMPORADA 2014/2015

Equipo		PJ	GF	GC	Puntos
1	Liga Quito	22	28	10	47
2	CS Emelec	22	41	18	45
3	Independient	22	35	24	42
4	Barcelona	22	33	24	32
5	Dep. Quito	22	33	37	29
6	Nacional	22	28	24	28
7	Guayaquil	22	27	32	26
8	Mushuc Runa	22	25	38	26
9	Deportivo	22	25	37	23
10	Aucas	22	32	34	22
11	Universidad	22	22	31	21
12	LDU Loja	22	17	37	16

Ver

TEMPORADA 2013/2014

Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	35	14	44
2	Independient	22	36	18	40
3	LDU Loja	22	25	31	36
4	Barcelona	22	26	18	35
5	Liga Quito	22	20	22	29
6	Universidad	22	26	28	28
7	Nacional	22	26	35	27
8	Dep. Quito	22	20	22	26
9	CD Olmedo	22	21	24	26
10	Mushuc Runa	22	19	24	26
11	Manta	22	21	29	23
12	Deportivo	22	21	31	23

Ver

TEMPORADA 2012/2013

Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	28	17	45
2	Liga Quito	22	26	19	41
3	Independient	22	37	25	39
4	Dep. Quito	22	41	24	38
5	Barcelona	22	33	19	38
6	Universidad	22	34	35	33
7	Nacional	22	29	33	26
8	Deportivo	22	29	36	25
9	Deportivo	22	26	34	23
10	Manta	22	26	33	22
11	LDU Loja	22	21	33	17
12	Macará	22	14	36	16

Ver

TEMPORADA 2011/2012

Equipo		PJ	GF	GC	Puntos
1	Barcelona	22	33	15	38
2	LDU Loja	22	25	18	38
3	CS Emelec	22	39	23	37
4	Independient	22	29	20	37
5	Deportivo	22	24	26	36
6	Liga Quito	22	32	22	34
7	Dep. Quito	22	34	23	31
8	Nacional	22	24	34	29
9	Manta	22	22	23	27
10	Macará	22	19	33	21
11	Técnico	22	18	32	18
12	CD Olmedo	22	14	44	14

Ver

TEMPORADA 2010/2011

Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	31	15	44
2	Liga Quito	22	29	13	40
3	Dep. Quito	22	39	25	39
4	Nacional	22	31	23	32
5	LDU Loja	22	27	27	32
6	Deportivo	22	27	30	31
7	CD Olmedo	22	27	32	29
8	Barcelona	22	22	23	27
9	Manta	22	20	26	27
10	Imbabura	22	25	33	23
11	Independient	22	29	44	19
12	Espoli	22	22	38	15

Ver

TEMPORADA 2009/2010

Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	37	22	46
2	Liga Quito	22	36	10	44
3	Barcelona	22	26	12	43
4	Dep. Quito	22	27	23	34
5	Deportivo	22	21	24	27
6	Nacional	22	34	27	25
7	Independient	22	26	31	25
8	Manta	22	23	30	24
9	CD Olmedo	22	18	27	23
10	Espoli	22	22	41	22
11	Universidad	22	21	32	20
12	Macará	22	22	34	18

Ver

TEMPORADA 2008/2009

Equipo		PJ	GF	GC	Puntos
1	CS Emelec	22	30	17	43
2	Liga Quito	22	44	20	42
3	Macará	22	28	26	34
4	CD Olmedo	22	28	25	33
5	Espoli	22	29	29	33
6	Nacional	22	24	21	29
7	Dep. Quito	22	18	21	28
8	Portoviejo	22	22	35	28
9	Barcelona	22	19	21	26
10	Deportivo	22	25	31	26
11	Técnico	22	29	41	24
12	Manta	22	15	24	23

Ver

TEMPORADA 2007/2008

Equipo		PJ	GF	GC	Puntos
1	Dep. Quito	22	39	18	45
2	Liga Quito	22	36	22	38
3	Deportivo	22	26	16	37
4	Nacional	22	30	21	37
5	Barcelona	22	34	27	35
6	Espoli	22	31	29	31
7	Macará	22	18	19	30
8	CS Emelec	22	23	28	29
9	Técnico	22	20	40	23
10	CD Olmedo	22	15	27	18
11	Universidad	22	22	38	18
12	Deportivo	22	22	31	17

Ver

TEMPORADA 2006/2007

Equipo		PJ	GF	GC	Puntos
1	CD Olmedo	18	27	15	37
2	Deportivo	18	26	19	32
3	Liga Quito	18	36	26	28
4	Deportivo	18	26	26	28
5	Nacional	18	37	27	27
6	Dep. Quito	18	21	26	21
7	Barcelona	18	19	28	20
8	Imbabura	18	21	33	20
9	Macará	18	25	31	18
10	CS Emelec	18	23	30	18

Ver

TEMPORADA 2005/2006

Equipo		PJ	GF	GC	Puntos
1	Liga Quito	18	37	24	36
2	Nacional	18	35	26	31
3	CD Olmedo	18	19	21	29
4	CS Emelec	18	30	21	28
5	Dep. Quito	18	22	23	25
6	Barcelona	18	26	24	24
7	Aucas	18	25	35	22
8	Deportivo	18	18	26	21
9	Macará	18	17	28	21
10	Espoli	18	31	32	18

Ver

TEMPORADA 2004/2005

Equipo		PJ	GF	GC	Puntos
1	Liga Quito	18	48	22	41
2	Nacional	18	41	27	33
3	Barcelona	18	19	31	26
4	Deportivo	18	26	28	25
5	LDU Loja	18	35	38	25
6	Dep. Quito	18	36	23	24
7	Aucas	18	22	27	24
8	CD Olmedo	18	22	25	23
9	CS Emelec	18	24	31	20
10	Deportivo	18	22	43	9

Ver

TEMPORADA 2003/2004

Equipo		PJ	GF	GC	Puntos
1	Aucas	18	31	15	36
2	Liga Quito	18	33	26	30
3	Deportivo	18	21	15	29
4	CS Emelec	18	26	21	28
5	Nacional	18	26	25	26
6	Dep. Quito	18	28	32	25
7	CD Olmedo	18	23	23	24
8	Barcelona	18	20	25	18
9	Espoli	18	14	23	17
10	Macará	18	16	33	12

Ver

TEMPORADA 2002/2003

Equipo		PJ	GF	GC	Puntos
1	Barcelona	18	41	19	38
2	Liga Quito	18	37	24	36
3	Nacional	18	31	22	31
4	Dep. Quito	18	29	23	28
5	CS Emelec	18	26	31	26
6	Deportivo	18	27	26	22
7	Aucas	18	24	26	22
8	Técnico	18	24	36	17
9	Espoli	18	25	37	15
10	Manta	18	17	37	12

Ver

TEMPORADA 2001/2002

Equipo		PJ	GF	GC	Puntos
1	Liga Quito	18	9	7	28
2	Aucas	18	12	5	26
3	Macará	18	9	9	26
4	Nacional	18	5	4	25
5	CS Emelec	18	9	7	23
6	Dep. Quito	18	8	12	23
7	Deportivo	18	10	10	22
8	Barcelona	18	5	7	21
9	CD Olmedo	18	8	11	21
10	Espoli	18	6	9	18

JUGADORES DESTACADOS

Nombre	Goles	Equipo
M. Parrales	13	RIV
M. Hoyos	10	IVT
R. Carrillo	9	NAC
A. Alvarado	9	LIG
D. Díaz	9	BSC
R. Becerra	8	CUE
M. Bolaños	7	EME
J. Blanco	7	TEC
Jhon Cifuente	7	AUC
B. Palacios	6	NAC

Equipos de esta liga

USO DE MEMORIA

7,079,056 bytes

BENCHMARKS

Loading Time Base Classes	0.0020
Controller Execution Time ( Home / Category )	0.1963
Total Execution Time	0.1984

CADENA URL

/ecuador2023/grupo1/historico

GET DATOS

$_GET['/ecuador2023/grupo1/historico']

POST DATOS

No hay datos POST existentes

CONSULTAS (39)

0.0018	SELECT type FROM routes WHERE alias = 'ecuador2023'
0.0047	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ecuador' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43 AND type_rel = 3
0.0038	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 43 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021	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 (1297904,1299685,1289627,1269214,1269123) ORDER BY n.cover_points DESC, update_date DESC
0.0022	SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=189 ORDER BY l.group_code ASC
0.0018	SELECT id,name,alias,stepParent FROM categories WHERE parentId=189 ORDER BY order_id ASC
0.0022	SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 70963 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020	SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 43 AND group_code = 1 and tables = 1 AND year <= 2023 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0022	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 = 70963 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 66293 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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 = 60928 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021	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 = 53546 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 42559 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 37745 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 20247 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022	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 = 9060 AND t.round = 22 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* `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 = 3511 AND t.round = 22 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* `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 = 2411 AND t.round = 22 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* `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 = 1543 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2011` 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 = 1290 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2010` 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 = 1259 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2009` 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 = 1025 AND t.round = 22 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* `tables2008` 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 = 1024 AND t.round = 22 ORDER BY team.conference 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* `tables2007` 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 = 256 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031	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* `tables2006` 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 = 9589 AND t.round = 18 ORDER BY team.conference 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* `tables2005` 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 = 9585 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023	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* `tables2004` 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 = 9580 AND t.round = 18 ORDER BY team.conference 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* `tables2003` 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 = 9572 AND t.round = 18 ORDER BY team.conference 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* `tables2002` 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 = 27489 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 08:52:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 08:52:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 08:52:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018	SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 08:52:10' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024	SELECT c., l., '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'ecuador' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2023 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0257	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70963 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70963 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0319	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70963 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70963 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0054	SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 70963 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 70963 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0049	SELECT ,(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 = 70963 AND t.round = 15 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Nombre	Amarillas	Equipo
J. Chalá	10	NAC
Yardely Rodriguez	8	CAL
J. Paredes	7	CFC
L. León	7	EME
C. García	7	DEL
E. Carcelén	7	TEC
F. Flores	6	GUA
J. Parrales	6	NAC
J. Preciado	6	GUA
M. Parrales	6	RIV

Nombre	Rojas	Equipo
Óscar Quiñonez	2	ORE
A. Arroyo	2	NAC
G. Anangonó	2	UCE
D. Porozo	1	CAL
L. Gustavino	1	CFC
J. Rezabala	1	AUC
J. Monaga	1	MUS
E. García	1	DEL
J. Ortiz	1	IVT
K. Minda	1	UCE


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