4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Rubio Ñu
TEMPORADA 2023/2024
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Deportivo Recoleta Deportivo 5 13 3 13
2 Sportivo San Lorenzo Sportivo 5 7 3 11
3 Encarnacion Encarnacion 5 6 4 10
4 Sportivo Carapeguá Sportivo 5 6 4 10
5 Atlético Tembetary Atlético 5 5 3 9
6 Fernando de la Mora Fernando 5 6 5 8
7 Club 12 de Junio Club Junio 5 7 8 7
8 Pastoreo Pastoreo 5 7 8 7
9 3 de Febrero Febrero 5 5 5 6
10 Resistencia Resistencia 5 7 9 6
11 Martín Ledesma Martín 5 6 6 5
12 Rubio Ñu Rubio Ñu 5 6 7 5
13 Guaireña Guaireña 5 5 6 5
14 Independiente FBC Independient 5 5 7 4
15 Deportivo Santaní Deportivo 5 4 11 4
16 CA Colegiales Colegiales 5 3 9 0
TEMPORADA 2022/2023
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Sol de América América 30 46 25 67
2 2 de Mayo 2 de Mayo 30 46 23 57
3 Independiente FBC Independient 30 53 35 51
4 Deportivo Recoleta Deportivo 30 59 45 51
5 Fernando de la Mora Fernando 30 40 31 48
6 Rubio Ñu Rubio Ñu 30 42 44 44
7 Deportivo Santaní Deportivo 30 41 43 44
8 Sportivo Carapeguá Sportivo 30 43 31 43
9 Pastoreo Pastoreo 30 37 31 43
10 Sportivo San Lorenzo Sportivo 30 35 27 42
11 3 de Febrero Febrero 30 39 42 39
12 CA Colegiales Colegiales 30 29 44 32
13 Martín Ledesma Martín 30 30 41 31
14 24 de Setiembre Setiembre 30 38 52 29
15 Atyrá Atyrá 30 32 58 26
16 12 de Octubre Octubre 30 24 62 14
TEMPORADA 2021/2022
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Sportivo Trinidense Sportivo 30 54 24 66
2 Sportivo Luqueño Sportivo 30 42 26 61
3 Sportivo San Lorenzo Sportivo 30 47 26 54
4 Pastoreo Pastoreo 30 44 28 53
5 Fernando de la Mora Fernando 30 48 31 48
6 Martín Ledesma Martín 30 30 29 45
7 Rubio Ñu Rubio Ñu 30 39 30 44
8 Independiente FBC Independient 30 33 36 41
9 Atyrá Atyrá 30 24 28 36
10 CA Colegiales Colegiales 30 32 42 36
11 3 de Febrero Febrero 30 29 36 35
12 Deportivo Santaní Deportivo 30 30 42 33
13 Guarani Trinidad Guarani 30 29 41 31
14 2 de Mayo 2 de Mayo 30 32 39 29
15 Club River Plate Club River. 30 27 39 26
16 Sportivo Iteño Sportivo 30 27 70 20
TEMPORADA 2020/2021
PARAGUAY - DIVISION INTERMEDIA GRUPO 1
Equipo PJ GF GC Puntos
1 General Caballero JLM General 34 67 31 73
2 Resistencia Resistencia 34 44 22 61
3 Tacuary Tacuary 34 54 44 57
4 Sportivo Ameliano Sportivo 34 51 37 56
5 Sportivo San Lorenzo Sportivo 34 60 44 53
6 Sportivo Trinidense Sportivo 34 48 48 52
7 Independiente FBC Independient 34 38 30 51
8 3 de Febrero Febrero 34 48 44 48
9 Fernando de la Mora Fernando 34 40 36 45
10 Atyrá Atyrá 34 47 45 43
11 Guarani Trinidad Guarani 34 34 37 41
12 Deportivo Santaní Deportivo 34 38 42 41
13 Rubio Ñu Rubio Ñu 34 34 44 39
14 Dep. Capiatá Dep. 34 34 47 39
15 Sportivo Iteño Sportivo 34 26 39 39
16 2 de Mayo 2 de Mayo 34 39 55 36
17 General Díaz General 34 25 53 24
18 Fulgencio Yegros Fulgencio 34 25 54 21
TEMPORADA 2019/2020
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 2 de Mayo 2 de Mayo 0 0 0 0
2 3 de Febrero Febrero 0 0 0 0
3 Atyrá Atyrá 0 0 0 0
4 Dep. Capiatá Dep. 0 0 0 0
5 Deportivo Santaní Deportivo 0 0 0 0
6 Fernando de la Mora Fernando 0 0 0 0
7 Fulgencio Yegros Fulgencio 0 0 0 0
8 General Caballero JLM General 0 0 0 0
9 Guarani Trinidad Guarani 0 0 0 0
10 Independiente FBC Independient 0 0 0 0
11 Resistencia Resistencia 0 0 0 0
12 Rubio Ñu Rubio Ñu 0 0 0 0
13 Sportivo Ameliano Sportivo 0 0 0 0
14 Sportivo Iteño Sportivo 0 0 0 0
15 Sportivo Trinidense Sportivo 0 0 0 0
16 Tacuary Tacuary 0 0 0 0
TEMPORADA 2018/2019
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Guaireña Guaireña 30 49 25 57
2 12 de Octubre Octubre 30 39 28 56
3 2 de Mayo 2 de Mayo 30 48 24 55
4 Atyrá Atyrá 30 46 40 49
5 Resistencia Resistencia 30 49 42 45
6 Fernando de la Mora Fernando 30 43 37 43
7 Independiente FBC Independient 30 37 36 41
8 General Caballero JLM General 30 41 42 41
9 Sportivo Trinidense Sportivo 30 37 36 40
10 3 de Febrero Febrero 30 36 40 39
11 Sportivo Iteño Sportivo 30 35 42 36
12 Rubio Ñu Rubio Ñu 30 32 39 35
13 RI 3 Corrales Corrales 30 32 33 32
14 Ovetense Ovetense 30 29 46 29
15 Fulgencio Yegros Fulgencio 30 25 45 24
16 Deportivo Caaguazú Deportivo 30 23 46 23
TEMPORADA 2017/2018
PARAGUAY - DIVISION INTERMEDIA
Equipo PJ GF GC Puntos
1 Club River Plate Club River. 30 41 26 55
2 Sportivo San Lorenzo Sportivo 30 47 30 51
3 Fernando de la Mora Fernando 30 41 28 51
4 Guaireña Guaireña 30 38 23 50
5 2 de Mayo 2 de Mayo 30 48 41 46
6 Rubio Ñu Rubio Ñu 30 40 38 44
7 Fulgencio Yegros Fulgencio 30 33 39 41
8 Resistencia Resistencia 30 32 33 40
9 CD Liberación Liberación 30 36 44 39
10 Sportivo Trinidense Sportivo 30 34 30 38
11 RI 3 Corrales Corrales 30 39 44 37
12 Ovetense Ovetense 30 29 35 36
13 General Caballero SC General 30 39 46 35
14 Sportivo Iteño Sportivo 30 35 41 34
15 Deportivo Caaguazú Deportivo 30 34 44 33
16 Martín Ledesma Martín 30 25 49 21
TEMPORADA 2016/2017
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Cerro Porteño Cerro 22 41 23 45
2 Olimpia Olimpia 22 37 20 42
3 Guaraní Guaraní 22 36 29 37
4 General Díaz General 22 30 21 35
5 Sportivo Luqueño Sportivo 22 36 31 33
6 Sol de América América 22 26 32 28
7 Nacional Nacional 22 26 30 27
8 Libertad Libertad 22 26 27 26
9 Dep. Capiatá Dep. 22 19 22 26
10 Rubio Ñu Rubio Ñu 22 16 25 25
11 Sportivo Trinidense Sportivo 22 20 28 19
12 Independiente FBC Independient 22 16 41 18
TEMPORADA 2015/2016
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Guaraní Guaraní 22 32 19 48
2 Olimpia Olimpia 22 44 22 47
3 Libertad Libertad 22 33 22 39
4 Dep. Capiatá Dep. 22 33 25 37
5 Cerro Porteño Cerro 22 45 30 35
6 Nacional Nacional 22 33 34 31
7 Sol de América América 22 32 34 28
8 Sportivo Luqueño Sportivo 22 19 31 26
9 General Díaz General 22 20 28 22
10 General Caballero SC General 22 23 34 20
11 Rubio Ñu Rubio Ñu 22 15 27 15
12 Club River Plate Club River. 22 25 48 12
TEMPORADA 2014/2015
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Olimpia Olimpia 22 40 22 44
2 Cerro Porteño Cerro 22 32 23 44
3 Guaraní Guaraní 22 52 29 39
4 Libertad Libertad 22 35 23 38
5 Dep. Capiatá Dep. 22 31 34 33
6 Sol de América América 22 35 35 26
7 Deportivo Santaní Deportivo 22 29 37 26
8 General Díaz General 22 18 35 24
9 Sportivo Luqueño Sportivo 22 39 43 23
10 Rubio Ñu Rubio Ñu 22 22 29 22
11 Sportivo San Lorenzo Sportivo 22 29 38 22
12 Nacional Nacional 22 21 35 21
TEMPORADA 2013/2014
APERTURA PARAGUAY
Equipo PJ GF GC Puntos
1 Libertad Libertad 22 41 17 50
2 Guaraní Guaraní 22 56 31 46
3 Olimpia Olimpia 22 32 26 33
4 Cerro Porteño Cerro 22 49 38 31
5 Sol de América América 22 36 31 31
6 Rubio Ñu Rubio Ñu 22 38 37 30
7 Nacional Nacional 22 26 27 30
8 Sportivo Luqueño Sportivo 22 23 25 28
9 Dep. Capiatá Dep. 22 22 37 26
10 General Díaz General 22 19 34 19
11 12 de Octubre Octubre 22 21 38 15
12 3 de Febrero Febrero 22 22 44 14
TEMPORADA 2012/2013
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Cerro Porteño Cerro 22 37 16 50
2 Libertad Libertad 22 25 19 39
3 Dep. Capiatá Dep. 22 36 32 38
4 Guaraní Guaraní 22 47 24 37
5 General Díaz General 22 30 24 33
6 Nacional Nacional 22 30 26 33
7 Sportivo Luqueño Sportivo 22 30 29 29
8 Rubio Ñu Rubio Ñu 22 25 32 25
9 Olimpia Olimpia 22 31 32 24
10 Sportivo Carapeguá Sportivo 22 24 38 22
11 Sol de América América 22 24 43 17
12 PF Cerro Por. Cerro Por. 22 23 47 16
TEMPORADA 2011/2012
CLAUSURA PARAGUAY
Equipo PJ GF GC Puntos
1 Libertad Libertad 22 44 16 47
2 Nacional Nacional 22 36 16 44
3 Guaraní Guaraní 22 28 19 43
4 Cerro Porteño Cerro 22 39 21 37
5 Sportivo Luqueño Sportivo 22 23 24 33
6 Olimpia Olimpia 22 33 31 32
7 PF Cerro Por. Cerro Por. 22 19 31 26
8 Sol de América América 22 24 26 25
9 Sportivo Carapeguá Sportivo 22 30 34 25
10 Tacuary Tacuary 22 31 39 22
11 Rubio Ñu Rubio Ñu 22 18 38 18
12 Independiente FBC Independient 22 14 44 9
TEMPORADA 2010/2011
APERTURA PARAGUAY
Equipo PJ GF GC Puntos
1 Nacional Nacional 22 34 18 47
2 Olimpia Olimpia 22 44 22 42
3 Libertad Libertad 22 28 18 39
4 Guaraní Guaraní 22 23 19 34
5 Rubio Ñu Rubio Ñu 22 35 34 31
6 Tacuary Tacuary 22 17 14 30
7 Cerro Porteño Cerro 22 23 29 24
8 3 de Febrero Febrero 22 23 31 23
9 Independiente FBC Independient 22 26 29 22
10 Sol de América América 22 21 33 21
11 Sportivo Luqueño Sportivo 22 24 36 20
12 General Caballero SC General 22 21 36 18

  USO DE MEMORIA  
6,289,952 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5773
Total Execution Time  0.5785
  CADENA URL  
/historico/Rubio-Nu
  GET DATOS  
$_GET['/historico/Rubio-Nu']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (35)  
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4376 AND type_rel = 2
0.0140  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4376 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0142  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 (8172,15509,48695,58111,101794) ORDER BY n.cover_points DESC, update_date DESC
0.0141  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 = '4376' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0130  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=4376 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (75239,71905) 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.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 75239 AND teamId = 4376
0.0135  SELECT count(id) as num_players from rel_players WHERE league_id = 71905 AND teamId = 4376
0.0135  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 = '4376' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0129  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '4376' and rp.type = 4
0.0140  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 = '4376' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0154  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 = 75239 WHERE rp.league_id = 75239 AND rp.teamId = 4376 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.0138  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 = 75239 WHERE rp.league_id = 75239 AND rp.teamId = 4376 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 75239 WHERE rp.league_id = 75239 AND rp.teamId = 4376 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0151  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 = 4376 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0142  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 = 75239 AND t.round = 6 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 70775 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0143  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 = 66216 AND t.round = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 61984 AND t.round = 34 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 = 53794 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.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 `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 = 48876 AND t.round = 30 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 `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 = 42469 AND t.round = 30 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 = 37684 AND t.round = 22 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 `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 = 38848 AND t.round = 22 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 `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 = 20174 AND t.round = 22 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 = 26801 AND t.round = 22 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 = 8951 AND t.round = 22 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 `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 = 15482 AND t.round = 22 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 `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 = 3351 AND t.round = 22 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 = 3570 AND t.round = 22 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 `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 = 2334 AND t.round = 22 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 `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 = 2706 AND t.round = 22 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 `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 = 1673 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 1573 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 1592 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC