4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al-Suwaiq
TEMPORADA 2022/2023
LIGA OMÁN
Equipo PJ GF GC Puntos
1 Al-Nahda Al-Nahda 26 34 8 56
2 Al-Suwaiq Al-Suwaiq 26 36 21 52
3 Al-Seeb Al-Seeb 26 36 14 51
4 Dhofar Dhofar 26 33 19 45
5 Al Rustaq Al Rustaq 26 26 23 43
6 Bahla Bahla 26 34 30 40
7 Oman FC Oman FC 26 25 23 37
8 Sohar Sohar 26 24 24 37
9 Al Musannah Al Musannah 26 22 24 33
10 Al-Nasr Salalah Al-Nasr 26 21 26 30
11 Sur Club Sur Club 26 22 29 28
12 Al Ittihad Al Ittihad 26 14 36 17
13 Al-Oruba Al-Oruba 26 22 45 17
14 Al Bashair Al Bashair 26 17 44 12
TEMPORADA 2021/2022
LIGA OMÁN
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
TEMPORADA 2020/2021
LIGA OMÁN
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
TEMPORADA 2019/2020
LIGA OMÁN
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
TEMPORADA 2018/2019
LIGA OMÁN
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
TEMPORADA 2017/2018
LIGA OMÁN
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
TEMPORADA 2016/2017
LIGA OMÁN
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
TEMPORADA 2015/2016
LIGA OMÁN
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
TEMPORADA 2014/2015
LIGA OMÁN
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
TEMPORADA 2013/2014
LIGA OMÁN
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
TEMPORADA 2012/2013
LIGA OMÁN
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
TEMPORADA 2011/2012
LIGA OMÁN
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
TEMPORADA 2010/2011
LIGA OMÁN
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
TEMPORADA 2009/2010
LIGA OMÁN
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
TEMPORADA 2005/2006
LIGA OMÁN
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,412,440 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2343
Total Execution Time  0.2362
  CADENA URL  
/historico/Al-Suwaiq
  GET DATOS  
$_GET['/historico/Al-Suwaiq']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (83)  
0.0026  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-Suwaiq' 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.0091  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-Suwaiq' 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.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0026  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0024  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0018  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=15518 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0029  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 = 69845
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15518 AND type_rel = 2
0.0027  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 = '15518' ORDER BY l.year DESC,cat.coefficient DESC
0.0023  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 = '15518' AND l.year = 2023 ORDER BY l.year DESC,cat.coefficient DESC
0.0022  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 = '15518' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = '15518' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 69845 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  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 = 68695 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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=15518 AND l.year in (2022,2023,2024) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (69845,68695) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 68695 AND teamId = 15518
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 69845 AND teamId = 15518
0.0040  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff 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 = 68695 AND t.round = 26 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0019  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 = '15518' 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 = '15518' and rp.type = 4
0.0021  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 = '15518' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0035  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 events2023 e ON e.player_id = p.id AND e.league_id = 68695 WHERE rp.league_id = 68695 AND rp.teamId = 15518 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.0022  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 events2023 e ON e.player_id = p.id AND e.league_id = 68695 WHERE rp.league_id = 68695 AND rp.teamId = 15518 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 events2023 e ON e.player_id = p.id AND e.league_id = 68695 WHERE rp.league_id = 68695 AND rp.teamId = 15518 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0023  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 = 15518 AND l.year <= 2023 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 68695 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.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 `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.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 `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.0029  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.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 `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.0036  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.0036  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.0029  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.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 = 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.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 = 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.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 `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.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 `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.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 `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.0032  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.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 dt.nameShow, dt.basealias, t.id, dt.id as dt_id FROM `teams` as t INNER JOIN `datateams` as dt ON dt.id = t.teamId WHERE league_id = 68695 ORDER BY nameShow LIMIT 100