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

Barranquilla

Entrenador: Nelson Flórez

Temporada 2020/2021
TEMPORADA 2020/2021
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Leones Leones 14 25 12 29
2 Bogotá Bogotá 14 18 9 28
3 Boyacá Chicó Boyacá 14 15 6 28
4 Fortaleza Fortaleza 14 24 10 26
5 Unión Magdalena Unión 14 24 17 25
6 Internacional de Palmira Internaciona 14 19 13 25
7 Llaneros Llaneros 14 20 15 23
8 Real Cartagena Real 14 17 14 20
9 Atlético Fútbol Club Atlético 14 17 20 19
10 Barranquilla Barranquilla 14 13 19 15
11 Orsomarso SC Orsomarso 14 14 22 15
12 Real Santander Real 14 15 24 10
13 Real Cundinamarca Real 14 13 23 8
14 Boca Juniors de Cali Boca Juniors 14 8 25 7
15 Tigres FC Tigres FC 14 6 19 6
TEMPORADA 2019/2020
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Fortaleza Fortaleza 0 0 0 0
2 Atlético Huila Atlético 0 0 0 0
3 Internacional de Palmira Internaciona 0 0 0 0
4 Atlético Fútbol Club Atlético 0 0 0 0
5 Barranquilla Barranquilla 0 0 0 0
6 Real Cundinamarca Real 0 0 0 0
7 Llaneros Llaneros 0 0 0 0
8 Tigres FC Tigres FC 0 0 0 0
9 Unión Magdalena Unión 0 0 0 0
10 Deportes Quindío Deportes 0 0 0 0
11 Orsomarso SC Orsomarso 0 0 0 0
12 Boca Juniors de Cali Boca Juniors 0 0 0 0
13 Real Cartagena Real 0 0 0 0
14 Real Santander Real 0 0 0 0
15 Bogotá Bogotá 0 0 0 0
16 Leones Leones 0 0 0 0
TEMPORADA 2018/2019
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Deportes Quindío Deportes 15 21 12 29
2 Boyacá Chicó Boyacá 15 25 19 27
3 Bogotá Bogotá 15 19 14 26
4 Internacional de Palmira Internaciona 15 24 19 25
5 Deportivo Pereira Deportivo 15 13 9 25
6 Real Cartagena Real 15 20 19 24
7 Fortaleza Fortaleza 15 18 15 22
8 Tigres FC Tigres FC 15 17 14 21
9 Leones Leones 15 19 17 21
10 Real Santander Real 15 16 17 20
11 Llaneros Llaneros 15 12 15 19
12 Real Cundinamarca Real 15 14 19 19
13 Atlético Fútbol Club Atlético 15 15 13 18
14 Boca Juniors de Cali Boca Juniors 15 15 25 11
15 Barranquilla Barranquilla 15 10 21 11
16 Orsomarso SC Orsomarso 15 13 23 8
TEMPORADA 2017/2018
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Cúcuta Deportivo Cúcuta 30 52 17 71
2 Unión Magdalena Unión 30 53 22 60
3 Deportivo Pereira Deportivo 30 43 31 53
4 Real Cartagena Real 30 40 34 47
5 Internacional de Palmira Internaciona 30 40 41 44
6 Deportes Quindío Deportes 30 29 33 43
7 Real Cundinamarca Real 30 40 38 41
8 Llaneros Llaneros 30 33 33 39
9 Fortaleza Fortaleza 30 39 38 38
10 Barranquilla Barranquilla 30 36 45 35
11 Tigres FC Tigres FC 30 30 35 34
12 Universitario Popayán Universitari 30 36 46 33
13 Bogotá Bogotá 30 30 49 31
14 Atlético Fútbol Club Atlético 30 29 42 29
15 Orsomarso SC Orsomarso 30 20 31 28
16 Real Santander Real 30 27 42 18
TEMPORADA 2016/2017
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Barranquilla Barranquilla 16 21 10 33
2 Deportivo Pereira Deportivo 16 23 13 30
3 Deportes Quindío Deportes 16 28 19 30
4 Leones Leones 16 20 15 30
5 Cúcuta Deportivo Cúcuta 16 30 20 27
6 Llaneros Llaneros 16 26 23 25
7 Real Cartagena Real 16 20 20 24
8 Orsomarso SC Orsomarso 16 16 14 23
9 Boyacá Chicó Boyacá 16 16 15 23
10 Unión Magdalena Unión 16 20 22 20
11 Atlético Fútbol Club Atlético 16 13 25 18
12 Bogotá Bogotá 16 10 19 14
13 Real Cundinamarca Real 16 14 28 14
14 Real Santander Real 16 21 25 14
15 Fortaleza Fortaleza 16 14 19 12
16 Universitario Popayán Universitari 16 13 18 12
TEMPORADA 2015/2016
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Deportivo Pereira Deportivo 32 58 28 70
2 América de Cali América 32 48 24 60
3 Real Cartagena Real 32 47 36 57
4 Leones Leones 32 43 31 49
5 Universitario Popayán Universitari 32 37 35 49
6 Tigres FC Tigres FC 32 26 24 48
7 Deportes Quindío Deportes 32 36 33 44
8 Bogotá Bogotá 32 37 39 44
9 Real Cundinamarca Real 32 34 37 44
10 Cúcuta Deportivo Cúcuta 32 35 31 42
11 Orsomarso SC Orsomarso 32 35 48 40
12 Barranquilla Barranquilla 32 31 37 35
13 Unión Magdalena Unión 32 30 39 35
14 Real Santander Real 32 33 51 33
15 Llaneros Llaneros 32 31 42 31
16 Atlético Fútbol Club Atlético 32 19 45 25
TEMPORADA 2014/2015
PRIMERA B COLOMBIA GRUPO 1
Equipo PJ GF GC Puntos
1 Atlético Bucaramanga Atlético 32 55 17 71
2 Deportivo Pereira Deportivo 32 54 36 60
3 América de Cali América 32 61 37 56
4 Fortaleza Fortaleza 32 41 35 51
5 Real Cartagena Real 32 46 43 50
6 Leones Leones 32 33 36 50
7 Unión Magdalena Unión 32 37 28 48
8 Universitario Popayán Universitari 32 36 30 47
9 Deportes Quindío Deportes 32 43 36 45
10 Real Cundinamarca Real 32 38 45 38
11 Bogotá Bogotá 32 30 44 34
12 Tigres FC Tigres FC 32 38 56 33
13 Real Santander Real 32 36 52 32
14 Barranquilla Barranquilla 32 23 37 31
15 Llaneros Llaneros 32 33 51 30
16 Atlético Fútbol Club Atlético 32 37 58 24
TEMPORADA 2013/2014
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Jaguares FC Jaguares FC 18 27 18 34
2 Deportivo Pereira Deportivo 18 28 15 33
3 Deportes Quindío Deportes 18 28 17 33
4 Deportivo Rionegro Deportivo 18 26 15 33
5 Unión Magdalena Unión 18 32 20 32
6 Cúcuta Deportivo Cúcuta 18 21 15 32
7 Atlético Bucaramanga Atlético 18 23 19 31
8 América de Cali América 18 25 17 30
9 Real Cartagena Real 18 20 18 30
10 Internacional de Palmira Internaciona 18 21 19 25
11 Real Cundinamarca Real 18 16 18 25
12 Llaneros Llaneros 18 25 25 22
13 Universitario Popayán Universitari 18 17 29 19
14 Real Santander Real 18 17 24 18
15 Tigres FC Tigres FC 18 11 20 13
16 Atlético Fútbol Club Atlético 18 18 35 13
17 Bogotá Bogotá 18 17 29 11
18 Barranquilla Barranquilla 18 11 30 11
TEMPORADA 2012/2013
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 América de Cali América 18 21 9 33
2 Deportivo Rionegro Deportivo 18 27 23 32
3 Real Cartagena Real 18 40 29 31
4 Internacional de Palmira Internaciona 18 26 20 29
5 Atlético Bucaramanga Atlético 18 19 15 28
6 Fortaleza Fortaleza 18 22 19 28
7 Uniautónoma Uniautónoma 18 24 25 27
8 Jaguares FC Jaguares FC 18 18 19 26
9 Deportivo Pereira Deportivo 18 20 18 24
10 Real Cundinamarca Real 18 22 20 22
11 Llaneros Llaneros 18 17 19 22
12 Atlético Fútbol Club Atlético 18 26 26 21
13 Real Santander Real 18 22 27 21
14 Bogotá Bogotá 18 15 20 21
15 Unión Magdalena Unión 18 19 24 19
16 Tigres FC Tigres FC 18 16 24 18
17 Universitario Popayán Universitari 18 21 34 18
18 Barranquilla Barranquilla 18 24 28 17
TEMPORADA 2011/2012
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 América de Cali América 18 33 15 38
2 Internacional de Palmira Internaciona 18 24 14 33
3 Deportivo Rionegro Deportivo 18 33 19 32
4 Sucre FC Sucre FC 18 22 18 31
5 Uniautónoma Uniautónoma 18 27 19 30
6 Universitario Popayán Universitari 18 25 18 30
7 Unión Magdalena Unión 18 27 21 28
8 Real Santander Real 18 25 23 27
9 Fortaleza Fortaleza 18 25 26 26
10 Real Cundinamarca Real 18 26 28 24
11 Deportivo Pereira Deportivo 18 21 23 23
12 Bogotá Bogotá 18 24 34 20
13 Academia Academia 18 22 22 19
14 Atlético Fútbol Club Atlético 18 23 34 18
15 Alianza FC Alianza FC 18 19 27 17
16 Atlético Bucaramanga Atlético 18 18 27 17
17 Barranquilla Barranquilla 18 18 28 16
18 Tigres FC Tigres FC 18 8 24 13
TEMPORADA 2010/2011
CLAUSURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Deportivo Pasto Deportivo 18 32 15 34
2 Centauros Centauros 18 28 25 31
3 Alianza FC Alianza FC 18 24 16 29
4 Bogotá Bogotá 18 26 21 29
5 Deportivo Rionegro Deportivo 18 33 23 28
6 Uniautónoma Uniautónoma 18 33 24 28
7 Tigres FC Tigres FC 18 21 15 28
8 Academia Academia 18 27 24 28
9 Real Santander Real 18 23 19 27
10 Fortaleza Fortaleza 18 20 18 26
11 Atlético Bucaramanga Atlético 18 16 18 23
12 Real Cundinamarca Real 18 22 27 23
13 Unión Magdalena Unión 18 18 22 20
14 Internacional de Palmira Internaciona 18 22 27 20
15 Patriotas Boyacá Patriotas 18 21 25 18
16 Pacífico Pacífico 18 14 28 15
17 Barranquilla Barranquilla 18 12 28 14
18 Atlético Fútbol Club Atlético 18 15 32 12
TEMPORADA 2009/2010
APERTURA PRIMERA B COLOMBIA
Equipo PJ GF GC Puntos
1 Águilas Doradas Águilas 18 28 15 33
2 Patriotas Boyacá Patriotas 18 24 13 32
3 Deportivo Rionegro Deportivo 18 24 16 29
4 Deportivo Pasto Deportivo 18 24 17 29
5 Unión Magdalena Unión 18 25 23 29
6 La Sabana La Sabana 18 20 18 29
7 Real Santander Real 18 29 18 27
8 Alianza FC Alianza FC 18 15 20 26
9 Pacífico Pacífico 18 21 19 24
10 Bogotá Bogotá 18 20 16 22
11 Atlético Fútbol Club Atlético 18 27 27 22
12 Tigres FC Tigres FC 18 16 17 22
13 Atlético Bucaramanga Atlético 18 15 18 22
14 Fortaleza Fortaleza 18 18 26 20
15 Barranquilla Barranquilla 18 10 19 20
16 Centauros Centauros 18 22 25 19
17 Academia Academia 18 19 33 14
18 Real Cundinamarca Real 18 11 28 14

  USO DE MEMORIA  
6,734,560 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1502
Total Execution Time  0.1521
  CADENA URL  
/historico/Barranquilla/2021
  GET DATOS  
$_GET['/historico/Barranquilla/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (43)  
0.0040  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 = 'Barranquilla' 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.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=11331 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=11331 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=11331 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=11331 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=11331 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11331 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0025  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 (109819,111730,112039,117687,190923) ORDER BY n.cover_points DESC, update_date DESC
0.0030  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 = '11331' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0043  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 = '11331' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0033  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=11331 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (70008,66316,66315,66308) 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.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 66308 AND teamId = 11331
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 66315 AND teamId = 11331
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 66316 AND teamId = 11331
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 70008 AND teamId = 11331
0.0022  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 = '11331' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '11331' 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 = '11331' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0032  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 = 60997 WHERE rp.league_id = 60997 AND rp.teamId = 11331 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.0030  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 = 60997 WHERE rp.league_id = 60997 AND rp.teamId = 11331 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0034  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 = 60997 WHERE rp.league_id = 60997 AND rp.teamId = 11331 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0031  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 = 11331 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 60997 AND t.round = 15 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 `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 = 63326 AND t.round = 15 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 `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 = 53797 AND t.round = 17 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 = 53812 AND t.round = 8 ORDER BY team.conference ASC,t.position 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 `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 = 48673 AND t.round = 15 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 `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 = 48674 AND t.round = 15 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 42552 AND t.round = 30 ORDER BY team.conference 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 `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 = 37761 AND t.round = 16 ORDER BY team.conference 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 `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 = 38802 AND t.round = 16 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 20265 AND t.round = 32 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 9458 AND t.round = 32 ORDER BY team.conference 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 `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 = 3477 AND t.round = 18 ORDER BY team.conference 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 `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 = 3209 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 2415 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 2622 AND t.round = 18 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 `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 = 1662 AND t.round = 18 ORDER BY team.conference 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 `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 = 1569 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 1391 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0024  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 = 1392 AND t.round = 18 ORDER BY team.conference 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 `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 = 9745 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC