4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Kawkab
TEMPORADA 2023/2024
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al Suqoor Al Suqoor 30 68 29 68
2 Al-Zulfi Al-Zulfi 30 56 32 60
3 Al Jeel Al Jeel 30 50 34 53
4 Al Rawdhah Al Rawdhah 30 31 24 52
5 Al-Shoalah FC Al-Shoalah 30 45 37 48
6 Al-Washm Al-Washm 30 36 31 45
7 Najran Najran 30 50 41 42
8 Mudhar Mudhar 30 40 37 42
9 Al-Taqadom Al-Taqadom 30 38 39 41
10 Al-Kawkab Al-Kawkab 30 34 45 38
11 Al Entesar Al Entesar 30 37 54 34
12 Al-Lewaa Al-Lewaa 30 33 41 33
13 Al-Rayyan Al-Rayyan 30 37 48 31
14 Al Najoom Al Najoom 30 37 52 27
15 AFIF AFIF 30 31 51 21
16 Al Nairyah Al Nairyah 30 33 61 17
17 Al Jubail Al Jubail 30 49 25 65
18 Al Draih Al Draih 30 50 22 58
19 Jerash Jerash 30 50 34 57
20 Bisha Bisha 30 55 30 54
21 Al-Saqer Al-Saqer 30 37 30 49
22 Al-Sahel Al-Sahel 30 45 36 47
23 Wej SC Wej SC 30 35 39 42
24 Hottain Hottain 30 29 27 41
25 Arar Arar 30 26 41 40
26 Al Qous Al Qous 30 32 33 39
27 Alhowra FC Alhowra FC 30 34 44 33
28 Al Sadd Al Sadd 30 27 48 30
29 Al-Ansar FC Al-Ansar FC 30 33 43 29
30 Tuwaiq Tuwaiq 30 30 40 28
31 Al-Shoaib Al-Shoaib 30 24 36 25
32 Al-Noor Al-Noor 30 25 53 17
TEMPORADA 2022/2023
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al Taraji Al Taraji 30 48 32 56
2 Al Bukayriyah Bukayriyah 30 41 27 55
3 Al Jandal Al Jandal 30 58 44 50
4 Tuwaiq Tuwaiq 30 43 36 49
5 Al-Saqer Al-Saqer 30 36 27 47
6 Jerash Jerash 30 44 40 44
7 Arar Arar 30 35 31 42
8 Al Sadd Al Sadd 30 41 36 39
9 Al Draih Al Draih 30 28 31 38
10 Al Entesar Al Entesar 30 32 38 38
11 Al-Lewaa Al-Lewaa 30 31 36 35
12 Al-Taqadom Al-Taqadom 30 29 36 35
13 Hottain Hottain 30 32 39 32
14 Al Qous Al Qous 30 28 37 32
15 Qilwah Qilwah 30 25 42 28
16 Al-Nahdha Al-Nahdha 30 25 44 23
17 Al-Najma FC Al-Najma FC 30 46 22 64
18 Al-Safa Al-Safa 30 41 20 58
19 Bisha Bisha 30 41 21 55
20 Al-Kawkab Al-Kawkab 30 31 24 53
21 Al Nairyah Al Nairyah 30 42 32 47
22 Al-Zulfi Al-Zulfi 30 47 33 46
23 Al Rawdhah Al Rawdhah 30 43 29 44
24 Al Jeel Al Jeel 30 31 31 42
25 Al-Rayyan Al-Rayyan 30 32 36 36
26 Wej SC Wej SC 30 38 46 36
27 Al-Ansar FC Al-Ansar FC 30 32 46 31
28 Al-Washm Al-Washm 30 37 40 30
29 Al-Shoaib Al-Shoaib 30 28 46 28
30 Al Suqoor Al Suqoor 30 34 46 27
31 Al Sharq Al Sharq 30 26 46 26
32 Sajer Sajer 30 21 52 18
TEMPORADA 2021/2022
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Khaleej Al-Khaleej 38 51 36 66
2 Al-Adalah Club Al-Adalah 38 42 32 66
3 Al-Wehda Al-Wehda 38 51 29 65
4 Hajer FC Hajer FC 38 44 31 63
5 Al-Jabalain FC Al-Jabalain 38 48 39 61
6 Ohod Ohod 38 51 42 59
7 Al Qadsiah FC Qadsiah 38 40 32 55
8 Al-Kholood Al-Kholood 38 40 36 54
9 Najran Najran 38 38 33 52
10 Al-Orubah FC Al-Orubah 38 45 44 52
11 Al-Ain FC Al-Ain FC 38 38 41 49
12 Al-Sahel Al-Sahel 38 50 43 48
13 Al-Shoalah FC Al-Shoalah 38 40 34 48
14 Al-Okhdood Al-Okhdood 38 43 44 48
15 Jeddah Club Jeddah Club 38 35 39 47
16 Al Jeel Al Jeel 38 37 51 47
17 Al-Diriyah Al-Diriyah 38 38 56 42
18 Al-Nahdha Al-Nahdha 38 37 52 38
19 Al-Kawkab Al-Kawkab 38 30 54 27
20 Bisha Bisha 38 27 57 25
TEMPORADA 2020/2021
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hazem SC Al-Hazem SC 38 77 27 91
2 Al-Fayha Al-Fayha 38 72 27 81
3 Al-Tai SC Al-Tai SC 38 58 33 77
4 Al-Jabalain FC Al-Jabalain 38 53 27 76
5 Hajer FC Hajer FC 38 49 37 55
6 Ohod Ohod 38 51 52 54
7 Al-Khaleej Al-Khaleej 38 42 47 52
8 Al-Shoalah FC Al-Shoalah 38 37 33 51
9 Jeddah Club Jeddah Club 38 49 53 51
10 Al-Kawkab Al-Kawkab 38 46 49 49
11 Al-Diriyah Al-Diriyah 38 34 39 48
12 Al-Adalah Club Al-Adalah 38 44 39 46
13 Al-Sahel Al-Sahel 38 34 48 46
14 Al Jeel Al Jeel 38 37 52 44
15 Najran Najran 38 43 47 43
16 Al-Nahdha Al-Nahdha 38 37 45 42
17 Al Bukayriyah Bukayriyah 38 29 48 40
18 Al-Thqba Al-Thqba 38 45 60 37
19 Arar Arar 38 28 62 26
20 Al Najoom Al Najoom 38 27 67 23
TEMPORADA 2019/2020
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Batin Al-Batin 38 52 28 76
2 Al Qadsiah FC Qadsiah 38 71 38 75
3 Al-Ain FC Al-Ain FC 38 57 29 72
4 Al Bukayriyah Bukayriyah 38 65 41 64
5 Al-Nahdha Al-Nahdha 38 55 47 60
6 Al-Jabalain FC Al-Jabalain 38 56 39 57
7 Ohod Ohod 38 51 42 57
8 Jeddah Club Jeddah Club 38 49 49 54
9 Al-Thqba Al-Thqba 38 61 46 53
10 Al-Tai SC Al-Tai SC 38 40 38 48
11 Najran Najran 38 49 51 48
12 Al-Shoalah FC Al-Shoalah 38 43 44 47
13 Al Jeel Al Jeel 38 38 52 46
14 Al-Kawkab Al-Kawkab 38 39 47 45
15 Al-Khaleej Al-Khaleej 38 45 50 44
16 Al Najoom Al Najoom 38 44 62 41
17 Al Mojzel Al Mojzel 38 37 64 39
18 Al-Taqadom Al-Taqadom 38 42 66 38
19 Al-Ansar FC Al-Ansar FC 38 34 62 35
20 Hottain Hottain 38 47 80 31
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
SEGUNDA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Jeddah Club Jeddah Club 18 27 16 35
2 Al Mojzel Al Mojzel 18 27 18 33
3 Al-Muzahimiyyah Al-Muzahimiy 18 26 17 29
4 Hottain Hottain 18 25 25 28
5 Al-Diriyah Al-Diriyah 18 28 29 24
6 Al-Washm Al-Washm 18 19 22 24
7 Abha Abha 18 14 15 20
8 Al Suqoor Al Suqoor 18 25 33 19
9 Al-Trgee Al-Trgee 18 18 26 16
10 Al-Safa Al-Safa 18 15 23 16
11 Al-Kawkab Al-Kawkab 18 25 15 31
12 Al-Ansar FC Al-Ansar FC 18 25 19 30
13 Al-Jabalain FC Al-Jabalain 18 30 26 27
14 Al-Ain FC Al-Ain FC 18 27 32 25
15 Al-Riyadh SC Al-Riyadh 18 26 23 24
16 Al-Thqba Al-Thqba 18 26 27 24
17 Al Sharq Al Sharq 18 26 24 23
18 Al Badaya Al Badaya 18 19 24 20
19 Sdoos Club Sdoos Club 18 19 23 18
20 Al-Najma FC Al-Najma FC 18 17 27 18
TEMPORADA 2015/2016
SEGUNDA ARABIA SAUDÍ GRUPO 2
Equipo PJ GF GC Puntos
1 Al-Qaisumah FC Al-Qaisumah 18 36 18 40
2 Al Badaya Al Badaya 18 25 13 31
3 Al-Muzahimiyyah Al-Muzahimiy 18 24 20 29
4 Sdoos Club Sdoos Club 18 30 23 28
5 Al-Kawkab Al-Kawkab 18 25 21 27
6 Al Sharq Al Sharq 18 24 24 25
7 Abha Abha 18 19 24 20
8 Al-Ansar FC Al-Ansar FC 18 25 27 19
9 Al-Okhdood Al-Okhdood 18 17 26 17
10 Al-Qalah Al-Qalah 18 10 39 7
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
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Hajer FC Hajer FC 30 45 28 57
2 Al-Khaleej Al-Khaleej 30 57 27 55
3 Al-Wehda Al-Wehda 30 48 28 52
4 Al-Tai SC Al-Tai SC 30 35 29 46
5 Al-Riyadh SC Al-Riyadh 30 52 44 45
6 Al Qadsiah FC Qadsiah 30 31 23 45
7 Al-Hazem SC Al-Hazem SC 30 37 35 44
8 Al-Diriyah Al-Diriyah 30 42 43 41
9 Al-Batin Al-Batin 30 39 38 40
10 Abha Abha 30 41 40 39
11 Al Jeel Al Jeel 30 37 42 38
12 Al Watani Al Watani 30 36 41 35
13 Hottain Hottain 30 35 56 30
14 Ohod Ohod 30 35 51 28
15 Al-Ansar FC Al-Ansar FC 30 27 50 27
16 Al-Kawkab Al-Kawkab 30 39 61 24
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
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Najma FC Al-Najma FC 18 36 16 35
2 Al-Kawkab Al-Kawkab 18 26 16 32
3 Al-Adalah Club Al-Adalah 18 25 15 30
4 Al-Arabi SC Al-Arabi SC 18 18 18 29
5 Al-Safa Al-Safa 18 22 22 25
6 Al-Oyoon Al-Oyoon 18 24 25 24
7 Al Taraji Al Taraji 18 22 29 22
8 Najd Najd 18 25 27 20
9 Al-Okhdood Al-Okhdood 18 19 25 14
10 Al Nakheal Al Nakheal 18 15 39 12
TEMPORADA 2010/2011
SEGUNDA ARABIA SAUDÍ GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Nahdha Al-Nahdha 18 50 16 41
2 Al-Kawkab Al-Kawkab 18 28 21 33
3 Sdoos Club Sdoos Club 18 30 19 32
4 Al-Arabi SC Al-Arabi SC 18 23 17 26
5 Al-Fayha Al-Fayha 18 23 24 24
6 Al Nakheal Al Nakheal 18 24 25 23
7 Al-Okhdood Al-Okhdood 18 27 28 22
8 Al-Taqadom Al-Taqadom 18 21 31 21
9 Al Ared Al Ared 18 25 46 17
10 Al Hait Al Hait 18 15 39 7

  USO DE MEMORIA  
6,913,640 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.6815
Total Execution Time  0.6835
  CADENA URL  
/historico/Al-Kawkab
  GET DATOS  
$_GET['/historico/Al-Kawkab']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0154  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 = 'Al-Kawkab' 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.0146  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=17266 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=17266 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0293  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 = 73649
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=17266 AND type_rel = 2
0.0146  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1549 AND type_rel = 3
0.0147  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1549 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0146  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 (578301) ORDER BY n.cover_points DESC, update_date DESC
0.0161  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 = '17266' ORDER BY l.year DESC,cat.coefficient DESC
0.0151  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 = '17266' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0155  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 = '17266' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  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 = 73649 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0151  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=17266 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0146  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 (73649) 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.0145  SELECT count(id) as num_players from rel_players WHERE league_id = 73649 AND teamId = 17266
0.0153  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 = 73649 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 = '17266' 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 = '17266' and rp.type = 4
0.0147  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 = '17266' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0147  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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 17266 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.0146  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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 17266 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0147  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 = 73649 WHERE rp.league_id = 73649 AND rp.teamId = 17266 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0149  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 = 17266 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0152  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 = 73649 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.0152  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 = 69722 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.0153  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 = 64123 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0152  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 = 59698 AND t.round = 38 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 = 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.0166  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.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 `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 = 36095 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0153  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 = 15564 AND t.round = 18 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 = 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.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 = 3553 AND t.round = 30 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 `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.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 = 27923 AND t.round = 18 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 = 27930 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC