4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Cork City Cork City 12 19 3 28
2 UC Dublin UC Dublin 12 17 11 21
3 Bray Wanderers Bray 12 22 18 18
4 Wexford Youths Wexford 11 22 21 18
5 Finn Harps Finn Harps 12 12 11 18
6 Athlone Town Athlone Town 12 16 18 18
7 Treaty United Treaty 11 10 12 12
8 Cobh Ramblers Cobh 11 15 21 10
9 Kerry FC Kerry FC 12 10 14 9
10 Longford Town Longford 11 12 26 4
TEMPORADA 2022/2023
SEGUNDA IRLANDA GRUPO 1
Equipo PJ GF GC Puntos
1 Galway United Galway 36 98 18 94
2 Waterford United Waterford 36 84 32 69
3 Cobh Ramblers Cobh 36 61 51 59
4 Wexford Youths Wexford 36 48 49 53
5 Athlone Town Athlone Town 36 55 61 47
6 Treaty United Treaty 36 49 61 44
7 Bray Wanderers Bray 36 48 62 44
8 Longford Town Longford 36 39 51 40
9 Finn Harps Finn Harps 36 39 74 37
10 Kerry FC Kerry FC 36 29 91 10
TEMPORADA 2021/2022
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Cork City Cork City 32 63 22 68
2 Waterford United Waterford 32 70 34 64
3 Galway United Galway 32 56 29 60
4 Longford Town Longford 32 49 41 52
5 Treaty United Treaty 32 37 43 44
6 Wexford Youths Wexford 32 45 47 41
7 Bray Wanderers Bray 32 30 62 27
8 Athlone Town Athlone Town 32 44 75 24
9 Cobh Ramblers Cobh 32 37 78 17
TEMPORADA 2020/2021
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Shelbourne Shelbourne 27 49 23 57
2 Galway United Galway 27 39 25 51
3 UC Dublin UC Dublin 27 55 38 46
4 Treaty United Treaty 27 36 27 42
5 Bray Wanderers Bray 27 36 32 37
6 Cork City Cork City 27 37 28 33
7 Athlone Town Athlone Town 27 32 43 33
8 Cobh Ramblers Cobh 27 25 46 28
9 Cabinteely Cabinteely 27 26 47 25
10 Wexford Youths Wexford 27 30 56 21
TEMPORADA 2019/2020
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Bray Wanderers Bray 18 30 13 38
2 Drogheda United Drogheda 17 37 17 36
3 UC Dublin UC Dublin 18 44 29 30
4 Longford Town Longford 18 26 23 29
5 Galway United Galway 18 26 19 27
6 Cobh Ramblers Cobh 18 22 20 27
7 Cabinteely Cabinteely 18 22 33 26
8 Shamrock Rovers II Shamrock 18 21 28 15
9 Athlone Town Athlone Town 18 21 43 12
10 Wexford Youths Wexford 17 13 37 12
TEMPORADA 2018/2019
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Shelbourne Shelbourne 27 50 19 60
2 Drogheda United Drogheda 27 59 36 51
3 Longford Town Longford 27 41 23 51
4 Cabinteely Cabinteely 27 39 28 50
5 Bray Wanderers Bray 27 44 26 46
6 Limerick Limerick 26 31 38 36
7 Cobh Ramblers Cobh 27 38 51 31
8 Galway United Galway 26 33 40 23
9 Athlone Town Athlone Town 27 30 61 18
10 Wexford Youths Wexford 27 22 65 11
TEMPORADA 2017/2018
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 UC Dublin UC Dublin 27 59 29 57
2 Finn Harps Finn Harps 27 46 22 54
3 Shelbourne Shelbourne 27 52 21 50
4 Drogheda United Drogheda 27 50 27 49
5 Longford Town Longford 27 54 36 45
6 Galway United Galway 27 41 36 37
7 Cabinteely Cabinteely 27 32 45 30
8 Cobh Ramblers Cobh 27 24 41 29
9 Wexford Youths Wexford 27 24 56 20
10 Athlone Town Athlone Town 27 13 82 4
TEMPORADA 2016/2017
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Waterford United Waterford 28 47 17 59
2 Cobh Ramblers Cobh 28 37 28 51
3 UC Dublin UC Dublin 28 42 23 47
4 Longford Town Longford 28 34 26 38
5 Cabinteely Cabinteely 28 41 37 38
6 Shelbourne Shelbourne 28 35 33 38
7 Wexford Youths Wexford 28 17 39 20
8 Athlone Town Athlone Town 28 29 79 17
TEMPORADA 2015/2016
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Limerick Limerick 28 86 26 75
2 Drogheda United Drogheda 28 42 29 52
3 Cobh Ramblers Cobh 28 40 33 50
4 UC Dublin UC Dublin 28 57 40 48
5 Waterford United Waterford 28 43 65 33
6 Shelbourne Shelbourne 28 36 40 30
7 Cabinteely Cabinteely 28 19 54 16
8 Athlone Town Athlone Town 28 26 62 14
TEMPORADA 2014/2015
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Wexford Youths Wexford 28 63 32 61
2 Finn Harps Finn Harps 28 42 23 55
3 UC Dublin UC Dublin 28 51 27 49
4 Shelbourne Shelbourne 28 37 34 45
5 Athlone Town Athlone Town 28 36 42 33
6 Cobh Ramblers Cobh 28 27 45 30
7 Waterford United Waterford 28 25 51 21
8 Cabinteely Cabinteely 28 23 50 20
TEMPORADA 2013/2014
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Dundalk Dundalk 33 73 24 74
2 Cork City Cork City 33 51 25 72
3 St Patrick's Patrick's 33 66 37 65
4 Shamrock Rovers Shamrock 33 43 26 62
5 Sligo Rovers Sligo Rovers 33 44 36 43
6 Limerick Limerick 33 37 45 41
7 Bohemian FC Bohemian FC 33 42 43 40
8 Derry City Derry City 33 42 41 38
9 Drogheda United Drogheda 33 40 63 36
10 Bray Wanderers Bray 33 28 61 26
11 UC Dublin UC Dublin 33 27 71 25
12 Athlone Town Athlone Town 33 35 56 22
TEMPORADA 2012/2013
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Athlone Town Athlone Town 28 42 22 55
2 Longford Town Longford 28 55 34 50
3 Mervue United Mervue 28 46 31 49
4 Waterford United Waterford 28 40 24 47
5 Wexford Youths Wexford 28 29 47 33
6 Finn Harps Finn Harps 28 31 42 31
7 Cobh Ramblers Cobh 28 42 54 31
8 Salthill Devon Salthill 28 23 54 17
TEMPORADA 2011/2012
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Limerick Limerick 28 51 20 62
2 Waterford United Waterford 28 46 29 58
3 Longford Town Longford 28 42 33 50
4 Wexford Youths Wexford 28 45 40 39
5 Finn Harps Finn Harps 28 40 43 36
6 Athlone Town Athlone Town 28 25 41 29
7 Mervue United Mervue 28 34 49 23
8 Salthill Devon Salthill 28 23 51 20
TEMPORADA 2010/2011
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Cork City Cork City 30 73 26 69
2 Shelbourne Shelbourne 30 62 24 68
3 Limerick Limerick 30 49 22 66
4 Monaghan United Monaghan 30 57 27 65
5 Waterford United Waterford 30 37 31 42
6 Longford Town Longford 30 38 41 40
7 Mervue United Mervue 30 37 45 34
8 Athlone Town Athlone Town 30 25 53 32
9 Finn Harps Finn Harps 30 29 42 29
10 Wexford Youths Wexford 30 29 69 14
11 Salthill Devon Salthill 30 18 74 11
TEMPORADA 2009/2010
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Derry City Derry City 33 65 24 69
2 Waterford United Waterford 33 59 27 66
3 Monaghan United Monaghan 33 59 29 62
4 Shelbourne Shelbourne 33 57 31 61
5 Limerick Limerick 33 55 35 57
6 Cork City Cork City 33 39 31 52
7 Wexford Youths Wexford 33 42 54 42
8 Finn Harps Finn Harps 33 37 43 40
9 Longford Town Longford 33 39 53 35
10 Athlone Town Athlone Town 33 35 50 31
11 Mervue United Mervue 33 34 84 19
12 Salthill Devon Salthill 33 26 86 15
TEMPORADA 2008/2009
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 UC Dublin UC Dublin 33 63 21 74
2 Shelbourne Shelbourne 33 66 31 73
3 Sporting Fingal Sporting 33 68 28 69
4 Waterford United Waterford 33 51 21 66
5 Monaghan United Monaghan 33 58 48 55
6 Wexford Youths Wexford 33 27 31 50
7 Limerick Limerick 33 48 43 42
8 Finn Harps Finn Harps 33 35 51 33
9 Longford Town Longford 33 46 61 29
10 Athlone Town Athlone Town 33 32 63 27
11 Mervue United Mervue 33 28 64 23
12 Kildare County Kildare 33 25 85 15
TEMPORADA 2007/2008
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Dundalk Dundalk 36 69 30 71
2 Shelbourne Shelbourne 36 55 25 70
3 Waterford United Waterford 36 55 35 63
4 Sporting Fingal Sporting 36 53 32 62
5 Limerick Limerick 36 49 45 52
6 Monaghan United Monaghan 36 38 51 47
7 Wexford Youths Wexford 36 36 51 37
8 Longford Town Longford 36 36 55 35
9 Athlone Town Athlone Town 36 23 51 32
10 Kildare County Kildare 36 34 73 26
TEMPORADA 2006/2007
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Cobh Ramblers Cobh 36 57 17 77
2 Finn Harps Finn Harps 36 61 20 76
3 Dundalk Dundalk 36 56 30 66
4 Limerick Limerick 36 46 41 53
5 Shelbourne Shelbourne 36 46 46 43
6 Athlone Town Athlone Town 36 40 55 41
7 Kildare County Kildare 36 48 62 39
8 Monaghan United Monaghan 36 38 52 38
9 Wexford Youths Wexford 36 32 55 31
10 Kilkenny City Kilkenny 36 33 79 26
TEMPORADA 2005/2006
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Shamrock Rovers Shamrock 36 53 13 72
2 Dundalk Dundalk 36 57 33 71
3 Galway United Galway 36 57 25 69
4 Cobh Ramblers Cobh 36 50 33 58
5 Limerick Limerick 36 38 48 47
6 Finn Harps Finn Harps 36 49 45 46
7 Kildare County Kildare 36 38 55 43
8 Athlone Town Athlone Town 36 29 47 42
9 Monaghan United Monaghan 36 32 64 27
10 Kilkenny City Kilkenny 36 25 65 17
TEMPORADA 2004/2005
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Sligo Rovers Sligo Rovers 36 45 27 61
2 Dublin City Dublin City 36 57 34 59
3 Cobh Ramblers Cobh 36 49 40 56
4 Kilkenny City Kilkenny 36 46 35 53
5 Galway United Galway 36 46 43 53
6 Dundalk Dundalk 36 44 40 49
7 Limerick Limerick 36 44 49 48
8 Kildare County Kildare 36 33 42 41
9 Monaghan United Monaghan 36 36 66 36
10 Athlone Town Athlone Town 36 28 52 28

  USO DE MEMORIA  
6,612,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5834
Total Execution Time  0.5846
  CADENA URL  
/historico/Athlone-Town
  GET DATOS  
$_GET['/historico/Athlone-Town']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (45)  
0.0124  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 = 'Athlone-Town' 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.0106  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=4613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=4613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=4613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0106  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=4613 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=4613 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0112  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 = 74882
0.0111  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 = 75046
0.0105  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4613 AND type_rel = 2
0.0106  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4613 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0107  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 (275605,1022090) ORDER BY n.cover_points DESC, update_date DESC
0.0112  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 = '4613' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0113  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 = '4613' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0107  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 = 75046 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
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 = 74882 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0115  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=4613 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0106  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 (75547,74882,72229,71432) 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.0119  SELECT count(id) as num_players from rel_players WHERE league_id = 74882 AND teamId = 4613
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 72229 AND teamId = 4613
0.0109  SELECT count(id) as num_players from rel_players WHERE league_id = 75547 AND teamId = 4613
0.0118  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 4613
0.0109  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 74882 AND t.round = 13 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0121  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 = 74882 WHERE rp.league_id = 74882 AND rp.teamId = 4613 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.0118  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 = 74882 WHERE rp.league_id = 74882 AND rp.teamId = 4613 AND (e.action = 4 or e.action = 5) 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 = 74882 WHERE rp.league_id = 74882 AND rp.teamId = 4613 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0114  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 = 4613 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0110  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 = 74882 AND t.round = 13 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0111  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 = 66252 AND t.round = 36 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 61338 AND t.round = 27 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 55070 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.0108  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 = 48596 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 42101 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0110  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 = 37801 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0112  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 = 20284 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 11766 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 3627 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 2784 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 15204 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 = 15207 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2009` 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 = 15209 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0109  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 `tables2008` 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 = 15211 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 `tables2007` 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 = 15212 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 15214 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0108  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 = 15215 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0106  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 = 74882 ORDER BY nameShow LIMIT 100