4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Serra FC
TEMPORADA 2023/2024
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 Manauara Manauara 1 3 1 3
2 Princesa Solimões Princesa 1 2 0 3
3 Manaus Manaus 1 0 0 1
4 Trem DC Trem DC 1 0 0 1
5 Humaitá Humaitá 0 0 0 0
6 Porto Velho Porto Velho 0 0 0 0
7 Rio Branco Acre Branco Acre 1 1 3 0
8 São Raimundo RR São 1 0 2 0
9 Maranhão Maranhão 1 2 1 3
10 Ríver Ríver 1 2 1 3
11 Altos Altos 1 1 0 3
12 Moto Club MA Moto Club 1 2 2 1
13 Tocantinópolis Tocantinópo 1 2 2 1
14 Aguia de Maraba Aguia Maraba 1 1 2 0
15 Fluminense PI Fluminense 1 1 2 0
16 Cametá Cametá 1 0 1 0
17 Treze Treze 1 4 3 3
18 Potiguar Mossoró Potiguar 1 2 1 3
19 América RN América RN 1 1 1 1
20 Maracanã Maracanã 1 1 1 1
21 Iguatu Iguatu 1 0 0 1
22 Sousa Sousa 1 0 0 1
23 Santa Cruz RN Santa Cruz 1 3 4 0
24 Atlético Cearense Atlético 1 1 2 0
25 ASA Arapiraquense Arapiraquens 1 3 2 3
26 Itabaiana Itabaiana 1 1 1 1
27 SD Juazeirense Juazeirense 1 1 1 1
28 CSE CSE 1 0 0 1
29 Jacuipense Jacuipense 1 0 0 1
30 Petrolina Petrolina 1 0 0 1
31 Retro FC Retro FC 1 0 0 1
32 Sergipe Sergipe 1 2 3 0
33 Capital Capital 1 2 0 3
34 Brasiliense Brasiliense 1 1 0 3
35 Iporá Iporá 1 2 2 1
36 União Rondonópolis União 1 2 2 1
37 CRAC CRAC 1 1 1 1
38 Mixto Mixto 1 1 1 1
39 Anápolis Anápolis 1 0 1 0
40 Real Brasília Real 1 0 2 0
41 Serra FC Serra FC 1 1 0 3
42 Democrata SL Democrata 1 1 1 1
43 Nova Iguaçu Nova Iguaçu 1 1 1 1
44 Ipatinga FC Ipatinga FC 1 0 0 1
45 Itabuna Itabuna 1 0 0 1
46 Portuguesa RJ Portuguesa 1 0 0 1
47 Real Noroeste Real 1 0 0 1
48 Audax Rio Audax Rio 1 0 1 0
49 Água Santa Água Santa 1 2 0 3
50 Maringá Maringá 1 2 1 3
51 Inter de Limeira Inter 1 1 0 3
52 Costa Rica Costa Rica 1 0 0 1
53 São José São José 1 0 0 1
54 Santo André Santo André 1 1 2 0
55 Pouso Alegre Pouso Alegre 1 0 1 0
56 Patrocinense Patrocinense 1 0 2 0
57 Concórdia Concórdia 1 2 0 3
58 Cascavel FC Cascavel FC 1 2 1 3
59 Barra FC Barra FC 1 1 1 1
60 Novo Hamburgo Novo 1 1 1 1
61 Cianorte Cianorte 1 0 0 1
62 Hercílio Luz Hercílio 1 0 0 1
63 EC Avenida EC Avenida 1 1 2 0
64 Brasil de Pelotas Brasil 1 0 2 0
TEMPORADA 2018/2019
SERIE D - BRASIL
Equipo PJ GF GC Puntos
1 São Raimundo RR São 6 15 6 12
2 Fast Clube Fast Clube 6 9 5 9
3 Barcelona RO Barcelona 6 7 10 8
4 Rio Branco Acre Branco Acre 6 6 16 4
5 Manaus Manaus 6 16 7 14
6 Real Ariquemes Real 6 9 9 11
7 Galvez EC Galvez EC 6 10 12 6
8 Santos AP Santos AP 6 3 10 1
9 Moto Club MA Moto Club 6 16 4 14
10 SAO Raimundo EC Raimundo 6 12 7 13
11 Ypiranga AP Ypiranga AP 6 8 13 5
12 Atlético Roraima Atlético 6 3 15 1
13 Floresta EC Floresta EC 6 11 7 9
14 Ríver Ríver 6 10 7 9
15 Bragantino PA Bragantino 6 8 7 9
16 Santa Cruz RN Santa Cruz 6 6 14 5
17 Atlético Cearense Atlético 6 12 6 15
18 Central SC Central SC 6 10 7 9
19 Altos Altos 6 7 10 9
20 Maranhão Maranhão 6 10 16 3
21 América RN América RN 6 20 1 14
22 Bahia de Feira Bahia Feira 6 12 5 10
23 América PE América PE 6 8 8 10
24 Serrano PB Serrano PB 6 2 28 0
25 Jacuipense Jacuipense 6 11 2 15
26 ASA Arapiraquense Arapiraquens 6 8 5 13
27 Campinense Campinense 6 6 5 7
28 Vitória das Tabocas Vitória 6 3 16 0
29 Fluminense de Feira Fluminense 6 8 4 12
30 Salgueiro Salgueiro 6 8 6 10
31 Sergipe Sergipe 6 11 10 5
32 Coruripe Coruripe 6 2 9 4
33 Itabaiana Itabaiana 6 9 5 13
34 SD Juazeirense Juazeirense 6 8 4 11
35 Aparecidense Aparecidense 6 8 5 9
36 Interporto Interporto 6 2 13 1
37 Iporá Iporá 6 7 5 10
38 Sinop FC Sinop FC 6 7 8 9
39 Corumbaense Corumbaense 6 9 9 7
40 Palmas FR Palmas FR 6 5 6 6
41 Patrocinense Patrocinense 6 9 7 10
42 União Rondonópolis União 6 10 9 10
43 Anapolina Anapolina 6 6 6 8
44 Operário MS Operário 6 6 9 5
45 Caldense Caldense 6 7 1 16
46 Vitória ES Vitória ES 6 7 4 11
47 Portuguesa RJ Portuguesa 6 5 6 7
48 Sobradinho Sobradinho 6 1 9 0
49 Brasiliense Brasiliense 6 5 2 12
50 Ituano Ituano 6 11 3 11
51 URT URT 6 2 3 6
52 Serra FC Serra FC 6 1 11 2
53 Novorizontino Novorizontin 6 13 3 14
54 Hercílio Luz Hercílio 6 5 6 9
55 Itaborai Itaborai 6 6 10 5
56 Tupi Tupi 6 5 10 5
57 Brusque Brusque 6 15 6 15
58 Boavista SC Boavista SC 6 9 5 15
59 Gaúcho Gaúcho 6 5 8 3
60 Foz do Iguaçu Iguaçu 6 3 13 3
61 Cianorte Cianorte 6 5 3 13
62 Caxias do Sul Caxias 6 8 4 11
63 São Caetano São Caetano 6 7 7 5
64 CA Tubarão CA Tubarão 6 7 13 4
65 EC Avenida EC Avenida 6 6 5 10
66 Ferroviária Ferroviária 6 4 3 9
67 Maringá Maringá 6 4 5 8
68 Joinville Joinville 6 3 4 7
TEMPORADA 2007/2008
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Rio Branco Acre Branco Acre 4 13 7 9
2 Luverdense Luverdense 4 11 8 9
3 Fast Clube Fast Clube 4 2 11 0
4 Holanda EC Holanda EC 6 11 8 12
5 Remo Remo 6 12 5 11
6 Cristal CA Cristal CA 6 5 5 8
7 Progresso Progresso 6 3 13 3
8 Aguia de Maraba Aguia Maraba 6 13 10 10
9 Paysandu Paysandu 6 7 5 9
10 Bacabal Bacabal 6 8 7 8
11 Palmas FR Palmas FR 6 6 12 6
12 Sampaio Correa Sampaio 6 8 2 12
13 Picos SE Picos SE 6 3 1 10
14 Barras Barras 6 2 6 5
15 Horizonte Horizonte 6 5 9 4
16 Campinense Campinense 6 11 6 11
17 Santa Cruz Santa Cruz 6 7 6 8
18 Potiguar Mossoró Potiguar 6 9 10 7
19 Central SC Central SC 6 1 6 6
20 Salgueiro Salgueiro 6 10 5 12
21 Icasa Icasa 6 7 4 11
22 Santa Cruz RN Santa Cruz 6 5 8 7
23 Treze Treze 6 3 8 2
24 ASA Arapiraquense Arapiraquens 6 14 6 13
25 Confiança Confiança 6 12 10 12
26 Atlético Alagoinhas Atlético 6 6 8 7
27 Petrolina Petrolina 6 6 14 3
28 Vitória da Conquista Vitória 6 12 7 13
29 Sergipe Sergipe 6 9 9 10
30 Itabuna Itabuna 6 8 7 9
31 CSA CSA 6 4 10 3
32 Atlético GO Atlético 6 15 5 14
33 Mixto Mixto 6 11 8 9
34 Operário MS Operário 6 3 5 7
35 Águia Negra Águia Negra 6 4 15 1
36 Real Brasília Real 6 8 8 9
37 Itumbiara Itumbiara 6 6 4 8
38 Anápolis Anápolis 6 7 11 8
39 Legião Legião 6 12 10 7
40 América Mineiro América 6 7 3 11
41 Duque de Caxias Duque Caxias 6 8 8 8
42 Paulista Paulista 6 6 6 8
43 Serra FC Serra FC 6 7 11 6
44 Guaratinguetá Guaratinguet 6 7 3 13
45 Boavista SC Boavista SC 6 13 4 10
46 Macaé Esporte Macaé 6 6 4 9
47 Linhares Linhares 6 3 18 1
48 Boa EC Boa EC 6 11 4 14
49 Noroeste Noroeste 6 9 9 8
50 Tupi Tupi 6 6 9 7
51 Mirassol Mirassol 6 7 11 4
52 Ituano Ituano 6 10 8 10
53 Guaraní Guaraní 6 5 4 10
54 Madureira RJ Madureira 6 8 9 7
55 Linense CA Linense CA 6 5 7 7
56 Toledo EC Toledo EC 6 8 6 9
57 Marcílio Dias Marcílio 6 6 4 9
58 Inter Santa Maria Inter Santa 6 7 5 8
59 Engenheiro Beltrão Engenheiro 6 3 9 6
60 Brasil de Pelotas Brasil 6 4 4 11
61 Caxias do Sul Caxias 6 8 4 8
62 J. Malucelli Malucelli 6 4 4 7
63 Metropolitano Metropolitan 6 4 8 4
TEMPORADA 2004/2005
SERIE C - BRASIL GRUPO 1
Equipo PJ GF GC Puntos
1 Nacional AM Nacional AM 4 8 4 10
2 Independência Independênc 4 4 7 4
3 Grêmio Coariense Grêmio 4 7 8 3
4 Vila Aurora Vila Aurora 6 12 7 12
5 São Raimundo AM São 6 12 8 8
6 Luverdense Luverdense 6 12 9 7
7 Ji-Paraná Ji-Paraná 6 2 14 5
8 Remo Remo 6 14 7 14
9 Abaeté Abaeté 6 9 7 10
10 São José AP São José 6 7 10 5
11 São Raimundo RR São 6 7 13 4
12 Moto Club MA Moto Club 6 8 5 11
13 Tocantinópolis Tocantinópo 6 10 7 10
14 Imperatriz Imperatriz 6 6 7 8
15 Parnahyba Parnahyba 6 9 14 4
16 Ferroviário Ferroviário 6 17 10 15
17 Icasa Icasa 6 9 8 9
18 Serrano PE Serrano PE 6 8 11 7
19 Piauí Piauí 6 1 6 4
20 Coruripe Coruripe 6 14 9 15
21 Nacional de Cabedelo Nacional 6 13 9 12
22 América RN América RN 6 9 5 9
23 Vitória das Tabocas Vitória 6 3 16 0
24 Treze Treze 6 14 10 13
25 ABC ABC 6 6 6 8
26 ASA Arapiraquense Arapiraquens 6 5 7 7
27 Baraunas Baraunas 6 8 10 5
28 Sergipe Sergipe 6 12 5 13
29 Itabaiana Itabaiana 6 7 6 10
30 Ipitanga Ipitanga 6 9 9 8
31 Juazeiro BA Juazeiro BA 6 5 13 3
32 Ipatinga FC Ipatinga FC 6 13 7 10
33 Serra FC Serra FC 6 11 10 10
34 Americano Americano 6 7 11 8
35 Estrela do Norte Estrela 6 6 9 5
36 Atlético Sorocaba Atlético 6 11 7 9
37 Mogi Mirim Mogi Mirim 6 9 6 9
38 Madureira RJ Madureira 6 6 8 8
39 Portuguesa Santista Portuguesa 6 5 10 6
40 Londrina Londrina 6 11 6 11
41 CENE CENE 6 10 8 11
42 Cianorte Cianorte 6 6 6 8
43 Operário MS Operário 6 5 12 2
44 Ceilândia Ceilândia 6 11 7 10
45 Mineiros Mineiros 6 5 4 9
46 Paranoá Paranoá 6 7 8 9
47 Gremio Inhumense Gremio 6 8 12 5
48 Rio Branco SP Branco 6 10 9 9
49 Boa EC Boa EC 6 9 11 8
50 União São João União São 6 14 13 7
51 América SP América SP 6 12 12 7
52 Villa Nova Villa Nova 6 6 4 9
53 Volta Redonda Volta 6 4 3 9
54 Cabofriense Cabofriense 6 4 5 6
55 América Mineiro América 6 5 7 6
56 Novo Hamburgo Novo 6 8 4 11
57 Joinville Joinville 6 9 6 10
58 Campo Mourão Campo 6 5 8 9
59 Iraty Iraty 6 5 9 4
60 GE Glória GE Glória 6 8 5 13
61 Gaúcho Gaúcho 6 5 5 9
62 Hermann Aichinger Hermann 6 5 4 8
63 Marcílio Dias Marcílio 6 1 5 4
TEMPORADA 2000/2001
SERIE B - BRASIL
Equipo PJ GF GC Puntos
1 Paysandu Paysandu 26 44 26 47
2 Caxias do Sul Caxias 26 44 35 46
3 Ceará Ceará 26 50 36 41
4 Náutico Náutico 26 43 34 41
5 CRB CRB 26 35 36 41
6 Fortaleza EC Fortaleza 26 40 27 40
7 América RN América RN 26 32 30 38
8 SAO Raimundo EC Raimundo 26 36 37 38
9 Anapolina Anapolina 26 45 47 34
10 Sergipe Sergipe 26 38 41 32
11 Remo Remo 26 33 39 32
12 Sampaio Correa Sampaio 26 32 40 32
13 Tuna Luso Tuna Luso 26 36 45 30
14 ABC ABC 26 32 40 29
15 Nacional AM Nacional AM 26 30 48 25
16 Figueirense Figueirense 26 50 38 42
17 Avaí Avaí 26 36 31 42
18 União São João União São 26 45 31 41
19 Joinville Joinville 26 39 26 41
20 XV de Piracicaba Piracicaba 26 39 45 38
21 Londrina Londrina 26 45 36 37
22 Vila Nova Vila Nova 26 43 44 37
23 América RJ América RJ 26 32 36 37
24 RB Bragantino Bragantino 26 40 43 35
25 J. Malucelli Malucelli 26 32 37 32
26 Criciúma Criciúma 26 35 40 30
27 Ferroviário Ferroviário 26 26 48 29
28 Serra FC Serra FC 26 33 49 24

  USO DE MEMORIA  
7,499,496 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.4238
Total Execution Time  0.4257
  CADENA URL  
/historico/Serra-Fc
  GET DATOS  
$_GET['/historico/Serra-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0116  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 = 'Serra-Fc' 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.0105  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=63552 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=63552 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0105  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=63552 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0217  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 = 74835
0.0106  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=63552 AND type_rel = 2
0.0106  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 63552 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0109  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 (688400) ORDER BY n.cover_points DESC, update_date DESC
0.0115  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 = '63552' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0115  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 = '63552' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0106  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 = 74835 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0110  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=63552 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0107  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,74835,72949) 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.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 75630 AND teamId = 63552
0.0110  SELECT count(id) as num_players from rel_players WHERE league_id = 74835 AND teamId = 63552
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 72949 AND teamId = 63552
0.0116  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 = '63552' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0105  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '63552' and rp.type = 4
0.0106  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 = '63552' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0110  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 = 63552 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.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 = 75630 WHERE rp.league_id = 75630 AND rp.teamId = 63552 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0124  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 = 63552 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 = 63552 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 1 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0162  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 = 49171 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0169  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.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 `tables2001` 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 = 23357 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC