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

Ilicitano

Entrenador: Donato

Temporada 2020/2021

TEMPORADA 2020/2021

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	UD Alzira	20	29	12	38
2	CD Roda	20	28	16	35
3	Saguntino	20	30	27	31
4	Villarreal	20	32	18	30
5	Silla CF	20	20	21	25
6	Recambios	20	16	19	23
7	Benicarló	20	22	21	22
8	Torrent	20	17	25	21
9	CD Acero	20	18	25	20
10	Paterna CF	20	14	25	20
11	Vilamarxant	20	13	30	15
12	Eldense	18	30	11	41
13	Ilicitano	18	33	17	38
14	Intercity	18	30	8	37
15	Olimpic	18	22	24	25
16	Benigànim	18	14	30	20
17	Jove	18	17	23	19
18	Crevillente	18	17	24	19
19	Hércules B	18	13	17	18
20	Villajoyosa	18	17	27	17
21	Novelda CF	18	15	27	12

TEMPORADA 2019/2020

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Alcoyano	28	55	14	65
2	UD Alzira	28	36	21	54
3	Atzeneta	28	40	22	50
4	Villarreal	28	46	29	48
5	Intercity	28	49	33	48
6	Eldense	28	36	27	40
7	Saguntino	28	35	28	40
8	Recambios	28	34	32	40
9	Novelda CF	28	35	33	39
10	Olimpic	28	30	29	39
11	Jove	28	37	34	38
12	CD Roda	28	32	41	38
13	Crevillente	28	25	36	34
14	Hércules B	28	27	28	32
15	Ilicitano	28	26	32	30
16	Paterna CF	28	26	37	29
17	Vilamarxant	28	37	54	29
18	CD Acero	28	24	35	26
19	Silla CF	28	20	39	25
20	Benigànim	28	20	66	16

TEMPORADA 2018/2019

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Orihuela CF	38	62	21	86
2	Nucía	38	53	25	70
3	Olimpic	38	52	29	69
4	Saguntino	38	47	27	66
5	Crevillente	38	47	34	65
6	Atzeneta	38	48	42	58
7	Jove	38	41	44	55
8	CD Roda	38	44	42	54
9	Eldense	38	47	48	53
10	Villarreal	38	52	44	52
11	Vilamarxant	38	52	49	50
12	Silla CF	38	40	44	48
13	Paterna CF	38	42	51	46
14	UD Alzira	38	33	52	43
15	Novelda CF	38	45	51	43
16	Ilicitano	38	42	47	41
17	CD Acero	38	45	53	39
18	Rayo Ibense	38	39	53	39
19	Torre	38	28	48	36
20	Paiporta	38	30	85	19

TEMPORADA 2017/2018

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	At. Levante	40	72	31	84
2	Castellón	40	64	32	83
3	Orihuela CF	40	62	28	78
4	Nucía	40	67	34	71
5	Eldense	40	54	40	70
6	Torre	40	48	27	69
7	Olimpic	40	39	32	60
8	Villarreal	40	53	55	56
9	UD Alzira	40	42	46	51
10	Novelda CF	40	37	42	51
11	CD Roda	40	47	45	51
12	Crevillente	40	35	46	48
13	Paterna CF	40	40	47	47
14	Silla CF	40	47	46	46
15	Rayo Ibense	40	34	48	46
16	Paiporta	40	42	63	43
17	Ilicitano	40	38	46	42
18	Almazora	40	32	64	42
19	Buñol	40	32	44	39
20	CF Borriol	40	34	69	27
21	Recambios	40	32	66	25

TEMPORADA 2016/2017

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Olimpic	40	68	19	87
2	UD Alzira	40	61	25	80
3	Ontinyent	40	56	29	76
4	Castellón	40	65	31	76
5	Orihuela CF	40	62	31	71
6	Novelda CF	40	46	27	70
7	Villarreal	40	67	47	69
8	Ilicitano	40	58	37	68
9	Torre	40	58	50	61
10	Crevillente	40	39	37	58
11	Silla CF	40	51	57	51
12	Rayo Ibense	40	49	56	49
13	Almazora	40	43	48	48
14	Recambios	40	33	44	46
15	CF Borriol	40	41	55	45
16	Paterna CF	40	35	60	43
17	Buñol	40	44	62	42
18	Muro	40	39	50	39
19	Torrevieja	40	38	71	35
20	Almoradí	40	32	77	27
21	Segorbe	40	22	94	13

TEMPORADA 2015/2016

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Saguntino	38	62	25	82
2	Ontinyent	38	62	39	71
3	Castellón	38	60	41	70
4	Ilicitano	38	64	39	69
5	Villarreal	38	64	43	61
6	UD Alzira	38	57	50	60
7	Novelda CF	38	51	39	58
8	Orihuela CF	38	50	46	56
9	Torre	38	43	35	55
10	Rayo Ibense	38	38	40	54
11	Torrevieja	38	46	47	52
12	Crevillente	38	41	37	51
13	Muro	38	44	51	49
14	Paterna CF	38	38	53	41
15	CF Borriol	38	36	51	40
16	Recambios	38	42	61	39
17	Buñol	38	22	43	39
18	Jove	38	34	48	38
19	Benigànim	38	41	66	33
20	CD Acero	38	28	69	23

TEMPORADA 2014/2015

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Gimnàstic	38	51	30	73
2	Huracán	38	46	30	65
3	Reus	38	44	33	63
4	Hércules	38	41	29	63
5	Lleida	38	45	34	61
6	Alcoyano	38	37	40	59
7	Badalona	38	37	37	56
8	Olimpic	38	38	37	55
9	L´Hospitale	38	41	36	54
10	Villarreal	38	51	45	53
11	Espanyol B	38	50	42	53
12	Atlético	38	48	45	49
13	Olot	38	37	38	48
14	Valencia	38	43	41	48
15	Cornellà	38	41	50	45
16	Eldense	38	45	49	45
17	Mallorca B	38	40	58	44
18	Sant Andreu	38	37	48	39
19	Ilicitano	38	38	60	35
20	Deportivo	38	39	67	34

TEMPORADA 2013/2014

SEGUNDA DIVISIÓN B GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Badalona	38	61	36	69
2	Lleida	38	52	35	68
3	Gimnàstic	38	52	34	68
4	L´Hospitale	38	58	32	66
5	Ilicitano	38	60	41	64
6	Alcoyano	38	52	34	64
7	Atlético	38	50	36	64
8	Espanyol B	38	43	45	54
9	Huracán	38	40	38	52
10	Olimpic	38	37	35	52
11	Villarreal	38	45	42	51
12	Reus	38	38	49	51
13	Badalona	38	38	39	46
14	Olot	38	47	60	45
15	Sant Andreu	38	33	44	44
16	Valencia	38	39	50	41
17	AE Prat	38	31	45	38
18	At. Levante	38	42	59	36
19	Constància	38	23	52	34
20	Ontinyent	38	34	69	27

TEMPORADA 2012/2013

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Ilicitano	40	47	28	71
2	Novelda CF	40	50	37	71
3	UD Alzira	40	50	39	69
4	Castellón	40	58	29	68
5	Nucía	40	47	36	62
6	Muro	40	53	47	59
7	Villarreal	40	53	50	59
8	CF Borriol	40	52	39	57
9	CD Utiel	40	45	40	56
10	Eldense	40	46	39	53
11	Saguntino	40	36	45	53
12	CD Llosa	40	44	45	52
13	Torrevieja	40	45	42	52
14	Jove	40	44	48	50
15	Ribarroja	40	35	46	48
16	CD Acero	40	49	60	48
17	CD Burriana	40	40	57	47
18	CF Gandia	39	32	39	45
19	Crevillente	40	40	51	45
20	Dénia	40	43	56	42
21	Catarroja	39	29	65	28

TEMPORADA 2011/2012

PRIMERA FFCV GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Ilicitano	34	75	31	73
2	Hércules B	34	73	35	70
3	Alcoyano	34	62	38	63
4	Santa Pola	34	64	43	63
5	Callosa	34	63	43	62
6	Villajoyosa	34	63	38	60
7	Pinoso	34	60	41	60
8	Horadada	34	64	45	59
9	Thader	34	63	65	52
10	Almoradí	34	47	61	38
11	Din.	34	49	64	37
12	Contestano	34	38	53	37
13	El Campello	34	46	74	37
14	Algueña	34	36	68	36
15	Jove	34	30	45	32
16	Rayo Ibense	34	39	61	29
17	Universidad	34	34	69	28
18	Polop	34	33	65	26

TEMPORADA 2010/2011

PRIMERA FFCV GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Altea	34	62	30	72
2	Ilicitano	34	51	29	71
3	Hércules B	34	56	42	59
4	El Campello	34	67	55	59
5	Santa Pola	34	62	41	56
6	Algueña	34	38	38	47
7	Universidad	34	56	55	46
8	Thader	34	42	37	44
9	Albatera	34	46	53	44
10	Alone	34	48	57	44
11	Jávea	34	42	48	43
12	Pinoso	34	38	50	42
13	Horadada	34	45	47	41
14	Jove	34	40	52	41
15	Polop	34	44	52	40
16	Alicante	34	41	49	39
17	Benferri Cf	34	39	58	30
18	Mutxamel	34	31	55	24

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	CF Gandia	36	51	27	68
2	UD Alzira	36	51	25	67
3	Villarreal	36	57	43	62
4	Novelda CF	36	48	40	61
5	Catarroja	36	41	36	58
6	Olimpic	36	48	32	57
7	Nucía	36	60	34	57
8	Juv. Barrio	36	37	21	55
9	At. Levante	36	44	39	54
10	Crevillente	36	53	40	52
11	Burjassot	36	43	50	50
12	Jove	36	35	39	46
13	Torrevieja	36	40	38	45
14	Ribarroja	36	29	33	45
15	Puçol	36	45	55	40
16	Eldense	36	34	46	38
17	Ilicitano	36	35	90	30
18	Onda	36	27	53	28
19	Alicante	36	17	54	27

TEMPORADA 2008/2009

PRIMERA FFCV GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Torrellano	34	58	30	74
2	Hércules B	34	66	39	62
3	Ilicitano	34	61	35	62
4	Altea	34	42	28	62
5	Algueña	34	54	40	55
6	Horadada	34	58	48	52
7	Pinoso	34	43	37	50
8	Orihuela B	34	48	48	46
9	Thader	34	41	45	43
10	Albatera	34	40	50	43
11	Aspe	34	37	53	43
12	Polop	34	41	47	41
13	Alone	34	36	55	41
14	El Campello	34	51	50	40
15	Santa Pola	34	42	44	40
16	Almoradí	34	33	38	38
17	Calpe	34	30	63	26
18	Villena	34	28	59	22

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	UD Alzira	40	64	28	79
2	Valencia	40	66	26	75
3	Nucía	40	59	32	72
4	Catarroja	40	60	38	72
5	Eldense	40	54	34	70
6	Novelda CF	40	58	38	69
7	CD Utiel	40	55	43	64
8	Villarreal	40	45	47	55
9	Onda	40	49	46	53
10	Jove	40	39	45	53
11	Burjassot	40	41	41	52
12	Puçol	40	39	53	51
13	Crevillente	40	32	35	50
14	Castellón	40	40	59	50
15	Torrevieja	40	51	55	49
16	Juv. Barrio	40	43	50	47
17	Pego	40	43	59	47
18	Thader	40	37	54	45
19	Olimpic	40	36	53	43
20	Ilicitano	40	36	65	33
21	Alone	40	34	80	31

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Dénia	39	75	35	83
2	Villarreal	39	74	25	80
3	Ontinyent	39	68	34	75
4	Torrevieja	39	62	33	74
5	Novelda CF	39	58	28	73
6	Burjassot	39	51	41	61
7	Castellón	39	54	48	56
8	Onda	39	51	43	55
9	Catarroja	39	42	46	54
10	Pego	40	42	49	54
11	Alone	39	46	59	49
12	Crevillente	39	43	50	49
13	Jove	39	43	63	46
14	Puçol	39	47	54	45
15	UD Alzira	39	37	57	44
16	Ilicitano	39	43	50	43
17	Dolores	39	36	45	43
18	SD Sueca	39	32	50	43
19	Horadada	39	45	56	42
20	UD Oliva	39	39	66	38
21	Alicante	39	34	58	37
22	Sp. Requena	40	33	65	31

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Villarreal	42	78	20	100
2	Valencia	42	75	30	89
3	Eldense	42	69	34	80
4	Dénia	42	63	38	76
5	Burjassot	42	65	38	75
6	Novelda CF	42	53	39	74
7	Ontinyent	42	65	40	73
8	Onda	42	58	46	64
9	Castellón	42	50	44	62
10	Alone	42	47	51	55
11	Catarroja	42	47	50	55
12	Torrevieja	42	43	44	52
13	Dolores	42	45	69	50
14	Ilicitano	42	33	47	47
15	Puzol	42	52	59	47
16	Alicante	42	41	68	42
17	UD Oliva	42	32	63	41
18	Pego	42	45	67	41
19	CD Burriana	42	37	61	39
20	CF Gandia	42	36	58	39
21	Benicassim	42	38	74	36
22	Santa Pola	42	29	61	34

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Valencia	38	67	23	73
2	Eldense	38	50	33	65
3	CF Gandia	38	50	31	63
4	Santa Pola	38	49	41	63
5	Villarreal	38	77	47	63
6	Ilicitano	38	50	42	62
7	Onda	38	58	42	59
8	Dénia	38	51	41	58
9	Catarroja	38	52	41	55
10	Alicante	38	42	48	52
11	Burjassot	38	42	44	51
12	Ontinyent	38	57	53	51
13	CD Burriana	38	45	53	44
14	Pego	38	40	58	42
15	Puzol	38	34	45	40
16	UD Oliva	38	34	42	39
17	Torrellano	38	40	52	39
18	Benicassim	38	50	68	38
19	Paterna CF	38	35	61	37
20	CD Acero	38	34	92	22

TEMPORADA 2003/2004

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Benidorm	38	69	29	71
2	At. Levante	38	68	32	67
3	Villarreal	38	44	36	67
4	Alcoyano	38	63	42	66
5	Ontinyent	38	46	37	63
6	Onda	38	57	42	62
7	Valencia	38	36	36	57
8	Dénia	38	46	40	56
9	Torrellano	38	49	45	56
10	Eldense	38	46	43	55
11	Santa Pola	38	39	40	53
12	CD Burriana	38	53	65	49
13	Ilicitano	38	51	61	46
14	Pego	38	44	50	45
15	Burjassot	38	37	50	40
16	UD Oliva	38	46	52	39
17	CF Gandia	38	41	59	38
18	Buñol	38	49	74	37
19	Castellón	38	32	52	34
20	Hércules B	38	34	65	29

TEMPORADA 2002/2003

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	Benidorm	42	65	30	83
2	Villajoyosa	42	66	34	74
3	Onda	42	50	31	71
4	At. Levante	42	63	40	71
5	Alcoyano	42	57	41	69
6	Santa Pola	42	53	40	68
7	Pego	42	42	46	63
8	Ilicitano	42	66	48	62
9	Torrellano	42	54	50	62
10	CF Gandia	42	51	47	61
11	Eldense	42	67	45	60
12	Burjassot	42	45	54	57
13	Ontinyent	42	51	53	56
14	Valencia	42	44	46	54
15	Dénia	42	55	65	52
16	Castellón	42	59	56	52
17	CD Burriana	42	37	44	52
18	Vinaròs	42	48	63	52
19	UD Alzira	42	42	52	51
20	Carcaixent	42	46	91	34
21	Juventud	42	37	65	33
22	Puzol	42	33	90	26

TEMPORADA 2001/2002

TERCERA DIVISIÓN GRUPO 6
Equipo		PJ	GF	GC	Puntos
1	CD Burriana	38	57	22	79
2	Burjassot	38	60	25	74
3	At. Levante	38	68	34	73
4	Villajoyosa	38	55	32	65
5	Eldense	38	45	37	61
6	UD Alzira	38	35	38	60
7	Gimnástico	38	37	30	53
8	Vinaròs	38	52	46	52
9	Ilicitano	38	54	50	52
10	Alcoyano	38	49	52	52
11	Ontinyent	38	42	36	51
12	CF Gandia	38	35	44	50
13	Pego	38	47	45	49
14	Santa Pola	38	42	41	47
15	Castellón	38	40	44	47
16	Torrellano	38	37	49	45
17	Carcaixent	38	30	63	36
18	Vall Uxó	38	29	61	33
19	Pinoso	38	33	61	29
20	Deportivo	38	35	72	25

Comparar equipos

Ilicitano

Selecciona un equipo

Competiciones que juega

RIVALES EN Tercera División

RIVALES EN Play Offs Ascens.

RIVALES EN Tercera División.

USO DE MEMORIA

8,607,408 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.6733
Total Execution Time	0.6746

CADENA URL

/historico/Elche-Ilicitano/2021

GET DATOS

$_GET['/historico/Elche-Ilicitano/2021']

POST DATOS

No hay datos POST existentes

CONSULTAS (48)

0.0124	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 = 'Elche-Ilicitano' AND l.year = 2021 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.0105	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=976 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=976 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105	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=976 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106	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=976 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0111	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 = 62373
0.0114	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 = 58584
0.0115	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 = 61773
0.0107	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=976 AND type_rel = 2
0.0116	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 976 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0118	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 (1152,6436,7478,9791,10343) ORDER BY n.cover_points DESC, update_date DESC
0.0144	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 = '976' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0151	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 = '976' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0117	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 = 58584 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0117	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 = 62373 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110	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 = 61773 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0116	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=976 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0111	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 (62390,62373,61773,58584,49506) 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.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 62390 AND teamId = 976
0.0114	SELECT count(id) as num_players from rel_players WHERE league_id = 58584 AND teamId = 976
0.0113	SELECT count(id) as num_players from rel_players WHERE league_id = 62373 AND teamId = 976
0.0111	SELECT count(id) as num_players from rel_players WHERE league_id = 61773 AND teamId = 976
0.0115	SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 976
0.0115	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 = '976' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0108	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '976' and rp.type = 4
0.0118	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 = '976' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0122	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 events2021 e ON e.player_id = p.id AND e.league_id = 62373 WHERE rp.league_id = 62373 AND rp.teamId = 976 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.0122	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 events2021 e ON e.player_id = p.id AND e.league_id = 62373 WHERE rp.league_id = 62373 AND rp.teamId = 976 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154	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 events2021 e ON e.player_id = p.id AND e.league_id = 62373 WHERE rp.league_id = 62373 AND rp.teamId = 976 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141	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 = 976 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0111	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 = 58584 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.0110	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 = 50274 AND t.round = 28 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 39030 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 33356 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 15447 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0119	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 = 1946 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0124	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 = 1462 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	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 = 1203 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127	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 = 830 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0123	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 = 329 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 13 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 91 AND t.round = 40 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0114	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 = 22118 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112	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 = 22099 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0115	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 = 22083 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0113	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 = 22067 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 22051 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111	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 = 62373 ORDER BY nameShow LIMIT 100