4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del El Gounah

El Gounah

Entrenador: Alaa Abdelaal

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Pyramids Pyramids 16 25 12 35
2 Al-Masry Al-Masry 19 28 25 34
3 ZED ZED 20 28 18 33
4 ENPPI ENPPI 19 21 17 29
5 Al Ittihad Alexandria Ittihad 19 24 23 29
6 Smouha SC Smouha SC 19 19 17 28
7 El Gounah El Gounah 19 24 26 28
8 Talaea El-Gaish Talaea 17 16 12 27
9 Ceramica Cleopatra Ceramica 18 28 20 25
10 Future FC Future FC 17 18 14 25
11 Al-Ahly Al-Ahly 11 24 13 21
12 Zamalek Zamalek 13 22 14 21
13 Ismaily Ismaily 19 18 22 19
14 Baladiyyat Baladiyyat 19 21 40 19
15 National Bank of Egypt National 19 25 28 18
16 Pharco FC Pharco FC 18 17 27 13
17 Al Mokawloon Mokawloon 19 17 31 12
18 El Dakhleya El Dakhleya 19 6 22 11
TEMPORADA 2022/2023
SEGUNDA EGIPTO GRUPO 1
Equipo PJ GF GC Puntos
1 El Gounah El Gounah 30 54 23 69
2 La Viena La Viena 30 51 19 68
3 Asyut Petroleum Asyut 30 40 18 59
4 Al Nasr Taaden Nasr Taaden 30 40 26 53
5 Misr El-Makasa Misr 30 46 41 48
6 El Minya El Minya 30 32 24 46
7 Kima Aswan Kima Aswan 30 34 31 45
8 Dayrout Dayrout 30 40 30 41
9 Aluminium Naq Hammadi Aluminium 30 36 28 40
10 Asmant Asyut Asmant Asyut 30 32 38 38
11 Shoban Moslemen Qena Shoban 30 31 40 30
12 AL Fayoum AL Fayoum 30 26 39 26
13 Tamya Tamya 30 22 44 25
14 Nasr Maloy Nasr Maloy 30 24 53 23
15 Telephonaat Beni Suef Telephonaat 30 26 50 23
16 Madina Monowara Madina 30 27 57 20
TEMPORADA 2021/2022
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Zamalek Zamalek 34 62 29 77
2 Pyramids Pyramids 34 56 25 71
3 Al-Ahly Al-Ahly 34 62 21 70
4 Talaea El-Gaish Talaea 34 27 24 56
5 Future FC Future FC 34 49 34 56
6 Smouha SC Smouha SC 34 44 45 47
7 National Bank of Egypt National 34 40 41 46
8 Pharco FC Pharco FC 34 21 22 42
9 ENPPI ENPPI 34 37 39 39
10 Al Mokawloon Mokawloon 34 30 31 38
11 Ismaily Ismaily 34 27 39 38
12 Al Ittihad Alexandria Ittihad 34 40 52 38
13 Al-Masry Al-Masry 34 40 41 38
14 Ceramica Cleopatra Ceramica 34 34 41 37
15 Ghazl El Mehalla Ghazl 34 26 37 36
16 El Gounah El Gounah 34 33 46 36
17 El Sharkeyah Sharkeyah 34 33 56 33
18 Misr El-Makasa Misr 34 12 50 15
TEMPORADA 2020/2021
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Zamalek Zamalek 34 61 21 80
2 Al-Ahly Al-Ahly 34 72 29 76
3 Pyramids Pyramids 34 57 37 55
4 Smouha SC Smouha SC 34 55 42 54
5 Al-Masry Al-Masry 34 44 38 50
6 ENPPI ENPPI 34 39 35 49
7 Al Ittihad Alexandria Ittihad 34 38 36 48
8 Talaea El-Gaish Talaea 34 41 37 42
9 Al Mokawloon Mokawloon 34 38 48 41
10 Ceramica Cleopatra Ceramica 34 41 46 39
11 Misr El-Makasa Misr 34 37 55 38
12 El Gounah El Gounah 34 36 43 38
13 Ismaily Ismaily 34 42 44 38
14 National Bank of Egypt National 34 39 44 35
15 Ghazl El Mehalla Ghazl 34 28 47 35
16 Wadi Degla Wadi Degla 34 31 40 30
17 El Entag El Harby Entag Harby 34 37 62 28
18 Aswan SC Aswan SC 34 29 61 27
TEMPORADA 2019/2020
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 74 8 89
2 Zamalek Zamalek 34 50 27 71
3 Pyramids Pyramids 34 54 33 65
4 Al Mokawloon Mokawloon 34 45 34 54
5 Smouha SC Smouha SC 34 44 33 51
6 Al-Masry Al-Masry 34 36 35 48
7 ENPPI ENPPI 34 34 33 48
8 El Entag El Harby Entag Harby 34 35 38 44
9 Misr El-Makasa Misr 34 40 39 42
10 Al Ittihad Alexandria Ittihad 34 36 36 42
11 Ismaily Ismaily 34 38 48 41
12 Talaea El-Gaish Talaea 34 31 37 39
13 El Gounah El Gounah 34 32 45 37
14 Aswan SC Aswan SC 34 39 50 37
15 Wadi Degla Wadi Degla 34 32 43 35
16 Haras El-Hodood Haras 34 31 41 33
17 Tanta Tanta 34 22 55 22
18 ZED ZED 34 18 56 22
TEMPORADA 2018/2019
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 34 56 20 80
2 Zamalek Zamalek 34 65 31 72
3 Pyramids Pyramids 34 61 31 70
4 Al-Masry Al-Masry 34 45 38 52
5 Al Mokawloon Mokawloon 34 45 38 48
6 Misr El-Makasa Misr 34 34 36 46
7 Ismaily Ismaily 34 30 36 43
8 Talaea El-Gaish Talaea 34 41 39 41
9 ENPPI ENPPI 34 39 42 40
10 Wadi Degla Wadi Degla 34 41 47 40
11 Al Ittihad Alexandria Ittihad 34 41 56 39
12 Haras El-Hodood Haras 34 30 37 38
13 El Entag El Harby Entag Harby 34 36 44 38
14 Smouha SC Smouha SC 34 33 41 38
15 El Gounah El Gounah 34 38 52 38
16 PetroJet PetroJet 34 30 43 35
17 El Dakhleya El Dakhleya 34 34 52 27
18 Nogoom Nogoom 34 30 46 26
TEMPORADA 2014/2015
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Zamalek Zamalek 38 69 21 87
2 Al-Ahly Al-Ahly 38 65 26 79
3 ENPPI ENPPI 38 65 29 70
4 Misr El-Makasa Misr 38 57 51 64
5 Wadi Degla Wadi Degla 38 46 36 57
6 Ismaily Ismaily 38 44 32 55
7 Al Mokawloon Mokawloon 38 47 41 55
8 Haras El-Hodood Haras 38 30 31 52
9 Talaea El-Gaish Talaea 38 49 56 52
10 Smouha SC Smouha SC 38 43 37 51
11 Al-Masry Al-Masry 38 37 41 50
12 El Dakhleya El Dakhleya 38 43 41 49
13 PetroJet PetroJet 38 49 53 49
14 Al Ittihad Alexandria Ittihad 38 39 38 48
15 Ittihad El-Shorta Ittihad 38 36 42 47
16 El Gounah El Gounah 38 33 35 46
17 El Raja El Raja 38 47 57 43
18 Al Nasr Al Nasr 38 34 70 29
19 Pyramids Pyramids 38 40 88 16
20 Alaab Damanhour Alaab 38 34 82 14
TEMPORADA 2013/2014
LIGA EGIPTO GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 20 30 10 40
2 Smouha SC Smouha SC 20 24 20 35
3 Al-Ittihad Al-Sakndary Al-Ittihad 20 20 17 31
4 Al Mokawloon Mokawloon 20 27 17 30
5 El Gounah El Gounah 20 17 16 26
6 El Dakhleya El Dakhleya 20 18 19 25
7 Misr El-Makasa Misr 20 17 22 24
8 ENPPI ENPPI 20 19 19 22
9 El Raja El Raja 20 23 34 21
10 Ghazl El Mehalla Ghazl 20 13 21 19
11 El Entag El Harby Entag Harby 20 15 28 14
TEMPORADA 2012/2013
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 15 27 10 39
2 ENPPI ENPPI 15 24 15 29
3 Smouha SC Smouha SC 16 19 9 27
4 Telephonat Beni Sweif Telephonat 15 10 10 21
5 Haras El-Hodood Haras 15 14 16 17
6 El Gounah El Gounah 15 12 19 14
7 Wadi Degla Wadi Degla 15 12 20 14
8 Misr El-Makasa Misr 15 9 17 12
9 Ghazl El Mehalla Ghazl 15 14 25 11
10 Zamalek Zamalek 15 26 11 39
11 Ismaily Ismaily 16 20 11 30
12 Ittihad El-Shorta Ittihad 15 21 15 22
13 Talaea El-Gaish Talaea 15 19 21 20
14 Al Mokawloon Mokawloon 15 21 20 19
15 El Dakhleya El Dakhleya 15 10 11 19
16 PetroJet PetroJet 15 16 21 17
17 Ittihad Bnei Sakhnin Ittihad Bnei 15 10 19 14
18 El Entag El Harby Entag Harby 15 9 23 6
TEMPORADA 2011/2012
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Haras El-Hodood Haras 14 25 9 37
2 Al-Ahly Al-Ahly 15 28 12 36
3 Zamalek Zamalek 14 27 11 32
4 Al-Masry Al-Masry 15 17 10 26
5 Ittihad El-Shorta Ittihad 15 16 10 26
6 Ismaily Ismaily 14 17 13 25
7 Misr El-Makasa Misr 15 29 19 24
8 ENPPI ENPPI 16 28 25 24
9 El Gounah El Gounah 16 22 18 22
10 Wadi Degla Wadi Degla 14 17 15 19
11 Telephonat Beni Sweif Telephonat 16 16 21 19
12 Talaea El-Gaish Talaea 16 19 21 17
13 Ittihad Bnei Sakhnin Ittihad Bnei 16 14 21 15
14 Smouha SC Smouha SC 15 15 23 13
15 PetroJet PetroJet 14 12 21 11
16 Ghazl El Mehalla Ghazl 14 11 29 11
17 Al Mokawloon Mokawloon 15 17 24 10
18 El Entag El Harby Entag Harby 17 8 26 9
19 El Dakhleya El Dakhleya 15 12 22 8
TEMPORADA 2010/2011
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 47 27 61
2 Zamalek Zamalek 30 49 32 56
3 Ismaily Ismaily 30 48 33 49
4 Ittihad El-Shorta Ittihad 30 31 23 47
5 ENPPI ENPPI 30 37 30 47
6 Misr El-Makasa Misr 30 41 28 45
7 Al-Masry Al-Masry 30 28 22 43
8 Haras El-Hodood Haras 30 40 39 39
9 Talaea El-Gaish Talaea 30 25 31 36
10 PetroJet PetroJet 30 31 38 35
11 El Gounah El Gounah 30 26 33 34
12 Wadi Degla Wadi Degla 30 39 50 33
13 El Entag El Harby Entag Harby 30 33 44 33
14 Ittihad Bnei Sakhnin Ittihad Bnei 30 37 51 30
15 Smouha SC Smouha SC 30 33 45 28
16 Al Mokawloon Mokawloon 30 27 46 24
TEMPORADA 2009/2010
LIGA EGIPTO
Equipo PJ GF GC Puntos
1 Al-Ahly Al-Ahly 30 47 23 65
2 Zamalek Zamalek 30 43 26 55
3 Ismaily Ismaily 30 34 25 48
4 Ittihad El-Shorta Ittihad 30 35 24 47
5 PetroJet PetroJet 30 42 37 47
6 Haras El-Hodood Haras 30 39 31 45
7 El Entag El Harby Entag Harby 30 36 32 41
8 ENPPI ENPPI 30 29 35 41
9 Al-Jaish Al-Jaish 30 42 38 40
10 Ittihad El-Iskandary Ittihad 30 27 36 35
11 Al Mokawloon Mokawloon 30 36 34 34
12 El Gounah El Gounah 29 26 30 34
13 Al-Masry Al-Masry 30 28 35 34
14 Ghazl El Mehalla Ghazl 29 15 30 28
15 El Mansura El Mansura 30 21 37 19
16 Asyut Petroleum Asyut 30 29 56 19

  USO DE MEMORIA  
6,647,528 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Home / Category )  0.5998
Total Execution Time  0.6012
  CADENA URL  
/historico/Gounah
  GET DATOS  
$_GET['/historico/Gounah']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0143  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 = 'Gounah' 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.0126  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=5285 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=5285 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=5285 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0127  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=5285 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0256  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 = 73594
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5285 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5285 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0127  SELECT /*35 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 (1506) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '5285' ORDER BY l.year DESC,cat.coefficient DESC
0.0132  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 = '5285' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0134  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 = '5285' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0146  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=5285 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0134  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 (75211,73594,70012) 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.0148  SELECT count(id) as num_players from rel_players WHERE league_id = 73594 AND teamId = 5285
0.0131  SELECT count(id) as num_players from rel_players WHERE league_id = 70012 AND teamId = 5285
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 75211 AND teamId = 5285
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 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 = 73594 AND t.round = 20 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0126  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 = '5285' 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 = '5285' 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 = '5285' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0140  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 = 73594 WHERE rp.league_id = 73594 AND rp.teamId = 5285 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.0140  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 = 73594 WHERE rp.league_id = 73594 AND rp.teamId = 5285 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0141  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 = 73594 WHERE rp.league_id = 73594 AND rp.teamId = 5285 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 5285 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 70012 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.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 `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 = 65437 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 = 60339 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.0134  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 = 51406 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.0138  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 = 44243 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 8378 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0144  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 = 3574 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0146  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 = 2212 AND t.round = 18 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 `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 = 1570 AND t.round = 19 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137  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 = 1258 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0136  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 = 10329 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC