4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Notch
TEMPORADA 2023/2024
LIGA SURINAM
Equipo PJ GF GC Puntos
1 Transvaal Transvaal 9 21 4 23
2 SV Robinhood Robinhood 9 27 8 19
3 Notch Notch 9 17 5 18
4 Inter Moengotapoe Inter 9 20 13 17
5 Voorwaarts Voorwaarts 9 10 6 15
6 PVV PVV 9 19 13 13
7 Flora Flora 9 10 21 10
8 FC Inter Wanica Inter Wanica 9 8 25 5
9 Leo Victor Leo Victor 9 7 25 3
10 Broki Broki 9 8 27 3
TEMPORADA 2022/2023
LIGA SURINAM
Equipo PJ GF GC Puntos
1 SV Robinhood Robinhood 24 94 20 62
2 Inter Moengotapoe Inter 24 66 32 47
3 Notch Notch 24 44 33 43
4 PVV PVV 24 42 25 43
5 Leo Victor Leo Victor 24 65 43 41
6 Transvaal Transvaal 24 53 37 41
7 Voorwaarts Voorwaarts 24 31 29 36
8 Broki Broki 24 38 52 30
9 SNL SNL 24 35 51 26
10 Flora Flora 24 36 57 24
11 Slee Juniors Slee Juniors 24 46 51 23
12 FC Inter Wanica Inter Wanica 24 30 66 18
13 Santos Santos 24 20 104 6
14 Bintang Lair Bintang Lair 0 0 0 0
TEMPORADA 2021/2022
LIGA SURINAM
Equipo PJ GF GC Puntos
1 SV Robinhood Robinhood 21 76 19 53
2 Inter Moengotapoe Inter 22 78 27 53
3 Leo Victor Leo Victor 22 50 27 40
4 Notch Notch 21 45 31 39
5 Voorwaarts Voorwaarts 22 54 31 36
6 FC Inter Wanica Inter Wanica 22 47 54 33
7 Transvaal Transvaal 22 35 38 30
8 Broki Broki 22 41 49 30
9 PVV PVV 21 45 31 28
10 Santos Santos 21 29 72 13
11 Bintang Lair Bintang Lair 21 26 95 10
12 SNL SNL 21 21 73 9
TEMPORADA 2019/2020
LIGA SURINAM
Equipo PJ GF GC Puntos
1 SV Robinhood Robinhood 11 29 11 25
2 Inter Moengotapoe Inter 10 23 6 24
3 Leo Victor Leo Victor 10 17 13 20
4 Notch Notch 11 26 21 20
5 Broki Broki 10 26 16 18
6 Transvaal Transvaal 11 20 19 18
7 PVV PVV 10 16 11 17
8 Bintang Lair Bintang Lair 11 20 22 16
9 West United West United 11 14 13 14
10 SNL SNL 12 12 28 11
11 Voorwaarts Voorwaarts 11 22 19 10
12 Acoconut Acoconut 10 12 24 6
13 FC Inter Wanica Inter Wanica 11 13 28 6
14 Santos Santos 11 16 35 2
TEMPORADA 2018/2019
LIGA SURINAM
Equipo PJ GF GC Puntos
1 Inter Moengotapoe Inter 30 75 28 77
2 SV Robinhood Robinhood 30 95 22 76
3 Leo Victor Leo Victor 30 69 34 66
4 Transvaal Transvaal 29 66 33 58
5 PVV PVV 30 63 39 54
6 WBC WBC 30 57 43 52
7 SNL SNL 30 65 54 48
8 West United West United 30 40 47 35
9 Notch Notch 30 39 63 34
10 Voorwaarts Voorwaarts 30 47 48 32
11 Broki Broki 30 52 61 32
12 Santos Santos 30 45 60 32
13 Nishan '42 Nishan '42 30 50 76 29
14 Acoconut Acoconut 30 51 87 23
15 Papatam Papatam 30 45 91 19
16 Botopasie Botopasie 29 29 102 12
TEMPORADA 2017/2018
LIGA SURINAM
Equipo PJ GF GC Puntos
1 SV Robinhood Robinhood 24 74 27 57
2 Transvaal Transvaal 24 52 25 52
3 Notch Notch 24 50 24 52
4 Inter Moengotapoe Inter 24 55 24 43
5 WBC WBC 24 53 43 42
6 Leo Victor Leo Victor 24 38 24 39
7 PVV PVV 24 47 50 35
8 Botopasie Botopasie 24 41 55 31
9 Voorwaarts Voorwaarts 24 35 43 28
10 West United West United 24 34 51 24
11 Papatam Papatam 24 27 73 13
12 Nishan '42 Nishan '42 24 32 63 12
13 SNL SNL 24 21 57 11
TEMPORADA 2016/2017
LIGA SURINAM
Equipo PJ GF GC Puntos
1 Leo Victor Leo Victor 22 49 20 49
2 Inter Moengotapoe Inter 22 47 19 49
3 WBC WBC 22 58 31 47
4 SV Robinhood Robinhood 22 59 29 43
5 Nishan '42 Nishan '42 22 34 33 30
6 Transvaal Transvaal 22 28 30 29
7 Botopasie Botopasie 22 39 40 27
8 Voorwaarts Voorwaarts 21 23 36 24
9 PVV PVV 22 31 50 20
10 Jong Rambaan Jong Rambaan 22 32 58 19
11 Notch Notch 22 22 47 18
12 SNL SNL 21 16 45 11
TEMPORADA 2015/2016
LIGA SURINAM
Equipo PJ GF GC Puntos
1 Inter Moengotapoe Inter 18 42 21 40
2 Transvaal Transvaal 18 33 24 32
3 Leo Victor Leo Victor 17 22 16 27
4 Nishan '42 Nishan '42 18 38 31 26
5 WBC WBC 18 40 37 26
6 Botopasie Botopasie 18 33 38 24
7 SV Robinhood Robinhood 18 27 31 21
8 Notch Notch 17 23 30 21
9 Takdier Boys Takdier Boys 18 24 30 20
10 Excelsior Meerzorg Excelsior 18 23 47 12
TEMPORADA 2014/2015
LIGA SURINAM
Equipo PJ GF GC Puntos
1 Inter Moengotapoe Inter 18 40 12 40
2 Notch Notch 18 40 18 39
3 WBC WBC 18 46 28 34
4 Leo Victor Leo Victor 18 42 29 30
5 Transvaal Transvaal 18 24 37 23
6 Botopasie Botopasie 18 31 37 22
7 Excelsior Meerzorg Excelsior 18 25 33 22
8 Takdier Boys Takdier Boys 18 30 44 18
9 Boma Star Boma Star 18 25 40 16
10 SNL SNL 18 18 43 9
TEMPORADA 2013/2014
LIGA SURINAM GRUPO 1
Equipo PJ GF GC Puntos
1 Inter Moengotapoe Inter 18 42 17 44
2 Excelsior Meerzorg Excelsior 18 40 28 38
3 Leo Victor Leo Victor 18 38 20 32
4 WBC WBC 18 46 28 29
5 SNL SNL 18 36 39 25
6 Notch Notch 18 26 30 19
7 Takdier Boys Takdier Boys 18 24 31 19
8 Transvaal Transvaal 18 19 30 18
9 Boskamp Boskamp 18 30 45 18
10 SV Robinhood Robinhood 18 20 53 6
TEMPORADA 2012/2013
LIGA SURINAM
Equipo PJ GF GC Puntos
1 Inter Moengotapoe Inter 18 49 13 45
2 Notch Notch 18 35 21 36
3 Leo Victor Leo Victor 18 34 21 30
4 WBC WBC 18 40 31 27
5 Excelsior Meerzorg Excelsior 18 32 36 27
6 Transvaal Transvaal 18 33 32 26
7 Boskamp Boskamp 18 18 34 19
8 SV Robinhood Robinhood 18 18 29 18
9 SNL SNL 18 33 40 17
10 Randjiet Boys Randjiet 18 15 50 12
TEMPORADA 2011/2012
LIGA SURINAM
Equipo PJ GF GC Puntos
1 SV Robinhood Robinhood 27 75 29 61
2 Inter Moengotapoe Inter 27 56 32 50
3 WBC WBC 27 55 44 48
4 Leo Victor Leo Victor 27 49 40 46
5 Transvaal Transvaal 27 38 28 42
6 Boskamp Boskamp 27 49 62 31
7 Notch Notch 27 37 56 30
8 Excelsior Meerzorg Excelsior 27 41 58 29
9 Voorwaarts Voorwaarts 27 38 54 27
10 Kamal Dewaker Kamal 27 19 54 15
TEMPORADA 2010/2011
SEGUNDA SURINAM
Equipo PJ GF GC Puntos
1 Notch Notch 7 14 6 15
2 Boma Star Boma Star 7 15 6 14
3 FCS Nacional Nacional 7 16 15 13
4 SNL SNL 7 17 8 12
5 Real Saramacca Real 7 14 9 12
6 Takdier Boys Takdier Boys 7 13 11 12
7 De Ster De Ster 7 10 12 12
8 Tammenga Tammenga 7 19 22 12
9 Randjiet Boys Randjiet 7 12 11 10
10 SV Jai Hanuman Hanuman 7 9 16 4
11 Fortuna 75 Lelydorp Fortuna 7 11 23 4
12 Inter Rica Inter Rica 7 6 17 3
TEMPORADA 2009/2010
SEGUNDA SURINAM
Equipo PJ GF GC Puntos
1 Kamal Dewaker Kamal 24 56 24 50
2 Excelsior Meerzorg Excelsior 24 66 32 49
3 SNL SNL 24 45 20 46
4 Tammenga Tammenga 24 75 46 44
5 Randjiet Boys Randjiet 24 50 34 37
6 Notch Notch 24 33 27 36
7 Takdier Boys Takdier Boys 24 42 40 36
8 Inter Rica Inter Rica 24 34 41 33
9 De Ster De Ster 24 39 49 29
10 Peto Peto 24 30 50 24
11 Royal 95 Royal 95 24 27 46 19
12 Young Rhythm Young Rhythm 24 22 68 17
13 Super Red Eagles Super Eagles 24 31 73 16
TEMPORADA 2008/2009
SEGUNDA SURINAM
Equipo PJ GF GC Puntos
1 SV Jai Hanuman Hanuman 24 59 32 52
2 The Brothers Brothers 23 60 35 45
3 Kamal Dewaker Kamal 24 46 36 40
4 Randjiet Boys Randjiet 22 30 27 37
5 Young Rhythm Young Rhythm 23 40 32 36
6 SNL SNL 24 42 25 35
7 Royal 95 Royal 95 23 32 41 33
8 Notch Notch 24 46 39 31
9 De Ster De Ster 24 44 61 31
10 Eendracht Livorno Eendracht 24 34 39 29
11 Fortuna 75 Lelydorp Fortuna 24 48 54 27
12 Pechan Uitkijk Pechan 24 41 52 25
13 PSV PSV 23 26 75 4
TEMPORADA 2007/2008
SEGUNDA SURINAM
Equipo PJ GF GC Puntos
1 Takdier Boys Takdier Boys 20 44 26 39
2 Excelsior Meerzorg Excelsior 20 53 31 38
3 Young Rhythm Young Rhythm 20 50 32 36
4 Kamal Dewaker Kamal 20 42 25 33
5 SNL SNL 20 36 28 33
6 Notch Notch 20 33 25 32
7 Eendracht Livorno Eendracht 20 30 23 30
8 Fortuna 75 Lelydorp Fortuna 20 31 39 29
9 Pechan Uitkijk Pechan 20 29 35 21
10 Lavoco Lavoco 20 26 47 14
11 Cosmos Cosmos 20 11 74 1

  USO DE MEMORIA  
6,096,016 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5791
Total Execution Time  0.5803
  CADENA URL  
/historico/Notch
  GET DATOS  
$_GET['/historico/Notch']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0136  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 = 'Notch' 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.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=57377 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=57377 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=57377 AND type_rel = 2
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1419 AND type_rel = 3
0.0130  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 = '57377' ORDER BY l.year DESC,cat.coefficient DESC
0.0127  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 = '57377' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0148  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 = '57377' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0141  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=57377 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0128  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 (75400) 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.0128  SELECT count(id) as num_players from rel_players WHERE league_id = 75400 AND teamId = 57377
0.0133  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 = 75400 AND t.round = 9 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0127  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 = '57377' 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 = '57377' and rp.type = 4
0.0126  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 = '57377' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0127  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 = 75400 WHERE rp.league_id = 75400 AND rp.teamId = 57377 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.0128  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 = 75400 WHERE rp.league_id = 75400 AND rp.teamId = 57377 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 75400 WHERE rp.league_id = 75400 AND rp.teamId = 57377 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0134  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 = 57377 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 = 75400 AND t.round = 9 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 `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 = 70867 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.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 `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 = 66863 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.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 `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 = 51804 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 `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 = 47388 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 `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 = 41046 AND t.round = 26 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 `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 = 37147 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 = 15666 AND t.round = 18 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 `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 = 8369 AND t.round = 18 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 = 28207 AND t.round = 18 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 `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 = 28214 AND t.round = 18 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 `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 = 28226 AND t.round = 27 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 `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 = 49037 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 `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 = 49038 AND t.round = 26 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 `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 = 49039 AND t.round = 16 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 `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 = 49040 AND t.round = 11 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0126  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 = 75400 ORDER BY nameShow LIMIT 100