4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 1984/1985
Equipo PJ GF GC Puntos
1 Yalovaspor Yalovaspor 30 48 18 65
2 Golcukspor Golcukspor 29 36 12 64
3 Pendikspor Pendikspor 30 51 26 60
4 Kocaeli BB Kağıtspor Kocaeli 30 57 32 54
5 Erdemir Ereğlispor Erdemir 30 35 22 53
6 Beykozspor Beykozspor 30 38 29 47
7 Anadolu Hisarı Anadolu 30 26 21 41
8 Kartalspor Kartalspor 30 32 36 38
9 İstanbul THY İstanbul 30 25 37 33
10 Galatasaray II Galatasaray 29 26 26 32
11 Taksim Taksim 30 29 49 32
12 Çengelköyspor Çengelköys 30 40 49 31
13 Umraniyespor Umraniyespor 30 30 51 30
14 Gebzespor Gebzespor 30 23 42 24
15 Sakarya Karadenizspor Sakarya 30 27 53 23
16 Beylerbeyispor Beylerbeyisp 30 28 48 19
Ver
TEMPORADA 1979/1980
Equipo PJ GF GC Puntos
1 Tarsus Idman Yurdu Tarsus Idman 28 43 25 56
2 Hatayspor Hatayspor 28 29 29 43
3 Malatyaspor Malatyaspor 28 34 32 39
4 Erzincanspor Erzincanspor 28 25 35 38
5 Konyaspor Konyaspor 28 32 33 35
6 Corumspor Corumspor 28 20 24 35
7 Tokatspor Tokatspor 28 26 31 35
8 Gençlerbirliği SK Gençlerbirl 28 28 28 32
Ver
TEMPORADA 1978/1979
Equipo PJ GF GC Puntos
1 Erzurumspor Erzurumspor 20 23 15 38
2 Tarsus Idman Yurdu Tarsus Idman 20 29 13 37
3 Giresunspor Giresunspor 20 20 9 34
4 Hatayspor Hatayspor 20 23 17 29
5 Tokatspor Tokatspor 20 21 21 28
6 Erzincanspor Erzincanspor 20 18 16 27
7 Malatyaspor Malatyaspor 20 14 24 27
8 Corumspor Corumspor 20 13 17 25
9 Petrol Ofisi SK Petrol Ofisi 20 19 21 23
10 Konya Ereğlispor Konya 20 14 25 20
11 İskenderunspor İskenderuns 20 15 31 14
Ver
TEMPORADA 1977/1978
Equipo PJ GF GC Puntos
1 Akçaabat Sebatspor Akçaabat 24 31 16 47
2 Erzurumspor Erzurumspor 24 31 22 41
3 Tarsus Idman Yurdu Tarsus Idman 24 26 17 41
4 Tokatspor Tokatspor 24 18 12 41
5 Hatayspor Hatayspor 24 22 23 35
6 Fatih Karagümrük Fatih 24 27 21 32
7 Corumspor Corumspor 24 20 23 32
8 Karsiyaka Karsiyaka 24 26 19 31
9 Ödemisspor Ödemisspor 24 26 30 29
10 Kirklarelispor Kirklarelisp 24 18 29 28
11 Kütahyaspor Kütahyaspor 24 16 22 27
12 Alibeykoyspor Alibeykoyspo 24 14 24 25
13 Keciorengucu Keciorengucu 24 11 28 15
Ver
TEMPORADA 1976/1977
Equipo PJ GF GC Puntos
1 Düzcespor Düzcespor 20 22 11 43
2 Usakspor Usakspor 20 26 13 38
3 Karsiyaka Karsiyaka 20 20 12 31
4 Petrol Ofisi SK Petrol Ofisi 20 19 18 29
5 Izmirspor Izmirspor 20 18 14 27
6 Konya Ereğlispor Konya 20 16 18 26
7 Ödemisspor Ödemisspor 20 18 17 23
8 Kütahyaspor Kütahyaspor 20 10 14 23
9 Kastamonuspor Kastamonuspo 20 21 26 23
10 Canakkale Dardanelspor Canakkale 20 15 23 22
11 Yeşilovaspor Yeşilovaspo 20 11 30 14
Ver
TEMPORADA 1975/1976
Equipo PJ GF GC Puntos
1 Ispartaspor Ispartaspor 30 58 14 66
2 Istanbulspor AS Istanbulspor 30 54 16 64
3 Izmirspor Izmirspor 30 47 26 57
4 Karsiyaka Karsiyaka 30 31 18 53
5 Kirklarelispor Kirklarelisp 30 24 19 50
6 Ödemisspor Ödemisspor 29 37 25 47
7 Tekirdağspor Tekirdağspo 30 38 28 42
8 Yeşilovaspor Yeşilovaspo 30 32 30 38
9 Kasımpaşa Kasımpaşa 30 22 33 36
10 Lüleburgazspor Lüleburgazs 30 18 24 35
11 Canakkale Dardanelspor Canakkale 30 24 34 35
12 Edirnespor Edirnespor 30 24 39 33
13 Alibeykoyspor Alibeykoyspo 30 22 42 29
14 Düzcespor Düzcespor 29 21 33 28
15 Usakspor Usakspor 30 16 44 17
16 Küçükçekmecespor Küçükçek 30 16 59 16
Ver
TEMPORADA 1974/1975
Equipo PJ GF GC Puntos
1 Bandirmaspor Bandirmaspor 31 44 18 62
2 Ispartaspor Ispartaspor 32 39 17 56
3 Izmirspor Izmirspor 32 37 23 50
4 Tekirdağspor Tekirdağspo 32 37 25 49
5 Karsiyaka Karsiyaka 32 30 25 49
6 Ödemisspor Ödemisspor 32 32 34 46
7 Alibeykoyspor Alibeykoyspo 32 30 36 42
8 Lüleburgazspor Lüleburgazs 32 26 33 42
9 Kirklarelispor Kirklarelisp 32 27 26 41
10 Kasımpaşa Kasımpaşa 32 23 26 40
11 Edirnespor Edirnespor 32 28 32 40
12 Düzcespor Düzcespor 32 19 23 40
13 Petrol Ofisi SK Petrol Ofisi 32 26 28 37
14 Yeşilovaspor Yeşilovaspo 32 19 27 37
15 Küçükçekmecespor Küçükçek 32 22 42 37
16 Canakkale Dardanelspor Canakkale 31 19 34 33
17 Feriköy Feriköy 32 24 33 32
Ver
TEMPORADA 1973/1974
Equipo PJ GF GC Puntos
1 MKE Kırıkkalespor Kırıkkales 38 62 18 78
2 Ispartaspor Ispartaspor 38 62 31 78
3 Karabükspor Karabükspor 38 40 16 73
4 Izmirspor Izmirspor 38 40 22 62
5 Galata Galata 38 35 33 54
6 Feriköy Feriköy 38 35 31 53
7 Canakkale Dardanelspor Canakkale 38 41 41 51
8 Üsküdar Anadolu Üsküdar 39 38 41 50
9 Karsiyaka Karsiyaka 38 28 32 49
10 Düzcespor Düzcespor 38 32 37 49
11 Kasımpaşa Kasımpaşa 38 30 38 48
12 Tekirdağspor Tekirdağspo 38 26 37 48
13 Kirklarelispor Kirklarelisp 39 37 38 47
14 Edirnespor Edirnespor 38 24 29 47
15 Afjet Afyonspor Afjet 39 27 41 47
16 Yeşilovaspor Yeşilovaspo 37 39 37 45
17 Küçükçekmecespor Küçükçek 38 31 35 45
18 Güneşspor Güneşspor 39 22 35 45
19 Ödemisspor Ödemisspor 38 24 35 44
20 Fatih Karagümrük Fatih 38 28 37 42
21 Keciorengucu Keciorengucu 37 25 35 37
22 Nazilli Belediyespor Nazilli 38 27 54 34
Ver
TEMPORADA 1972/1973
Equipo PJ GF GC Puntos
1 Erzurumspor Erzurumspor 24 44 9 58
2 MKE Kırıkkalespor Kırıkkales 24 30 16 48
3 Akçaabat Sebatspor Akçaabat 24 29 21 44
4 Ceyhanspor Adana Ceyhanspor 23 26 22 35
5 Amasyaspor Amasyaspor 24 27 32 34
6 Kirsehirspor Kirsehirspor 24 22 20 33
7 Keciorengucu Keciorengucu 24 26 35 30
8 Elazigspor Elazigspor 24 18 20 28
9 Petrol Ofisi SK Petrol Ofisi 24 24 23 27
10 Sitespor Sitespor 24 14 23 27
11 Kastamonuspor Kastamonuspo 24 13 21 26
12 Mardinspor Mardinspor 23 12 25 21
13 Toprakofis Toprakofis 24 14 32 15
Ver
TEMPORADA 1971/1972
Equipo PJ GF GC Puntos
1 Beykozspor Beykozspor 28 55 11 64
2 Düzcespor Düzcespor 28 53 16 60
3 Ispartaspor Ispartaspor 27 40 22 47
4 Kirklarelispor Kirklarelisp 28 26 17 44
5 Canakkale Dardanelspor Canakkale 28 36 22 41
6 Edirnespor Edirnespor 27 28 23 40
7 Taksim Taksim 28 25 23 40
8 İzmir Demirspor İzmir 28 24 17 39
9 Fatih Karagümrük Fatih 28 31 30 36
10 Üsküdar Anadolu Üsküdar 28 16 21 36
11 Eyupspor Eyupspor 28 24 46 34
12 Tirespor Tirespor 28 22 25 33
13 Davutpaşa Davutpaşa 28 24 31 33
14 Beylerbeyispor Beylerbeyisp 27 21 33 26
15 Yeşildirek SK Yeşildirek 27 11 99 2
Ver
TEMPORADA 1970/1971
Equipo PJ GF GC Puntos
1 Sariyer Sariyer 26 42 7 64
2 Eskişehir Demirspor Eskişehir 26 59 12 63
3 Lüleburgazspor Lüleburgazs 26 58 15 57
4 Tekirdağspor Tekirdağspo 27 47 19 56
5 Ödemisspor Ödemisspor 26 21 18 46
6 Yedikule GSK Yedikule 26 24 20 38
7 Yeşilovaspor Yeşilovaspo 26 28 23 35
8 Kasımpaşa Kasımpaşa 26 18 30 34
9 Burdurspor Burdurspor 26 25 29 33
10 Alibeykoyspor Alibeykoyspo 26 17 24 28
11 Ülküspor Ülküspor 26 22 35 24
12 Hasköyspor Hasköyspor 26 16 46 18
13 Muğlaspor Muğlaspor 26 16 47 18
14 Küçükçekmecespor Küçükçek 27 13 58 18
15 Beyogluspor Beyogluspor 26 16 39 14
Ver
TEMPORADA 1969/1970
Equipo PJ GF GC Puntos
1 Hatayspor Hatayspor 40 70 19 86
2 İskenderunspor İskenderuns 40 71 26 83
3 Malatyaspor Malatyaspor 40 68 29 83
4 MKE Kırıkkalespor Kırıkkales 40 56 30 68
5 Petrol Ofisi SK Petrol Ofisi 40 50 29 64
6 Rizespor Rizespor 40 45 36 63
7 Amasyaspor Amasyaspor 40 50 34 62
8 Elazigspor Elazigspor 40 56 42 61
9 Corumspor Corumspor 40 37 30 61
10 Erzurumspor Erzurumspor 40 34 38 59
11 Erzincanspor Erzincanspor 40 34 34 56
12 Kirsehirspor Kirsehirspor 40 47 44 54
13 Ceyhanspor Adana Ceyhanspor 40 39 33 49
14 Nevşehir Belediyespor Nevşehir 40 27 44 49
15 Diyarbakirspor Diyarbakirsp 40 27 32 48
16 Yenimahallespor Yenimahalles 40 32 58 39
17 Hacettepe SK Hacettepe 40 32 58 38
18 Konya Ereğlispor Konya 40 30 65 35
19 Sanliurfaspor Sanliurfaspo 40 24 62 35
20 Mardinspor Mardinspor 40 33 77 33
21 Tokatspor Tokatspor 40 27 69 29
Ver
TEMPORADA 1968/1969
Equipo PJ GF GC Puntos
1 Rizespor Rizespor 26 38 16 52
2 Tarsus Idman Yurdu Tarsus Idman 26 42 18 51
3 MKE Kırıkkalespor Kırıkkales 25 27 16 49
4 Malatyaspor Malatyaspor 26 38 17 48
5 İskenderunspor İskenderuns 26 38 18 47
6 Hatayspor Hatayspor 26 28 26 39
7 Corumspor Corumspor 26 31 28 38
8 Amasyaspor Amasyaspor 25 32 27 35
9 Elazigspor Elazigspor 26 32 39 35
10 Diyarbakirspor Diyarbakirsp 26 24 27 32
11 Petrol Ofisi SK Petrol Ofisi 26 19 32 28
12 Hacettepe SK Hacettepe 26 21 45 20
13 Ceyhanspor Adana Ceyhanspor 26 23 45 17
14 Altındağ Altındağ 26 9 48 8
Ver
TEMPORADA 1967/1968
Equipo PJ GF GC Puntos
1 Düzcespor Düzcespor 32 57 17 64
2 MKE Kırıkkalespor Kırıkkales 32 58 46 58
3 İskenderunspor İskenderuns 32 31 21 57
4 Eskişehir Demirspor Eskişehir 32 46 25 56
5 Nazilli Belediyespor Nazilli 32 45 32 53
6 Tekirdağspor Tekirdağspo 32 27 21 51
7 Konya İdman Yurdu Konya İdman 32 38 30 49
8 Hatayspor Hatayspor 32 39 35 46
9 Lüleburgazspor Lüleburgazs 32 41 37 44
10 Canakkale Dardanelspor Canakkale 32 32 29 42
11 Tarsus Idman Yurdu Tarsus Idman 32 42 49 41
12 Beyogluspor Beyogluspor 32 26 37 38
13 Corumspor Corumspor 32 25 34 37
14 Elazigspor Elazigspor 32 30 48 31
15 Muğlaspor Muğlaspor 32 27 55 30
16 Davutpaşa Davutpaşa 32 24 38 25
17 Ceyhanspor Adana Ceyhanspor 32 28 62 22

  USO DE MEMORIA  
6,562,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0951
Total Execution Time  0.0971
  CADENA URL  
/2_lig_turquia1985/grupo1/historico
  GET DATOS  
$_GET['/2_lig_turquia1985/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (24)  
0.0019  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 = 50938 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0026  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 359 AND group_code = 1 and tables = 1 AND year <= 1985 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 `tables1985` 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 = 50938 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 `tables1980` 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 = 50988 AND t.round = 28 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 `tables1979` 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 = 50990 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 `tables1978` 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 = 50992 AND t.round = 26 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 `tables1977` 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 = 50994 AND t.round = 22 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 `tables1976` 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 = 50997 AND t.round = 30 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 `tables1975` 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 = 50999 AND t.round = 34 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 `tables1974` 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 = 51004 AND t.round = 38 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 `tables1973` 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 = 51005 AND t.round = 26 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 `tables1972` 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 = 51009 AND t.round = 30 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 `tables1971` 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 = 51013 AND t.round = 28 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 `tables1970` 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 = 51017 AND t.round = 42 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 `tables1969` 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 = 51019 AND t.round = 26 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 `tables1968` 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 = 51024 AND t.round = 34 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-27 18:33:34' 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-27 18:33:34' 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-27 18:33:34' 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-27 18:33:34' GROUP BY url ORDER BY page_views DESC LIMIT 5
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 events1985 e ON e.player_id = p.id AND e.league_id = 50938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50938 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 events1985 e ON e.player_id = p.id AND e.league_id = 50938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50938 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 events1985 e ON e.player_id = p.id AND e.league_id = 50938 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 50938 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0045  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1985` 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 = 50938 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC