4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Taawoun

Al-Taawoun

Entrenador: Péricles Chamusca

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 29 89 18 83
2 Al-Nassr Al-Nassr 29 84 35 71
3 Al-Ahli SFC Al-Ahli SFC 29 58 31 55
4 Al-Taawoun Al-Taawoun 30 48 34 51
5 Al-Ittihad Al-Ittihad 30 56 43 50
6 Al-Fateh SC Al-Fateh SC 30 50 46 41
7 Al-Ettifaq Al-Ettifaq 30 36 32 41
8 Al-Fayha Al-Fayha 30 40 47 41
9 Al-Shabab Al-Shabab 29 39 36 38
10 Damac FC Damac FC 30 41 39 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 30 28 53 29
15 Al-Okhdood Al-Okhdood 30 27 47 28
16 Abha Abha 30 34 79 28
17 Al-Tai SC Al-Tai SC 29 29 57 26
18 Al-Hazem SC Al-Hazem SC 30 29 68 20
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
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 30 69 27 70
2 Al-Hilal SFC Al-Hilal 30 66 33 69
3 Al-Taawoun Al-Taawoun 30 61 31 56
4 Al-Ahli SFC Al-Ahli SFC 30 68 41 55
5 Al-Shabab Al-Shabab 30 39 25 54
6 Al-Faisaly FC Al-Faisaly 30 51 47 43
7 Al-Wehda Al-Wehda 30 41 41 42
8 Al-Raed Al-Raed 30 38 48 38
9 Al-Fateh SC Al-Fateh SC 30 32 45 35
10 Al-Ittihad Al-Ittihad 30 44 45 34
11 Al-Ettifaq Al-Ettifaq 30 40 55 33
12 Al-Fayha Al-Fayha 30 36 52 32
13 Al-Hazem SC Al-Hazem SC 30 33 50 31
14 Al Qadsiah FC Qadsiah 30 34 51 28
15 Al-Batin Al-Batin 30 29 53 25
16 Ohod Ohod 30 25 62 21
TEMPORADA 2017/2018
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 26 47 23 56
2 Al-Ahli SFC Al-Ahli SFC 26 59 26 55
3 Al-Nassr Al-Nassr 26 47 34 44
4 Al-Ettifaq Al-Ettifaq 26 37 46 36
5 Al-Fateh SC Al-Fateh SC 26 34 39 36
6 Al-Faisaly FC Al-Faisaly 26 39 33 35
7 Al-Taawoun Al-Taawoun 26 43 36 34
8 Al-Fayha Al-Fayha 26 36 40 34
9 Al-Ittihad Al-Ittihad 26 34 41 33
10 Al-Shabab Al-Shabab 26 36 36 31
11 Al-Batin Al-Batin 26 35 46 31
12 Al Qadsiah FC Qadsiah 26 28 41 25
13 Al-Raed Al-Raed 26 43 53 24
14 Ohod Ohod 26 24 48 18
TEMPORADA 2016/2017
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 26 63 16 66
2 Al-Ahli SFC Al-Ahli SFC 26 57 30 55
3 Al-Nassr Al-Nassr 26 44 25 52
4 Al-Ittihad Al-Ittihad 26 57 37 52
5 Al-Raed Al-Raed 26 37 47 35
6 Al-Shabab Al-Shabab 26 28 32 33
7 Al-Taawoun Al-Taawoun 26 33 40 31
8 Al-Fateh SC Al-Fateh SC 26 33 39 29
9 Al-Faisaly FC Al-Faisaly 26 30 41 28
10 Al Qadsiah FC Qadsiah 26 38 38 28
11 Al-Ettifaq Al-Ettifaq 26 31 45 27
12 Al-Batin Al-Batin 26 31 43 26
13 Al-Khaleej Al-Khaleej 26 32 51 23
14 Al-Wehda Al-Wehda 26 35 65 17
TEMPORADA 2015/2016
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ahli SFC Al-Ahli SFC 26 55 21 63
2 Al-Hilal SFC Al-Hilal 26 52 23 55
3 Al-Ittihad Al-Ittihad 26 54 37 49
4 Al-Taawoun Al-Taawoun 26 54 35 45
5 Al-Fateh SC Al-Fateh SC 26 35 28 41
6 Al-Shabab Al-Shabab 26 27 28 39
7 Al-Khaleej Al-Khaleej 26 27 43 33
8 Al-Nassr Al-Nassr 26 39 33 32
9 Al-Wehda Al-Wehda 26 30 37 31
10 Al-Faisaly FC Al-Faisaly 26 28 37 29
11 Al Qadsiah FC Qadsiah 26 26 32 28
12 Al-Raed Al-Raed 26 30 45 24
13 Najran Najran 26 36 53 21
14 Hajer FC Hajer FC 26 15 56 9
TEMPORADA 2014/2015
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 26 62 20 64
2 Al-Ahli SFC Al-Ahli SFC 26 59 22 60
3 Al-Hilal SFC Al-Hilal 26 46 17 54
4 Al-Ittihad Al-Ittihad 26 44 33 52
5 Al-Shabab Al-Shabab 26 37 31 40
6 Al-Fateh SC Al-Fateh SC 26 35 43 33
7 Al-Faisaly FC Al-Faisaly 26 31 42 30
8 Al-Khaleej Al-Khaleej 26 35 41 29
9 Al-Taawoun Al-Taawoun 26 42 46 28
10 Hajer FC Hajer FC 26 29 56 28
11 Al-Raed Al-Raed 26 33 45 26
12 Najran Najran 26 28 41 24
13 Al-Shoalah FC Al-Shoalah 26 26 48 21
14 Al-Orubah FC Al-Orubah 26 21 43 17
TEMPORADA 2013/2014
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Nassr Al-Nassr 26 60 21 65
2 Al-Hilal SFC Al-Hilal 26 60 24 63
3 Al-Ahli SFC Al-Ahli SFC 26 48 24 45
4 Al-Shabab Al-Shabab 26 42 38 37
5 Al-Taawoun Al-Taawoun 26 33 28 35
6 Al-Ittihad Al-Ittihad 26 45 46 32
7 Al-Faisaly FC Al-Faisaly 26 28 35 32
8 Al-Orubah FC Al-Orubah 26 24 33 29
9 Al-Raed Al-Raed 26 21 33 29
10 Al-Fateh SC Al-Fateh SC 26 33 39 28
11 Najran Najran 26 32 43 28
12 Al-Ettifaq Al-Ettifaq 26 30 41 26
13 Al-Shoalah FC Al-Shoalah 26 30 42 26
14 Al-Nahdha Al-Nahdha 26 29 68 16
TEMPORADA 2012/2013
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Fateh SC Al-Fateh SC 26 52 23 64
2 Al-Hilal SFC Al-Hilal 26 62 26 56
3 Al-Shabab Al-Shabab 26 53 36 56
4 Al-Nassr Al-Nassr 26 41 24 50
5 Al-Ahli SFC Al-Ahli SFC 26 51 33 44
6 Al-Ettifaq Al-Ettifaq 26 33 38 35
7 Al-Ittihad Al-Ittihad 26 36 36 33
8 Al-Raed Al-Raed 26 30 41 32
9 Al-Shoalah FC Al-Shoalah 26 32 42 30
10 Najran Najran 26 31 52 25
11 Al-Faisaly FC Al-Faisaly 26 35 43 24
12 Al-Taawoun Al-Taawoun 26 25 37 19
13 Hajer FC Hajer FC 26 24 48 16
14 Al-Wehda Al-Wehda 26 26 52 12
TEMPORADA 2011/2012
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Shabab Al-Shabab 26 50 16 64
2 Al-Ahli SFC Al-Ahli SFC 26 60 22 62
3 Al-Hilal SFC Al-Hilal 26 58 22 60
4 Al-Ettifaq Al-Ettifaq 26 41 26 47
5 Al-Ittihad Al-Ittihad 26 49 35 37
6 Al-Fateh SC Al-Fateh SC 26 37 41 37
7 Al-Nassr Al-Nassr 26 40 37 35
8 Al-Faisaly FC Al-Faisaly 26 36 41 30
9 Najran Najran 26 34 49 30
10 Al-Raed Al-Raed 26 28 39 28
11 Hajer FC Hajer FC 26 23 45 25
12 Al-Taawoun Al-Taawoun 26 28 52 19
13 Al Qadsiah FC Qadsiah 26 34 52 18
14 Al-Ansar FC Al-Ansar FC 26 19 60 10
TEMPORADA 2010/2011
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 26 52 18 64
2 Al-Ittihad Al-Ittihad 26 49 23 51
3 Al-Ettifaq Al-Ettifaq 26 45 30 48
4 Al-Shabab Al-Shabab 26 42 30 46
5 Al-Nassr Al-Nassr 26 44 34 43
6 Al-Ahli SFC Al-Ahli SFC 26 48 41 37
7 Al-Faisaly FC Al-Faisaly 26 39 47 35
8 Al-Taawoun Al-Taawoun 26 37 31 32
9 Al-Fateh SC Al-Fateh SC 26 27 35 31
10 Al-Raed Al-Raed 26 31 40 30
11 Najran Najran 26 33 52 26
12 Al Qadsiah FC Qadsiah 26 31 39 23
13 Al-Wehda Al-Wehda 26 43 44 21
14 Al-Hazem SC Al-Hazem SC 26 13 70 6
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
TEMPORADA 1997/1998
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 22 40 24 45
2 Al-Najma FC Al-Najma FC 22 34 29 41
3 Al-Shabab Al-Shabab 22 46 29 39
4 Al-Ahli SFC Al-Ahli SFC 22 39 31 38
5 Al-Nassr Al-Nassr 22 34 27 37
6 Al-Ettifaq Al-Ettifaq 22 29 33 31
7 Al-Ittihad Al-Ittihad 22 28 32 28
8 Al-Tai SC Al-Tai SC 22 28 38 24
9 Al-Riyadh SC Al-Riyadh 22 41 38 23
10 Al-Wehda Al-Wehda 22 28 33 23
11 Al-Shoalah Al-Shoalah 22 23 36 19
12 Al-Taawoun Al-Taawoun 22 18 38 14

  USO DE MEMORIA  
7,275,240 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.7183
Total Execution Time  0.7197
  CADENA URL  
/historico/Al-Taawon
  GET DATOS  
$_GET['/historico/Al-Taawon']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
0.0294  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 = 72207
0.0151  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 = 73198
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=6444 AND type_rel = 2
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 6444 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0147  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 (98032,122076,172342,344952,626817) ORDER BY n.cover_points DESC, update_date DESC
0.0151  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 = '6444' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0147  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.0147  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.0150  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=6444 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0145  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.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 72207 AND teamId = 6444
0.0149  SELECT count(id) as num_players from rel_players WHERE league_id = 73198 AND teamId = 6444
0.0151  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 6444
0.0149  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 = 72207 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0147  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 = '6444' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0144  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '6444' and rp.type = 4
0.0146  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 = '6444' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0161  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 = 6444 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.0158  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 = 6444 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0154  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 = 6444 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 6444 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0149  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 = 30 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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.0149  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.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 `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.0149  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.0150  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 = 43671 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 38735 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0147  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 = 33397 AND t.round = 26 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 `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 = 15465 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 3879 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  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 = 3254 AND t.round = 26 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 `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 = 1971 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 1594 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  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 = 1593 AND t.round = 26 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 `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.0160  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.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 `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
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 `tables1998` 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 = 56723 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC