4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1959/1960
Equipo PJ GF GC Puntos
1 Lillestrom SK Lillestrom 14 28 21 19
2 Valerenga IF Valerenga 14 27 21 18
3 Viking Stavanger Viking 14 25 18 16
4 Larvik Turn Larvik Turn 14 32 22 15
5 Greåker IF Greåker IF 14 25 20 14
6 Sandefjord Sandefjord 14 16 18 14
7 SK Brann SK Brann 14 19 29 11
8 IK Start IK Start 14 15 38 5
9 Fredrikstad Fredrikstad 14 41 16 23
10 Eik Tønsberg Tønsberg 14 30 21 17
11 Skeid Skeid 14 30 23 17
12 Rapid Moss Rapid Moss 14 21 26 15
13 Odd Odd 14 25 25 13
14 Strømmen IF Strømmen 14 23 27 13
15 Raufoss IL Raufoss IL 14 20 36 8
16 SK Brage SK Brage 14 14 30 6
Ver
TEMPORADA 1958/1959
Equipo PJ GF GC Puntos
1 Fredrikstad Fredrikstad 14 34 14 22
2 Eik Tønsberg Tønsberg 14 26 15 18
3 Viking Stavanger Viking 14 25 17 17
4 Sandefjord Sandefjord 14 19 21 12
5 SK Brann SK Brann 14 21 27 12
6 Greåker IF Greåker IF 14 19 25 12
7 Asker Asker 14 18 19 11
8 Årstad IL Årstad IL 14 12 36 8
9 Lillestrom SK Lillestrom 14 36 25 19
10 Larvik Turn Larvik Turn 14 38 25 16
11 Strømmen IF Strømmen 14 27 20 16
12 Skeid Skeid 14 28 18 15
13 Raufoss IL Raufoss IL 14 24 19 15
14 Odd Odd 14 23 29 13
15 SK Freidig SK Freidig 14 34 38 12
16 Kapp IF Kapp IF 14 19 55 6
Ver
TEMPORADA 1957/1958
Equipo PJ GF GC Puntos
1 Viking Stavanger Viking 14 32 14 21
2 Larvik Turn Larvik Turn 14 36 22 21
3 Strømmen IF Strømmen 14 29 16 18
4 SK Brann SK Brann 14 26 28 17
5 Raufoss IL Raufoss IL 14 35 30 14
6 Odd Odd 14 30 26 14
7 Frigg Frigg 14 20 38 6
8 Sparta Sarpsborg Sparta 14 10 44 1
9 Skeid Skeid 14 41 13 23
10 Fredrikstad Fredrikstad 14 45 18 21
11 Asker Asker 14 36 26 17
12 Sandefjord Sandefjord 14 16 16 15
13 Lillestrom SK Lillestrom 14 34 32 13
14 Eik Tønsberg Tønsberg 14 22 27 13
15 Molde FK Molde FK 14 18 38 7
16 Steinkjer Steinkjer 14 17 59 3
Ver
TEMPORADA 1956/1957
Equipo PJ GF GC Puntos
1 Odd Odd 14 23 14 20
2 Larvik Turn Larvik Turn 14 25 16 17
3 Sandefjord Sandefjord 14 23 14 17
4 Skeid Skeid 14 25 19 15
5 Viking Stavanger Viking 14 19 15 15
6 Sparta Sarpsborg Sparta 14 17 28 10
7 Årstad IL Årstad IL 14 21 32 9
8 Sarpsborg FK Sarpsborg 14 14 29 9
9 Fredrikstad Fredrikstad 14 60 25 23
10 Strømmen IF Strømmen 14 39 22 18
11 Lillestrom SK Lillestrom 14 21 22 16
12 Asker Asker 14 34 35 14
13 Steinkjer Steinkjer 14 26 41 14
14 Frigg Frigg 14 25 26 12
15 Valerenga IF Valerenga 14 20 29 11
16 Rapid Moss Rapid Moss 14 15 40 4
Ver
TEMPORADA 1955/1956
Equipo PJ GF GC Puntos
1 Larvik Turn Larvik Turn 14 40 15 21
2 Sandefjord Sandefjord 14 26 19 16
3 Viking Stavanger Viking 14 25 26 15
4 Valerenga IF Valerenga 14 23 28 14
5 Rapid Moss Rapid Moss 14 23 26 12
6 Odd Odd 14 18 24 12
7 Varegg Varegg 14 15 32 11
8 Fredrikstad Fredrikstad 14 54 17 27
9 Asker Asker 14 41 16 23
10 Skeid Skeid 14 34 18 17
11 Lillestrom SK Lillestrom 14 19 25 13
12 Frigg Frigg 14 27 37 12
13 SK Brann SK Brann 14 27 27 11
14 Sarpsborg FK Sarpsborg 14 27 30 11
15 Kvik Trondheim Kvik 14 12 44 6
16 Ranheim Ranheim 14 12 39 3
Ver
TEMPORADA 1954/1955
Equipo PJ GF GC Puntos
1 Fredrikstad Fredrikstad 14 43 24 19
2 Viking Stavanger Viking 14 23 24 15
3 Odd Odd 14 20 25 15
4 Valerenga IF Valerenga 14 22 21 14
5 SK Brann SK Brann 14 23 24 14
6 Lillestrom SK Lillestrom 14 27 30 14
7 Fram Fram 14 21 24 13
8 Sparta Sarpsborg Sparta 14 21 28 8
9 Larvik Turn Larvik Turn 14 40 16 21
10 Skeid Skeid 14 34 22 19
11 Sandefjord Sandefjord 14 26 23 19
12 Asker Asker 14 27 20 16
13 Sarpsborg FK Sarpsborg 14 27 33 14
14 Ranheim Ranheim 14 20 29 10
15 Strømmen IF Strømmen 14 22 27 7
16 SK Freidig SK Freidig 14 13 39 6
Ver
TEMPORADA 1953/1954
Equipo PJ GF GC Puntos
1 Skeid Skeid 14 33 14 22
2 Sparta Sarpsborg Sparta 14 29 17 21
3 Asker Asker 14 35 21 18
4 Larvik Turn Larvik Turn 14 35 24 16
5 Viking Stavanger Viking 14 19 20 13
6 Sandefjord Sandefjord 14 20 22 11
7 Varegg Varegg 14 16 38 8
8 Nordnes IL Nordnes IL 14 8 39 3
9 Fredrikstad Fredrikstad 14 47 20 21
10 Strømmen IF Strømmen 14 32 17 20
11 Lillestrom SK Lillestrom 14 45 22 19
12 Odd Odd 14 26 25 14
13 Sarpsborg FK Sarpsborg 14 24 29 12
14 SK Freidig SK Freidig 14 20 26 11
15 Geithus IL Geithus IL 14 18 45 8
16 Moss Moss 14 23 51 7
Ver
TEMPORADA 1952/1953
Equipo PJ GF GC Puntos
1 Skeid Skeid 14 48 10 23
2 Fredrikstad Fredrikstad 14 40 19 18
3 Sarpsborg FK Sarpsborg 14 20 17 18
4 Viking Stavanger Viking 14 23 17 17
5 Strømmen IF Strømmen 14 30 21 15
6 Varegg Varegg 14 16 39 8
7 SK Brann SK Brann 14 9 36 7
8 Årstad IL Årstad IL 14 11 38 6
9 Larvik Turn Larvik Turn 14 44 11 22
10 Asker Asker 14 20 14 19
11 Lillestrom SK Lillestrom 14 25 22 16
12 Sandefjord Sandefjord 14 25 32 15
13 Odd Odd 14 34 30 13
14 Sparta Sarpsborg Sparta 14 15 22 12
15 Lyn 1896 FK Lyn 1896 FK 14 24 31 8
16 Ranheim Ranheim 14 12 37 7
Ver
TEMPORADA 1951/1952
Equipo PJ GF GC Puntos
1 SK Brann SK Brann 14 27 21 17
2 Skeid Skeid 14 33 19 15
3 Odd Odd 14 30 23 15
4 Viking Stavanger Viking 14 21 19 15
5 Asker Asker 14 27 23 14
6 Årstad IL Årstad IL 14 22 35 14
7 Valerenga IF Valerenga 14 25 22 13
8 Ørn Horten Ørn Horten 14 21 44 9
9 Fredrikstad Fredrikstad 14 41 16 26
10 Sarpsborg FK Sarpsborg 14 22 15 17
11 Sparta Sarpsborg Sparta 14 18 18 14
12 Lyn 1896 FK Lyn 1896 FK 14 19 20 14
13 Sandefjord Sandefjord 14 16 19 13
14 Strømmen IF Strømmen 14 25 23 12
15 Kvik Trondheim Kvik 14 23 25 12
16 Notodden Notodden 14 9 37 4
Ver
TEMPORADA 1950/1951
Equipo PJ GF GC Puntos
1 Fredrikstad Fredrikstad 14 44 14 23
2 Valerenga IF Valerenga 14 35 21 19
3 Sandefjord Sandefjord 14 24 23 14
4 Viking Stavanger Viking 14 19 18 14
5 SK Brann SK Brann 14 24 30 13
6 Strømmen IF Strømmen 14 22 29 13
7 Lisleby FK Lisleby FK 14 21 35 9
8 Fram Fram 14 14 33 7
9 Odd Odd 14 31 13 20
10 Lyn 1896 FK Lyn 1896 FK 14 41 18 19
11 Sparta Sarpsborg Sparta 14 19 16 16
12 Skeid Skeid 14 29 28 16
13 Sarpsborg FK Sarpsborg 14 20 21 13
14 Ørn Horten Ørn Horten 14 23 25 13
15 Selbak Turn og IF Selbak Turn 14 22 25 11
16 Kristiansund BK Kristiansund 14 16 55 4
Ver
TEMPORADA 1949/1950
Equipo PJ GF GC Puntos
1 Fram Fram 14 22 13 20
2 Sarpsborg FK Sarpsborg 14 24 17 17
3 Viking Stavanger Viking 14 28 20 16
4 Valerenga IF Valerenga 14 23 24 16
5 Lyn 1896 FK Lyn 1896 FK 14 21 21 13
6 Selbak Turn og IF Selbak Turn 14 17 21 13
7 Ålgård Ålgård 14 8 18 9
8 Storm BK Storm BK 14 18 27 8
9 Fredrikstad Fredrikstad 14 38 11 21
10 Sparta Sarpsborg Sparta 14 26 9 21
11 Ørn Horten Ørn Horten 14 32 24 17
12 Skeid Skeid 14 19 18 16
13 Strømmen IF Strømmen 14 19 25 13
14 Sandefjord Sandefjord 14 15 25 11
15 Ranheim Ranheim 14 10 29 9
16 Mjøndalen IF Mjøndalen 14 9 27 4
Ver
TEMPORADA 1948/1949
Equipo PJ GF GC Puntos
1 Valerenga IF Valerenga 14 23 13 20
2 Sparta Sarpsborg Sparta 14 30 18 19
3 Viking Stavanger Viking 14 25 18 18
4 Ålgård Ålgård 14 18 17 17
5 Skeid Skeid 14 34 25 14
6 Ørn Horten Ørn Horten 14 25 23 14
7 Pors Grenland Pors 14 11 34 6
8 SK Brann SK Brann 14 25 43 4
9 Fredrikstad Fredrikstad 14 29 10 22
10 Sarpsborg FK Sarpsborg 14 26 14 18
11 Lyn 1896 FK Lyn 1896 FK 14 19 17 16
12 Sandefjord Sandefjord 14 25 20 15
13 Mjøndalen IF Mjøndalen 14 18 26 12
14 Storm BK Storm BK 14 15 24 12
15 SK Freidig SK Freidig 14 15 27 9
16 Sandaker SFK Sandaker 14 22 31 8
Ver
TEMPORADA 1947/1948
Equipo PJ GF GC Puntos
1 Viking Stavanger Viking 2 6 3 6
2 Storm BK Storm BK 2 4 1 6
3 Mjøndalen IF Mjøndalen 2 4 2 4
4 Valerenga IF Valerenga 2 2 4 1
5 Donn Donn 2 3 6 0
6 Ørn Horten Ørn Horten 2 1 4 0
Ver
TEMPORADA 1938/1939
Equipo PJ GF GC Puntos
1 Stavanger IF Stavanger 2 4 2 6
2 Skeid Skeid 2 5 2 4
3 Ørn Horten Ørn Horten 2 4 2 3
4 Odd Odd 2 2 4 3
5 Nydalen Nydalen 2 2 5 1
6 Flekkefjord Flekkefjord 2 2 4 0
Ver
TEMPORADA 1937/1938
Equipo PJ GF GC Puntos
1 Viking Stavanger Viking 2 3 0 4
2 Fram Fram 2 2 1 4
3 Lyn 1896 FK Lyn 1896 FK 2 2 1 4
4 Mjøndalen IF Mjøndalen 2 1 2 1
5 Odd Odd 2 1 2 1
6 Vigør Vigør 2 0 3 1

  USO DE MEMORIA  
6,484,720 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0989
Total Execution Time  0.1008
  CADENA URL  
/noruega1960/grupo1/historico
  GET DATOS  
$_GET['/noruega1960/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (28)  
0.0018  SELECT type FROM routes WHERE alias = 'noruega1960'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'noruega' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1960 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 10852 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 18 AND group_code = 1 and tables = 1 AND year <= 1960 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1960` 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 = 10852 AND t.round = 14 ORDER BY team.conference 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 `tables1959` 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 = 10851 AND t.round = 14 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 `tables1958` 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 = 10850 AND t.round = 14 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 `tables1957` 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 = 10849 AND t.round = 14 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 `tables1956` 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 = 10848 AND t.round = 14 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 `tables1955` 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 = 10847 AND t.round = 14 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 `tables1954` 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 = 10846 AND t.round = 14 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 `tables1953` 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 = 10845 AND t.round = 14 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 `tables1952` 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 = 10844 AND t.round = 14 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 `tables1951` 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 = 10843 AND t.round = 14 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 `tables1950` 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 = 10842 AND t.round = 14 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 `tables1949` 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 = 10841 AND t.round = 14 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 `tables1948` 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 = 26732 AND t.round = 1 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 `tables1939` 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 = 26722 AND t.round = 1 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 `tables1938` 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 = 26708 AND t.round = 2 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 02:54:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 02:54:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 02:54:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 02:54:40' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'noruega' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 1960 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1960 e ON e.player_id = p.id AND e.league_id = 10852 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10852 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1960 e ON e.player_id = p.id AND e.league_id = 10852 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10852 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1960 e ON e.player_id = p.id AND e.league_id = 10852 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 10852 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0033  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1960` 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 = 10852 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC