4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del FC Victoria Bardar
TEMPORADA 2023/2024
SEGUNDA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Victoria Bardar Victoria 15 46 17 34
2 FC Sheriff II Sheriff 15 38 10 32
3 Speranța Drochia Speranța 15 14 15 21
4 Iskra Rîbniţa Iskra 15 24 32 21
5 FCM Ungheni FCM Ungheni 15 38 30 20
6 Dinamo-Auto Cioburciu Dinamo-Auto 15 6 62 1
7 Saksan Saksan 15 44 14 35
8 Oguzsport Comrat Oguzsport 15 33 18 33
9 Speranis Nisporeni Speranis 15 26 28 19
10 Flacăra Făleşti Flacăra 15 24 32 17
11 Olimp Comrat Olimp Comrat 15 19 24 17
12 Real Succes Real Succes 15 14 44 4
TEMPORADA 2022/2023
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Florești Florești 10 15 8 21
2 Flacăra Făleşti Flacăra 10 22 16 19
3 FC Sheriff II Sheriff 10 28 6 18
4 Ungheni Ungheni 10 20 15 16
5 Speranis Nisporeni Speranis 10 17 27 10
6 Sucleia Sucleia 10 10 40 3
7 FC Victoria Bardar Victoria 10 41 9 24
8 Spartanii Selemet Spartanii 10 25 11 24
9 Speranța Drochia Speranța 10 14 14 13
10 Văsieni Văsieni 10 13 24 12
11 Olimp Comrat Olimp Comrat 10 12 28 8
12 Real Succes Real Succes 10 13 32 7
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
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 FC Sheriff II Sheriff 21 52 13 48
2 Petrocub Hîncești Petrocub 21 54 20 44
3 Speranţa Nisporeni Speranţa 21 29 16 41
4 FC Sfintul Gheorghe Sfintul 21 38 29 33
5 Budăi Budăi 21 28 23 32
6 FC Victoria Bardar Victoria 21 33 23 31
7 Zimbru II Zimbru II 21 31 26 31
8 FC Edinet FC Edinet 21 30 31 27
9 Intersport Aroma Intersport 21 13 34 23
10 Dacia Buiucani Dacia 21 14 31 15
11 Real Succes Real Succes 21 17 44 14
12 Oguzsport Comrat Oguzsport 21 17 66 13
TEMPORADA 2013/2014
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Saksan Saksan 24 66 12 58
2 Dacia Buiucani Dacia 24 53 20 57
3 FC Victoria Bardar Victoria 24 44 30 44
4 FC Sheriff II Sheriff 24 44 19 42
5 FC Sfintul Gheorghe Sfintul 24 40 28 39
6 Zimbru II Zimbru II 24 41 26 37
7 FC Edinet FC Edinet 24 35 37 30
8 Intersport Aroma Intersport 24 35 40 30
9 Real Succes Real Succes 24 31 45 27
10 Oguzsport Comrat Oguzsport 24 31 53 26
11 Locomotiv Balti Locomotiv 24 25 53 20
12 CF Riscani CF Riscani 24 27 58 18
13 FC Slobozia Mare Slobozia 24 14 65 7
14 Nistru Otaci Nistru Otaci 0 0 0 0
TEMPORADA 2012/2013
SEGUNDA MOLDAVIA
Equipo PJ GF GC Puntos
1 Veris Veris 28 103 5 74
2 FC Sheriff II Sheriff 28 79 21 64
3 Dinamo-Auto Cioburciu Dinamo-Auto 28 51 23 56
4 Saksan Saksan 28 55 27 53
5 Dacia Buiucani Dacia 28 54 27 50
6 Intersport Aroma Intersport 28 41 31 45
7 Zimbru II Zimbru II 28 48 26 42
8 FC Sfintul Gheorghe Sfintul 28 38 51 40
9 Locomotiv Balti Locomotiv 28 54 57 37
10 FC Victoria Bardar Victoria 28 33 46 35
11 Oguzsport Comrat Oguzsport 28 37 59 33
12 FC Edinet FC Edinet 28 30 65 22
13 FC Tighina FC Tighina 28 35 90 20
14 Real Succes Real Succes 28 26 67 16
15 Maiak Chirsova Maiak 28 34 123 11
16 Olimpia 2 Tiligul Olimpia 0 0 0 0
TEMPORADA 2011/2012
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Victoria Bardar Victoria 18 57 9 47
2 CFR Ialoveni Ialoveni 18 60 16 41
3 CSF Cricova CSF Cricova 18 37 25 29
4 Universitatea Agrară Universitate 18 38 39 29
5 Sinteza Căuşeni Sinteza 18 42 26 27
6 Politehnica Chişinău Politehnica 18 52 34 26
7 Codru Călărași II Codru 18 27 39 23
8 Codru Lozova Codru Lozova 18 27 40 19
9 Olan Olănești Olan 18 19 67 11
10 Haiduc Haiduc 18 21 85 2
11 Nisporeni Nisporeni 0 0 0 0
TEMPORADA 2010/2011
TERCERA MOLDAVIA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Victoria Bardar Victoria 18 89 14 51
2 Izvoraş-67 Ratuş Izvoraş-67 18 43 20 38
3 Universitatea Agrară Universitate 18 40 23 35
4 CSF Cricova CSF Cricova 18 36 22 35
5 CFR Ialoveni Ialoveni 18 70 26 31
6 Sinteza Căuşeni Sinteza 18 52 34 27
7 Olan Olănești Olan 18 35 39 20
8 Criuleni Criuleni 18 26 78 13
9 Cimişlia Cimişlia 18 24 65 9
10 Locomotiva Basarabeasca Locomotiva 18 15 109 2
TEMPORADA 1996/1997
LIGA MOLDAVIA
Equipo PJ GF GC Puntos
1 Tiraspol Tiraspol 29 82 10 78
2 Zimbru Chişinău Zimbru 29 112 21 67
3 Tiligul Tiraspol Tiligul 29 73 12 65
4 Olimpia Bălţi Olimpia 29 75 34 57
5 Nistru Otaci Nistru Otaci 28 58 21 57
6 Speranta Cahul Speranta 30 34 36 42
7 Unisport-Auto Chisinau Unisport-Aut 30 40 44 41
8 Dinamo-Auto Cioburciu Dinamo-Auto 28 42 45 38
9 Locomotiva Basarabeasca Locomotiva 29 44 58 38
10 Codru Lozova Codru Lozova 29 43 48 37
11 Agro Chisinau Agro 30 53 47 36
12 FC Victoria Bardar Victoria 28 33 61 23
13 MHM-93 MHM-93 29 32 53 22
14 Ciuhur Ciuhur 29 20 97 21
15 Spumante Spumante 19 21 44 13
16 Ungheni Ungheni 27 10 141 1

  USO DE MEMORIA  
6,603,648 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.1345
Total Execution Time  0.1360
  CADENA URL  
/historico/Fc-Victoria-Bardar
  GET DATOS  
$_GET['/historico/Fc-Victoria-Bardar']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0030  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 = 'Fc-Victoria-Bardar' 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.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=13315 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=13315 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=13315 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=13315 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=13315 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0043  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 = 74916
0.0039  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13315 AND type_rel = 2
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=376 AND type_rel = 3
0.0021  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.0022  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.0039  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 = '13315' ORDER BY l.year DESC,cat.coefficient DESC
0.0032  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 = '13315' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0048  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 = '13315' 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 = 74916 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.0034  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 = 13315 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 = 68584 AND t.round = 10 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 `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.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 `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.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 `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.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 `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.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 `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.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 = 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.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 `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.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 `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 = 4176 AND t.round = 22 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 = 3275 AND t.round = 26 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 = 15224 AND t.round = 30 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 `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 = 24999 AND t.round = 22 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 `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 = 25002 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0031  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 `tables1997` 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 = 26371 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 73215 ORDER BY nameShow LIMIT 100