4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2021/2022
Equipo PJ GF GC Puntos
1 Al-Seeb Al-Seeb 26 50 17 55
2 Al-Nahda Al-Nahda 26 35 17 53
3 Dhofar Dhofar 26 39 17 48
4 Al Musannah Al Musannah 26 33 24 43
5 Al-Nasr Salalah Al-Nasr 26 28 22 42
6 Sohar Sohar 26 32 31 39
7 Al Rustaq Al Rustaq 26 25 24 35
8 Oman FC Oman FC 26 30 33 31
9 Al-Suwaiq Al-Suwaiq 26 24 28 31
10 Al Ittihad Al Ittihad 26 20 39 25
11 Bahla Bahla 26 28 35 24
12 Al Shabab Muscat Shabab 26 21 33 22
13 Saham Saham 26 19 36 20
14 Nizwa Nizwa 26 15 43 20
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Dhofar Dhofar 10 19 3 26
2 Al-Seeb Al-Seeb 10 21 3 22
3 Al Musannah Al Musannah 10 14 10 20
4 Al-Nasr Salalah Al-Nasr 10 11 8 18
5 Al-Suwaiq Al-Suwaiq 10 11 9 17
6 Bahla Bahla 10 10 9 15
7 Al Rustaq Al Rustaq 10 9 9 14
8 Al-Nahda Al-Nahda 10 9 9 12
9 Al Ittihad Al Ittihad 10 10 12 12
10 Oman FC Oman FC 10 6 9 11
11 Sohar Sohar 10 8 14 8
12 Nizwa Nizwa 10 8 15 7
13 Saham Saham 10 7 20 6
14 Al Shabab Muscat Shabab 10 4 17 3
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Al-Seeb Al-Seeb 26 38 13 57
2 Dhofar Dhofar 26 44 13 52
3 Al-Nahda Al-Nahda 26 40 34 40
4 Fanja Fanja 26 42 41 39
5 Al-Nasr Salalah Al-Nasr 26 28 31 37
6 Bahla Bahla 26 33 25 35
7 Al Shabab Muscat Shabab 26 35 35 35
8 Al-Suwaiq Al-Suwaiq 26 30 30 35
9 Al Rustaq Al Rustaq 26 33 30 33
10 Saham Saham 26 32 36 33
11 Sohar Sohar 26 28 30 32
12 Oman FC Oman FC 26 21 38 27
13 Al-Oruba Al-Oruba 26 21 33 26
14 Mrbat Mrbat 26 20 56 12
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Dhofar Dhofar 18 36 8 44
2 Al-Nasr Salalah Al-Nasr 19 29 20 33
3 Al-Nahda Al-Nahda 18 25 17 30
4 Mrbat Mrbat 18 19 16 27
5 Al Shabab Muscat Shabab 19 23 22 27
6 Al-Oruba Al-Oruba 19 21 13 26
7 Sohar Sohar 18 28 26 25
8 Al-Suwaiq Al-Suwaiq 18 20 19 25
9 Saham Saham 18 25 29 25
10 Al Rustaq Al Rustaq 18 17 18 21
11 Mjees FC Mjees FC 19 10 27 17
12 Al-Shabab Al-Shabab 18 21 33 16
13 Sur Club Sur Club 18 18 30 15
14 Oman FC Oman FC 18 17 31 15
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 26 50 25 63
2 Al-Shabab Al-Shabab 26 32 30 42
3 Al-Nahda Al-Nahda 26 41 34 37
4 Al-Nasr Salalah Al-Nasr 26 28 26 35
5 Al-Oruba Al-Oruba 26 22 26 34
6 Dhofar Dhofar 26 34 31 33
7 Saham Saham 26 36 35 33
8 Sohar Sohar 26 37 42 33
9 Al Shabab Muscat Shabab 26 34 39 33
10 Mrbat Mrbat 26 35 47 32
11 Oman FC Oman FC 26 31 27 31
12 Fanja Fanja 26 33 34 31
13 Al-Mudhaibi Al-Mudhaibi 26 26 34 31
14 Al Salam Al Salam 26 25 34 30
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Dhofar Dhofar 26 44 27 51
2 Al-Shabab Al-Shabab 26 42 27 48
3 Al-Oruba Al-Oruba 26 45 37 45
4 Al-Nasr Salalah Al-Nasr 26 31 30 39
5 Fanja Fanja 26 42 40 37
6 Al-Suwaiq Al-Suwaiq 26 35 25 36
7 Saham Saham 26 40 45 36
8 Sohar Sohar 26 36 36 35
9 Al-Nahda Al-Nahda 26 33 34 33
10 Al Shabab Muscat Shabab 26 36 36 31
11 Oman FC Oman FC 26 32 36 31
12 Al Khaboora Al Khaboora 26 28 35 30
13 Jaalan Jaalan 26 27 44 20
14 Al Rustaq Al Rustaq 26 32 51 17
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Fanja Fanja 26 42 20 51
2 Al-Suwaiq Al-Suwaiq 27 30 20 49
3 Al-Oruba Al-Oruba 26 38 17 47
4 Dhofar Dhofar 26 37 36 39
5 Al-Nahda Al-Nahda 26 31 26 38
6 Sohar Sohar 26 31 26 37
7 Al-Nasr Salalah Al-Nasr 26 22 24 36
8 Saham Saham 26 27 28 33
9 Al Khaboora Al Khaboora 27 27 26 31
10 Al-Shabab Al-Shabab 26 29 40 31
11 Al Shabab Muscat Shabab 26 30 33 30
12 Al Musannah Al Musannah 26 21 32 29
13 Sur Club Sur Club 26 23 34 21
14 Salalah Salalah 26 19 45 14
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Al-Oruba Al-Oruba 26 34 23 49
2 Fanja Fanja 26 43 34 47
3 Sur Club Sur Club 26 37 26 46
4 Al-Nasr Salalah Al-Nasr 26 46 31 41
5 Dhofar Dhofar 26 41 32 38
6 Al-Nahda Al-Nahda 26 40 36 38
7 Al Khaboora Al Khaboora 26 34 31 37
8 Al Musannah Al Musannah 26 41 37 33
9 Al-Suwaiq Al-Suwaiq 26 31 41 33
10 Al-Shabab Al-Shabab 26 35 39 32
11 Saham Saham 26 36 37 31
12 Sohar Sohar 26 25 32 30
13 Busher Busher 26 23 47 21
14 Al-Seeb Al-Seeb 26 22 42 18
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Al-Nahda Al-Nahda 26 57 23 57
2 Fanja Fanja 26 44 27 52
3 Al-Suwaiq Al-Suwaiq 26 48 32 47
4 Al-Seeb Al-Seeb 26 38 27 42
5 Al Musannah Al Musannah 26 25 24 37
6 Dhofar Dhofar 26 28 19 36
7 Sohar Sohar 26 35 35 36
8 Saham Saham 26 36 34 35
9 Sur Club Sur Club 26 38 38 34
10 Al-Shabab Al-Shabab 26 36 38 34
11 Al-Oruba Al-Oruba 26 29 34 34
12 Al-Nasr Salalah Al-Nasr 26 27 35 28
13 Mjees FC Mjees FC 26 27 65 14
14 Al Ittihad Al Ittihad 26 20 57 8
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 26 33 21 50
2 Fanja Fanja 26 33 24 50
3 Saham Saham 26 40 19 48
4 Al-Nahda Al-Nahda 26 41 30 43
5 Al-Nasr Salalah Al-Nasr 26 39 29 40
6 Dhofar Dhofar 26 34 28 40
7 Al-Oruba Al-Oruba 26 26 22 35
8 Al-Shabab Al-Shabab 26 31 31 33
9 Al Musannah Al Musannah 26 26 32 31
10 Sur Club Sur Club 26 26 30 30
11 Al-Seeb Al-Seeb 26 22 33 29
12 Al Taleea Al Taleea 26 26 38 27
13 Oman FC Oman FC 26 25 38 24
14 Salalah Salalah 26 23 50 15
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 Fanja Fanja 22 31 19 43
2 Al-Shabab Al-Shabab 22 28 19 43
3 Al-Oruba Al-Oruba 22 28 16 40
4 Al Taleea Al Taleea 22 23 22 32
5 Dhofar Dhofar 22 19 18 31
6 Oman FC Oman FC 22 24 25 30
7 Al-Suwaiq Al-Suwaiq 22 30 22 28
8 Sur Club Sur Club 22 20 23 28
9 Al-Nahda Al-Nahda 22 27 33 27
10 Salalah Salalah 22 22 35 25
11 Al Musannah Al Musannah 22 35 39 22
12 Al Ahli / Sedab Ahli Sedab 22 24 40 13
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 22 31 15 43
2 Al-Oruba Al-Oruba 22 31 14 40
3 Al-Nahda Al-Nahda 22 30 18 38
4 Dhofar Dhofar 22 24 22 30
5 Oman FC Oman FC 22 24 22 29
6 Al-Shabab Al-Shabab 22 25 29 28
7 Salalah Salalah 22 25 29 27
8 Al Taleea Al Taleea 22 27 27 26
9 Al Shabab Muscat Shabab 22 23 30 26
10 Saham Saham 22 18 27 26
11 Al Ahli / Sedab Ahli Sedab 22 14 23 26
12 Al-Nasr Salalah Al-Nasr 22 17 33 19
Ver
TEMPORADA 2009/2010
Equipo PJ GF GC Puntos
1 Al-Suwaiq Al-Suwaiq 22 30 18 44
2 Dhofar Dhofar 22 33 26 41
3 Al-Nahda Al-Nahda 22 29 21 40
4 Al Shabab Muscat Shabab 22 26 22 30
5 Al Taleea Al Taleea 22 21 28 27
6 Saham Saham 22 19 26 27
7 Al-Nasr Salalah Al-Nasr 22 25 27 26
8 Al-Shabab Al-Shabab 22 30 25 25
9 Oman FC Oman FC 22 27 29 25
10 Al-Oruba Al-Oruba 22 18 22 25
11 Al Khaboora Al Khaboora 22 20 27 24
12 Al-Seeb Al-Seeb 22 19 26 24
Ver
TEMPORADA 2008/2009
Equipo PJ GF GC Puntos
1 Al-Nahda Al-Nahda 22 32 15 45
2 Al Shabab Muscat Shabab 22 24 13 37
3 Al-Oruba Al-Oruba 22 26 14 36
4 Al Khaboora Al Khaboora 22 27 19 35
5 Saham Saham 22 30 29 30
6 Al-Shabab Al-Shabab 22 27 31 30
7 Dhofar Dhofar 22 24 33 29
8 Al Taleea Al Taleea 22 32 31 28
9 Al-Seeb Al-Seeb 22 25 24 26
10 Al-Nasr Salalah Al-Nasr 22 28 30 25
11 Sur Club Sur Club 22 20 33 21
12 Shar Shar 22 19 42 14
Ver
TEMPORADA 2007/2008
Equipo PJ GF GC Puntos
1 Al-Oruba Al-Oruba 22 36 16 45
2 Dhofar Dhofar 22 32 16 38
3 Al Khaboora Al Khaboora 22 29 20 34
4 Al-Seeb Al-Seeb 22 25 20 33
5 Al-Nasr Salalah Al-Nasr 22 19 19 33
6 Sur Club Sur Club 22 28 23 31
7 Al-Nahda Al-Nahda 22 20 20 28
8 Al Shabab Muscat Shabab 22 18 27 27
9 Al Taleea Al Taleea 22 23 26 26
10 Al Wehda Al Wehda 22 25 34 25
11 Oman FC Oman FC 22 27 39 21
12 Bahla Bahla 22 23 45 13
Ver
TEMPORADA 2006/2007
Equipo PJ GF GC Puntos
1 Al-Nahda Al-Nahda 22 35 20 43
2 Al-Oruba Al-Oruba 22 28 18 41
3 Dhofar Dhofar 22 31 22 36
4 Al-Nasr Salalah Al-Nasr 22 28 19 35
5 Al Shabab Muscat Shabab 22 26 18 32
6 Al Taleea Al Taleea 22 19 17 32
7 Al-Seeb Al-Seeb 22 31 29 30
8 Sur Club Sur Club 22 24 25 29
9 Bahla Bahla 22 24 32 22
10 Al Khaboora Al Khaboora 22 15 26 22
11 Mjees FC Mjees FC 22 16 32 20
12 Al Salam Al Salam 22 24 43 17
Ver
TEMPORADA 2005/2006
Equipo PJ GF GC Puntos
1 Al Shabab Muscat Shabab 22 33 15 45
2 Al-Nahda Al-Nahda 22 39 18 43
3 Al Taleea Al Taleea 22 35 22 43
4 Al-Nasr Salalah Al-Nasr 22 32 27 35
5 Sur Club Sur Club 22 26 25 33
6 Al-Seeb Al-Seeb 22 24 21 32
7 Al-Oruba Al-Oruba 22 26 25 32
8 Bahla Bahla 22 27 37 25
9 Al-Suwaiq Al-Suwaiq 22 27 29 21
10 Mjees FC Mjees FC 22 22 38 21
11 Dhofar Dhofar 22 19 28 20
12 Oman FC Oman FC 22 17 42 10

  USO DE MEMORIA  
6,630,840 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.1226
Total Execution Time  0.1246
  CADENA URL  
/league_oman2022/grupo1/historico
  GET DATOS  
$_GET['/league_oman2022/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (36)  
0.0018  SELECT type FROM routes WHERE alias = 'league_oman2022'
0.0039  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_oman' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=502 AND type_rel = 3
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 502 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 (1083737,117382,41760) ORDER BY n.cover_points DESC, update_date DESC
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=502 ORDER BY order_id ASC
0.0018  SELECT max(l.year) as max_year, min(l.year) as min_year FROM leagues l WHERE categoryID = 502 GROUP BY l.categoryId
0.0018  SELECT l.year FROM leagues AS l WHERE (l.group_code =0 OR l.total_num_tablesR>=1 OR l.total_teamsR >=1 OR l.text_mode != 0) AND l.categoryId=502 GROUP BY l.year ORDER BY l.year DESC
0.0019  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 65354 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 502 AND group_code = 1 and tables = 1 AND year <= 2022 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
0.0021  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 = 65354 AND t.round = 26 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 `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 = 60364 AND t.round = 10 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 50034 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 44749 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 39727 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 34738 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 `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 = 15596 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 `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 = 4144 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 `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 = 3259 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 `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 = 24159 AND t.round = 26 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 `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 = 24163 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 = 24165 AND t.round = 22 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 `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 = 24167 AND t.round = 22 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 `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 = 24170 AND t.round = 22 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 = 24182 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2007` 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 = 24183 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  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 `tables2006` 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 = 24184 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-20 05:11:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-20 05:11:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-20 05:11:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-20 05:11:57' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0024  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'league_oman' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0068  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65354 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65354 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65354 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65354 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0020  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2022 e ON e.player_id = p.id AND e.league_id = 65354 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 65354 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0028  SELECT *,(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 = 65354 AND t.round = 26 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC