4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Botafogo PB

Botafogo PB

Entrenador: Felipe Surian

Temporada 2023/2024
TEMPORADA 2023/2024
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Athletic Club Athletic 1 4 0 3
2 Ypiranga FC Ypiranga FC 1 3 1 3
3 Aparecidense Aparecidense 1 2 0 3
4 Figueirense Figueirense 1 2 1 3
5 Botafogo PB Botafogo PB 1 2 1 3
6 Tombense Tombense 1 1 0 3
7 Volta Redonda Volta 1 2 1 3
8 Confiança Confiança 1 1 1 1
9 Ferroviária Ferroviária 1 1 1 1
10 ABC ABC 1 1 1 1
11 Londrina Londrina 1 1 1 1
12 Náutico Náutico 1 1 1 1
13 São Bernardo FC São 1 1 1 1
14 Remo Remo 1 1 2 0
15 Floresta EC Floresta EC 1 1 2 0
16 EC São José São José 1 0 1 0
17 CSA CSA 1 1 3 0
18 Sampaio Correa Sampaio 1 0 2 0
19 Caxias do Sul Caxias 1 0 4 0
20 Ferroviário Ferroviário 1 1 2 0
TEMPORADA 2022/2023
SERIE C - BRASIL GRUPO 2
Equipo PJ GF GC Puntos
1 Brusque Brusque 6 9 7 13
2 Operário PR Operário 6 9 9 7
3 São Bernardo FC São 6 6 6 7
4 EC São José São José 6 5 7 6
5 Amazonas FC Amazonas FC 6 9 4 12
6 Paysandu Paysandu 6 7 6 10
7 Volta Redonda Volta 6 6 7 10
8 Botafogo PB Botafogo PB 6 6 11 3
TEMPORADA 2021/2022
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Mirassol Mirassol 19 32 20 33
2 Paysandu Paysandu 19 31 17 33
3 Figueirense Figueirense 19 27 18 33
4 Volta Redonda Volta 19 29 22 32
5 Botafogo SP Botafogo SP 19 26 22 32
6 ABC ABC 19 22 16 31
7 Vitória Vitória 19 21 15 29
8 Aparecidense Aparecidense 19 23 18 29
9 Botafogo PB Botafogo PB 19 17 13 29
10 Ypiranga FC Ypiranga FC 19 25 20 28
11 EC São José São José 19 33 27 26
12 Remo Remo 19 25 22 26
13 Manaus Manaus 19 16 21 25
14 Confiança Confiança 19 12 17 23
15 Floresta EC Floresta EC 19 17 25 23
16 Altos Altos 19 21 31 21
17 Atlético Cearense Atlético 19 17 35 19
18 Brasil de Pelotas Brasil 19 19 29 17
19 Ferroviário Ferroviário 19 15 27 16
20 Campinense Campinense 19 15 28 16
TEMPORADA 2020/2021
SERIE C - BRASIL GRUPO 3
Equipo PJ GF GC Puntos
1 Ituano Ituano 6 11 5 13
2 Criciúma Criciúma 6 3 1 9
3 Botafogo PB Botafogo PB 6 3 4 8
4 Paysandu Paysandu 6 2 9 2
5 Tombense Tombense 6 8 6 11
6 Novorizontino Novorizontin 6 7 10 9
7 Manaus Manaus 6 10 8 6
8 Ypiranga FC Ypiranga FC 6 6 7 6
TEMPORADA 2019/2020
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Santa Cruz Santa Cruz 18 32 16 37
2 Remo Remo 18 20 10 31
3 Vila Nova Vila Nova 18 20 11 31
4 Paysandu Paysandu 18 25 14 29
5 Manaus Manaus 18 19 18 26
6 Jacuipense Jacuipense 18 19 21 24
7 Ferroviário Ferroviário 18 27 22 23
8 Botafogo PB Botafogo PB 18 19 17 20
9 Treze Treze 18 19 21 19
10 Imperatriz Imperatriz 18 10 60 1
TEMPORADA 2018/2019
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Náutico Náutico 18 24 18 33
2 Sampaio Correa Sampaio 18 22 19 31
3 Imperatriz Imperatriz 18 27 22 28
4 Confiança Confiança 18 22 22 26
5 Ferroviário Ferroviário 18 21 20 25
6 Botafogo PB Botafogo PB 18 26 22 25
7 Santa Cruz Santa Cruz 18 24 27 25
8 Treze Treze 18 22 27 19
9 ABC ABC 18 19 22 18
10 Globo Globo 18 19 27 16
TEMPORADA 2017/2018
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Náutico Náutico 18 26 22 31
2 Atlético Acreano Atlético 18 25 22 30
3 Santa Cruz Santa Cruz 18 22 13 28
4 Botafogo PB Botafogo PB 18 22 17 26
5 Confiança Confiança 18 24 25 23
6 Remo Remo 18 18 20 22
7 Globo Globo 18 19 19 22
8 ABC ABC 18 18 24 21
9 SD Juazeirense Juazeirense 18 16 20 19
10 Salgueiro Salgueiro 18 11 19 17
TEMPORADA 2016/2017
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Sampaio Correa Sampaio 18 24 20 32
2 CSA CSA 18 21 12 32
3 Fortaleza EC Fortaleza 18 20 15 27
4 Confiança Confiança 18 23 25 25
5 Salgueiro Salgueiro 18 19 16 24
6 Cuiabá Cuiabá 18 17 17 23
7 Remo Remo 18 19 21 22
8 Botafogo PB Botafogo PB 18 18 21 21
9 Moto Club MA Moto Club 18 18 20 20
10 ASA Arapiraquense Arapiraquens 18 11 23 13
TEMPORADA 2015/2016
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 26 17 30
2 ABC ABC 18 24 15 30
3 Botafogo PB Botafogo PB 18 19 13 28
4 ASA Arapiraquense Arapiraquens 18 16 15 26
5 Remo Remo 18 21 20 25
6 Confiança Confiança 18 22 26 22
7 Cuiabá Cuiabá 18 19 17 22
8 Salgueiro Salgueiro 18 13 18 21
9 América RN América RN 18 17 23 20
10 Ríver Ríver 18 13 26 13
TEMPORADA 2014/2015
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 30 14 36
2 ASA Arapiraquense Arapiraquens 18 24 17 35
3 Vila Nova Vila Nova 18 24 13 33
4 Confiança Confiança 18 25 16 31
5 América RN América RN 18 23 17 29
6 Botafogo PB Botafogo PB 18 25 30 23
7 Salgueiro Salgueiro 18 17 20 19
8 Cuiabá Cuiabá 18 20 25 19
9 Aguia de Maraba Aguia Maraba 18 19 28 15
10 Icasa Icasa 18 15 42 7
TEMPORADA 2013/2014
SERIE C - BRASIL
Equipo PJ GF GC Puntos
1 Fortaleza EC Fortaleza 18 23 11 35
2 CRB CRB 18 23 17 27
3 Salgueiro Salgueiro 18 20 22 27
4 Paysandu Paysandu 18 21 17 26
5 ASA Arapiraquense Arapiraquens 18 23 22 25
6 Botafogo PB Botafogo PB 18 20 19 25
7 Cuiabá Cuiabá 18 19 19 23
8 Aguia de Maraba Aguia Maraba 18 21 25 20
9 Treze Treze 18 19 25 19
10 CRAC CRAC 18 14 26 10
11 Tupi Tupi 18 30 13 34
12 Mogi Mirim Mogi Mirim 18 22 24 31
13 Madureira RJ Madureira 18 20 17 26
14 Macaé Esporte Macaé 18 15 17 26
15 Guaratinguetá Guaratinguet 18 32 18 25
16 EC Juventude Juventude 18 16 14 25
17 Guaraní Guaraní 18 14 15 24
18 Caxias do Sul Caxias 18 17 20 22
19 São Caetano São Caetano 18 13 19 21
20 Duque de Caxias Duque Caxias 18 10 32 7
TEMPORADA 2012/2013
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 Nacional AM Nacional AM 8 21 14 15
2 Plácido de Castro Plácido 8 9 12 13
3 Paragominas Paragominas 8 15 7 11
4 Náutico RR Náutico RR 8 11 16 7
5 Gênus Gênus 8 11 18 5
6 Tiradentes CE Tiradentes 8 13 2 19
7 Salgueiro Salgueiro 8 16 7 15
8 Gurupi Gurupi 8 12 16 15
9 Parnahyba Parnahyba 8 9 10 11
10 Maranhão Maranhão 8 13 10 9
11 Central SC Central SC 8 8 4 13
12 Guarany de Sobral Guarany 8 8 8 12
13 Ypiranga PE Ypiranga PE 8 9 11 10
14 Ypiranga AP Ypiranga AP 8 6 13 5
15 Potiguar Mossoró Potiguar 8 3 16 2
16 Botafogo PB Botafogo PB 8 14 7 17
17 Sergipe Sergipe 8 16 7 16
18 Vitória da Conquista Vitória 8 6 7 11
19 SD Juazeirense Juazeirense 8 8 16 8
20 CSA CSA 8 6 13 4
21 Mixto Mixto 8 7 4 16
22 Aparecidense Aparecidense 8 11 4 15
23 Goianésia Goianésia 8 10 10 10
24 Águia Negra Águia Negra 8 8 12 9
25 Brasília Brasília 8 8 14 5
26 Tupi Tupi 8 17 8 21
27 Resende Resende 8 11 6 14
28 Santo André Santo André 8 11 8 14
29 Marcílio Dias Marcílio 8 10 9 11
30 Penapolense Penapolense 8 8 9 9
31 Metropolitano Metropolitan 8 11 8 13
32 Nova Iguaçu Nova Iguaçu 8 8 9 9
33 Villa Nova Villa Nova 8 6 11 8
34 Aracruz Aracruz 8 8 14 6
35 Araxá Araxá 8 5 12 5
36 EC Juventude Juventude 8 9 7 15
37 Londrina Londrina 8 9 9 13
38 J. Malucelli Malucelli 8 14 13 10
39 Botafogo SP Botafogo SP 8 8 7 9
40 Lajeadense Lajeadense 8 8 13 9
TEMPORADA 2005/2006
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Tuna Luso Tuna Luso 4 9 4 10
2 Rio Negro AM Negro 4 7 8 4
3 ADESG ADESG 4 3 7 3
4 Fast Clube Fast Clube 6 7 3 13
5 Ananindeua Ananindeua 6 12 8 10
6 Amapá Clube Amapá Clube 6 7 11 5
7 São Raimundo RR São 6 5 9 5
8 Operário MT Operário 6 8 6 9
9 Mixto Mixto 6 6 6 9
10 Araguaína Araguaína 6 6 8 7
11 SC Ulbra SC Ulbra 6 7 7 0
12 Ríver Ríver 6 12 4 13
13 Maranhão Maranhão 6 8 6 10
14 Imperatriz Imperatriz 6 6 4 8
15 Flamengo PI Flamengo PI 6 3 15 2
16 Icasa Icasa 6 13 7 12
17 CA Porto CA Porto 6 10 8 11
18 Baraunas Baraunas 6 8 12 5
19 Botafogo PB Botafogo PB 6 8 12 4
20 Ferroviário Ferroviário 6 9 9 10
21 Treze Treze 6 7 5 9
22 Potiguar Mossoró Potiguar 6 6 3 8
23 Ypiranga PE Ypiranga PE 6 6 11 0
24 Bahía Bahía 6 12 7 13
25 Confiança Confiança 6 8 7 9
26 CSA CSA 6 8 10 5
27 Colo Colo BA Colo Colo 6 8 12 5
28 Vitória Vitória 6 10 5 11
29 Coruripe Coruripe 6 9 7 11
30 Olímpico Pirambú Olímpico 6 7 8 7
31 Ipitanga Ipitanga 6 5 11 4
32 Jataiense Jataiense 6 12 6 12
33 Anapolina Anapolina 6 13 6 10
34 Luziânia Luziânia 6 5 15 4
35 Coxim Coxim 6 4 7 0
36 Boa EC Boa EC 6 8 2 13
37 Atlético GO Atlético 6 6 6 8
38 Chapadão Chapadão 6 3 5 7
39 Ceilândia Ceilândia 6 5 9 0
40 América Mineiro América 6 10 4 15
41 Grêmio Barueri Grêmio 6 7 4 13
42 Vitória ES Vitória ES 6 5 9 4
43 América RJ América RJ 6 4 9 2
44 Americano Americano 6 9 5 14
45 Ipatinga FC Ipatinga FC 6 6 4 10
46 CA Juventus CA Juventus 6 7 9 4
47 Estrela do Norte Estrela 6 5 9 0
48 Cabofriense Cabofriense 6 10 6 11
49 Rio Branco SP Branco 6 13 8 10
50 Madureira RJ Madureira 6 8 7 7
51 União Barbarense União 6 5 15 6
52 J. Malucelli Malucelli 6 8 4 10
53 Noroeste Noroeste 6 5 4 9
54 Campo Mourão Campo 6 4 5 7
55 América SP América SP 6 3 7 5
56 Joinville Joinville 6 8 4 11
57 Canoas SC Canoas SC 6 7 5 10
58 Caxias do Sul Caxias 6 8 7 7
59 Rio Branco PR Branco 6 3 10 4
60 Brasil de Pelotas Brasil 6 10 8 15
61 Criciúma Criciúma 6 20 9 13
62 Novo Hamburgo Novo 6 7 14 7
63 Marcílio Dias Marcílio 6 7 13 0
TEMPORADA 1985/1986
LIGA BRASILEÑA GRUPO 2
Equipo PJ GF GC Puntos
1 Flamengo Flamengo 10 15 7 14
2 Corinthians Corinthians 10 16 6 13
3 Ponte Preta Ponte Preta 10 18 11 13
4 Athletico Paranaense Athletico 10 12 5 12
5 Grêmio Grêmio 10 15 11 11
6 América RJ América RJ 10 10 11 10
7 Goiás EC Goiás EC 10 8 9 10
8 Joinville Joinville 10 14 17 9
9 Sergipe Sergipe 10 5 16 8
10 Botafogo PB Botafogo PB 10 9 16 7
11 Paysandu Paysandu 10 5 18 3
TEMPORADA 1984/1985
LIGA BRASILEÑA GRUPO 5
Equipo PJ GF GC Puntos
1 Sport Recife Sport Recife 11 23 7 28
2 Ceará Ceará 11 20 9 27
3 Nacional AM Nacional AM 11 24 11 21
4 CSA CSA 11 16 8 18
5 Paysandu Paysandu 11 15 13 18
6 Mixto Mixto 11 11 12 18
7 Botafogo PB Botafogo PB 11 12 16 13
8 Remo Remo 11 9 20 12
9 ABC ABC 11 17 18 11
10 Flamengo PI Flamengo PI 11 7 14 8
11 Sergipe Sergipe 11 9 20 6
12 Sampaio Correa Sampaio 11 12 27 5
TEMPORADA 1979/1980
LIGA BRASILEÑA GRUPO 8
Equipo PJ GF GC Puntos
1 Cruzeiro Cruzeiro 6 10 2 14
2 Fluminense Fluminense 6 9 6 9
3 Sport Recife Sport Recife 6 5 8 5
4 Botafogo PB Botafogo PB 6 4 12 3

  USO DE MEMORIA  
7,512,848 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.2029
Total Execution Time  0.2043
  CADENA URL  
/historico/Botafogo-Pb
  GET DATOS  
$_GET['/historico/Botafogo-Pb']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0056  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 = 'Botafogo-Pb' 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.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=17670 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=17670 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=17670 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=17670 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=17670 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=17670 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=17670 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=17670 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17670 AND type_rel = 2
0.0023  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.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 (67026,105429,175528,783891,792947) ORDER BY n.cover_points DESC, update_date DESC
0.0213  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' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0039  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.0022  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 = 75206 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 74870 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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.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 (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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74996 AND teamId = 17670
0.0030  SELECT count(id) as num_players from rel_players WHERE league_id = 71069 AND teamId = 17670
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75735 AND teamId = 17670
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 75677 AND teamId = 17670
0.0036  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 17670
0.0020  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.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '17670' and rp.type = 4
0.0020  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.0036  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.0031  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.0019  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.0037  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.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 `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.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 `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.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 `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.0020  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.0020  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.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 `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.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 `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.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 `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.0029  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.0027  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.0037  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.0029  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.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 `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.0037  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.0027  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.0032  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.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 `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
0.0025  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