4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Shelbourne Shelbourne 12 15 9 24
2 Shamrock Rovers Shamrock 11 18 11 19
3 Derry City Derry City 12 19 13 19
4 Bohemian FC Bohemian FC 12 13 14 19
5 Galway United Galway 12 7 7 16
6 St Patrick's Patrick's 12 11 11 15
7 Sligo Rovers Sligo Rovers 12 13 14 14
8 Waterford United Waterford 12 12 14 13
9 Drogheda United Drogheda 11 12 16 11
10 Dundalk Dundalk 12 6 17 8
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
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Shamrock Rovers Shamrock 36 59 28 78
2 St Patrick's Patrick's 36 56 42 62
3 Sligo Rovers Sligo Rovers 36 43 32 57
4 Derry City Derry City 36 49 42 54
5 Bohemian FC Bohemian FC 36 60 46 52
6 Dundalk Dundalk 36 44 46 48
7 Drogheda United Drogheda 36 45 43 44
8 Finn Harps Finn Harps 36 44 52 44
9 Waterford United Waterford 36 36 56 42
10 Longford Town Longford 36 22 71 15
TEMPORADA 2019/2020
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Shamrock Rovers Shamrock 17 42 7 45
2 Bohemian FC Bohemian FC 18 23 12 37
3 Dundalk Dundalk 18 25 23 26
4 Sligo Rovers Sligo Rovers 18 19 23 25
5 Waterford United Waterford 18 17 22 24
6 St Patrick's Patrick's 18 14 17 21
7 Derry City Derry City 17 18 16 20
8 Finn Harps Finn Harps 18 15 24 20
9 Shelbourne Shelbourne 18 13 22 19
10 Cork City Cork City 18 10 30 11
TEMPORADA 2018/2019
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Dundalk Dundalk 36 73 18 86
2 Shamrock Rovers Shamrock 36 62 21 75
3 Bohemian FC Bohemian FC 36 47 28 60
4 Derry City Derry City 36 56 34 57
5 St Patrick's Patrick's 36 29 35 52
6 Waterford United Waterford 36 46 53 43
7 Sligo Rovers Sligo Rovers 36 38 47 42
8 Cork City Cork City 36 29 49 37
9 Finn Harps Finn Harps 36 26 64 28
10 UC Dublin UC Dublin 36 25 82 19
TEMPORADA 2017/2018
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Dundalk Dundalk 36 85 20 87
2 Cork City Cork City 36 71 27 77
3 Shamrock Rovers Shamrock 36 57 27 62
4 Waterford United Waterford 36 52 44 59
5 St Patrick's Patrick's 36 51 47 50
6 Bohemian FC Bohemian FC 36 52 45 48
7 Sligo Rovers Sligo Rovers 36 38 50 42
8 Derry City Derry City 36 47 70 42
9 Limerick Limerick 36 25 75 27
10 Bray Wanderers Bray 36 23 96 18
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
SEGUNDA IRLANDA
Equipo PJ GF GC Puntos
1 Longford Town Longford 28 56 19 60
2 Shelbourne Shelbourne 28 46 30 52
3 Galway United Galway 28 47 23 49
4 Wexford Youths Wexford 28 45 35 46
5 Finn Harps Finn Harps 28 26 28 32
6 Shamrock Rovers II Shamrock 28 25 50 26
7 Waterford United Waterford 28 25 43 25
8 Cobh Ramblers Cobh 28 24 66 14
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
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Drogheda United Drogheda 33 48 24 68
2 St Patrick's Patrick's 33 54 29 61
3 Bohemian FC Bohemian FC 33 35 17 58
4 Cork City Cork City 33 44 32 55
5 Shamrock Rovers Shamrock 33 36 26 51
6 Sligo Rovers Sligo Rovers 33 34 45 41
7 Derry City Derry City 33 30 31 37
8 Galway United Galway 33 28 35 35
9 Bray Wanderers Bray 33 30 48 34
10 UC Dublin UC Dublin 33 31 44 31
11 Waterford United Waterford 33 23 47 30
12 Longford Town Longford 33 34 49 29
TEMPORADA 2005/2006
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Shelbourne Shelbourne 30 60 27 62
2 Derry City Derry City 30 46 20 62
3 Drogheda United Drogheda 30 37 23 58
4 Cork City Cork City 30 37 15 56
5 Sligo Rovers Sligo Rovers 30 33 42 40
6 UC Dublin UC Dublin 30 26 26 38
7 St Patrick's Patrick's 30 32 29 37
8 Longford Town Longford 30 23 27 34
9 Bohemian FC Bohemian FC 30 29 34 29
10 Bray Wanderers Bray 30 22 64 17
11 Waterford United Waterford 30 20 58 12
TEMPORADA 2004/2005
LIGA IRLANDA
Equipo PJ GF GC Puntos
1 Cork City Cork City 33 53 18 74
2 Derry City Derry City 33 55 25 72
3 Shelbourne Shelbourne 33 62 25 67
4 Drogheda United Drogheda 33 40 33 48
5 Longford Town Longford 33 29 32 45
6 Bohemian FC Bohemian FC 33 42 46 45
7 Bray Wanderers Bray 33 40 57 39
8 Waterford United Waterford 33 30 49 34
9 UC Dublin UC Dublin 33 28 44 33
10 St Patrick's Patrick's 33 26 36 32
11 Shamrock Rovers Shamrock 33 33 52 27
12 Finn Harps Finn Harps 33 30 51 21

  USO DE MEMORIA  
6,576,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7555
Total Execution Time  0.7568
  CADENA URL  
/historico/Waterford-United
  GET DATOS  
$_GET['/historico/Waterford-United']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (48)  
0.0141  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 = 'Waterford-United' 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.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=12543 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=12543 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=12543 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=12543 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0253  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 = 74841
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 = 75150
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12543 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12543 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 (401422,627409,1064859,1285779) ORDER BY n.cover_points DESC, update_date DESC
0.0135  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 = '12543' ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '12543' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '12543' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 75150 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 = 74841 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0145  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=12543 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0131  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 (75150,74841,74502,74440,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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 74841 AND teamId = 12543
0.0165  SELECT count(id) as num_players from rel_players WHERE league_id = 74440 AND teamId = 12543
0.0154  SELECT count(id) as num_players from rel_players WHERE league_id = 74502 AND teamId = 12543
0.0140  SELECT count(id) as num_players from rel_players WHERE league_id = 72229 AND teamId = 12543
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75150 AND teamId = 12543
0.0137  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 12543
0.0126  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 = '12543' 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 = '12543' 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 = '12543' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0142  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 = 74841 WHERE rp.league_id = 74841 AND rp.teamId = 12543 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.0157  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 = 74841 WHERE rp.league_id = 74841 AND rp.teamId = 12543 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0132  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 = 74841 WHERE rp.league_id = 74841 AND rp.teamId = 12543 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 12543 AND l.year <= 2024 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 `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 = 74841 AND t.round = 12 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129  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 = 70791 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.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 `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.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 `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 = 61159 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.0129  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 = 53592 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.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 `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 = 48595 AND t.round = 36 ORDER BY team.conference 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 = 42100 AND t.round = 36 ORDER BY team.conference 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 `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.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 `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.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 `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.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 `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 = 3745 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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.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 `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.0129  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 = 15206 AND t.round = 33 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 `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.0134  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.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 `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 = 10524 AND t.round = 33 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 `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 = 10526 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC