4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Operário PR

Operário PR

Entrenador: Rafael Guanaes

Temporada 2020/2021
TEMPORADA 2020/2021
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Botafogo Botafogo 38 56 31 70
2 Goiás EC Goiás EC 38 48 31 65
3 Coritiba Coritiba 38 49 35 64
4 Avaí Avaí 38 44 35 64
5 CSA CSA 38 48 33 62
6 Guaraní Guaraní 38 54 41 60
7 CRB CRB 38 47 39 60
8 Náutico Náutico 38 50 50 53
9 Vila Nova Vila Nova 38 35 36 51
10 Vasco da Gama Vasco Gama 38 43 52 49
11 Ponte Preta Ponte Preta 38 39 40 49
12 Operário PR Operário 38 35 46 48
13 Brusque Brusque 38 44 56 48
14 Cruzeiro Cruzeiro 38 42 44 48
15 Sampaio Correa Sampaio 38 41 42 47
16 Londrina Londrina 38 31 41 44
17 Remo Remo 38 31 42 43
18 Vitória Vitória 38 31 32 40
19 Confiança Confiança 38 35 48 37
20 Brasil de Pelotas Brasil 38 23 52 23
TEMPORADA 2019/2020
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Chapecoense Chapecoense 38 42 21 73
2 América Mineiro América 38 43 23 73
3 EC Juventude Juventude 38 52 42 61
4 Cuiabá Cuiabá 38 48 40 61
5 CSA CSA 38 50 37 58
6 Sampaio Correa Sampaio 38 50 38 57
7 Ponte Preta Ponte Preta 38 54 49 57
8 Operário PR Operário 38 40 34 57
9 Avaí Avaí 38 45 49 55
10 CRB CRB 38 48 47 52
11 Cruzeiro Cruzeiro 38 39 32 49
12 Brasil de Pelotas Brasil 38 31 33 49
13 Guaraní Guaraní 38 41 48 48
14 Vitória Vitória 38 45 45 48
15 Confiança Confiança 38 38 46 46
16 Náutico Náutico 38 35 42 44
17 Figueirense Figueirense 38 35 49 39
18 Paraná Paraná 38 34 50 37
19 Botafogo SP Botafogo SP 38 26 39 34
20 Oeste Oeste 38 28 60 29
TEMPORADA 2018/2019
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 RB Bragantino Bragantino 38 64 27 75
2 Sport Recife Sport Recife 38 49 29 68
3 Coritiba Coritiba 38 48 34 66
4 Atlético GO Atlético 38 44 29 62
5 América Mineiro América 38 42 34 61
6 Paraná Paraná 38 34 33 56
7 CRB CRB 38 44 43 55
8 Cuiabá Cuiabá 38 42 40 52
9 Botafogo SP Botafogo SP 38 38 38 50
10 Operário PR Operário 38 32 40 50
11 Ponte Preta Ponte Preta 38 41 39 47
12 Vitória Vitória 38 42 48 45
13 Guaraní Guaraní 38 27 37 44
14 Brasil de Pelotas Brasil 38 31 47 44
15 Oeste Oeste 38 41 49 41
16 Figueirense Figueirense 38 31 38 41
17 Londrina Londrina 38 37 53 39
18 São Bento São Bento 38 46 54 39
19 Criciúma Criciúma 38 30 38 39
20 Vila Nova Vila Nova 38 27 40 39
TEMPORADA 2017/2018
SERIE C - BRASIL GRUPO 2
Equipo PJ GF GC Puntos
1 Botafogo SP Botafogo SP 18 30 14 35
2 Operário PR Operário 18 25 17 35
3 Cuiabá Cuiabá 18 32 21 32
4 RB Bragantino Bragantino 18 21 16 29
5 Luverdense Luverdense 18 27 25 24
6 Tombense Tombense 18 17 17 22
7 Ypiranga FC Ypiranga FC 18 25 27 22
8 Volta Redonda Volta 18 18 25 20
9 Tupi Tupi 18 19 30 20
10 Joinville Joinville 18 13 35 14
TEMPORADA 2016/2017
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 Atlético Acreano Atlético 6 16 6 13
2 Princesa Solimões Princesa 6 9 4 12
3 Trem DC Trem DC 6 7 11 9
4 Real Ariquemes Real 6 3 14 1
5 Gurupi Gurupi 6 9 6 11
6 SAO Raimundo EC Raimundo 6 11 7 10
7 Fast Clube Fast Clube 6 6 7 7
8 Baré EC Baré EC 6 3 9 3
9 Rio Branco Acre Branco Acre 6 10 6 13
10 São Francisco PA São 6 7 6 9
11 São Raimundo RR São 6 7 9 5
12 Gênus Gênus 6 7 10 5
13 Santos AP Santos AP 6 11 6 13
14 Altos Altos 6 14 6 10
15 Cordino Cordino 6 5 9 7
16 Tocantis Miracema Tocantis 6 5 14 4
17 Guarany de Sobral Guarany 6 10 7 13
18 Maranhão Maranhão 6 9 4 10
19 Ríver Ríver 6 8 9 9
20 Potiguar Mossoró Potiguar 6 4 11 2
21 Globo Globo 6 7 3 12
22 Parnahyba Parnahyba 6 6 4 9
23 América PE América PE 6 3 5 7
24 Guarani de Juazeiro Guarani 6 3 7 7
25 SD Juazeirense Juazeirense 6 9 6 9
26 Sousa Sousa 6 6 4 9
27 Coruripe Coruripe 6 9 10 7
28 Central SC Central SC 6 7 11 7
29 Fluminense de Feira Fluminense 6 9 5 9
30 Campinense Campinense 6 6 5 8
31 Atlético PE Atlético 6 9 12 7
32 Itabaiana Itabaiana 6 8 10 5
33 América RN América RN 6 13 4 15
34 Jacobina Jacobina 6 9 9 9
35 Sergipe Sergipe 6 7 11 6
36 Murici Murici 6 7 12 6
37 Ceilândia Ceilândia 6 8 5 10
38 Comercial MS Comercial 6 10 9 10
39 Anápolis Anápolis 6 8 6 9
40 Sinop FC Sinop FC 6 5 11 3
41 União Rondonópolis União 6 8 6 11
42 Aparecidense Aparecidense 6 10 8 10
43 Luziânia Luziânia 6 11 5 10
44 7 de Setembro SM Setembro 6 3 13 1
45 Portuguesa RJ Portuguesa 6 9 2 14
46 URT URT 6 4 5 10
47 Itumbiara Itumbiara 6 5 6 8
48 Audax São Paulo Audax São P. 6 4 9 1
49 Villa Nova Villa Nova 6 6 6 9
50 Desportiva Ferroviária Desportiva 6 5 5 8
51 Bangu Bangu 6 7 8 8
52 Portuguesa Portuguesa 6 5 4 7
53 Boavista SC Boavista SC 6 10 7 11
54 Espirito Santo Espirito 6 6 4 9
55 RB Brasil RB Brasil 6 5 5 7
56 Caldense Caldense 6 6 11 6
57 Operário PR Operário 6 6 3 12
58 Brusque Brusque 6 8 5 10
59 XV de Piracicaba Piracicaba 6 7 8 9
60 São Paulo RS São Paulo 6 7 12 4
61 São Bernardo FC São 6 7 3 13
62 Internacional SC Internaciona 6 4 4 8
63 Foz do Iguaçu Iguaçu 6 4 6 6
64 Novo Hamburgo Novo 6 4 6 5
65 EC São José São José 6 13 4 12
66 Metropolitano Metropolitan 6 3 5 10
67 Ituano Ituano 6 4 4 8
68 PSTC PSTC 6 3 10 4
TEMPORADA 2014/2015
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 Remo Remo 8 14 6 17
2 Rio Branco Acre Branco Acre 8 10 6 15
3 Nacional AM Nacional AM 8 10 12 8
4 Vilhena Vilhena 8 8 14 6
5 Náutico RR Náutico RR 8 8 12 4
6 Ríver Ríver 8 8 3 16
7 Palmas FR Palmas FR 8 7 4 14
8 Santos AP Santos AP 8 8 11 10
9 Imperatriz Imperatriz 8 11 11 8
10 Guarani de Juazeiro Guarani 8 4 9 5
11 Campinense Campinense 8 10 5 14
12 Coruripe Coruripe 8 15 10 13
13 Serra Talhada Serra 8 7 9 8
14 Colo Colo BA Colo Colo 8 9 12 8
15 Globo Globo 8 5 10 8
16 Central SC Central SC 8 11 5 16
17 Treze Treze 8 11 5 15
18 Estanciano Estanciano 8 14 11 15
19 Goianésia Goianésia 8 3 10 5
20 Serrano SC Serrano SC 8 6 14 5
21 Rio Branco ES Branco 8 12 7 17
22 Caldense Caldense 8 8 4 14
23 Aparecidense Aparecidense 8 9 5 13
24 Comercial MS Comercial 8 6 10 7
25 Operário MT Operário 8 7 16 4
26 CRAC CRAC 8 7 1 18
27 Botafogo SP Botafogo SP 8 11 5 13
28 Gama Gama 8 9 6 13
29 Duque de Caxias Duque Caxias 8 10 11 7
30 Villa Nova Villa Nova 8 9 23 3
31 Ypiranga FC Ypiranga FC 8 7 3 16
32 Operário PR Operário 8 11 8 16
33 Resende Resende 8 9 10 9
34 RB Brasil RB Brasil 8 5 8 8
35 Internacional SC Internaciona 8 6 9 7
36 São Caetano São Caetano 8 22 5 19
37 Lajeadense Lajeadense 8 11 9 15
38 Volta Redonda Volta 8 10 14 9
39 Metropolitano Metropolitan 8 8 12 8
40 Foz do Iguaçu Iguaçu 8 10 21 5
TEMPORADA 2010/2011
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 Cuiabá Cuiabá 8 19 11 16
2 Peñarol AC Peñarol AC 8 9 8 14
3 Plácido de Castro Plácido 8 16 9 12
4 Nacional AM Nacional AM 8 9 14 7
5 Vila Aurora Vila Aurora 8 7 18 6
6 Independiente PA Independient 8 12 10 14
7 Sampaio Correa Sampaio 8 17 8 13
8 Trem DC Trem DC 8 8 11 11
9 SAO Raimundo EC Raimundo 8 9 8 10
10 Comercial PI Comercial 8 6 15 7
11 Santa Cruz RN Santa Cruz 8 9 6 16
12 Santa Cruz Santa Cruz 8 10 6 15
13 Guarani de Juazeiro Guarani 8 7 4 11
14 Alecrim Alecrim 8 7 12 9
15 CA Porto CA Porto 8 6 11 5
16 Coruripe Coruripe 8 13 11 16
17 Treze Treze 8 14 11 15
18 Bahia de Feira Bahia Feira 8 12 9 12
19 River Plate River Plate 8 10 12 8
20 Vitória da Conquista Vitória 8 6 12 7
21 Tupi Tupi 8 10 8 14
22 Anapolina Anapolina 8 15 11 13
23 Itumbiara Itumbiara 8 13 10 13
24 Gama Gama 8 8 9 9
25 Tocantinópolis Tocantinópo 8 10 18 7
26 Villa Nova Villa Nova 8 11 6 16
27 Volta Redonda Volta 8 11 3 15
28 Sendas EC Sendas EC 8 13 7 11
29 Formosa Formosa 8 5 12 9
30 São Mateus São Mateus 8 7 19 3
31 Oeste Oeste 8 12 8 14
32 Mirassol Mirassol 8 6 7 14
33 CENE CENE 8 15 13 13
34 Operário PR Operário 8 7 9 10
35 Ceramica AC Ceramica AC 8 6 9 5
36 EC Juventude Juventude 8 19 7 19
37 Cianorte Cianorte 8 9 9 14
38 Brusque Brusque 8 6 11 10
39 Metropolitano Metropolitan 8 14 16 9
40 Cruzeiro RS Cruzeiro RS 8 6 11 5
TEMPORADA 2009/2010
SERIE D - BRASIL GRUPO 3
Equipo PJ GF GC Puntos
1 Araguaína Araguaína 2 6 4 6
2 Madureira RJ Madureira 2 3 1 4
3 Guarany de Sobral Guarany 2 4 3 4
4 Joinville Joinville 2 1 0 4
5 Vila Aurora Vila Aurora 2 3 1 3
6 América FC América FC 2 1 3 3
7 Sampaio Correa Sampaio 2 3 4 1
8 Operário PR Operário 2 0 1 1
9 Uberaba SC Uberaba SC 2 1 3 1
10 Brasília Brasília 2 4 6 0
TEMPORADA 1978/1979
LIGA BRASILEÑA GRUPO 2
Equipo PJ GF GC Puntos
1 Adap Galo Maringá Adap Galo M. 9 15 5 21
2 Desportiva Ferroviária Desportiva 9 10 5 18
3 Caldense Caldense 9 10 9 15
4 Brasil de Pelotas Brasil 9 9 4 13
5 Criciúma Criciúma 9 9 8 13
6 Caxias Joinville FC Caxias 9 11 6 12
7 São Paulo RS São Paulo 8 9 9 11
8 Operário PR Operário 8 3 13 7
9 Colatina Colatina 9 2 9 6
10 Chapecoense Chapecoense 9 6 16 3

  USO DE MEMORIA  
7,192,480 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.6891
Total Execution Time  0.6903
  CADENA URL  
/historico/Operario-Pr/2021
  GET DATOS  
$_GET['/historico/Operario-Pr/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0167  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 = 'Operario-Pr' AND l.year = 2021 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.0128  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=17234 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=17234 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=17234 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=17234 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=17234 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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 = 61677
0.0130  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 = 60892
0.0132  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 = 62609
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17234 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 17234 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0128  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 (70779,71344,623655,643095,781050) ORDER BY n.cover_points DESC, update_date DESC
0.0136  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 = '17234' ORDER BY l.year DESC,cat.coefficient DESC
0.0138  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 = '17234' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0143  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 = '17234' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0126  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 = 62609 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0131  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 = 61677 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0128  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 = 61713 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=17234 AND l.year in (2020,2021,2022) 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 (66918,66515,66292,49506) 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.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 66292 AND teamId = 17234
0.0139  SELECT count(id) as num_players from rel_players WHERE league_id = 66515 AND teamId = 17234
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 66918 AND teamId = 17234
0.0203  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 17234
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 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 = 61713 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '17234' 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 = '17234' 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 = '17234' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0146  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 events2021 e ON e.player_id = p.id AND e.league_id = 61713 WHERE rp.league_id = 61713 AND rp.teamId = 17234 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.0149  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 events2021 e ON e.player_id = p.id AND e.league_id = 61713 WHERE rp.league_id = 61713 AND rp.teamId = 17234 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 events2021 e ON e.player_id = p.id AND e.league_id = 61713 WHERE rp.league_id = 61713 AND rp.teamId = 17234 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0131  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 = 17234 AND l.year <= 2021 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 `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 = 61713 AND t.round = 38 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 `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 = 55368 AND t.round = 38 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 `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 = 42705 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 38063 AND t.round = 6 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 `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.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 `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 = 13448 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 `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 = 13479 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 42945 AND t.round = 2 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 `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 = 42946 AND t.round = 2 ORDER BY team.conference 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 `tables1979` 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 = 25694 AND t.round = 9 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0135  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 = 61713 ORDER BY nameShow LIMIT 100