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

Damac FC

Entrenador: Cosmin Contra

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 28 86 18 80
2 Al-Nassr Al-Nassr 29 84 35 71
3 Al-Ahli SFC Al-Ahli SFC 28 54 30 52
4 Al-Taawoun Al-Taawoun 29 48 31 51
5 Al-Ittihad Al-Ittihad 29 55 40 50
6 Al-Ettifaq Al-Ettifaq 29 35 30 41
7 Al-Fateh SC Al-Fateh SC 29 48 44 40
8 Damac FC Damac FC 29 40 35 38
9 Al-Shabab Al-Shabab 29 39 36 38
10 Al-Fayha Al-Fayha 29 38 46 38
11 Al-Khaleej Al-Khaleej 29 32 40 35
12 Al-Wehda Al-Wehda 29 41 49 32
13 Al-Raed Al-Raed 29 38 45 31
14 Al-Riyadh SC Al-Riyadh 29 26 51 28
15 Al-Okhdood Al-Okhdood 29 27 47 27
16 Al-Tai SC Al-Tai SC 29 29 57 26
17 Abha Abha 29 31 78 25
18 Al-Hazem SC Al-Hazem SC 29 29 68 19
TEMPORADA 2022/2023
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ittihad Al-Ittihad 30 60 13 72
2 Al-Nassr Al-Nassr 30 63 18 67
3 Al-Hilal SFC Al-Hilal 30 54 29 59
4 Al-Shabab Al-Shabab 30 57 33 56
5 Al-Taawoun Al-Taawoun 30 46 34 55
6 Al-Fateh SC Al-Fateh SC 30 48 43 43
7 Al-Ettifaq Al-Ettifaq 30 28 36 37
8 Damac FC Damac FC 30 33 43 36
9 Al-Raed Al-Raed 30 41 49 34
10 Al-Tai SC Al-Tai SC 30 41 49 34
11 Al-Fayha Al-Fayha 30 31 43 33
12 Abha Abha 30 33 52 33
13 Al-Wehda Al-Wehda 30 26 43 32
14 Al-Khaleej Al-Khaleej 30 30 44 31
15 Al-Adalah Club Al-Adalah 30 30 56 28
16 Al-Batin Al-Batin 30 27 63 20
TEMPORADA 2021/2022
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 30 63 28 67
2 Al-Ittihad Al-Ittihad 30 62 29 65
3 Al-Nassr Al-Nassr 30 58 36 61
4 Al-Shabab Al-Shabab 30 52 36 55
5 Damac FC Damac FC 30 38 44 44
6 Al-Tai SC Al-Tai SC 30 33 45 37
7 Al-Raed Al-Raed 30 35 45 36
8 Al-Fateh SC Al-Fateh SC 30 45 41 35
9 Abha Abha 30 27 43 35
10 Al-Fayha Al-Fayha 30 21 24 35
11 Al-Ettifaq Al-Ettifaq 30 40 47 34
12 Al-Taawoun Al-Taawoun 30 43 48 34
13 Al-Batin Al-Batin 30 31 41 33
14 Al-Faisaly FC Al-Faisaly 30 28 37 33
15 Al-Ahli SFC Al-Ahli SFC 30 38 43 32
16 Al-Hazem SC Al-Hazem SC 30 23 50 17
TEMPORADA 2020/2021
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 30 60 27 61
2 Al-Shabab Al-Shabab 30 68 43 57
3 Al-Ittihad Al-Ittihad 30 45 29 56
4 Al-Taawoun Al-Taawoun 30 42 30 47
5 Al-Ettifaq Al-Ettifaq 30 50 48 47
6 Al-Nassr Al-Nassr 30 53 40 46
7 Al-Fateh SC Al-Fateh SC 30 55 55 42
8 Al-Ahli SFC Al-Ahli SFC 30 44 56 39
9 Al-Faisaly FC Al-Faisaly 30 42 47 36
10 Al-Raed Al-Raed 30 44 47 36
11 Damac FC Damac FC 30 43 48 36
12 Al-Batin Al-Batin 30 43 55 36
13 Abha Abha 30 42 50 36
14 Al Qadsiah FC Qadsiah 30 41 47 35
15 Al-Wehda Al-Wehda 30 40 60 32
16 Al-Ain FC Al-Ain FC 30 34 64 20
TEMPORADA 2019/2020
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 30 74 26 72
2 Al-Nassr Al-Nassr 30 60 26 64
3 Al-Ahli SFC Al-Ahli SFC 30 49 36 50
4 Al-Wehda Al-Wehda 30 45 40 49
5 Al-Faisaly FC Al-Faisaly 30 41 36 48
6 Al-Raed Al-Raed 30 41 50 46
7 Al-Shabab Al-Shabab 30 38 37 43
8 Al-Ettifaq Al-Ettifaq 30 46 38 42
9 Abha Abha 30 41 52 38
10 Damac FC Damac FC 30 37 52 35
11 Al-Ittihad Al-Ittihad 30 42 41 35
12 Al-Taawoun Al-Taawoun 30 33 40 35
13 Al-Fateh SC Al-Fateh SC 30 42 49 33
14 Al-Fayha Al-Fayha 30 34 44 32
15 Al-Hazem SC Al-Hazem SC 30 40 61 27
16 Al-Adalah Club Al-Adalah 30 27 62 21
TEMPORADA 2018/2019
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Abha Abha 40 55 40 73
2 Damac FC Damac FC 38 52 31 64
3 Al-Adalah Club Al-Adalah 38 49 39 63
4 Al-Khaleej Al-Khaleej 38 49 39 60
5 Al Jeel Al Jeel 38 52 44 57
6 Al-Tai SC Al-Tai SC 38 39 34 57
7 Najran Najran 38 47 43 52
8 Jeddah Club Jeddah Club 38 46 43 50
9 Al Najoom Al Najoom 38 46 44 50
10 Al-Qaisumah FC Al-Qaisumah 39 47 53 50
11 Al-Shoalah FC Al-Shoalah 40 44 49 49
12 Al-Nahdha Al-Nahdha 38 41 42 49
13 Al-Ain FC Al-Ain FC 38 43 45 49
14 Al-Jabalain FC Al-Jabalain 38 35 40 48
15 Al Mojzel Al Mojzel 38 41 45 48
16 Al-Kawkab Al-Kawkab 38 45 52 48
17 Al-Ansar FC Al-Ansar FC 38 39 41 47
18 Hajer FC Hajer FC 38 39 42 47
19 Al-Washm Al-Washm 39 35 52 43
20 Al-Orubah FC Al-Orubah 38 37 63 26
TEMPORADA 2017/2018
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Wehda Al-Wehda 30 49 32 58
2 Al-Hazem SC Al-Hazem SC 30 50 32 53
3 Al-Tai SC Al-Tai SC 30 52 35 52
4 Al-Kawkab Al-Kawkab 30 52 33 50
5 Hajer FC Hajer FC 30 39 35 50
6 Al-Shoalah FC Al-Shoalah 30 42 43 43
7 Al-Khaleej Al-Khaleej 30 45 40 41
8 Al-Qaisumah FC Al-Qaisumah 30 52 54 40
9 Damac FC Damac FC 30 49 43 39
10 Al-Orubah FC Al-Orubah 30 36 39 38
11 Al-Nahdha Al-Nahdha 30 35 50 35
12 Al Najoom Al Najoom 30 34 41 33
13 Al Mojzel Al Mojzel 30 39 52 33
14 Najran Najran 30 39 51 33
15 Al Watani Al Watani 30 33 48 27
16 Jeddah Club Jeddah Club 30 43 61 25
TEMPORADA 2016/2017
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Fayha Al-Fayha 30 50 35 50
2 Ohod Ohod 30 42 30 48
3 Al-Nahdha Al-Nahdha 30 38 32 46
4 Najran Najran 30 38 34 46
5 Al-Qaisumah FC Al-Qaisumah 30 44 50 41
6 Al-Shoalah FC Al-Shoalah 30 35 33 41
7 Al-Orubah FC Al-Orubah 30 34 32 41
8 Damac FC Damac FC 30 33 39 40
9 Hajer FC Hajer FC 30 38 36 40
10 Al Najoom Al Najoom 30 39 37 39
11 Al-Hazem SC Al-Hazem SC 30 36 30 38
12 Al-Tai SC Al-Tai SC 30 34 42 37
13 Al Watani Al Watani 30 27 37 37
14 Al-Adalah Club Al-Adalah 30 31 41 36
15 Al Jeel Al Jeel 30 45 46 34
16 Wajj Wajj 30 37 47 30
TEMPORADA 2015/2016
PRIMERA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Ettifaq Al-Ettifaq 31 47 22 55
2 Al-Batin Al-Batin 31 50 32 54
3 Al Mojzel Al Mojzel 30 46 32 54
4 Al-Orubah FC Al-Orubah 30 49 32 51
5 Al Jeel Al Jeel 32 46 42 48
6 Damac FC Damac FC 31 36 34 46
7 Al-Shoalah FC Al-Shoalah 30 33 33 43
8 Al-Tai SC Al-Tai SC 30 38 36 42
9 Ohod Ohod 30 29 33 37
10 Al-Fayha Al-Fayha 30 33 41 37
11 Al Watani Al Watani 30 29 29 36
12 Al Najoom Al Najoom 31 35 40 35
13 Al-Hazem SC Al-Hazem SC 30 32 42 33
14 Al-Nahdha Al-Nahdha 30 35 46 32
15 Al-Riyadh SC Al-Riyadh 30 34 44 28
16 Al-Diriyah Al-Diriyah 30 22 56 14
TEMPORADA 2014/2015
SEGUNDA ARABIA SAUDÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Damac FC Damac FC 18 31 16 36
2 Al-Kawkab Al-Kawkab 18 25 15 34
3 Sdoos Club Sdoos Club 18 34 19 30
4 Al-Najma FC Al-Najma FC 18 17 20 27
5 Al-Adalah Club Al-Adalah 18 16 15 23
6 Al Sharq Al Sharq 18 18 21 23
7 Al-Ansar FC Al-Ansar FC 18 16 16 22
8 Al-Tuhami Al-Tuhami 18 19 19 20
9 Al-Zulfi Al-Zulfi 18 16 25 16
10 Al-Sahel Al-Sahel 18 7 33 9
TEMPORADA 2013/2014
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Safa Al-Safa 18 26 9 36
2 Al Taraji Al Taraji 18 21 17 29
3 Damac FC Damac FC 18 26 18 28
4 Al Suqoor Al Suqoor 18 26 27 25
5 Al-Zulfi Al-Zulfi 18 24 29 23
6 Al-Tuhami Al-Tuhami 18 18 16 22
7 Al-Najma FC Al-Najma FC 18 19 18 22
8 Al Sharq Al Sharq 18 21 23 20
9 Jeddah Club Jeddah Club 18 15 28 19
10 Al-Arabi SC Al-Arabi SC 18 20 31 15
11 Al-Fayha Al-Fayha 18 25 16 34
12 Al Mojzel Al Mojzel 18 26 15 31
13 Al-Oyoon Al-Oyoon 18 28 24 30
14 Sdoos Club Sdoos Club 18 25 20 26
15 Al Ramh Al Ramh 18 23 20 24
16 Al-Okhdood Al-Okhdood 18 15 27 23
17 Al Najoom Al Najoom 18 22 22 21
18 Al Hamadah Al Hamadah 18 20 25 21
19 Al-Jabalain FC Al-Jabalain 18 25 31 20
20 Al-Qalah Al-Qalah 18 21 30 14
TEMPORADA 2012/2013
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Diriyah Al-Diriyah 18 31 14 40
2 Ohod Ohod 18 27 22 30
3 Al-Oyoon Al-Oyoon 18 33 22 29
4 Al-Tuhami Al-Tuhami 18 20 19 24
5 Al-Jabalain FC Al-Jabalain 18 23 26 24
6 Al Suqoor Al Suqoor 18 19 24 24
7 Al Hamadah Al Hamadah 18 22 22 21
8 Al-Qalah Al-Qalah 18 27 33 21
9 Al-Adalah Club Al-Adalah 18 22 27 19
10 Najd Najd 18 15 30 10
11 Al-Kawkab Al-Kawkab 18 33 19 39
12 Al Mojzel Al Mojzel 18 31 25 34
13 Al-Safa Al-Safa 18 22 12 31
14 Al-Fayha Al-Fayha 18 23 19 29
15 Al-Arabi SC Al-Arabi SC 18 33 26 26
16 Al Ramh Al Ramh 18 24 22 24
17 Damac FC Damac FC 18 17 23 22
18 Al Taraji Al Taraji 18 17 20 21
19 Al Ameade Al Ameade 18 20 32 15
20 Wajj Wajj 18 15 37 10
TEMPORADA 2011/2012
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shoalah FC Al-Shoalah 30 48 34 55
2 Al-Wehda Al-Wehda 30 59 37 54
3 Al-Nahdha Al-Nahdha 30 39 24 52
4 Abha Abha 30 36 28 49
5 Al-Hazem SC Al-Hazem SC 30 39 28 48
6 Al-Tai SC Al-Tai SC 30 42 26 47
7 Al Jeel Al Jeel 30 32 28 47
8 Al-Khaleej Al-Khaleej 30 41 41 43
9 Hottain Hottain 30 53 52 38
10 Al-Orubah FC Al-Orubah 30 24 38 37
11 Al Watani Al Watani 30 31 45 36
12 Al-Riyadh SC Al-Riyadh 30 27 23 34
13 Al-Batin Al-Batin 30 39 50 34
14 Ohod Ohod 30 30 42 28
15 Damac FC Damac FC 30 33 51 26
16 Al Suqoor Al Suqoor 30 28 54 23
TEMPORADA 2010/2011
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Hajer FC Hajer FC 30 51 32 63
2 Al-Ansar FC Al-Ansar FC 30 40 24 55
3 Al-Riyadh SC Al-Riyadh 30 38 29 52
4 Abha Abha 30 59 43 51
5 Al-Khaleej Al-Khaleej 30 44 36 49
6 Al Watani Al Watani 30 44 34 46
7 Al-Tai SC Al-Tai SC 30 33 33 43
8 Damac FC Damac FC 30 51 47 39
9 Ohod Ohod 30 40 46 39
10 Hottain Hottain 30 48 39 37
11 Al-Orubah FC Al-Orubah 30 44 55 37
12 Al Jeel Al Jeel 30 36 45 35
13 Al-Shoalah FC Al-Shoalah 30 36 46 34
14 Al-Adalah Club Al-Adalah 30 33 41 32
15 Jeddah Club Jeddah Club 30 37 60 22
16 Al-Najma FC Al-Najma FC 30 32 56 20
TEMPORADA 2009/2010
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Faisaly FC Al-Faisaly 26 44 12 58
2 Al-Taawoun Al-Taawoun 26 35 18 56
3 Al-Ansar FC Al-Ansar FC 26 41 26 50
4 Abha Abha 26 39 36 41
5 Al-Tai SC Al-Tai SC 26 30 25 40
6 Al-Khaleej Al-Khaleej 26 34 34 34
7 Hajer FC Hajer FC 26 34 41 33
8 Al-Adalah Club Al-Adalah 26 32 33 31
9 Al-Shoalah FC Al-Shoalah 26 36 40 29
10 Damac FC Damac FC 26 29 43 29
11 Al Watani Al Watani 26 35 44 27
12 Hottain Hottain 26 38 49 27
13 Ohod Ohod 26 32 41 25
14 Al-Riyadh SC Al-Riyadh 26 24 41 25
TEMPORADA 2008/2009
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al Qadsiah FC Qadsiah 26 41 15 54
2 Al-Fateh SC Al-Fateh SC 26 41 28 51
3 Al-Faisaly FC Al-Faisaly 26 38 26 47
4 Al-Tai SC Al-Tai SC 26 35 28 44
5 Damac FC Damac FC 26 39 36 40
6 Hajer FC Hajer FC 26 42 37 35
7 Al-Khaleej Al-Khaleej 26 36 33 35
8 Al-Taawoun Al-Taawoun 26 39 40 33
9 Ohod Ohod 26 25 30 33
10 Al-Riyadh SC Al-Riyadh 26 28 32 30
11 Al-Ansar FC Al-Ansar FC 26 24 34 28
12 Hottain Hottain 26 19 33 24
13 Al-Orubah FC Al-Orubah 26 32 49 21
14 Sdoos Club Sdoos Club 26 31 49 14
TEMPORADA 2007/2008
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Raed Al-Raed 26 27 15 45
2 Abha Abha 26 47 37 45
3 Al-Ansar FC Al-Ansar FC 26 36 28 43
4 Al-Khaleej Al-Khaleej 26 39 35 40
5 Al-Fateh SC Al-Fateh SC 26 29 23 38
6 Damac FC Damac FC 26 30 27 38
7 Al-Taawoun Al-Taawoun 26 34 35 35
8 Al-Faisaly FC Al-Faisaly 26 28 33 35
9 Sdoos Club Sdoos Club 26 35 30 34
10 Hajer FC Hajer FC 26 36 35 34
11 Ohod Ohod 26 30 33 34
12 Al-Riyadh SC Al-Riyadh 26 22 30 34
13 Al-Jabalain FC Al-Jabalain 26 23 37 33
14 Al-Fayha Al-Fayha 26 13 31 13

  USO DE MEMORIA  
7,349,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0011
Controller Execution Time ( Home / Category )  0.1201
Total Execution Time  0.1213
  CADENA URL  
/historico/Dhamk-Club
  GET DATOS  
$_GET['/historico/Dhamk-Club']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=59562 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=61 AND type_rel = 3
0.0031  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 61 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0021  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 (1312885,1312645,1312329,1312142,1274748) ORDER BY n.cover_points DESC, update_date DESC
0.0023  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 = '59562' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0023  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 = 73198 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=59562 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (73198,72207,71432) 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.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 72207 AND teamId = 59562
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 73198 AND teamId = 59562
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 59562
0.0022  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 = '59562' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '59562' and rp.type = 4
0.0020  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 = '59562' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0034  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 = 72207 WHERE rp.league_id = 72207 AND rp.teamId = 59562 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.0030  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 = 72207 WHERE rp.league_id = 72207 AND rp.teamId = 59562 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 72207 WHERE rp.league_id = 72207 AND rp.teamId = 59562 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 59562 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72207 AND t.round = 29 ORDER BY team.conference ASC,t.position 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 `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 = 68576 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.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 `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 = 63430 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.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 `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 = 59048 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.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 `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 = 50041 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.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 `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 = 44795 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 `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 = 39088 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 `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 = 33686 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 `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 = 15470 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0027  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 = 9282 AND t.round = 18 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 `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 = 27901 AND t.round = 18 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 `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 = 27914 AND t.round = 18 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 `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 = 8880 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 `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 = 8878 AND t.round = 30 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 `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 = 8876 AND t.round = 26 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 `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 = 8874 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 `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 = 8872 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC