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

Jumilla

Temporada 2010/2011

TEMPORADA 2010/2011

SEGUNDA DIVISIÓN B GRUPO 4
Equipo		PJ	GF	GC	Puntos
1	Real Murcia	38	68	21	82
2	Sevilla At.	38	82	40	74
3	UD Melilla	38	53	28	72
4	Cádiz	38	61	37	69
5	Roque Lepe	38	42	35	63
6	AgD Ceuta	38	52	42	60
7	CD Roquetas	38	48	36	59
8	Real Jaén	38	39	29	56
9	Écija	38	41	45	54
10	Lucena	38	42	40	52
11	Cfba	38	41	40	49
12	Puertollano	38	40	50	48
13	Almería B	38	38	46	46
14	Poli Ejido	38	41	51	44
15	Lorca	38	37	55	43
16	Betis	38	36	45	42
17	CD Alcalá	38	30	52	40
18	Unión	38	37	45	40
19	Yeclano	38	28	63	27
20	Jumilla	38	16	72	19

TEMPORADA 2009/2010

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Jumilla	38	84	26	86
2	Yeclano	38	93	37	84
3	Lorca	38	95	36	84
4	Costa Calida	38	81	39	83
5	Cartagena	38	84	40	81
6	Pinatar	38	68	28	80
7	Cieza	38	80	32	80
8	Pulpileño	38	61	56	52
9	Plus Ultra	38	59	56	52
10	Santomera	38	51	44	49
11	Puente	38	48	56	48
12	Club Fortuna	38	50	73	47
13	CPeinsa	38	59	55	43
14	CD Beniel	38	53	71	42
15	Calasparra	38	44	70	36
16	Base Abarán	38	26	81	31
17	Bala Azul	38	47	76	30
18	Mazarrón	38	41	68	28
19	Lumbreras	38	28	127	18
20	Cuarto	38	30	111	14

TEMPORADA 2008/2009

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Cfba	38	115	26	87
2	Moratalla	38	82	32	83
3	Unión	38	76	27	80
4	Yeclano	38	83	37	80
5	Pinatar	38	77	37	72
6	Mazarrón	38	81	46	67
7	Cieza	38	77	45	62
8	Jumilla	38	63	35	62
9	CD Beniel	38	39	32	56
10	Santomera	38	51	66	49
11	Pulpileño	38	50	67	46
12	Murcia	38	59	56	45
13	San Ginés	38	49	54	42
14	Bala Azul	38	52	86	40
15	Plus Ultra	38	43	64	40
16	Calasparra	38	43	60	40
17	Lumbreras	38	41	90	30
18	Pozo	38	40	88	30
19	Muleño CF	38	33	85	23
20	Ciudad Lorca	38	32	153	14

TEMPORADA 2007/2008

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Atlético	38	84	29	93
2	Sangonera	38	78	34	79
3	Real Murcia	38	75	30	79
4	Cfba	38	93	38	76
5	Pinatar	38	90	38	75
6	Calasparra	38	62	45	65
7	Unión	38	55	39	62
8	Las Palas	38	60	44	60
9	Moratalla	38	56	41	59
10	Cieza	38	66	61	55
11	Santomera	38	46	44	53
12	Yeclano	38	62	54	49
13	Muleño CF	38	43	64	45
14	Jumilla	38	45	66	39
15	San Ginés	38	39	53	37
16	Imperial	38	50	98	34
17	Bala Azul	38	42	71	33
18	Olímpico	38	41	91	29
19	Alquerias	38	27	83	22
20	Ceuti At.	38	25	116	13

TEMPORADA 2006/2007

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Real Murcia	38	80	26	89
2	Mazarrón	38	84	39	88
3	Cfba	38	82	26	79
4	Sangonera	38	77	28	79
5	Racing	38	77	30	78
6	Unión	38	45	37	57
7	Pinatar	38	53	50	54
8	Calasparra	38	45	37	53
9	Las Palas	38	49	43	50
10	Moratalla	38	55	59	49
11	Atlético	38	48	57	46
12	Ciudad	38	39	49	45
13	Yeclano	38	55	61	44
14	Olímpico	38	42	44	43
15	Imperial	38	43	52	42
16	Jumilla	38	37	69	36
17	Bala Azul	38	36	69	33
18	Molinense	38	28	63	32
19	San Gines	38	24	82	27
20	CD Beniel	38	25	103	10

TEMPORADA 2005/2006

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Orihuela CF	38	67	16	85
2	Menor	38	76	36	74
3	Ciudad Lorca	38	61	34	68
4	Pinatar	38	64	43	68
5	Sangonera	38	61	30	66
6	Real Murcia	38	63	36	61
7	Jumilla	38	45	44	59
8	Las Palas	38	47	43	58
9	Unión	38	46	45	56
10	Ciudad	38	44	35	54
11	Mazarrón	38	47	45	49
12	Molinense	38	49	64	45
13	Horadada	38	44	51	45
14	Caravaca	38	41	46	43
15	Atlético	38	39	57	42
16	Calasparra	38	32	52	38
17	Moratalla	38	46	69	36
18	Muleño CF	38	38	63	33
19	CD Balsicas	38	39	72	33
20	Santomera	38	26	94	18

TEMPORADA 2004/2005

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Orihuela CF	38	58	25	76
2	Águilas CF	38	79	32	76
3	Sangonera	38	65	35	75
4	Menor	38	77	42	75
5	Mazarrón	38	69	37	71
6	Real Murcia	38	59	31	69
7	Horadada	38	52	43	60
8	Cfba	38	51	58	54
9	Pinatar	38	57	50	53
10	Ciudad Lorca	38	54	57	51
11	Molinense	38	53	49	50
12	Las Palas	38	61	59	46
13	Jumilla	38	39	54	45
14	Calasparra	38	40	58	43
15	Balsicas	38	52	74	42
16	Unión	38	50	66	40
17	UCAM Murcia	38	38	51	34
18	Santomera	38	38	64	34
19	Cieza	38	40	74	33
20	Bala Azul	38	38	111	16

TEMPORADA 2003/2004

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Menor	38	95	28	90
2	Mazarrón	38	82	34	77
3	Horadada	38	77	39	77
4	Caravaca	38	67	39	77
5	Orihuela CF	38	74	39	75
6	Águilas CF	38	67	51	63
7	Real Murcia	38	66	53	63
8	Calasparra	38	67	57	58
9	Pinatar	38	61	61	54
10	Sangonera	38	48	42	53
11	Jumilla	38	59	64	46
12	Balsicas	38	47	76	42
13	Las Palas	38	45	62	42
14	Molinense	38	46	53	42
15	Bala Azul	38	46	55	40
16	UCAM Murcia	38	48	54	40
17	CD Abarán	38	40	71	40
18	Dolores	38	42	59	39
19	Muleño CF	38	16	92	18
20	Lumbreras	38	24	88	16

TEMPORADA 2002/2003

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca	38	89	25	91
2	Yeclano CF	38	85	36	87
3	Menor	38	111	34	87
4	Águilas CF	38	92	45	79
5	Sangonera	38	65	37	73
6	Real Murcia	38	70	57	66
7	Caravaca	38	76	46	64
8	CD Abarán	38	62	50	63
9	Jumilla	38	66	45	61
10	Bala Azul	38	62	39	56
11	UCAM Murcia	38	52	46	49
12	Mazarrón	38	38	63	42
13	Las Palas	38	39	63	40
14	Lumbreras	38	32	57	36
15	Pinatar	38	37	72	35
16	Molinense	38	31	66	34
17	Calasparra	38	42	75	31
18	CD Beniel	38	41	95	25
19	Blanca FC	38	33	101	21
20	Olímpico	38	29	100	18

TEMPORADA 2001/2002

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Orihuela CF	38	101	37	92
2	Águilas CF	38	90	35	81
3	Yeclano CF	38	72	33	80
4	Lorca CF	38	71	25	80
5	Sangonera	38	76	32	80
6	Menor	38	69	36	70
7	Cfba	38	69	56	66
8	Bala Azul	38	58	38	61
9	Real Murcia	38	60	49	53
10	UCAM Murcia	38	53	56	49
11	CD Abarán	38	53	75	46
12	Jumilla	38	52	57	44
13	Balsicas	38	52	60	44
14	Relesa Palas	38	50	59	43
15	Calasparra	38	36	73	39
16	Molinense	38	54	70	37
17	Mazarrón	38	39	82	35
18	Horadada	38	27	62	34
19	UA. Ceutí	38	32	104	22
20	Alquerias	38	31	106	16

TEMPORADA 2000/2001

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Ciudad	42	87	20	99
2	Orihuela CF	42	102	25	98
3	Yeclano CF	42	95	29	94
4	Lorca CF	42	104	35	93
5	Menor	42	82	40	85
6	Águilas CF	42	65	43	73
7	Sangonera	42	58	48	70
8	Las Palas	42	77	44	69
9	Bala Azul	42	71	57	61
10	Real Murcia	42	66	65	57
11	Horadada	42	64	70	57
12	Mazarrón	42	48	65	55
13	Jumilla	42	49	67	50
14	UCAM Murcia	42	48	76	46
15	Caravaca	42	45	67	45
16	Molinense	42	51	71	44
17	Alquerias	42	36	67	41
18	Olímpico	42	40	93	35
19	Alhameño	42	41	89	34
20	Cieza	42	40	90	32
21	Pinatar	42	40	101	31
22	Lumbreras	42	35	82	22

TEMPORADA 1999/2000

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Olímpico	38	80	35	76
2	Horadada	38	66	29	76
3	Menor	38	70	39	75
4	Orihuela CF	38	66	35	71
5	Jumilla	38	56	41	68
6	Las Palas	38	60	44	61
7	Alhameño	38	68	46	59
8	Molinense	38	54	43	59
9	Real Murcia	38	63	46	57
10	Cieza	38	47	45	54
11	Bala Azul	38	56	51	50
12	CD Bullense	38	41	48	47
13	Alquerias	38	37	58	42
14	Sangonera	38	40	51	41
15	Lumbreras	38	36	58	39
16	CD Abarán	38	49	71	38
17	Caravaca	38	51	79	38
18	Muleño CF	38	46	78	35
19	UA. Ceutí	38	41	84	29
20	CD Beniel	38	28	74	23

TEMPORADA 1998/1999

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Orihuela CF	38	86	28	87
2	Lorca CF	38	81	28	82
3	Menor	38	73	32	78
4	Horadada	38	67	31	74
5	Olímpico	38	57	46	61
6	Relesa Palas	38	46	43	61
7	CD Bullense	38	48	33	60
8	Alhameño	38	47	40	58
9	Caravaca	38	43	40	52
10	Jumilla	38	44	47	50
11	Real Murcia	38	37	32	48
12	Cieza	38	41	48	47
13	CD Abarán	38	46	61	45
14	Alquerias	38	38	62	43
15	Lumbreras	38	42	72	42
16	Sangonera	38	34	48	37
17	CD Beniel	38	30	52	37
18	Santomera	38	31	62	33
19	Blanca FC	38	32	65	29
20	Imperial	38	26	79	25

TEMPORADA 1997/1998

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Cartagena	37	110	30	92
2	Águilas CF	37	75	24	77
3	Sangonera	37	62	35	69
4	Cfba	37	52	42	69
5	Relesa Palas	37	62	38	68
6	CD Bullense	37	56	38	61
7	Orihuela CF	37	56	41	60
8	Olímpico	37	46	44	57
9	Real Murcia	37	54	41	54
10	Horadada	37	55	49	51
11	Cieza	37	40	59	45
12	Blanca FC	37	46	70	42
13	Jumilla	37	40	54	39
14	CD Abarán	37	43	69	37
15	Alquerias	37	30	41	37
16	CD Beniel	37	34	58	34
17	Santomera	37	31	75	31
18	Cartagena	19	23	24	27
19	Pinatar	37	30	68	26
20	Cotillas	37	26	71	25

TEMPORADA 1996/1997

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Cartagena	32	95	17	76
2	Lorca CF	32	67	20	69
3	Jumilla	32	60	35	64
4	Águilas CF	32	67	31	63
5	Caravaca	32	35	24	55
6	Las Palas	32	48	37	55
7	Alquerias	32	51	43	49
8	CD Bullense	32	33	34	47
9	Real Murcia	32	50	42	46
10	CD Abarán	32	49	54	40
11	Olímpico	32	40	49	37
12	Pinatar	32	39	69	34
13	Cotillas	32	33	49	32
14	Santomera	32	29	56	29
15	CD Beniel	32	30	82	22
16	Garres	32	34	73	17
17	Blanca FC	32	19	64	14
18	Cartagena	0	0	0	0
19	Club Fortuna	0	0	0	0
20	Torre	0	0	0	0

TEMPORADA 1995/1996

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Real Murcia	38	101	21	91
2	Cartagena	38	63	28	78
3	Menor	38	62	28	75
4	Águilas CF	38	76	26	74
5	Cotillas	38	49	19	71
6	Relesa Palas	38	66	41	63
7	Pinatar	38	53	43	59
8	Caravaca	38	50	52	57
9	Santomera	38	45	53	55
10	Club Fortuna	38	39	35	54
11	Garres	38	45	50	50
12	Torre	38	46	62	48
13	CD Beniel	38	39	46	44
14	Jumilla	38	43	47	43
15	CD Abarán	38	42	62	42
16	Olímpico	38	33	54	38
17	Cehegin	38	46	80	35
18	Cieza	38	33	70	32
19	CD Roldán	38	29	74	26
20	Muleño CF	38	29	98	17

TEMPORADA 1994/1995

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Lorca CF	36	83	26	54
2	Águilas CF	36	93	25	53
3	Jumilla	36	48	32	47
4	Muleño CF	36	46	33	45
5	Cfba	36	49	31	42
6	Relesa Palas	36	58	26	42
7	Pinatar	36	42	42	39
8	CD Roldán	36	43	43	37
9	Torre	36	49	52	37
10	CD Abarán	36	45	49	36
11	Cieza	36	31	42	34
12	CD Beniel	36	33	56	32
13	Menor	36	42	53	32
14	Olímpico	36	43	59	31
15	Club Fortuna	36	36	48	29
16	Santomera	36	28	49	27
17	Real Murcia	36	42	57	27
18	Dolores	36	31	68	23
19	Cartagena	36	27	78	17
20	Atlético	0	0	0	0

TEMPORADA 1993/1994

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Águilas CF	38	91	22	59
2	CD Roldán	38	78	26	58
3	Torre	38	61	37	53
4	Cfba	38	74	32	50
5	Real Murcia	38	69	30	50
6	Pinatar	38	65	50	43
7	Jumilla	38	58	54	40
8	Lorca	38	57	63	37
9	Menor	38	62	65	36
10	CD Beniel	38	31	45	36
11	Cartagena	38	49	61	34
12	Las Palas	38	54	67	34
13	Santomera	38	44	73	33
14	Muleño CF	38	37	39	32
15	CD Abarán	38	44	69	31
16	Atlético	38	45	54	30
17	Lorca	38	48	64	30
18	Bala Azul	38	33	59	28
19	Cehegin	38	34	80	24
20	CD Alberca	38	34	78	22

TEMPORADA 1992/1993

TERCERA DIVISIÓN GRUPO 13
Equipo		PJ	GF	GC	Puntos
1	Cieza	38	62	24	56
2	Cfba	38	60	30	53
3	CD Roldán	38	75	39	52
4	Menor	38	62	41	48
5	CD Beniel	38	53	30	47
6	Lorca	38	62	37	45
7	Torre	38	60	39	44
8	Cartagena	38	46	40	41
9	Pinatar	38	49	43	40
10	Águilas CF	38	47	44	37
11	CD Abarán	38	48	39	37
12	Lorca	38	42	59	32
13	Cehegin	38	31	53	32
14	Muleño CF	38	29	54	32
15	Real Murcia	38	38	49	32
16	Santomera	38	48	69	29
17	Jumilla	38	38	57	28
18	Cotillas	38	31	55	26
19	Cieza	38	28	76	25
20	Miguel	38	32	63	24

TEMPORADA 1991/1992

TERCERA DIVISIÓN GRUPO 14
Equipo		PJ	GF	GC	Puntos
1	Águilas CF	38	73	30	53
2	Real Murcia	38	54	22	53
3	CD Beniel	37	53	23	52
4	Santomera	38	62	41	50
5	Cfba	38	46	32	48
6	Lorca	38	65	41	43
7	Cieza	38	54	45	42
8	Menor	38	45	40	41
9	Jumilla	38	49	41	41
10	Fuente	38	56	53	38
11	Cieza	38	37	41	34
12	Pinatar	38	31	40	33
13	Muleño CF	38	34	45	33
14	Miguel	38	35	52	32
15	CD Abarán	38	46	60	32
16	Cehegin	38	38	54	31
17	Olímpico	38	30	48	30
18	CD Alberca	38	32	61	29
19	Barinas CF	37	36	60	24
20	Algarrobo	38	29	76	17

Comparar equipos

Jumilla

Selecciona un equipo

Competiciones que juega

RIVALES EN Copa del Rey

RIVALES EN Segunda División.

USO DE MEMORIA

8,375,648 bytes

BENCHMARKS

Loading Time Base Classes	0.0019
Controller Execution Time ( Home / Category )	0.8075
Total Execution Time	0.8095

CADENA URL

/historico/Jumilla/2011

GET DATOS

$_GET['/historico/Jumilla/2011']

POST DATOS

No hay datos POST existentes

CONSULTAS (50)

0.0141	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 = 'Jumilla' AND l.year = 2011 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.0125	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=1424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0125	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=1424 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253	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 = 1115
0.0130	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 = 1103
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1424 AND type_rel = 2
0.0127	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 1424 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0129	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 (1903,2601,2835,3254,6752) ORDER BY n.cover_points DESC, update_date DESC
0.0133	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 = '1424' ORDER BY l.year DESC,cat.coefficient DESC
0.0149	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 = '1424' AND l.year = 2011 ORDER BY l.year DESC,cat.coefficient DESC
0.0152	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 = '1424' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = '1424' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0151	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 = 1115 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	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 = 1103 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146	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=1424 AND l.year in (2010,2011,2012) ORDER BY l.id DESC, l.year DESC ;
0.0132	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 (1447,1323,1115,1103,1000) 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.0136	SELECT count(id) as num_players from rel_players WHERE league_id = 1103 AND teamId = 1424
0.0131	SELECT count(id) as num_players from rel_players WHERE league_id = 1447 AND teamId = 1424
0.0155	SELECT count(id) as num_players from rel_players WHERE league_id = 1115 AND teamId = 1424
0.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 1000 AND teamId = 1424
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 1323 AND teamId = 1424
0.0129	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 = '1424' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0125	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '1424' and rp.type = 4
0.0127	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 = '1424' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0125	SELECT count(id_content) as cuenta FROM `rel_videos` as rp WHERE rp.id_content = '1424' and rp.type = 4
0.0133	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 events2011 e ON e.player_id = p.id AND e.league_id = 1115 WHERE rp.league_id = 1115 AND rp.teamId = 1424 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.0132	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 events2011 e ON e.player_id = p.id AND e.league_id = 1115 WHERE rp.league_id = 1115 AND rp.teamId = 1424 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0135	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 events2011 e ON e.player_id = p.id AND e.league_id = 1115 WHERE rp.league_id = 1115 AND rp.teamId = 1424 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138	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 = 1424 AND l.year <= 2011 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0138	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 = 1103 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 841 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 143 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 20 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 98 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 22125 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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 = 22106 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 22090 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 22074 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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 = 22058 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0134	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* `tables2001` 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 = 22042 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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* `tables2000` 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 = 22026 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables1999` 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 = 22010 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0131	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* `tables1998` 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 = 21994 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129	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* `tables1997` 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 = 21976 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0130	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* `tables1996` 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 = 21955 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132	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* `tables1995` 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 = 21935 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0145	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* `tables1994` 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 = 21913 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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* `tables1993` 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 = 21892 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147	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* `tables1992` 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 = 21871 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC