Sitios
- Twitter
Notificaciones 0
Amigos 0
Actividad

No hay actividad de la comunidad para mostrarte.

4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

Resultados de Fútbol

CRAC

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE D - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Manauara	1	3	1	3
2	Princesa	1	2	0	3
3	Porto Velho	1	1	0	3
4	Manaus	1	0	0	1
5	Trem DC	1	0	0	1
6	Humaitá	1	0	1	0
7	Branco Acre	1	1	3	0
8	São	1	0	2	0
9	Maranhão	1	2	1	3
10	Ríver	1	2	1	3
11	Altos	1	1	0	3
12	Moto Club	1	2	2	1
13	Tocantinópo	1	2	2	1
14	Aguia Maraba	1	1	2	0
15	Fluminense	1	1	2	0
16	Cametá	1	0	1	0
17	Treze	1	4	3	3
18	Potiguar	1	2	1	3
19	América RN	1	1	1	1
20	Maracanã	1	1	1	1
21	Iguatu	1	0	0	1
22	Sousa	1	0	0	1
23	Santa Cruz	1	3	4	0
24	Atlético	1	1	2	0
25	Arapiraquens	1	3	2	3
26	Itabaiana	1	1	1	1
27	Juazeirense	1	1	1	1
28	CSE	1	0	0	1
29	Jacuipense	1	0	0	1
30	Petrolina	1	0	0	1
31	Retro FC	1	0	0	1
32	Sergipe	1	2	3	0
33	Capital	1	2	0	3
34	Brasiliense	1	1	0	3
35	Iporá	1	2	2	1
36	União	1	2	2	1
37	CRAC	1	1	1	1
38	Mixto	1	1	1	1
39	Anápolis	1	0	1	0
40	Real	1	0	2	0
41	Serra FC	1	1	0	3
42	Democrata	1	1	1	1
43	Nova Iguaçu	1	1	1	1
44	Ipatinga FC	1	0	0	1
45	Itabuna	1	0	0	1
46	Portuguesa	1	0	0	1
47	Real	1	0	0	1
48	Audax Rio	1	0	1	0
49	Água Santa	1	2	0	3
50	Maringá	1	2	1	3
51	Inter	1	1	0	3
52	Costa Rica	1	0	0	1
53	São José	1	0	0	1
54	Santo André	1	1	2	0
55	Pouso Alegre	1	0	1	0
56	Patrocinense	1	0	2	0
57	Concórdia	1	2	0	3
58	Cascavel FC	1	2	1	3
59	Barra FC	1	1	1	1
60	Novo	1	1	1	1
61	Cianorte	1	0	0	1
62	Hercílio	1	0	0	1
63	EC Avenida	1	1	2	0
64	Brasil	1	0	2	0

TEMPORADA 2022/2023

SERIE D - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Nacional AM	14	22	7	30
2	Tuna Luso	14	21	10	28
3	Aguia Maraba	14	18	8	24
4	Princesa	14	21	13	19
5	São	14	24	24	18
6	Humaitá	14	16	21	18
7	São	14	5	33	9
8	Trem DC	14	8	19	8
9	Ferroviário	14	30	6	36
10	Atlético	14	22	15	23
11	Maranhão	14	18	11	21
12	Parnahyba	14	14	23	17
13	Caucaia EC	14	20	20	16
14	Tocantinópo	14	14	15	15
15	Cordino	14	13	26	11
16	Fluminense	14	9	24	8
17	Sousa	14	24	15	26
18	Nacional	14	17	11	24
19	Potiguar	14	16	11	23
20	Pacajus	14	21	16	22
21	Campinense	14	18	14	21
22	Santa Cruz	14	15	12	20
23	Iguatu	14	16	19	16
24	Globo	14	5	34	4
25	Retro FC	14	19	13	26
26	Bahia Feira	14	15	9	21
27	Arapiraquens	14	14	16	19
28	Falcon FC	14	16	15	19
29	Sergipe	14	19	19	19
30	Cruzeiro	14	13	22	18
31	Atlético	14	15	18	15
32	Jacuipense	14	20	19	15
33	Ceilândia	14	28	5	28
34	Anápolis	14	26	6	25
35	Operário	14	29	16	24
36	Brasiliense	14	31	11	24
37	União	14	17	9	23
38	Iporá	14	20	20	16
39	Interporto	14	3	47	6
40	Real	14	4	44	5
41	Athletic	14	19	9	29
42	Portuguesa	14	25	12	29
43	Democrata	14	18	15	25
44	Vitória ES	14	23	20	20
45	Santo André	14	15	16	19
46	Resende	14	12	18	14
47	Nova Iguaçu	14	15	23	10
48	Real	14	9	23	7
49	Patrocinense	14	16	8	24
50	Maringá	14	13	8	24
51	Inter	14	15	15	22
52	Ferroviária	14	16	11	20
53	CRAC	14	16	14	18
54	Piracicaba	14	20	21	16
55	Cascavel FC	14	12	17	16
56	Operário	14	5	19	8
57	Hercílio	14	21	10	29
58	Caxias	14	19	16	23
59	Camboriú	14	19	14	22
60	Brasil	14	15	13	20
61	Joseense	14	15	15	20
62	Concórdia	14	15	13	19
63	Aimoré	14	8	21	10
64	Novo	14	13	23	7

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 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 D - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Remo	8	20	16	16
2	Vilhena	8	17	10	15
3	Atlético	8	19	15	13
4	Peñarol AC	8	16	16	9
5	Náutico RR	8	9	24	6
6	Sampaio	8	25	2	24
7	Mixto	8	13	9	12
8	Comercial	8	6	13	5
9	Santos AP	8	9	16	4
10	Araguaína	8	4	17	3
11	Baraunas	8	12	7	15
12	Campinense	8	11	8	14
13	Horizonte	8	9	5	13
14	Ypiranga PE	8	13	15	8
15	Petrolina	8	9	19	3
16	CSA	8	15	3	20
17	Sousa	8	7	5	13
18	Feirense FC	8	9	12	11
19	Itabaiana	8	5	10	6
20	Vitória	8	7	13	4
21	CRAC	8	15	9	15
22	Ceilândia	8	14	14	14
23	CENE	8	17	11	13
24	Aparecidense	8	11	15	10
25	Sobradinho	8	8	16	3
26	Friburguense	8	13	4	16
27	Nacional	8	7	5	13
28	Aracruz	8	5	7	9
29	Volta	8	5	6	8
30	Guarani MG	8	3	11	6
31	Cianorte	8	14	4	18
32	Mogi Mirim	8	10	7	13
33	Ceramica AC	8	10	7	11
34	Marília	8	7	15	7
35	Concórdia	8	7	15	4
36	Metropolitan	8	8	7	14
37	Juventude	8	7	4	12
38	Arapongas	8	6	6	10
39	Brasil	8	6	7	9
40	Mirassol	8	8	11	7

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 2006/2007

SERIE C - BRASIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Bragantino	14	21	13	26
2	Bahía	14	26	18	24
3	Vila Nova	14	27	20	23
4	ABC	14	20	21	23
5	Atlético	14	24	17	21
6	CRAC	14	24	20	21
7	Barras	14	15	31	10
8	Nacional	14	9	26	8

Competiciones que juega

Serie D - Brasil

Pos	Equipos		Pts
1		Manauara	3
2		Água Santa	3
3		Capital	3
4		Concórdia	3
5		Princesa Solimões	3
6		Treze	3
7		ASA Arapiraquense	3
8		Cascavel FC	3
9		Maranhão	3
10		Maringá	3
11		Potiguar Mossoró	3
12		Ríver	3
13		Altos	3
14		Brasiliense	3
15		Inter de Limeira	3
16		Porto Velho	3
17		Serra FC	3
18		Iporá	1
19		Moto Club MA	1
20		Tocantinópolis	1
21		União Rondonópolis	1
22		América RN	1
23		Barra FC	1
24		CRAC	1
25		Democrata SL	1
26		Itabaiana	1
27		Maracanã	1
28		Mixto	1
29		Nova Iguaçu	1
30		Novo Hamburgo	1
31		SD Juazeirense	1
32		Cianorte	1
33		Costa Rica	1
34		CSE	1
35		Hercílio Luz	1
36		Iguatu	1
37		Ipatinga FC	1
38		Itabuna	1
39		Jacuipense	1
40		Manaus	1
41		Petrolina	1
42		Portuguesa RJ	1
43		Real Noroeste	1
44		Retro FC	1
45		São José	1
46		Sousa	1
47		Trem DC	1
48		Santa Cruz RN	0
49		Sergipe	0
50		Aguia de Maraba	0
51		Atlético Cearense	0
52		EC Avenida	0
53		Fluminense PI	0
54		Santo André	0
55		Anápolis	0
56		Audax Rio	0
57		Cametá	0
58		Humaitá	0
59		Pouso Alegre	0
60		Rio Branco Acre	0
61		Brasil de Pelotas	0
62		Patrocinense	0
63		Real Brasília	0
64		São Raimundo RR	0

	Series Finales : Manauara, Água Santa, Capital, Concórdia

RIVALES EN Goiano 1

RIVALES EN Serie D - Brasil

USO DE MEMORIA

7,657,720 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.5532
Total Execution Time	0.5545

CADENA URL

/historico/Crac

GET DATOS

$_GET['/historico/Crac']

POST DATOS

No hay datos POST existentes

CONSULTAS (31)

0.0137	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 = 'Crac' 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.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=15145 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=15145 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126	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=15145 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0255	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 = 75630
0.0134	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 = 74874
0.0125	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15145 AND type_rel = 2
0.0140	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 = '15145' ORDER BY l.year DESC,cat.coefficient DESC
0.0140	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 = '15145' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0142	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 = '15145' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130	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 = 74874 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0138	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=15145 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128	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 (75630,74874) 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.0143	SELECT count(id) as num_players from rel_players WHERE league_id = 75630 AND teamId = 15145
0.0135	SELECT count(id) as num_players from rel_players WHERE league_id = 74874 AND teamId = 15145
0.0126	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 = '15145' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0124	SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '15145' 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 = '15145' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142	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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 15145 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.0147	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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 15145 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0137	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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 15145 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0158	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 = 15145 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0164	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* `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 = 75630 AND t.round = 2 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0170	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables2023` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 71346 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.0164	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.0149	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.0142	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.0135	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 = 13449 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0133	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.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* `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.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* `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 = 13013 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC


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

Resultados de Fútbol

CRAC

CRAC

Selecciona un equipo

Competiciones que juega

Serie D - Brasil

RIVALES EN Goiano 1

RIVALES EN Serie D - Brasil