4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Najran
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
PRIMERA ARABIA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ahli SFC Al-Ahli SFC 34 48 24 72
2 Al-Okhdood Al-Okhdood 34 65 35 68
3 Al-Hazem SC Al-Hazem SC 34 55 29 68
4 Al-Riyadh SC Al-Riyadh 34 52 37 63
5 Al-Faisaly FC Al-Faisaly 34 45 32 58
6 Al-Arabi SC Al-Arabi SC 34 43 43 49
7 Al-Kholood Al-Kholood 34 33 31 43
8 Hajer FC Hajer FC 34 36 41 43
9 Ohod Ohod 34 29 38 42
10 Al-Jabalain FC Al-Jabalain 34 42 43 41
11 Al-Orubah FC Al-Orubah 34 35 41 40
12 Al Qadsiah FC Qadsiah 34 29 34 40
13 Al-Qaisumah FC Al-Qaisumah 34 35 44 40
14 Al-Ain FC Al-Ain FC 34 34 46 39
15 Jeddah Club Jeddah Club 34 34 40 38
16 Najran Najran 34 36 55 36
17 Al-Sahel Al-Sahel 34 36 51 32
18 Al-Shoalah FC Al-Shoalah 34 23 46 23
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
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
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
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Hilal SFC Al-Hilal 22 56 18 56
2 Al-Ittihad Al-Ittihad 22 46 30 45
3 Al-Nassr Al-Nassr 22 38 23 43
4 Al-Shabab Al-Shabab 22 36 23 40
5 Al-Wehda Al-Wehda 22 34 27 28
6 Al-Ahli SFC Al-Ahli SFC 22 28 29 28
7 Al-Hazem SC Al-Hazem SC 22 29 38 24
8 Al-Fateh SC Al-Fateh SC 22 26 38 24
9 Al-Ettifaq Al-Ettifaq 22 24 30 22
10 Al Qadsiah FC Qadsiah 22 20 40 20
11 Al-Raed Al-Raed 22 18 35 16
12 Najran Najran 22 22 46 16
TEMPORADA 2008/2009
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ittihad Al-Ittihad 22 57 21 55
2 Al-Hilal SFC Al-Hilal 22 41 9 50
3 Al-Ahli SFC Al-Ahli SFC 22 33 20 40
4 Al-Shabab Al-Shabab 22 37 29 35
5 Al-Nassr Al-Nassr 22 24 22 34
6 Al-Ettifaq Al-Ettifaq 22 23 20 29
7 Al-Wehda Al-Wehda 22 33 39 26
8 Al-Hazem SC Al-Hazem SC 22 25 31 25
9 Najran Najran 22 22 42 21
10 Al-Raed Al-Raed 22 28 43 19
11 Abha Abha 22 19 40 19
12 Al Watani Al Watani 22 22 48 12
TEMPORADA 2007/2008
LIGA SAUDÍ
Equipo PJ GF GC Puntos
1 Al-Ittihad Al-Ittihad 22 39 16 48
2 Al-Hilal SFC Al-Hilal 22 36 13 48
3 Al-Shabab Al-Shabab 22 39 21 42
4 Al-Ettifaq Al-Ettifaq 22 34 25 35
5 Al-Nassr Al-Nassr 22 34 35 33
6 Al-Wehda Al-Wehda 22 29 27 29
7 Al-Hazem SC Al-Hazem SC 22 25 27 27
8 Al-Ahli SFC Al-Ahli SFC 22 30 31 26
9 Al Watani Al Watani 22 20 32 25
10 Najran Najran 22 29 44 21
11 Al-Tai SC Al-Tai SC 22 20 37 13
12 Al Qadsiah FC Qadsiah 22 17 44 12

  USO DE MEMORIA  
7,207,736 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.5521
Total Execution Time  0.5534
  CADENA URL  
/historico/Najran
  GET DATOS  
$_GET['/historico/Najran']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (32)  
0.0260  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.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11428 AND type_rel = 2
0.0126  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 11428 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0126  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 (31565) ORDER BY n.cover_points DESC, update_date DESC
0.0130  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 = '11428' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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.0129  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=11428 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 (73649,68577) 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 = 68577 AND teamId = 11428
0.0132  SELECT count(id) as num_players from rel_players WHERE league_id = 73649 AND teamId = 11428
0.0133  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.0127  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 = 11428 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.0127  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 = 11428 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0138  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 = 11428 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0152  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 = 11428 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0141  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.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 = 68577 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 = 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.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 `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.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 = 50042 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.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 `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.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 `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.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 = 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.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 `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.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 = 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.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 `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.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 `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.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 `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.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 `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.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 `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 = 1054 AND t.round = 22 ORDER BY team.conference 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 `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 = 1053 AND t.round = 22 ORDER BY team.conference 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 `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 = 270 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC