Has elegido rechazar las cookies basadas en consentimiento que utilizamos principalmente para gestionar la publicidad y las recomendaciones de contenido.

En adelante, para aceder a nuestra web tienes que elegir alguna de las siguientes opciones.

Has cambiado de idea y quieres
NAVEGAR GRATIS Y CON PUBLICIDAD...

Navega por besoccer.com y resultados-futbol.com con publicidad personalizada, seguimiento y cookies de forma gratuita.

Optar por esta opción te permitirá mantener tu experiencia de navegación como hasta ahora. Al aceptar las cookies y tecnologías similares, estás dando tu consentimiento para que recopilemos y utilicemos tu información de navegación con el propósito de adaptar la publicidad y la personalización según tus intereses. La presencia de esta publicidad es crucial para continuar proporcionando contenido de calidad, sevicios eficientes a los usuarios y mejorar la experiencia general de uso.

Nosotros y nuestros socios hacemos el siguiente tratamiento de datos: almacenamiento y acceso a información de geolocalización con propósitos de publicidad dirigida, almacenamiento y acceso a información de geolocalización para realizar estudios de mercado, almacenar o acceder a información en un dispositivo, analizar activamente las características del dispositivo para su identificación, compartir tus análisis de navegación y grupos de interés con terceros, crear un perfil para la personalización de contenidos, crear un perfil publicitario personalizado, desarrollar y mejorar productos, enriquecer el perfil con información de terceros, medir el rendimiento de los anuncios, medir el rendimiento del contenido, seleccionar anuncios básicos, seleccionar anuncios personalizados, seleccionar contenido personalizado, utilizar datos de localización geográfica precisa, utilizar estudios de mercado a fin de generar información sobre el público.

Aceptar y continuar gratis

...O sigues prefiriendo rechazar las cookies y entonces
CONTINÚA REGISTRÁNDOTE Y SUSCRIBIÉNDOTE

Navega por besoccer.com y resultados-futbol.com sin publicidad ni seguimiento suscribiéndote a nuestra web por 0,50 € al día.

Además de abonar la suscripción, es necesario realizar un registro previo para acceder. El mismo perfil de usuario es compartido entre los sitios besoccer.com y resultados-futbol.com

Accede por 0,50 € al día

Para saber más, consulta nuestra Política de Cookies.

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

Imperatriz

Temporada 2023/2024

TEMPORADA 2020/2021

SERIE D - BRASIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Castanhal	14	33	11	36
2	São	14	28	11	29
3	Peñarol AC	14	23	14	24
4	Galvez EC	14	22	24	22
5	Fast Clube	14	21	20	15
6	Ypiranga AP	14	13	22	13
7	GA Sampaio	14	12	29	9
8	Atlético	14	14	35	7
9	Guarany	14	24	16	28
10	4 de Julho	14	18	11	24
11	Paragominas	14	26	19	23
12	Moto Club	14	20	19	21
13	Palmas FR	14	19	17	18
14	Imperatriz	14	14	17	17
15	Juventude	14	13	21	14
16	Tocantinópo	14	17	31	7
17	ABC	14	30	13	28
18	Campinense	14	23	12	25
19	América RN	14	25	20	22
20	Atlético	14	22	20	21
21	Sousa	14	16	18	16
22	Central SC	14	13	17	15
23	Treze	14	18	16	15
24	Caucaia EC	14	20	51	9
25	Juazeirense	14	18	9	27
26	Itabaiana	14	22	13	26
27	Sergipe	14	16	8	23
28	Retro FC	14	17	14	20
29	Atlético	14	15	17	18
30	Bahia Feira	14	18	20	15
31	Arapiraquens	14	12	22	12
32	Murici	14	14	29	6
33	Aparecidense	14	19	8	28
34	Nova Mutum	14	18	11	27
35	União	14	21	15	24
36	Brasiliense	14	22	14	21
37	Goianésia	14	15	14	21
38	Porto Velho	14	10	16	13
39	Gama	14	13	18	12
40	Jaraguá	14	6	28	5
41	Ferroviária	14	24	5	33
42	Boa EC	14	20	11	24
43	Uberlândia	14	21	15	23
44	Caldense	14	26	19	21
45	Branco-VN	14	18	13	21
46	Branco	14	17	22	15
47	Patrocinense	14	9	22	7
48	Águia Negra	14	13	41	7
49	Portuguesa	14	20	12	24
50	Santo André	14	16	13	21
51	Cianorte	14	12	9	20
52	Bangu	14	14	16	19
53	Inter	14	11	14	19
54	Boavista SC	14	11	13	18
55	São Bento	14	10	13	14
56	Madureira	14	12	16	14
57	Joinville	14	17	6	28
58	Cascavel FC	14	27	17	27
59	Esportivo	14	15	13	18
60	Caxias	14	15	13	18
61	Juventus SC	14	12	11	18
62	Marcílio	14	13	17	18
63	Aimoré	14	15	18	12
64	Branco	14	8	27	7

TEMPORADA 2019/2020

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Santa Cruz	18	32	16	37
2	Remo	18	20	10	31
3	Vila Nova	18	20	11	31
4	Paysandu	18	25	14	29
5	Manaus	18	19	18	26
6	Jacuipense	18	19	21	24
7	Ferroviário	18	27	22	23
8	Botafogo PB	18	19	17	20
9	Treze	18	19	21	19
10	Imperatriz	18	10	60	1

TEMPORADA 2018/2019

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Náutico	18	24	18	33
2	Sampaio	18	22	19	31
3	Imperatriz	18	27	22	28
4	Confiança	18	22	22	26
5	Ferroviário	18	21	20	25
6	Botafogo PB	18	26	22	25
7	Santa Cruz	18	24	27	25
8	Treze	18	22	27	19
9	ABC	18	19	22	18
10	Globo	18	19	27	16

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 2014/2015

SERIE D - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Remo	8	14	6	17
2	Branco Acre	8	10	6	15
3	Nacional AM	8	10	12	8
4	Vilhena	8	8	14	6
5	Náutico RR	8	8	12	4
6	Ríver	8	8	3	16
7	Palmas FR	8	7	4	14
8	Santos AP	8	8	11	10
9	Imperatriz	8	11	11	8
10	Guarani	8	4	9	5
11	Campinense	8	10	5	14
12	Coruripe	8	15	10	13
13	Serra	8	7	9	8
14	Colo Colo	8	9	12	8
15	Globo	8	5	10	8
16	Central SC	8	11	5	16
17	Treze	8	11	5	15
18	Estanciano	8	14	11	15
19	Goianésia	8	3	10	5
20	Serrano SC	8	6	14	5
21	Branco	8	12	7	17
22	Caldense	8	8	4	14
23	Aparecidense	8	9	5	13
24	Comercial	8	6	10	7
25	Operário	8	7	16	4
26	CRAC	8	7	1	18
27	Botafogo SP	8	11	5	13
28	Gama	8	9	6	13
29	Duque Caxias	8	10	11	7
30	Villa Nova	8	9	23	3
31	Ypiranga FC	8	7	3	16
32	Operário	8	11	8	16
33	Resende	8	9	10	9
34	RB Brasil	8	5	8	8
35	Internaciona	8	6	9	7
36	São Caetano	8	22	5	19
37	Lajeadense	8	11	9	15
38	Volta	8	10	14	9
39	Metropolitan	8	8	12	8
40	Iguaçu	8	10	21	5

TEMPORADA 2006/2007

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Branco Acre	6	15	5	12
2	Fast Clube	6	6	3	11
3	Jaruense	6	8	13	8
4	São	6	7	15	1
5	Nacional AM	6	10	6	11
6	Tuna Luso	6	7	7	10
7	Amapá Clube	6	6	8	7
8	São	6	5	7	5
9	Araguaína	6	8	4	11
10	Imperatriz	6	4	2	10
11	Ananindeua	6	6	6	9
12	Paysandu	6	3	9	1
13	Barras	6	9	5	11
14	Sampaio	6	5	5	9
15	Ríver	6	9	11	8
16	Itapipoca	6	10	12	4
17	Nacional	6	8	6	11
18	Potiguar	6	10	8	7
19	CA Porto	6	8	10	7
20	Icasa	6	5	7	7
21	ABC	6	12	6	13
22	Atlético	6	4	3	10
23	Central SC	6	9	10	6
24	Vera Cruz	6	3	9	4
25	Bahía	6	11	1	16
26	Confiança	6	11	5	13
27	América SE	6	1	7	4
28	Arapiraquens	6	3	13	1
29	Coruripe	6	11	4	14
30	Linhares	6	12	10	8
31	Atlético	6	7	12	6
32	Poções	6	6	10	4
33	Atlético	6	8	4	12
34	CRAC	6	7	7	9
35	Ceilândia	6	6	7	7
36	Cacerense	6	5	8	7
37	Vila Nova	6	12	5	13
38	Itumbiara	6	11	8	12
39	Grêmio	6	14	9	10
40	CDR Guará	6	3	18	0
41	América RJ	6	10	7	10
42	Guaraní	6	8	7	10
43	Jaguaré	6	12	12	7
44	Tupi	6	8	12	7
45	Rio Claro	6	4	3	9
46	Volta	6	6	6	8
47	Friburguense	6	5	5	7
48	Noroeste	6	5	6	6
49	Bragantino	6	10	3	13
50	Águia Negra	6	7	8	8
51	CENE	6	6	7	8
52	Sertãozinho	6	8	13	4
53	Villa Nova	6	12	6	9
54	Democrata	6	7	10	9
55	CA Juventus	6	3	2	8
56	Madureira	6	1	5	3
57	Roma	6	10	3	14
58	Canoas SC	6	9	5	9
59	Chapecoense	6	5	10	4
60	Paranavaí	6	4	10	4
61	Joinville	6	8	4	13
62	Esportivo	6	6	9	9
63	Adap Galo M.	6	10	8	8
64	Caxias	6	4	7	3

TEMPORADA 2005/2006

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Tuna Luso	4	9	4	10
2	Negro	4	7	8	4
3	ADESG	4	3	7	3
4	Fast Clube	6	7	3	13
5	Ananindeua	6	12	8	10
6	Amapá Clube	6	7	11	5
7	São	6	5	9	5
8	Operário	6	8	6	9
9	Mixto	6	6	6	9
10	Araguaína	6	6	8	7
11	SC Ulbra	6	7	7	0
12	Ríver	6	12	4	13
13	Maranhão	6	8	6	10
14	Imperatriz	6	6	4	8
15	Flamengo PI	6	3	15	2
16	Icasa	6	13	7	12
17	CA Porto	6	10	8	11
18	Baraunas	6	8	12	5
19	Botafogo PB	6	8	12	4
20	Ferroviário	6	9	9	10
21	Treze	6	7	5	9
22	Potiguar	6	6	3	8
23	Ypiranga PE	6	6	11	0
24	Bahía	6	12	7	13
25	Confiança	6	8	7	9
26	CSA	6	8	10	5
27	Colo Colo	6	8	12	5
28	Vitória	6	10	5	11
29	Coruripe	6	9	7	11
30	Olímpico	6	7	8	7
31	Ipitanga	6	5	11	4
32	Jataiense	6	12	6	12
33	Anapolina	6	13	6	10
34	Luziânia	6	5	15	4
35	Coxim	6	4	7	0
36	Boa EC	6	8	2	13
37	Atlético	6	6	6	8
38	Chapadão	6	3	5	7
39	Ceilândia	6	5	9	0
40	América	6	10	4	15
41	Grêmio	6	7	4	13
42	Vitória ES	6	5	9	4
43	América RJ	6	4	9	2
44	Americano	6	9	5	14
45	Ipatinga FC	6	6	4	10
46	CA Juventus	6	7	9	4
47	Estrela	6	5	9	0
48	Cabofriense	6	10	6	11
49	Branco	6	13	8	10
50	Madureira	6	8	7	7
51	União	6	5	15	6
52	Malucelli	6	8	4	10
53	Noroeste	6	5	4	9
54	Campo	6	4	5	7
55	América SP	6	3	7	5
56	Joinville	6	8	4	11
57	Canoas SC	6	7	5	10
58	Caxias	6	8	7	7
59	Branco	6	3	10	4
60	Brasil	6	10	8	15
61	Criciúma	6	20	9	13
62	Novo	6	7	14	7
63	Marcílio	6	7	13	0

TEMPORADA 2004/2005

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nacional AM	4	8	4	10
2	Independênc	4	4	7	4
3	Grêmio	4	7	8	3
4	Vila Aurora	6	12	7	12
5	São	6	12	8	8
6	Luverdense	6	12	9	7
7	Ji-Paraná	6	2	14	5
8	Remo	6	14	7	14
9	Abaeté	6	9	7	10
10	São José	6	7	10	5
11	São	6	7	13	4
12	Moto Club	6	8	5	11
13	Tocantinópo	6	10	7	10
14	Imperatriz	6	6	7	8
15	Parnahyba	6	9	14	4
16	Ferroviário	6	17	10	15
17	Icasa	6	9	8	9
18	Serrano PE	6	8	11	7
19	Piauí	6	1	6	4
20	Coruripe	6	14	9	15
21	Nacional	6	13	9	12
22	América RN	6	9	5	9
23	Vitória	6	3	16	0
24	Treze	6	14	10	13
25	ABC	6	6	6	8
26	Arapiraquens	6	5	7	7
27	Baraunas	6	8	10	5
28	Sergipe	6	12	5	13
29	Itabaiana	6	7	6	10
30	Ipitanga	6	9	9	8
31	Juazeiro BA	6	5	13	3
32	Ipatinga FC	6	13	7	10
33	Serra FC	6	11	10	10
34	Americano	6	7	11	8
35	Estrela	6	6	9	5
36	Atlético	6	11	7	9
37	Mogi Mirim	6	9	6	9
38	Madureira	6	6	8	8
39	Portuguesa	6	5	10	6
40	Londrina	6	11	6	11
41	CENE	6	10	8	11
42	Cianorte	6	6	6	8
43	Operário	6	5	12	2
44	Ceilândia	6	11	7	10
45	Mineiros	6	5	4	9
46	Paranoá	6	7	8	9
47	Gremio	6	8	12	5
48	Branco	6	10	9	9
49	Boa EC	6	9	11	8
50	União São	6	14	13	7
51	América SP	6	12	12	7
52	Villa Nova	6	6	4	9
53	Volta	6	4	3	9
54	Cabofriense	6	4	5	6
55	América	6	5	7	6
56	Novo	6	8	4	11
57	Joinville	6	9	6	10
58	Campo	6	5	8	9
59	Iraty	6	5	9	4
60	GE Glória	6	8	5	13
61	Gaúcho	6	5	5	9
62	Hermann	6	5	4	8
63	Marcílio	6	1	5	4

Competiciones que juega

Grupo 2

RIVALES EN Maranhense

USO DE MEMORIA

7,498,640 bytes

BENCHMARKS

Loading Time Base Classes	0.0012
Controller Execution Time ( Home / Category )	0.5264
Total Execution Time	0.5276

CADENA URL

/historico/Imperatriz

GET DATOS

$_GET['/historico/Imperatriz']

POST DATOS

No hay datos POST existentes

CONSULTAS (35)

0.0126	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 = 'Imperatriz' 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.0108	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=59912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0109	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=59912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0113	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=59912 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0242	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 = 75777
0.0113	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 = 74873
0.0107	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59912 AND type_rel = 2
0.0105	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1514 AND type_rel = 3
0.0108	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1514 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0107	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 (72047) ORDER BY n.cover_points DESC, update_date DESC
0.0123	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 = '59912' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0140	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 = '59912' 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 = 74873 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0136	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=59912 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0117	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 (75777,74262) 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.0121	SELECT count(id) as num_players from rel_players WHERE league_id = 75777 AND teamId = 59912
0.0113	SELECT count(id) as num_players from rel_players WHERE league_id = 74262 AND teamId = 59912
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 FROM* `tables2024` 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 = 75777 AND t.round = 1 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0117	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 = '59912' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0111	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59912' and rp.type = 4
0.0119	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 = '59912' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127	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 events2024 e ON e.player_id = p.id AND e.league_id = 75777 WHERE rp.league_id = 75777 AND rp.teamId = 59912 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.0128	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 events2024 e ON e.player_id = p.id AND e.league_id = 75777 WHERE rp.league_id = 75777 AND rp.teamId = 59912 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0109	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 events2024 e ON e.player_id = p.id AND e.league_id = 75777 WHERE rp.league_id = 75777 AND rp.teamId = 59912 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0117	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 = 59912 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0120	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 = 62039 AND t.round = 14 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* `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 = 55525 AND t.round = 18 ORDER BY team.conference ASC,t.position 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* `tables2019` 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 = 49045 AND t.round = 18 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* `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.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* `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 = 16458 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144	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 = 12983 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146	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 = 12990 AND t.round = 6 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* `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 = 12995 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106	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 = 75777 ORDER BY nameShow LIMIT 100
0.0116	SELECT l.year,l.group_code FROM leagues_besoccer l WHERE l.categoryId = 1514 AND l.year = 2024 ORDER BY l.group_code ASC

Imperatriz

Imperatriz

Selecciona un equipo

Competiciones que juega

RIVALES EN Maranhense