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

Macaé Esporte

Temporada 2017/2018

TEMPORADA 2017/2018

SERIE D - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Manaus	6	14	8	12
2	Branco Acre	6	13	7	11
3	Macapá	6	7	16	6
4	Baré EC	6	5	8	5
5	Independient	6	8	3	12
6	Santos AP	6	13	8	8
7	Barcelona	6	8	7	8
8	Plácido	6	8	19	4
9	Nacional AM	6	9	4	10
10	São	6	10	11	8
11	Raimundo	6	7	8	8
12	Real	6	7	10	6
13	Ferroviário	6	7	5	10
14	Cordino	6	6	4	9
15	4 de Julho	6	3	5	6
16	Interporto	6	7	9	5
17	Moto Club	6	6	3	13
18	Altos	6	7	3	11
19	SD Sparta	6	6	9	5
20	ASSU	6	2	6	4
21	América RN	6	11	6	14
22	Imperatriz	6	10	3	9
23	Belo Jardim	6	6	12	4
24	Guarani	6	8	14	3
25	Sergipe	6	8	5	13
26	Jacuipense	6	8	8	8
27	Central SC	6	7	6	6
28	Arapiraquens	6	7	11	4
29	Campinense	6	12	3	16
30	Fluminense	6	18	3	13
31	Flamengo	6	4	16	4
32	Murici	6	4	16	1
33	Treze	6	14	4	12
34	Itabaiana	6	11	9	10
35	Vitória	6	4	6	8
36	Santa Rita	6	6	16	3
37	Iporá	6	10	4	13
38	Brasiliense	6	9	3	11
39	Corumbaense	6	5	9	8
40	Dom Bosco	6	2	10	1
41	Sinop FC	6	6	5	10
42	Novoperário	6	7	7	10
43	Aparecidense	6	11	10	8
44	Ceilândia	6	9	11	5
45	Macaé	6	10	8	11
46	URT	6	10	8	10
47	Itumbiara	6	8	6	10
48	Espirito	6	6	12	2
49	Uberlândia	6	10	7	11
50	Novorizontin	6	10	9	9
51	Americano	6	10	11	8
52	Itapemirim	6	3	6	3
53	Linense CA	6	5	3	9
54	Maringá	6	7	6	9
55	Madureira	6	6	7	6
56	Caldense	6	5	7	6
57	Caxias	6	13	2	16
58	Internaciona	6	7	11	9
59	Mirassol	6	3	5	7
60	Nova Iguaçu	6	6	11	3
61	CA Tubarão	6	9	3	15
62	Novo	6	7	6	8
63	Cianorte	6	2	5	6
64	Ferroviária	6	3	7	3
65	São José	6	10	4	18
66	Brusque	6	9	5	9
67	Prudentópol	6	6	8	6
68	Mogi Mirim	6	6	14	3

TEMPORADA 2016/2017

SERIE C - BRASIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	São Bento	18	20	10	31
2	Tupi	18	21	18	28
3	Tombense	18	19	17	26
4	Volta	18	24	17	25
5	Joinville	18	28	23	25
6	Botafogo SP	18	25	20	25
7	Ypiranga FC	18	23	21	23
8	Bragantino	18	16	19	21
9	Macaé	18	16	28	19
10	Mogi Mirim	18	15	34	13

TEMPORADA 2015/2016

SERIE C - BRASIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Guaraní	18	26	11	38
2	Boa EC	18	28	10	35
3	Botafogo SP	18	28	13	31
4	Juventude	18	28	18	30
5	Tombense	18	27	16	29
6	Ypiranga FC	18	22	23	28
7	Mogi Mirim	18	12	15	22
8	Macaé	18	16	26	16
9	Portuguesa	18	13	26	14
10	Guaratinguet	18	13	55	4

TEMPORADA 2014/2015

SERIE B - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Botafogo	38	60	30	72
2	Santa Cruz	38	63	43	67
3	Vitória	38	58	40	66
4	América	38	55	39	65
5	Náutico	38	49	42	63
6	Bragantino	38	56	56	60
7	Paysandu	38	49	40	60
8	Sampaio	38	51	43	58
9	Bahía	38	48	41	58
10	Luverdense	38	46	40	54
11	CRB	38	47	45	54
12	Criciúma	38	36	41	49
13	Paraná	38	39	43	47
14	Atlético	38	36	46	46
15	Ceará	38	42	50	45
16	Oeste	38	37	45	44
17	Macaé	38	46	54	43
18	ABC	38	41	64	32
19	Boa EC	38	34	54	31
20	Mogi Mirim	38	32	69	23

TEMPORADA 2013/2014

SERIE C - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	18	23	11	35
2	CRB	18	23	17	27
3	Salgueiro	18	20	22	27
4	Paysandu	18	21	17	26
5	Arapiraquens	18	23	22	25
6	Botafogo PB	18	20	19	25
7	Cuiabá	18	19	19	23
8	Aguia Maraba	18	21	25	20
9	Treze	18	19	25	19
10	CRAC	18	14	26	10
11	Tupi	18	30	13	34
12	Mogi Mirim	18	22	24	31
13	Madureira	18	20	17	26
14	Macaé	18	15	17	26
15	Guaratinguet	18	32	18	25
16	Juventude	18	16	14	25
17	Guaraní	18	14	15	24
18	Caxias	18	17	20	22
19	São Caetano	18	13	19	21
20	Duque Caxias	18	10	32	7

TEMPORADA 2012/2013

SERIE C - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Santa Cruz	19	31	18	34
2	Sampaio	19	32	17	32
3	Fortaleza	19	36	21	31
4	Luverdense	19	27	20	31
5	Aguia Maraba	19	30	24	31
6	Brasiliense	19	19	19	30
7	Treze	19	26	33	30
8	CRB	19	21	15	29
9	Cuiabá	19	29	20	27
10	Baraunas	19	15	41	13
11	Branco Acre	20	8	46	6
12	Macaé	17	27	19	31
13	Caxias	17	17	14	29
14	Mogi Mirim	17	22	16	27
15	Vila Nova	17	19	13	26
16	Ipatinga FC	17	19	16	25
17	Guaraní	17	14	12	23
18	Madureira	17	17	15	19
19	Duque Caxias	17	18	22	16
20	CRAC	17	11	19	16
21	Grêmio	17	18	36	14

TEMPORADA 2011/2012

SERIE C - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	18	28	11	39
2	Luverdense	18	32	26	34
3	Paysandu	18	26	19	24
4	Icasa	18	18	19	24
5	Santa Cruz	18	26	22	22
6	Treze	18	24	33	22
7	Aguia Maraba	18	22	32	22
8	Cuiabá	18	20	21	20
9	Salgueiro	18	25	29	20
10	Guarany	18	21	30	14
11	Macaé	18	33	17	32
12	Chapecoense	18	24	12	29
13	Oeste	18	22	19	29
14	Duque Caxias	18	22	23	29
15	Caxias	18	23	26	27
16	Vila Nova	18	27	26	23
17	Brasiliense	18	25	29	23
18	Madureira	18	17	21	23
19	Santo André	18	14	22	18
20	Tupi	18	13	25	14

TEMPORADA 2010/2011

SERIE C - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Branco Acre	8	12	10	16
2	Paysandu	8	13	7	14
3	Luverdense	8	11	6	13
4	Aguia Maraba	8	11	8	13
5	Araguaína	8	3	19	1
6	América RN	8	16	8	16
7	CRB	8	7	13	11
8	Guarany	8	9	9	9
9	Fortaleza	8	11	12	9
10	Campinense	8	7	8	9
11	Ipatinga FC	8	15	8	18
12	Brasiliense	8	8	5	13
13	Madureira	8	7	8	10
14	Macaé	8	14	17	8
15	Marília	8	11	17	8
16	Chapecoense	8	13	7	16
17	Joinville	8	17	11	15
18	Caxias	8	11	14	8
19	Santo André	8	8	13	8
20	Brasil	8	11	15	2

TEMPORADA 2009/2010

SERIE C - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Paysandu	8	15	9	14
2	Aguia Maraba	8	11	7	12
3	Fortaleza	8	9	7	12
4	Branco Acre	8	12	17	10
5	São	8	8	15	3
6	ABC	8	11	6	12
7	Salgueiro	8	11	12	11
8	CRB	8	8	11	11
9	Campinense	8	7	7	10
10	Alecrim	8	9	10	10
11	Boa EC	8	9	4	15
12	Macaé	8	12	8	14
13	Luverdense	8	12	10	12
14	Marília	8	7	12	6
15	Gama	8	5	11	5
16	Criciúma	8	7	4	12
17	Chapecoense	8	9	9	11
18	Caxias	8	6	6	10
19	Brasil	8	4	5	10
20	Juventude	8	6	8	8

TEMPORADA 2008/2009

SERIE D - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Nacional AM	4	6	4	9
2	Gênus	4	7	5	6
3	Atlético	4	3	7	3
4	Raimundo	6	9	7	10
5	Cristal CA	6	6	5	10
6	Moto Club	6	10	6	8
7	Tocantins	6	6	13	5
8	Ferroviário	6	8	4	10
9	Alecrim	6	7	5	10
10	Treze	6	5	7	8
11	Flamengo PI	6	5	9	5
12	Central SC	6	7	4	12
13	CSA	6	5	6	7
14	Sergipe	6	4	6	7
15	Santa Cruz	6	8	8	5
16	Macaé	6	9	4	13
17	Fluminense	6	10	9	10
18	Branco	6	11	9	8
19	Atlético	6	6	14	3
20	Tupi	6	4	3	11
21	Paulista	6	4	3	9
22	Madureira	6	9	8	8
23	Friburguense	6	6	9	4
24	Uberaba SC	6	11	6	10
25	Uberlândia	6	10	6	10
26	Mirassol	6	6	11	5
27	Ituano	6	5	9	4
28	Araguaia AC	6	11	6	10
29	Brasília	6	11	11	6
30	CRAC	6	9	10	5
31	Anapolina	6	9	13	5
32	Chapecoense	6	13	5	13
33	Londrina	6	9	7	9
34	Ypiranga FC	6	9	12	8
35	Naviraiense	6	5	12	0
36	São José	6	9	6	12
37	Malucelli	6	9	5	11
38	Brusque	6	10	9	10
39	Pelotas	6	4	12	1

TEMPORADA 2007/2008

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Branco Acre	4	13	7	9
2	Luverdense	4	11	8	9
3	Fast Clube	4	2	11	0
4	Holanda EC	6	11	8	12
5	Remo	6	12	5	11
6	Cristal CA	6	5	5	8
7	Progresso	6	3	13	3
8	Aguia Maraba	6	13	10	10
9	Paysandu	6	7	5	9
10	Bacabal	6	8	7	8
11	Palmas FR	6	6	12	6
12	Sampaio	6	8	2	12
13	Picos SE	6	3	1	10
14	Barras	6	2	6	5
15	Horizonte	6	5	9	4
16	Campinense	6	11	6	11
17	Santa Cruz	6	7	6	8
18	Potiguar	6	9	10	7
19	Central SC	6	1	6	6
20	Salgueiro	6	10	5	12
21	Icasa	6	7	4	11
22	Santa Cruz	6	5	8	7
23	Treze	6	3	8	2
24	Arapiraquens	6	14	6	13
25	Confiança	6	12	10	12
26	Atlético	6	6	8	7
27	Petrolina	6	6	14	3
28	Vitória	6	12	7	13
29	Sergipe	6	9	9	10
30	Itabuna	6	8	7	9
31	CSA	6	4	10	3
32	Atlético	6	15	5	14
33	Mixto	6	11	8	9
34	Operário	6	3	5	7
35	Águia Negra	6	4	15	1
36	Real	6	8	8	9
37	Itumbiara	6	6	4	8
38	Anápolis	6	7	11	8
39	Legião	6	12	10	7
40	América	6	7	3	11
41	Duque Caxias	6	8	8	8
42	Paulista	6	6	6	8
43	Serra FC	6	7	11	6
44	Guaratinguet	6	7	3	13
45	Boavista SC	6	13	4	10
46	Macaé	6	6	4	9
47	Linhares	6	3	18	1
48	Boa EC	6	11	4	14
49	Noroeste	6	9	9	8
50	Tupi	6	6	9	7
51	Mirassol	6	7	11	4
52	Ituano	6	10	8	10
53	Guaraní	6	5	4	10
54	Madureira	6	8	9	7
55	Linense CA	6	5	7	7
56	Toledo EC	6	8	6	9
57	Marcílio	6	6	4	9
58	Inter Santa	6	7	5	8
59	Engenheiro	6	3	9	6
60	Brasil	6	4	4	11
61	Caxias	6	8	4	8
62	Malucelli	6	4	4	7
63	Metropolitan	6	4	8	4

Comparar equipos

Macaé Esporte

Selecciona un equipo

Competiciones que juega

Serie D - Brasil

Pos	Equipos		Pts
1		EC São José	18
2		Caxias do Sul	16
3		Campinense	16
4		CA Tubarão	15
5		América RN	14
6		Fluminense de Feira	13
7		Iporá	13
8		Sergipe	13
9		Moto Club MA	13
10		Treze	12
11		Manaus	12
12		Independiente PA	12
13		Rio Branco Acre	11
14		Brasiliense	11
15		Altos	11
16		Uberlândia	11
17		Macaé Esporte	11
18		Nacional AM	10
19		Itabaiana	10
20		URT	10
21		Itumbiara	10
22		Ferroviário	10
23		Sinop FC	10
24		Novoperário	10
25		Imperatriz	9
26		Brusque	9
27		Cordino	9
28		Linense CA	9
29		Novorizontino	9
30		Maringá	9
31		Internacional SC	9
32		Santos AP	8
33		Aparecidense	8
34		Barcelona RO	8
35		Novo Hamburgo	8
36		Jacuipense	8
37		São Raimundo RR	8
38		Americano	8
39		SAO Raimundo EC	8
40		Vitória da Conquista	8
41		Corumbaense	8
42		Mirassol	7
43		Central SC	6
44		Madureira RJ	6
45		Prudentópolis	6
46		Caldense	6
47		4 de Julho	6
48		Real Ariquemes	6
49		Cianorte	6
50		Macapá	6
51		Ceilândia	5
52		Interporto	5
53		SD Sparta	5
54		Baré EC	5
55		ASA Arapiraquense	4
56		ASSU	4
57		Belo Jardim FC	4
58		Plácido de Castro	4
59		Flamengo Arcoverde	4
60		Itapemirim	3
61		Ferroviária	3
62		Nova Iguaçu	3
63		Guarani de Juazeiro	3
64		Mogi Mirim	3
65		Santa Rita	3
66		Espirito Santo	2
67		Dom Bosco	1
68		Murici	1

	Siguiente Ronda : EC São José
	Posible siguiente ronda : Caxias do Sul

RIVALES EN Carioca

RIVALES EN Copa Río

RIVALES EN Serie D - Brasil

USO DE MEMORIA

8,249,816 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.2920
Total Execution Time	0.2932

CADENA URL

/historico/Macae

GET DATOS

$_GET['/historico/Macae']

POST DATOS

No hay datos POST existentes

CONSULTAS (102)

0.0034	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 = 'Macae' 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.0101	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 = 'Macae' 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021	SELECT dp.nick, dp.fullname,rp.date_ini, rp.date_end FROM futbol.rel_people rp INNER JOIN futbol.datapeople dp on dp.id=rp.people_id WHERE rp.teamId=15143 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=15143 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=15143 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022	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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 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=15143 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
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 = 42917
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 = 43545
0.0018	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15143 AND type_rel = 2
0.0020	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 15143 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022	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 (2615,149042,154457,853084) 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 = '15143' AND l.year = 2018 ORDER BY l.year DESC,cat.coefficient DESC
0.0030	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 = '15143' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021	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 = 42917 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026	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=15143 AND l.year in (2017,2018,2019) 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 (48680,44271,43545,37759) 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.0023	SELECT count(id) as num_players from rel_players WHERE league_id = 37759 AND teamId = 15143
0.0022	SELECT count(id) as num_players from rel_players WHERE league_id = 43545 AND teamId = 15143
0.0021	SELECT count(id) as num_players from rel_players WHERE league_id = 48680 AND teamId = 15143
0.0019	SELECT count(id) as num_players from rel_players WHERE league_id = 44271 AND teamId = 15143
0.0028	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 42917 AND t.round = 6 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0044	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 = '15143' 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 = '15143' and rp.type = 4
0.0021	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 = '15143' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0043	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 events2018 e ON e.player_id = p.id AND e.league_id = 42917 WHERE rp.league_id = 42917 AND rp.teamId = 15143 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.0033	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 events2018 e ON e.player_id = p.id AND e.league_id = 42917 WHERE rp.league_id = 42917 AND rp.teamId = 15143 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0041	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 events2018 e ON e.player_id = p.id AND e.league_id = 42917 WHERE rp.league_id = 42917 AND rp.teamId = 15143 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028	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 = 15143 AND l.year <= 2018 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0038	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 = 42917 AND t.round = 6 ORDER BY team.conference 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* `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 = 37759 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* `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 = 20240 AND t.round = 18 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* `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 = 11072 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028	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 = 3272 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* `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 = 12973 AND t.round = 19 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* `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 = 12975 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* `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 = 12976 AND t.round = 10 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* `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 = 12978 AND t.round = 10 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* `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 = 13478 AND t.round = 6 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* `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 = 12980 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC