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

Botafogo PB

Entrenador: Felipe Surian

Temporada 2023/2024

TEMPORADA 2023/2024

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Athletic	2	7	1	6
2	Náutico	2	4	1	4
3	São	2	5	3	4
4	Figueirense	2	3	2	4
5	Ypiranga FC	1	3	1	3
6	Aparecidense	1	2	0	3
7	Botafogo PB	1	2	1	3
8	Volta	1	2	1	3
9	Tombense	2	3	4	3
10	Confiança	1	1	1	1
11	Ferroviária	1	1	1	1
12	Sampaio	2	1	3	1
13	ABC	2	1	4	1
14	Londrina	1	1	1	1
15	Floresta EC	1	1	2	0
16	Ferroviário	1	1	2	0
17	São José	1	0	1	0
18	CSA	1	1	3	0
19	Remo	2	2	5	0
20	Caxias	1	0	4	0

TEMPORADA 2022/2023

SERIE C - BRASIL GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Brusque	6	9	7	13
2	Operário	6	9	9	7
3	São	6	6	6	7
4	São José	6	5	7	6
5	Amazonas FC	6	9	4	12
6	Paysandu	6	7	6	10
7	Volta	6	6	7	10
8	Botafogo PB	6	6	11	3

TEMPORADA 2021/2022

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Mirassol	19	32	20	33
2	Paysandu	19	31	17	33
3	Figueirense	19	27	18	33
4	Volta	19	29	22	32
5	Botafogo SP	19	26	22	32
6	ABC	19	22	16	31
7	Vitória	19	21	15	29
8	Aparecidense	19	23	18	29
9	Botafogo PB	19	17	13	29
10	Ypiranga FC	19	25	20	28
11	São José	19	33	27	26
12	Remo	19	25	22	26
13	Manaus	19	16	21	25
14	Confiança	19	12	17	23
15	Floresta EC	19	17	25	23
16	Altos	19	21	31	21
17	Atlético	19	17	35	19
18	Brasil	19	19	29	17
19	Ferroviário	19	15	27	16
20	Campinense	19	15	28	16

TEMPORADA 2020/2021

SERIE C - BRASIL GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Ituano	6	11	5	13
2	Criciúma	6	3	1	9
3	Botafogo PB	6	3	4	8
4	Paysandu	6	2	9	2
5	Tombense	6	8	6	11
6	Novorizontin	6	7	10	9
7	Manaus	6	10	8	6
8	Ypiranga FC	6	6	7	6

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 C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Náutico	18	26	22	31
2	Atlético	18	25	22	30
3	Santa Cruz	18	22	13	28
4	Botafogo PB	18	22	17	26
5	Confiança	18	24	25	23
6	Remo	18	18	20	22
7	Globo	18	19	19	22
8	ABC	18	18	24	21
9	Juazeirense	18	16	20	19
10	Salgueiro	18	11	19	17

TEMPORADA 2016/2017

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Sampaio	18	24	20	32
2	CSA	18	21	12	32
3	Fortaleza	18	20	15	27
4	Confiança	18	23	25	25
5	Salgueiro	18	19	16	24
6	Cuiabá	18	17	17	23
7	Remo	18	19	21	22
8	Botafogo PB	18	18	21	21
9	Moto Club	18	18	20	20
10	Arapiraquens	18	11	23	13

TEMPORADA 2015/2016

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	18	26	17	30
2	ABC	18	24	15	30
3	Botafogo PB	18	19	13	28
4	Arapiraquens	18	16	15	26
5	Remo	18	21	20	25
6	Confiança	18	22	26	22
7	Cuiabá	18	19	17	22
8	Salgueiro	18	13	18	21
9	América RN	18	17	23	20
10	Ríver	18	13	26	13

TEMPORADA 2014/2015

SERIE C - BRASIL GRUPO 1
Equipo		PJ	GF	GC	Puntos
1	Fortaleza	18	30	14	36
2	Arapiraquens	18	24	17	35
3	Vila Nova	18	24	13	33
4	Confiança	18	25	16	31
5	América RN	18	23	17	29
6	Botafogo PB	18	25	30	23
7	Salgueiro	18	17	20	19
8	Cuiabá	18	20	25	19
9	Aguia Maraba	18	19	28	15
10	Icasa	18	15	42	7

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 D - BRASIL
Equipo		PJ	GF	GC	Puntos
1	Nacional AM	8	21	14	15
2	Plácido	8	9	12	13
3	Paragominas	8	15	7	11
4	Náutico RR	8	11	16	7
5	Gênus	8	11	18	5
6	Tiradentes	8	13	2	19
7	Salgueiro	8	16	7	15
8	Gurupi	8	12	16	15
9	Parnahyba	8	9	10	11
10	Maranhão	8	13	10	9
11	Central SC	8	8	4	13
12	Guarany	8	8	8	12
13	Ypiranga PE	8	9	11	10
14	Ypiranga AP	8	6	13	5
15	Potiguar	8	3	16	2
16	Botafogo PB	8	14	7	17
17	Sergipe	8	16	7	16
18	Vitória	8	6	7	11
19	Juazeirense	8	8	16	8
20	CSA	8	6	13	4
21	Mixto	8	7	4	16
22	Aparecidense	8	11	4	15
23	Goianésia	8	10	10	10
24	Águia Negra	8	8	12	9
25	Brasília	8	8	14	5
26	Tupi	8	17	8	21
27	Resende	8	11	6	14
28	Santo André	8	11	8	14
29	Marcílio	8	10	9	11
30	Penapolense	8	8	9	9
31	Metropolitan	8	11	8	13
32	Nova Iguaçu	8	8	9	9
33	Villa Nova	8	6	11	8
34	Aracruz	8	8	14	6
35	Araxá	8	5	12	5
36	Juventude	8	9	7	15
37	Londrina	8	9	9	13
38	Malucelli	8	14	13	10
39	Botafogo SP	8	8	7	9
40	Lajeadense	8	8	13	9

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 1985/1986

LIGA BRASILEÑA GRUPO 2
Equipo		PJ	GF	GC	Puntos
1	Flamengo	10	15	7	14
2	Corinthians	10	16	6	13
3	Ponte Preta	10	18	11	13
4	Athletico	10	12	5	12
5	Grêmio	10	15	11	11
6	América RJ	10	10	11	10
7	Goiás EC	10	8	9	10
8	Joinville	10	14	17	9
9	Sergipe	10	5	16	8
10	Botafogo PB	10	9	16	7
11	Paysandu	10	5	18	3

TEMPORADA 1984/1985

LIGA BRASILEÑA GRUPO 5
Equipo		PJ	GF	GC	Puntos
1	Sport Recife	11	23	7	28
2	Ceará	11	20	9	27
3	Nacional AM	11	24	11	21
4	CSA	11	16	8	18
5	Paysandu	11	15	13	18
6	Mixto	11	11	12	18
7	Botafogo PB	11	12	16	13
8	Remo	11	9	20	12
9	ABC	11	17	18	11
10	Flamengo PI	11	7	14	8
11	Sergipe	11	9	20	6
12	Sampaio	11	12	27	5

TEMPORADA 1979/1980

LIGA BRASILEÑA GRUPO 3
Equipo		PJ	GF	GC	Puntos
1	Santos FC	9	17	5	22
2	Flamengo	9	16	7	18
3	Botafogo PB	9	14	16	16
4	Internaciona	9	13	10	15
5	Ponte Preta	9	20	11	14
6	Ferroviário	9	9	10	10
7	Náutico	9	12	14	9
8	Itabaiana	9	10	22	9
9	Mixto	9	11	18	7
10	São Paulo	9	6	15	6

Competiciones que juega

Serie C - Brasil Grupo 1

Pos	Equipos		Pts
1		Athletic Club	6
2		Náutico	4
3		São Bernardo FC	4
4		Figueirense	4
5		Ypiranga FC	3
6		Aparecidense	3
7		Botafogo PB	3
8		Volta Redonda	3
9		Tombense	3
10		Confiança	1
11		Ferroviária	1
12		Sampaio Correa	1
13		ABC	1
14		Londrina	1
15		Floresta EC	0
16		Ferroviário	0
17		EC São José	0
18		CSA	0
19		Remo	0
20		Caxias do Sul	0

	Playoff Ascenso : Athletic Club, Náutico, São Bernardo FC, Figueirense, Ypiranga FC, Aparecidense, Botafogo PB, Volta Redonda
	Descenso : EC São José, CSA, Remo, Caxias do Sul

RIVALES EN Copa do Nordeste

RIVALES EN Paraibano

RIVALES EN Serie C - Brasil

USO DE MEMORIA

7,499,176 bytes

BENCHMARKS

Loading Time Base Classes	0.0013
Controller Execution Time ( Home / Category )	0.6782
Total Execution Time	0.6795

CADENA URL

/historico/Botafogo-Pb

GET DATOS

$_GET['/historico/Botafogo-Pb']

POST DATOS

No hay datos POST existentes

CONSULTAS (41)

0.0252	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 = 74561
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 = 75677
0.0130	SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17670 AND type_rel = 2
0.0142	SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17670 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0138	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 (67026,105429,175528,783891,792947) ORDER BY n.cover_points DESC, update_date DESC
0.0187	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 = '17670' ORDER BY l.year DESC,cat.coefficient DESC
0.0138	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 = '17670' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0135	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=17670 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0127	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 (75735,75677,74996,71432,71069) 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.0133	SELECT count(id) as num_players from rel_players WHERE league_id = 74996 AND teamId = 17670
0.0138	SELECT count(id) as num_players from rel_players WHERE league_id = 71069 AND teamId = 17670
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 75735 AND teamId = 17670
0.0130	SELECT count(id) as num_players from rel_players WHERE league_id = 75677 AND teamId = 17670
0.0134	SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17670
0.0128	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 = '17670' 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 = '17670' 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 = '17670' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139	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 = 74996 WHERE rp.league_id = 74996 AND rp.teamId = 17670 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.0148	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 = 74996 WHERE rp.league_id = 74996 AND rp.teamId = 17670 AND (e.action = 4 or e.action = 5) 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 = 74996 WHERE rp.league_id = 74996 AND rp.teamId = 17670 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0145	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 = 17670 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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* `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 = 74996 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.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* `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 = 71174 AND t.round = 19 ORDER BY team.conference ASC,t.position 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* `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 = 73855 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0141	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* `tables2022` 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 = 66740 AND t.round = 19 ORDER BY team.conference ASC,t.position 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* `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 = 62011 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.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* `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 = 64663 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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.0127	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `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 = 42704 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* `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 = 37758 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* `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 = 20239 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* `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 = 11073 AND t.round = 18 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* `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.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* `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 = 13450 AND t.round = 10 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* `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.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1986` 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 = 25411 AND t.round = 11 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* `tables1985` 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 = 25465 AND t.round = 11 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* `tables1985` 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 = 25501 AND t.round = 11 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* `tables1980` 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 = 25612 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0128	SELECT t.,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM* `tables1980` 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 = 25595 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC

Botafogo PB

Botafogo PB

Selecciona un equipo

Competiciones que juega

Serie C - Brasil Grupo 1

RIVALES EN Copa do Nordeste

RIVALES EN Paraibano

RIVALES EN Serie C - Brasil