4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Foresta Suceava
TEMPORADA 2019/2020
TERCERA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Aerostar Bacău Aerostar 16 40 10 42
2 Foresta Suceava Foresta 16 44 20 35
3 FC Ceahlaul Piatra Neamt Ceahlaul 16 34 10 33
4 Bucovina Rădăuţi Bucovina 16 35 13 32
5 Focşani Focşani 16 24 14 30
6 Oțelul Galați Oțelul 16 25 20 30
7 Ştiinţa Miroslava Ştiinţa 16 31 20 29
8 Ozana Târgu Neamţ Ozana Târgu 16 30 27 23
9 Şomuz Fălticeni Şomuz 16 20 26 20
10 Sporting Lieşti Sporting 16 24 25 19
11 KSE Târgu Secuiesc Târgu 16 20 22 17
12 Hușana Huși Hușana 16 18 25 17
13 Botosani II Botosani II 16 23 31 16
14 Universitatea Galaţi Universitate 16 15 29 10
15 CSM Bacău CSM Bacău 16 7 26 9
16 Paşcani Paşcani 16 11 83 0
TEMPORADA 2018/2019
TERCERA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Buzău FC Buzău 28 77 17 73
2 Bucovina Rădăuţi Bucovina 28 51 19 57
3 Oțelul Galați Oțelul 28 46 31 53
4 Ştiinţa Miroslava Ştiinţa 28 44 34 50
5 Focşani Focşani 28 41 24 49
6 Foresta Suceava Foresta 28 50 39 49
7 Metalul Buzău Metalul 28 47 35 44
8 Sporting Lieşti Sporting 28 41 36 40
9 KSE Târgu Secuiesc Târgu 28 46 51 37
10 FC Ceahlaul Piatra Neamt Ceahlaul 28 35 34 35
11 Gauss Bacău Gauss Bacău 28 32 46 29
12 Şomuz Fălticeni Şomuz 28 28 54 29
13 Paşcani Paşcani 28 33 51 25
14 Râmnicu Sarat Râmnicu 28 22 51 18
15 Sănătatea Darabani Sănătatea 28 22 93 8
16 Petrotub Roman Petrotub 0 0 0 0
TEMPORADA 2017/2018
SEGUNDA RUMANÍA
Equipo PJ GF GC Puntos
1 Dunărea Călăraşi Dunărea 38 75 24 93
2 Hermannstadt Hermannstadt 38 66 13 91
3 Chindia Târgovişte Chindia 38 71 28 75
4 FC Arges FC Arges 38 61 35 68
5 Afumati Afumati 38 53 32 68
6 LPS HD Clinceni Clinceni 38 63 54 58
7 ASU Politehnica Timisoara Politehnica 38 55 43 57
8 Luceafărul Oradea Luceafărul 38 65 59 53
9 Mioveni Mioveni 38 54 46 52
10 CS Sportul Snagov Sportul 38 51 37 51
11 Ripensia Timisoara Ripensia 38 72 60 48
12 UTA Arad UTA Arad 38 60 55 47
13 Baloteşti Baloteşti 38 54 74 47
14 Pandurii Pandurii 38 49 57 42
15 Brăila Brăila 38 70 72 41
16 Metaloglobus Metaloglobus 38 38 55 41
17 Ştiinţa Miroslava Ştiinţa 38 46 73 37
18 Foresta Suceava Foresta 38 35 106 33
19 Tîrgu Mures Tîrgu Mures 37 38 85 31
20 FC Olimpia Satu Mare Olimpia Satu 37 19 87 0
TEMPORADA 2016/2017
SEGUNDA RUMANÍA
Equipo PJ GF GC Puntos
1 Daco-Getica Daco-Getica 34 77 18 84
2 Sepsi Sepsi 34 62 29 71
3 UTA Arad UTA Arad 34 64 32 66
4 Mioveni Mioveni 34 51 30 59
5 Chindia Târgovişte Chindia 34 57 37 58
6 Dunărea Călăraşi Dunărea 34 52 40 56
7 Afumati Afumati 34 56 36 56
8 FC Brasov FC Brasov 34 49 35 56
9 FC Olimpia Satu Mare Olimpia Satu 34 53 34 54
10 Luceafărul Oradea Luceafărul 34 48 38 47
11 Brăila Brăila 34 37 56 46
12 Foresta Suceava Foresta 34 50 70 41
13 LPS HD Clinceni Clinceni 34 47 69 39
14 ASU Politehnica Timisoara Politehnica 34 48 59 38
15 Baloteşti Baloteşti 33 41 56 37
16 CS Sportul Snagov Sportul 34 35 77 21
17 CSM Râmnicu Vâlcea Râmnicu 33 16 67 18
18 Unirea Tărlungeni Unirea 32 16 76 1
19 Berceni Berceni 0 0 0 0
20 Şoimii Pâncota Şoimii 0 0 0 0
TEMPORADA 2015/2016
SEGUNDA RUMANÍA GRUPO 4
Equipo PJ GF GC Puntos
1 Baloteşti Baloteşti 10 20 8 32
2 Berceni Berceni 10 21 12 30
3 FC Buzău FC Buzău 10 17 20 29
4 Foresta Suceava Foresta 10 21 16 28
5 Bucovina Pojorâta Bucovina 10 23 16 23
6 FC Ceahlaul Piatra Neamt Ceahlaul 10 0 30 5
TEMPORADA 2014/2015
SEGUNDA RUMANÍA GRUPO 3
Equipo PJ GF GC Puntos
1 Voluntari Voluntari 10 23 10 26
2 LPS HD Clinceni Clinceni 10 23 5 21
3 SC Bacău SC Bacău 10 19 15 16
4 FC Buzău FC Buzău 10 17 25 12
5 Brăila Brăila 10 10 17 7
6 Foresta Suceava Foresta 10 11 31 2
TEMPORADA 2013/2014
SEGUNDA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Politehnica Iași Politehnica 22 47 16 49
2 FC Rapid Bucuresti Rapid 22 34 20 41
3 Unirea Slobozia Unirea 22 29 22 41
4 LPS HD Clinceni Clinceni 22 41 28 37
5 Berceni Berceni 22 33 26 36
6 SC Bacău SC Bacău 22 29 31 29
7 Unirea Tărlungeni Unirea 22 18 22 27
8 FC Buzău FC Buzău 22 25 24 25
9 Brăila Brăila 22 24 34 23
10 Foresta Suceava Foresta 22 22 42 19
11 FC Farul Constanta Farul 22 12 35 18
12 Dunărea Galaţi Dunărea 22 24 38 17
13 Sportul Studenţesc Sportul 0 0 0 0
TEMPORADA 2012/2013
SEGUNDA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Botosani Botosani 24 47 19 53
2 Săgeata Năvodari Săgeata 24 43 29 46
3 Delta Tulcea Delta Tulcea 24 45 22 42
4 Otopeni Otopeni 24 37 27 41
5 Brăila Brăila 24 39 35 40
6 LPS HD Clinceni Clinceni 24 34 38 32
7 Unirea Slobozia Unirea 24 35 38 30
8 Dunărea Galaţi Dunărea 24 23 30 28
9 Sportul Studenţesc Sportul 24 28 58 28
10 Foresta Suceava Foresta 24 31 35 27
11 FC Farul Constanta Farul 24 35 41 27
12 Chindia Târgovişte Chindia 24 33 41 26
13 Dinamo Bucureşti II Dinamo 24 27 44 19
14 Callatis Mangalia Callatis 0 0 0 0
15 FC Municipal Bacău Municipal 0 0 0 0
TEMPORADA 2011/2012
TERCERA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 SC Bacău SC Bacău 4 13 4 10
2 Foresta Suceava Foresta 5 12 4 10
3 Sporting Suceava Sporting 5 8 4 10
4 Oţelul Galaţi II Oţelul 5 12 10 10
5 Dorohoi Dorohoi 4 11 4 9
6 Râmnicu Sarat Râmnicu 4 9 4 9
7 Aerostar Bacău Aerostar 6 8 5 9
8 Focşani Focşani 5 5 7 9
9 Panciu Panciu 5 9 6 7
10 Politehnica Galaţi Politehnica 5 8 8 7
11 Ceahlăul II Ceahlăul 6 8 17 5
12 Cetatea Târgu Neamţ Cetatea 6 5 10 4
13 Paşcani Paşcani 5 3 9 4
14 Petrotub Roman Petrotub 6 6 13 3
15 ABC St. Stoicescu Stoicescu 5 4 16 3
TEMPORADA 2010/2011
TERCERA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 FC Municipal Bacău Municipal 26 78 12 72
2 SC Bacău SC Bacău 26 57 11 62
3 Petrotub Roman Petrotub 26 43 18 49
4 Paşcani Paşcani 26 40 41 38
5 Panciu Panciu 26 41 33 36
6 Oţelul Galaţi II Oţelul 26 37 31 36
7 Politehnica Galaţi Politehnica 26 28 32 36
8 Ceahlăul II Ceahlăul 26 27 36 33
9 Onesti Onesti 26 29 37 32
10 Aerostar Bacău Aerostar 26 34 45 31
11 Cetatea Târgu Neamţ Cetatea 26 26 64 30
12 Foresta Suceava Foresta 26 31 38 29
13 Focşani Focşani 26 26 45 24
14 Luceafarul Eminescu Luceafarul 26 19 73 12
15 Cetatea Suceava Cetatea 0 0 0 0
16 Willy Bacau Willy Bacau 0 0 0 0
TEMPORADA 2009/2010
TERCERA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Brăila Brăila 32 90 18 81
2 Panciu Panciu 32 64 32 66
3 Petrotub Roman Petrotub 32 68 30 64
4 FC Politehnica Iasi II Politehnica 32 60 37 57
5 Foresta Suceava Foresta 32 58 42 51
6 Ceahlăul II Ceahlăul 32 44 47 50
7 Willy Bacau Willy Bacau 32 61 58 48
8 Politehnica Galaţi Politehnica 32 49 47 48
9 Cetatea Târgu Neamţ Cetatea 32 47 46 48
10 Oţelul Galaţi II Oţelul 32 51 36 46
11 Focşani Focşani 32 35 31 45
12 Aerostar Bacău Aerostar 32 52 46 44
13 Pambac Bacau Pambac Bacau 32 44 48 43
14 Paşcani Paşcani 32 43 53 38
15 Dunărea Galaţi II Dunărea 32 22 66 22
16 FC Vaslui II Vaslui 32 24 102 16
17 Gura Homorului Gura 32 8 81 8
TEMPORADA 2008/2009
TERCERA RUMANÍA GRUPO 1
Equipo PJ GF GC Puntos
1 Olimpia Ramnicu Sarat Olimpia 33 70 12 83
2 Oţelul Galaţi II Oţelul 34 97 29 74
3 Pambac Bacau Pambac Bacau 34 72 36 74
4 Focşani Focşani 34 71 36 61
5 Panciu Panciu 34 50 28 59
6 Petrotub Roman Petrotub 33 45 23 58
7 Aerostar Bacău Aerostar 34 57 26 57
8 Voluntari Voluntari 34 53 33 53
9 Foresta Suceava Foresta 34 54 32 51
10 FC Politehnica Iasi II Politehnica 34 56 52 50
11 Paşcani Paşcani 34 39 61 43
12 Cetatea Târgu Neamţ Cetatea 34 39 51 40
13 Willy Bacau Willy Bacau 34 59 60 39
14 Ceahlăul II Ceahlăul 34 47 70 33
15 Raraul Raraul 34 25 124 30
16 FCM Bacău II Bacău 32 19 68 17
17 FC Barlad FC Barlad 32 17 69 17
18 Luceafarul Eminescu Luceafarul 32 11 71 13

  USO DE MEMORIA  
6,383,624 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7844
Total Execution Time  0.7856
  CADENA URL  
/historico/Rapid-Suceava/2020
  GET DATOS  
$_GET['/historico/Rapid-Suceava/2020']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0192  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 = 'Rapid-Suceava' AND l.year = 2020 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.0146  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=8967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=8967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=8967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=8967 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 50676
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=8967 AND type_rel = 2
0.0148  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=284 AND type_rel = 3
0.0154  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 284 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0157  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 (1187764,918096,808298,20463) ORDER BY n.cover_points DESC, update_date DESC
0.0170  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 = '8967' AND l.year = 2020 ORDER BY l.year DESC,cat.coefficient DESC
0.0184  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 = '8967' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0189  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 = 50676 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0150  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 = 51098 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=8967 AND l.year in (2019,2020,2021) ORDER BY l.id DESC, l.year DESC ;
0.0145  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 (62542,58603,49506) 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.0146  SELECT count(id) as num_players from rel_players WHERE league_id = 62542 AND teamId = 8967
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 58603 AND teamId = 8967
0.0147  SELECT count(id) as num_players from rel_players WHERE league_id = 49506 AND teamId = 8967
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 51098 AND t.round = 16 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0148  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 = '8967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0146  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '8967' and rp.type = 4
0.0154  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 = '8967' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0155  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 events2020 e ON e.player_id = p.id AND e.league_id = 51098 WHERE rp.league_id = 51098 AND rp.teamId = 8967 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.0152  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 events2020 e ON e.player_id = p.id AND e.league_id = 51098 WHERE rp.league_id = 51098 AND rp.teamId = 8967 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 events2020 e ON e.player_id = p.id AND e.league_id = 51098 WHERE rp.league_id = 51098 AND rp.teamId = 8967 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 = 8967 AND l.year <= 2020 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0148  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 = 51098 AND t.round = 16 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 44929 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 38850 AND t.round = 38 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 `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 = 33804 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 15516 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 24173 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 4437 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0158  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 = 11796 AND t.round = 10 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 2739 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0161  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 = 2192 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  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 = 1855 AND t.round = 6 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 25910 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0167  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 = 25866 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 25147 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  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 = 51098 ORDER BY nameShow LIMIT 100