4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Iskra Rîbniţa
TEMPORADA 2023/2024
SEGUNDA MOLDAVIA GRUPO 2
Equipo PJ GF GC Puntos
1 Dinamo-Auto Cioburciu Dinamo-Auto 0 0 0 0
2 FC Sheriff II Sheriff 0 0 0 0
3 FCM Ungheni FCM Ungheni 0 0 0 0
4 Flacăra Făleşti Flacăra 0 0 0 0
5 Iskra Rîbniţa Iskra 0 0 0 0
6 Olimp Comrat Olimp Comrat 0 0 0 0
7 Real Succes Real Succes 0 0 0 0
8 Speranis Nisporeni Speranis 0 0 0 0
TEMPORADA 2022/2023
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Iskra Rîbniţa Iskra 24 57 21 57
2 Inter Soroca Inter Soroca 24 54 37 43
3 Ocniţa Ocniţa 24 39 23 42
4 Pepeni Pepeni 24 41 27 42
5 Sîngerei Sîngerei 24 48 40 40
6 Vulturii Cutezători Vulturii 24 42 28 39
7 FC Edinet FC Edinet 24 34 28 39
8 Tarigrad Tarigrad 24 37 40 35
9 FC Olimpia FC Olimpia 24 56 51 32
10 EFA Visoca EFA Visoca 24 38 39 30
11 FC Visoca FC Visoca 24 23 44 23
12 Grănicerul Grănicerul 24 22 54 14
13 CF Riscani CF Riscani 24 27 86 4
14 Cruiz Cruiz 0 0 0 0
TEMPORADA 2021/2022
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Sheriff II Sheriff 22 49 15 49
2 FC Victoria Bardar Victoria 22 51 24 49
3 Dacia Buiucani Dacia 22 58 15 48
4 Spartanii Selemet Spartanii 22 46 26 44
5 Speranis Nisporeni Speranis 22 31 31 36
6 Olimp Comrat Olimp Comrat 22 41 36 35
7 Sucleia Sucleia 22 34 40 27
8 Iskra Rîbniţa Iskra 22 28 44 25
9 Ungheni Ungheni 22 38 42 24
10 Real Succes Real Succes 22 22 45 18
11 Speranța Drochia Speranța 22 20 48 16
12 Cahul Cahul 22 6 58 2
TEMPORADA 2020/2021
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Bălți FC Bălți 26 85 17 69
2 Cahul Cahul 26 70 23 57
3 FC Sheriff II Sheriff 26 46 24 54
4 Spartanii Selemet Spartanii 26 57 42 46
5 Sucleia Sucleia 26 64 38 46
6 Speranța Drochia Speranța 26 49 41 42
7 Olimp Comrat Olimp Comrat 26 51 44 38
8 Iskra Rîbniţa Iskra 26 53 49 35
9 FC Tighina FC Tighina 26 42 61 30
10 Real Succes Real Succes 26 44 35 28
11 FC Victoria Bardar Victoria 26 61 65 26
12 Grănicerul Grănicerul 26 25 61 22
13 Flacăra Făleşti Flacăra 26 40 92 18
14 Sireți Sireți 26 26 121 9
TEMPORADA 2019/2020
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Dacia Buiucani Dacia 28 68 17 69
2 FC Florești Florești 28 71 29 69
3 FC Tighina FC Tighina 28 84 31 60
4 Spartanii Selemet Spartanii 28 70 29 60
5 Cahul Cahul 28 60 34 48
6 FC Victoria Bardar Victoria 28 58 54 43
7 Speranța Drochia Speranța 28 44 37 41
8 Grănicerul Grănicerul 28 47 66 34
9 Sireți Sireți 28 48 83 33
10 FC Bălți FC Bălți 29 66 61 32
11 Real Succes Real Succes 28 60 61 32
12 Iskra Rîbniţa Iskra 29 52 63 32
13 Ungheni Ungheni 28 55 83 30
14 Sîngerei Sîngerei 28 38 72 21
15 CS Sparta CS Sparta 28 6 107 2
TEMPORADA 2018/2019
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Codru Lozova Codru Lozova 22 53 20 48
2 FC Florești Florești 22 40 27 40
3 Sîngerei Sîngerei 22 47 42 36
4 FC Victoria Bardar Victoria 22 51 43 35
5 Grănicerul Grănicerul 22 43 35 34
6 Saksan Saksan 22 41 31 30
7 Ungheni Ungheni 22 50 65 28
8 Cahul Cahul 22 38 31 27
9 Sireți Sireți 22 36 47 23
10 Real Succes Real Succes 22 49 75 22
11 CS Sparta CS Sparta 22 34 51 21
12 Iskra Rîbniţa Iskra 22 27 42 20
TEMPORADA 2017/2018
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Victoria Bardar Victoria 12 34 15 29
2 FC Sheriff II Sheriff 12 40 12 25
3 Spartanii Selemet Spartanii 12 29 18 23
4 Cahul Cahul 12 33 26 21
5 Grănicerul Grănicerul 12 22 11 21
6 Sîngerei Sîngerei 12 19 20 19
7 Zimbru II Zimbru II 12 29 18 18
8 Iskra Rîbniţa Iskra 12 18 24 16
9 Moldova 03 Ungheni Moldova 12 20 24 11
10 Saxan Ceadir-Lunga II Saxan 12 13 24 11
11 Real Succes Real Succes 12 11 35 7
12 Codru Lozova Codru Lozova 12 15 32 7
13 FC Edinet FC Edinet 12 7 31 4
TEMPORADA 2016/2017
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Sheriff II Sheriff 28 94 19 68
2 FC Sfintul Gheorghe Sfintul 28 79 23 66
3 Spicul Chișcăreni Spicul 28 62 22 66
4 FC Victoria Bardar Victoria 28 78 26 64
5 Zimbru II Zimbru II 28 57 38 44
6 Spartanii Selemet Spartanii 28 51 61 41
7 Sîngerei Sîngerei 28 48 53 40
8 FC Edinet FC Edinet 28 55 57 36
9 Iskra Rîbniţa Iskra 28 39 50 35
10 Dacia Buiucani Dacia 28 39 45 34
11 Real Succes Real Succes 28 37 54 29
12 Oguzsport Comrat Oguzsport 28 51 74 29
13 Codru Lozova Codru Lozova 28 48 81 27
14 Intersport Aroma Intersport 28 20 50 22
15 Constructorul Leova Constructoru 28 19 124 7
TEMPORADA 2015/2016
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Spicul Chișcăreni Spicul 26 85 19 68
2 FC Sheriff II Sheriff 26 64 25 59
3 Zimbru II Zimbru II 26 53 23 51
4 Ungheni Ungheni 26 49 38 46
5 Dacia Buiucani Dacia 26 40 41 41
6 Oguzsport Comrat Oguzsport 26 43 44 37
7 FC Victoria Bardar Victoria 26 38 34 36
8 Codru Lozova Codru Lozova 26 44 51 32
9 Iskra Rîbniţa Iskra 26 47 63 29
10 FC Edinet FC Edinet 26 42 47 27
11 Intersport Aroma Intersport 26 31 48 26
12 FC Sfintul Gheorghe Sfintul 26 43 60 24
13 Real Succes Real Succes 26 29 56 23
14 Constructorul Leova Constructoru 26 30 89 15
TEMPORADA 2014/2015
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 Spicul Chișcăreni Spicul 21 95 18 61
2 Iskra Rîbniţa Iskra 22 70 24 47
3 Sîngerei Sîngerei 22 48 28 46
4 Intersport Sănătăuca Intersport 22 35 31 41
5 FC Florești Florești 22 41 39 31
6 Flacăra Făleşti Flacăra 22 43 45 30
7 Dava Soroca Dava Soroca 22 40 53 28
8 Cotiujănii Mari Cotiujănii 22 44 73 26
9 Drochia Drochia 21 32 40 24
10 Grănicerul Grănicerul 22 22 42 18
11 Teleneşti Teleneşti 22 19 53 12
12 CF Riscani CF Riscani 22 24 67 9
TEMPORADA 2012/2013
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Sheriff Sheriff 33 65 17 80
2 Dacia Chişinău Dacia 33 47 19 66
3 Tiraspol Tiraspol 33 54 20 64
4 Milsami Orhei Milsami 33 48 30 58
5 Rapid Ghidighici Rapid 33 36 38 49
6 Zimbru Chişinău Zimbru 33 53 38 46
7 Academia Chişinău Academia 33 55 52 44
8 Costuleni Costuleni 33 38 48 38
9 Iskra Rîbniţa Iskra 33 37 55 38
10 Olimpia Bălţi Olimpia 33 31 50 35
11 Speranta Cahul Speranta 33 35 70 19
12 Nistru Otaci Nistru Otaci 33 21 83 12
TEMPORADA 2011/2012
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Sheriff Sheriff 33 75 18 81
2 Dacia Chişinău Dacia 33 63 17 77
3 Zimbru Chişinău Zimbru 33 47 24 61
4 Milsami Orhei Milsami 33 41 37 47
5 Olimpia Bălţi Olimpia 33 26 27 45
6 Tiraspol Tiraspol 33 36 32 42
7 Iskra Rîbniţa Iskra 33 41 48 40
8 Nistru Otaci Nistru Otaci 33 30 41 39
9 Academia Chişinău Academia 33 32 48 31
10 FC Sfintul Gheorghe Sfintul 33 23 55 30
11 Rapid Ghidighici Rapid 33 20 52 26
12 Costuleni Costuleni 33 19 54 20
TEMPORADA 2010/2011
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Dacia Chişinău Dacia 39 66 16 92
2 Sheriff Sheriff 39 81 16 83
3 Milsami Orhei Milsami 39 71 23 78
4 Zimbru Chişinău Zimbru 39 56 20 76
5 Iskra Rîbniţa Iskra 39 62 26 74
6 Olimpia Bălţi Olimpia 39 59 31 74
7 Tiraspol Tiraspol 39 57 45 57
8 Rapid Ghidighici Rapid 39 39 37 55
9 Academia Chişinău Academia 39 44 37 52
10 Costuleni Costuleni 39 23 68 27
11 Nistru Otaci Nistru Otaci 39 33 75 25
12 FC Sfintul Gheorghe Sfintul 39 30 83 25
13 Oguzsport Comrat Oguzsport 39 38 89 23
14 FC Tighina FC Tighina 39 25 118 22
TEMPORADA 2009/2010
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Sheriff Sheriff 33 75 8 84
2 Iskra Rîbniţa Iskra 33 50 25 65
3 Olimpia Bălţi Olimpia 33 45 23 60
4 Zimbru Chişinău Zimbru 33 47 29 59
5 Dacia Chişinău Dacia 33 54 30 58
6 Rapid Ghidighici Rapid 33 40 39 45
7 Academia Chişinău Academia 33 36 37 42
8 Milsami Orhei Milsami 33 32 45 36
9 Tiraspol Tiraspol 33 20 34 34
10 FC Tighina FC Tighina 33 36 66 32
11 FC Sfintul Gheorghe Sfintul 33 29 67 24
12 Nistru Otaci Nistru Otaci 33 13 74 11
TEMPORADA 2008/2009
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Sheriff Sheriff 30 61 15 78
2 Dacia Chişinău Dacia 30 47 17 63
3 Iskra Rîbniţa Iskra 30 28 15 52
4 Zimbru Chişinău Zimbru 30 42 30 46
5 FC Tighina FC Tighina 30 41 45 42
6 Olimpia Bălţi Olimpia 30 30 31 40
7 Tiraspol Tiraspol 30 30 35 32
8 Nistru Otaci Nistru Otaci 30 30 43 30
9 Rapid Ghidighici Rapid 30 27 47 29
10 Tiligul Tiraspol Tiligul 30 24 60 25
11 Academia Chişinău Academia 30 27 49 24
TEMPORADA 2007/2008
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Sheriff Sheriff 30 68 8 81
2 Dacia Chişinău Dacia 30 60 28 62
3 Nistru Otaci Nistru Otaci 30 34 17 59
4 Tiraspol Tiraspol 30 36 21 55
5 Zimbru Chişinău Zimbru 30 43 21 52
6 Iskra Rîbniţa Iskra 30 23 34 35
7 Tiligul Tiraspol Tiligul 30 16 36 29
8 Olimpia Bălţi Olimpia 30 24 46 27
9 FC Tighina FC Tighina 30 30 57 26
10 Rapid Ghidighici Rapid 30 21 55 18
11 Politehnica Chişinău Politehnica 30 7 39 15
TEMPORADA 2006/2007
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Sheriff Sheriff 36 70 7 92
2 Zimbru Chişinău Zimbru 36 62 23 71
3 Nistru Otaci Nistru Otaci 36 44 36 57
4 Dacia Chişinău Dacia 36 36 30 55
5 Tiraspol Tiraspol 36 37 32 46
6 Olimpia Bălţi Olimpia 36 38 50 42
7 Politehnica Chişinău Politehnica 36 29 47 33
8 Tiligul Tiraspol Tiligul 36 23 46 33
9 Iskra Rîbniţa Iskra 36 22 43 31
10 FC Tighina FC Tighina 36 24 71 22

  USO DE MEMORIA  
6,629,048 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1414
Total Execution Time  0.1428
  CADENA URL  
/historico/Iskra-Ribnita
  GET DATOS  
$_GET['/historico/Iskra-Ribnita']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0041  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 = 73215
0.0023  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 = 74915
0.0026  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 = 73520
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61685 AND type_rel = 2
0.0020  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=376 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 376 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0019  SELECT /*53 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 (15930) ORDER BY n.cover_points DESC, update_date DESC
0.0024  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 = '61685' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '61685' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 73520 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 73215 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=61685 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0023  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 (74915,73520,68585) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 74915 AND teamId = 61685
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 68585 AND teamId = 61685
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73520 AND teamId = 61685
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 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 = 73215 AND t.round = 15 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0023  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 = '61685' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '61685' and rp.type = 4
0.0025  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 = '61685' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0022  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 = 73215 WHERE rp.league_id = 73215 AND rp.teamId = 61685 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.0025  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 = 73215 WHERE rp.league_id = 73215 AND rp.teamId = 61685 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73215 WHERE rp.league_id = 73215 AND rp.teamId = 61685 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0035  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 = 61685 AND l.year <= 2024 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 `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 = 73215 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.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 `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 = 74915 AND t.round = 7 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 `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 = 68585 AND t.round = 26 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 `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 = 63553 AND t.round = 22 ORDER BY team.conference ASC,t.position 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 `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 = 58054 AND t.round = 26 ORDER BY team.conference ASC,t.position 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 `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 = 49426 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.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 `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 = 43306 AND t.round = 22 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 `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 = 38878 AND t.round = 13 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 `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 = 33978 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0039  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 = 15790 AND t.round = 26 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 `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 = 9505 AND t.round = 22 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 `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 = 2860 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 10735 AND t.round = 33 ORDER BY team.conference 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 `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 = 10736 AND t.round = 39 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 10737 AND t.round = 33 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 10738 AND t.round = 33 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 `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 = 10743 AND t.round = 33 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 `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 = 10744 AND t.round = 36 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC