4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Çatalca Spor

Çatalca Spor

Entrenador: Armagan Turhan

Temporada 2023/2024
TEMPORADA 2023/2024
3. LIG GRUPO 4
Equipo PJ GF GC Puntos
1 Adana 1954 FK Adana 1954 28 60 27 63
2 Sebat Gençlik SK Sebat 28 42 27 50
3 Muş Menderesspor Muş 28 41 29 47
4 Tokat Bld Plevnespor Tokat 28 32 27 45
5 Alanya Kestelspor Alanya 28 42 33 43
6 Bursa Yıldırımspor Bursa 28 39 34 42
7 Orduspor 1967 Orduspor 28 49 33 41
8 Balikesirspor Balikesirspo 28 28 32 33
9 Bergama Belediyespor Bergama 28 34 39 31
10 Çankaya FK Çankaya FK 28 26 37 31
11 23 Elazig 23 Elazig 28 25 42 31
12 Nevşehir Belediyespor Nevşehir 28 19 31 30
13 Siirt İl Özel İdaresi Siirt Özel 28 21 32 29
14 Çatalca Spor Çatalca 28 27 38 26
15 Sultanbeyli Belediyespor Sultanbeyli 28 26 50 25
TEMPORADA 2022/2023
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Mersin Mersin 34 49 21 68
2 Belediye Derincespor Belediye 34 51 24 66
3 Belediye Kütahyaspor Belediye 34 52 34 65
4 52 Orduspor 52 Orduspor 34 54 34 64
5 Nevşehir Belediyespor Nevşehir 34 52 40 58
6 Karaköprü Bld. Karaköprü 34 44 32 56
7 Karsiyaka Karsiyaka 34 44 28 54
8 Çatalca Spor Çatalca 34 40 39 44
9 Yeni Amasyaspor Yeni 34 33 36 44
10 Elazigspor Elazigspor 34 44 53 42
11 1922 Konyaspor 1922 34 42 47 41
12 Hacettepe SK Hacettepe 34 41 50 36
13 Ağrı Spor Ağrı Spor 34 23 39 36
14 Edirnespor Edirnespor 34 35 45 35
15 1954 Kelkit Belediyespor 1954 Kelkit 34 25 35 35
16 Yomraspor Yomraspor 34 36 42 34
17 Eskişehirspor Eskişehirsp 34 39 69 26
18 Sile Yildizspor Sile 34 29 65 26
TEMPORADA 2021/2022
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Batman Petrolspor Batman 34 55 29 74
2 Belediye Kütahyaspor Belediye 34 63 32 66
3 Bursa Yıldırımspor Bursa 34 45 27 62
4 Artvin Hopaspor Artvin 34 45 26 59
5 Arnavutkoy Arnavutkoy 34 47 29 59
6 Erbaaspor Erbaaspor 34 48 33 52
7 Çatalca Spor Çatalca 34 47 32 50
8 Nevşehir Belediyespor Nevşehir 34 56 53 50
9 1954 Kelkit Belediyespor 1954 Kelkit 34 41 40 48
10 Bergama Belediyespor Bergama 34 54 47 46
11 Fatsa Belediye Fatsa 34 32 31 42
12 Osmaniyespor Kulübü Osmaniyespor 34 33 34 40
13 Karaman FK Karaman FK 34 33 44 40
14 Kahta 02 Spor Kahta Spor 34 39 42 39
15 Elazigspor Elazigspor 34 36 51 39
16 Hendek Spor Hendek Spor 34 33 41 32
17 Mamak Fk Mamak Fk 34 22 79 18
18 Sancaktepe Belediye Istanbu Sancaktepe 34 28 87 13
TEMPORADA 2020/2021
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Somaspor Somaspor 32 64 30 69
2 Erokspor Erokspor 32 59 27 64
3 Ispartaspor Ispartaspor 32 49 35 50
4 İçel İdmanyurdu Spor İçel 32 41 32 50
5 Çatalca Spor Çatalca 32 35 31 49
6 Çarşambaspor Çarşambasp 32 37 29 45
7 Osmaniyespor Kulübü Osmaniyespor 32 35 32 44
8 Karsiyaka Karsiyaka 32 36 39 44
9 Kalecik FK Kalecik FK 32 36 34 43
10 Sile Yildizspor Sile 32 38 39 43
11 23 Elazig 23 Elazig 32 37 38 42
12 Erbaaspor Erbaaspor 32 29 35 40
13 Batman Petrolspor Batman 32 24 30 39
14 Cizrespor 2010 Cizrespor 32 30 55 32
15 Golcukspor Golcukspor 32 27 39 30
16 Arhavispor Arhavispor 32 23 49 27
17 Yalovaspor Yalovaspor 32 26 52 22
TEMPORADA 2019/2020
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Serik Belediye Serik 28 49 24 55
2 Erzincanspor Erzincanspor 28 47 22 52
3 68 Aksaray Belediyespor Aksaray 28 43 27 50
4 Buca FK Buca FK 28 47 34 49
5 Artvin Hopaspor Artvin 28 38 21 47
6 Düzcespor Düzcespor 28 32 18 46
7 Karaköprü Bld. Karaköprü 28 25 22 42
8 Çatalca Spor Çatalca 28 39 28 41
9 Silivrispor Kulübü Silivrispor 28 37 31 38
10 Sultanbeyli Belediyespor Sultanbeyli 28 33 27 38
11 Kizilcabolukspor Kizilcaboluk 28 39 37 36
12 Yomraspor Yomraspor 28 28 30 36
13 52 Orduspor 52 Orduspor 28 21 20 35
14 Çankaya FK Çankaya FK 28 33 37 34
15 Sile Yildizspor Sile 28 23 30 29
16 İskenderunspor İskenderuns 28 27 34 28
17 Tokatspor Tokatspor 28 16 66 7
18 Manisaspor Manisaspor 28 16 85 0
TEMPORADA 2018/2019
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Kirsehirspor Kirsehirspor 34 54 38 63
2 Erokspor Erokspor 34 56 30 62
3 Vanspor FK Vanspor FK 34 60 27 60
4 Kizilcabolukspor Kizilcaboluk 34 60 39 55
5 Karsiyaka Karsiyaka 34 39 32 55
6 Kalecik FK Kalecik FK 34 46 30 54
7 Çatalca Spor Çatalca 34 39 45 48
8 Pazarspor Pazarspor 34 39 42 47
9 52 Orduspor 52 Orduspor 34 49 38 46
10 Osmaniyespor Kulübü Osmaniyespor 34 40 42 44
11 Sultanbeyli Belediyespor Sultanbeyli 34 32 39 43
12 Kemerspor Kemerspor 34 36 45 43
13 Düzcespor Düzcespor 34 35 44 43
14 Ofspor Ofspor 34 37 39 42
15 23 Elazig 23 Elazig 34 34 50 41
16 Adıyaman 1954 Spor Adıyaman 34 35 51 37
17 Alibeykoyspor Alibeykoyspo 34 40 51 33
18 Bergama Belediyespor Bergama 34 25 74 15
TEMPORADA 2017/2018
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Manisa FK Manisa FK 34 60 27 75
2 Bayburt Bayburt 34 51 33 62
3 Kemerspor Kemerspor 34 62 44 57
4 Bayrampasaspor Bayrampasasp 34 43 34 57
5 Ofspor Ofspor 34 41 27 55
6 Düzcespor Düzcespor 34 41 34 55
7 Halide Edip Adivar Halide Edip 34 45 33 51
8 Batman Petrolspor Batman 34 43 36 48
9 Erbaaspor Erbaaspor 34 46 41 48
10 Kalecik FK Kalecik FK 34 42 44 42
11 Çatalca Spor Çatalca 34 33 37 41
12 Kozanspor Kozanspor 34 42 52 39
13 Yomraspor Yomraspor 34 23 42 37
14 İskenderunspor İskenderuns 34 35 53 36
15 12 Bingölspor Bingölspor 34 28 42 34
16 Bergama Belediyespor Bergama 34 35 54 34
17 Orhangazispor Orhangazispo 34 34 52 31
18 Canakkale Dardanelspor Canakkale 34 35 54 26
TEMPORADA 2016/2017
3. LIG GRUPO 2
Equipo PJ GF GC Puntos
1 Bodrumspor Bodrumspor 34 59 31 65
2 Erbaaspor Erbaaspor 34 48 29 60
3 Manisa FK Manisa FK 34 59 37 58
4 Silivrispor Kulübü Silivrispor 34 34 25 58
5 Çatalca Spor Çatalca 34 42 33 55
6 Düzcespor Düzcespor 34 55 46 54
7 Halide Edip Adivar Halide Edip 34 46 39 53
8 Kirikhanspor Kirikhanspor 34 36 39 47
9 Kemerspor Kemerspor 34 52 45 45
10 Yomraspor Yomraspor 34 28 29 44
11 Batman Petrolspor Batman 34 38 38 43
12 Buca FK Buca FK 34 41 46 43
13 Yeşil Bursa Yeşil Bursa 34 40 35 41
14 Canakkale Dardanelspor Canakkale 34 42 54 41
15 Pazarspor Pazarspor 34 34 46 39
16 Dersim Spor Dersim Spor 34 33 54 33
17 Derince Belediyespor Derince 34 31 59 26
18 Turk Metal Kirikkale Turk Metal. 34 28 61 23
TEMPORADA 2015/2016
3. LIG GRUPO 3
Equipo PJ GF GC Puntos
1 Kastamonuspor Kastamonuspo 36 58 31 74
2 Nigde Anadolu Nigde 36 52 34 61
3 Bayburt Bayburt 36 37 26 61
4 Corum FK Corum FK 36 47 36 59
5 Beylerbeyi A.S. Beylerbeyi 36 45 37 59
6 Golcukspor Golcukspor 36 43 33 58
7 Darica Genclerbirligi Darica 36 50 36 54
8 Erzincan Refahiyespor Erzincan 36 42 29 54
9 Dersim Spor Dersim Spor 36 40 44 51
10 Canakkale Dardanelspor Canakkale 36 45 38 49
11 Çatalca Spor Çatalca 36 37 33 47
12 Batman Petrolspor Batman 36 37 42 47
13 Manavgat Evrensekispor Manavgat 36 50 52 44
14 Bergama Belediyespor Bergama 36 39 46 42
15 Vanspor FK Vanspor FK 36 33 46 42
16 Iskenderun DC Iskenderun 36 37 55 40
17 Tavsanlı Linyitspor Tavsanlı 36 31 44 34
18 Çine MadranSpor Çine 36 27 48 31
19 Sandiklispor Sandiklispor 36 35 75 21
TEMPORADA 2014/2015
3. LIG GRUPO 1
Equipo PJ GF GC Puntos
1 Tuzlaspor Tuzlaspor 34 73 33 74
2 Darica Genclerbirligi Darica 34 50 23 68
3 Zonguldak Kömürspor Zonguldak 34 50 24 63
4 Istanbulspor AS Istanbulspor 34 53 23 61
5 Corum FK Corum FK 34 44 36 56
6 Bursa Niluferspor Bursa 34 45 26 54
7 Buca FK Buca FK 34 56 39 54
8 Kizilcabolukspor Kizilcaboluk 34 50 35 53
9 Çankaya FK Çankaya FK 34 50 39 48
10 Nigde Anadolu Nigde 34 44 40 47
11 Çatalca Spor Çatalca 34 34 32 45
12 Kirikhanspor Kirikhanspor 34 41 34 44
13 Manavgat Evrensekispor Manavgat 34 42 38 44
14 Batman Petrolspor Batman 34 40 41 44
15 Gaziosmanpasaspor Gaziosmanpas 34 39 46 36
16 Akçaabat Akçaabat 34 18 70 21
17 Turanspor Turanspor 34 23 71 19
18 Bozuyukspor Bozuyukspor 34 0 102 0

  USO DE MEMORIA  
6,358,832 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.5488
Total Execution Time  0.5500
  CADENA URL  
/historico/Catalca-Spor
  GET DATOS  
$_GET['/historico/Catalca-Spor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (33)  
0.0142  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 = 'Catalca-Spor' 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=24947 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=24947 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0131  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=24947 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0289  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 = 73222
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=24947 AND type_rel = 2
0.0127  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 360 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0127  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 (1307337,30416) ORDER BY n.cover_points DESC, update_date DESC
0.0131  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 = '24947' ORDER BY l.year DESC,cat.coefficient DESC
0.0129  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 = '24947' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0133  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 = '24947' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0129  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 = 73222 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0132  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=24947 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (74094,73222) 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 = 73222 AND teamId = 24947
0.0133  SELECT count(id) as num_players from rel_players WHERE league_id = 74094 AND teamId = 24947
0.0128  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 = '24947' 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 = '24947' and rp.type = 4
0.0127  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 = '24947' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0139  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 = 73222 WHERE rp.league_id = 73222 AND rp.teamId = 24947 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.0136  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 = 73222 WHERE rp.league_id = 73222 AND rp.teamId = 24947 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0133  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 = 73222 WHERE rp.league_id = 73222 AND rp.teamId = 24947 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0130  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 = 24947 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73222 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.0132  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 = 68887 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 63654 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 58627 AND t.round = 34 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 `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 = 50977 AND t.round = 28 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 = 44490 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 38978 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
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 `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 = 33914 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  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 = 15825 AND t.round = 38 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 `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 = 4465 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC