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

Al-Rayyan

Entrenador: Leonardo Jardim

Temporada 2020/2021
TEMPORADA 2020/2021
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Sadd Al-Sadd 22 77 14 60
2 Al-Duhail Al-Duhail 22 53 25 47
3 Al-Rayyan Al-Rayyan 22 31 22 35
4 Al-Gharafa Al-Gharafa 22 41 34 33
5 Al-Ahli SC Al-Ahli SC 22 28 38 33
6 Qatar SC Qatar SC 22 30 24 32
7 Al-Arabi Doha Al-Arabi 22 28 32 29
8 Al-Wakrah Al-Wakrah 22 19 29 26
9 Al-Sailiya Al-Sailiya 22 22 36 26
10 Umm Salal Umm Salal 22 13 31 21
11 Al-Khor Al-Khor 22 17 42 17
12 Al Kharitiyath Kharitiyath 22 17 49 12
TEMPORADA 2019/2020
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Duhail Al-Duhail 22 39 16 52
2 Al-Rayyan Al-Rayyan 22 40 15 51
3 Al-Sadd Al-Sadd 22 51 29 45
4 Al-Gharafa Al-Gharafa 22 34 29 36
5 Al-Sailiya Al-Sailiya 22 22 25 29
6 Al-Wakrah Al-Wakrah 22 28 31 27
7 Al-Arabi Doha Al-Arabi 22 28 28 26
8 Qatar SC Qatar SC 22 18 26 20
9 Al-Ahli SC Al-Ahli SC 22 24 37 20
10 Umm Salal Umm Salal 22 18 37 18
11 Al-Khor Al-Khor 22 25 35 17
12 Al Shahaniya Shahaniya 22 24 43 16
TEMPORADA 2018/2019
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Sadd Al-Sadd 22 100 22 57
2 Al-Duhail Al-Duhail 22 52 17 50
3 Al-Sailiya Al-Sailiya 22 38 26 38
4 Al-Rayyan Al-Rayyan 22 34 31 37
5 Al-Ahli SC Al-Ahli SC 22 32 39 34
6 Al-Arabi Doha Al-Arabi 22 27 41 30
7 Al Shahaniya Shahaniya 22 26 34 27
8 Al-Gharafa Al-Gharafa 22 35 39 26
9 Umm Salal Umm Salal 22 24 44 23
10 Al-Khor Al-Khor 22 22 36 20
11 Qatar SC Qatar SC 22 20 42 16
12 Al Kharitiyath Kharitiyath 22 19 58 15
TEMPORADA 2017/2018
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Duhail Al-Duhail 22 86 27 60
2 Al-Sadd Al-Sadd 22 68 25 49
3 Al-Rayyan Al-Rayyan 22 54 39 43
4 Al-Gharafa Al-Gharafa 22 43 34 35
5 Umm Salal Umm Salal 22 33 34 33
6 Al-Sailiya Al-Sailiya 22 40 42 28
7 Al-Arabi Doha Al-Arabi 22 30 42 24
8 Al-Khor Al-Khor 22 24 39 24
9 Al-Ahli SC Al-Ahli SC 22 25 43 22
10 Qatar SC Qatar SC 22 24 46 22
11 Al Kharitiyath Kharitiyath 22 29 62 16
12 Al-Markhiya Al-Markhiya 22 19 42 13
TEMPORADA 2016/2017
LIGA CATAR
Equipo PJ GF GC Puntos
1 Lekhwiya Lekhwiya 26 79 33 63
2 Al-Sadd Al-Sadd 26 77 23 61
3 Al-Rayyan Al-Rayyan 26 53 27 51
4 El Jaish El Jaish 26 45 40 45
5 Al-Gharafa Al-Gharafa 26 42 43 40
6 Umm Salal Umm Salal 26 32 35 37
7 Al Kharitiyath Kharitiyath 26 27 32 34
8 Al-Sailiya Al-Sailiya 26 32 45 31
9 Al-Arabi Doha Al-Arabi 26 39 56 28
10 Al-Ahli SC Al-Ahli SC 26 33 45 27
11 Al-Khor Al-Khor 26 27 40 25
12 Al Shahaniya Shahaniya 26 30 53 22
13 Muaither Muaither 26 25 48 20
14 Al-Wakrah Al-Wakrah 26 29 50 15
TEMPORADA 2015/2016
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Rayyan Al-Rayyan 26 69 23 62
2 Al-Sadd Al-Sadd 26 55 37 50
3 El Jaish El Jaish 26 48 29 48
4 Lekhwiya Lekhwiya 26 60 41 44
5 Umm Salal Umm Salal 26 39 34 41
6 Al-Ahli SC Al-Ahli SC 26 42 40 37
7 Al-Arabi Doha Al-Arabi 26 33 37 35
8 Al-Gharafa Al-Gharafa 26 33 37 34
9 Al-Khor Al-Khor 26 25 31 33
10 Al-Sailiya Al-Sailiya 26 39 47 33
11 Al-Wakrah Al-Wakrah 26 34 45 30
12 Al Kharitiyath Kharitiyath 26 38 47 27
13 Qatar SC Qatar SC 26 31 51 27
14 Al Mesaimeer Mesaimeer 26 15 62 6
TEMPORADA 2014/2015
SEGUNDA CATAR
Equipo PJ GF GC Puntos
1 Al-Rayyan Al-Rayyan 17 87 13 48
2 Muaither Muaither 17 55 18 40
3 Al Mesaimeer Mesaimeer 17 61 38 38
4 Al-Markhiya Al-Markhiya 17 37 31 31
5 Al Gharafa II Gharafa 17 43 36 28
6 Al Sadd II Al Sadd II 17 36 35 26
7 Al Kharitiyath II Kharitiyath 17 34 47 24
8 Lekhwiya II Lekhwiya II 17 43 32 22
9 Al Arabi II Al Arabi II 17 38 32 22
10 Umm Salal II Salal 17 32 38 20
11 El Jaish II El Jaish II 17 39 52 19
12 Al Ahli II Al Ahli II 17 24 41 19
13 Al Shahaniya II Shahaniya 17 31 39 18
14 Al Shamal II Shamal 17 16 38 18
15 Al Wakrah II Wakrah 17 25 35 17
16 Al Sailiya II Sailiya 17 29 48 16
17 Qatar II Qatar II 17 27 36 15
18 Al Khor II Al Khor II 17 21 69 11
TEMPORADA 2013/2014
LIGA CATAR
Equipo PJ GF GC Puntos
1 Lekhwiya Lekhwiya 26 55 30 53
2 El Jaish El Jaish 26 39 27 48
3 Al-Sadd Al-Sadd 26 54 30 47
4 Al-Sailiya Al-Sailiya 26 45 37 42
5 Al-Arabi Doha Al-Arabi 26 41 41 39
6 Al-Ahli SC Al-Ahli SC 26 48 50 34
7 Umm Salal Umm Salal 26 34 36 34
8 Al-Gharafa Al-Gharafa 26 40 41 32
9 Al-Wakrah Al-Wakrah 26 41 48 32
10 Qatar SC Qatar SC 26 34 40 31
11 Al-Khor Al-Khor 26 29 30 30
12 Al Kharaitiyat Kharaitiyat 26 31 34 29
13 Al-Rayyan Al-Rayyan 26 34 40 29
14 Muaither Muaither 26 28 69 14
TEMPORADA 2012/2013
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Sadd Al-Sadd 22 47 23 51
2 Lekhwiya Lekhwiya 22 42 22 46
3 El Jaish El Jaish 22 25 23 40
4 Al-Rayyan Al-Rayyan 22 49 37 37
5 Umm Salal Umm Salal 22 30 37 31
6 Al-Gharafa Al-Gharafa 22 26 28 30
7 Al-Khor Al-Khor 22 26 24 29
8 Qatar SC Qatar SC 22 31 34 26
9 Al-Wakrah Al-Wakrah 22 27 31 26
10 Al Kharitiyath Kharitiyath 22 21 27 20
11 Al-Arabi Doha Al-Arabi 22 25 40 17
12 Al-Sailiya Al-Sailiya 22 29 52 13
TEMPORADA 2011/2012
LIGA CATAR
Equipo PJ GF GC Puntos
1 Lekhwiya Lekhwiya 22 36 16 43
2 El Jaish El Jaish 22 48 24 41
3 Al-Rayyan Al-Rayyan 22 49 26 39
4 Al-Sadd Al-Sadd 22 35 24 36
5 Al-Khor Al-Khor 22 30 29 32
6 Al-Gharafa Al-Gharafa 22 26 27 31
7 Al-Wakrah Al-Wakrah 22 30 37 28
8 Al Kharitiyath Kharitiyath 22 24 35 25
9 Al-Arabi Doha Al-Arabi 22 19 28 24
10 Qatar SC Qatar SC 22 32 46 24
11 Umm Salal Umm Salal 22 20 32 20
12 Al-Ahli SC Al-Ahli SC 22 24 49 12
TEMPORADA 2010/2011
LIGA CATAR
Equipo PJ GF GC Puntos
1 Lekhwiya Lekhwiya 22 40 17 48
2 Al-Gharafa Al-Gharafa 22 51 31 43
3 Al-Rayyan Al-Rayyan 22 39 22 42
4 Al-Arabi Doha Al-Arabi 22 39 26 41
5 Qatar SC Qatar SC 22 40 26 40
6 Al-Sadd Al-Sadd 22 32 26 36
7 Al-Wakrah Al-Wakrah 22 30 36 27
8 Al Kharitiyath Kharitiyath 22 27 40 25
9 Al-Khor Al-Khor 22 24 33 19
10 Umm Salal Umm Salal 22 24 39 19
11 Al-Sailiya Al-Sailiya 22 25 47 15
12 Al-Ahli SC Al-Ahli SC 22 16 44 15
TEMPORADA 2009/2010
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Gharafa Al-Gharafa 22 55 16 53
2 Al-Sadd Al-Sadd 22 55 22 50
3 Al-Arabi Doha Al-Arabi 22 52 30 40
4 Qatar SC Qatar SC 22 32 23 38
5 Al-Rayyan Al-Rayyan 22 41 30 37
6 Al Kharitiyath Kharitiyath 22 23 36 29
7 Umm Salal Umm Salal 22 27 30 28
8 Al-Wakrah Al-Wakrah 22 44 44 27
9 Al-Khor Al-Khor 22 21 30 20
10 Al-Ahli SC Al-Ahli SC 22 31 53 20
11 Al-Sailiya Al-Sailiya 22 16 28 19
12 Al-Shamal Al-Shamal 22 17 72 8
TEMPORADA 2008/2009
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Gharafa Al-Gharafa 27 56 33 56
2 Al-Sadd Al-Sadd 27 60 25 52
3 Al-Rayyan Al-Rayyan 27 62 35 52
4 Qatar SC Qatar SC 27 42 36 43
5 Al-Khor Al-Khor 27 38 28 40
6 Umm Salal Umm Salal 27 46 45 35
7 Al-Arabi Doha Al-Arabi 27 37 51 29
8 Al-Wakrah Al-Wakrah 27 32 56 27
9 Al-Sailiya Al-Sailiya 27 31 55 20
10 Al Kharitiyath Kharitiyath 27 19 59 15
TEMPORADA 2007/2008
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Gharafa Al-Gharafa 27 72 35 62
2 Al-Sadd Al-Sadd 27 54 38 53
3 Umm Salal Umm Salal 27 45 36 50
4 Qatar SC Qatar SC 27 53 38 46
5 Al-Rayyan Al-Rayyan 27 39 42 39
6 Al-Arabi Doha Al-Arabi 27 37 35 33
7 Al-Khor Al-Khor 27 35 48 28
8 Al-Sailiya Al-Sailiya 27 33 46 27
9 Al-Wakrah Al-Wakrah 27 41 67 27
10 Al-Shamal Al-Shamal 27 27 51 18
TEMPORADA 2006/2007
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Sadd Al-Sadd 27 52 29 55
2 Al-Gharafa Al-Gharafa 27 51 41 43
3 Umm Salal Umm Salal 27 35 28 39
4 Al-Rayyan Al-Rayyan 27 40 42 37
5 Al-Wakrah Al-Wakrah 27 29 29 34
6 Qatar SC Qatar SC 27 35 36 34
7 Al-Khor Al-Khor 27 35 40 33
8 Al-Shamal Al-Shamal 27 26 36 32
9 Al-Arabi Doha Al-Arabi 27 35 41 30
10 Al-Ahli SC Al-Ahli SC 27 29 45 29
TEMPORADA 2005/2006
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Sadd Al-Sadd 27 48 33 52
2 Qatar SC Qatar SC 27 49 34 49
3 Al-Arabi Doha Al-Arabi 27 41 36 46
4 Al-Rayyan Al-Rayyan 27 30 28 41
5 Al-Ahli SC Al-Ahli SC 27 44 40 39
6 Al-Gharafa Al-Gharafa 27 29 30 34
7 Al-Khor Al-Khor 27 44 49 33
8 Al-Wakrah Al-Wakrah 27 29 32 32
9 Al-Shamal Al-Shamal 27 41 56 23
10 Al-Sailiya Al-Sailiya 27 30 47 23
TEMPORADA 2004/2005
LIGA CATAR
Equipo PJ GF GC Puntos
1 Al-Gharafa Al-Gharafa 27 71 23 66
2 Al-Rayyan Al-Rayyan 27 66 34 52
3 Al-Khor Al-Khor 27 46 30 48
4 Qatar SC Qatar SC 27 40 34 45
5 Al-Arabi Doha Al-Arabi 27 53 35 44
6 Al-Wakrah Al-Wakrah 27 37 35 34
7 Al-Sadd Al-Sadd 27 35 35 34
8 Al-Ahli SC Al-Ahli SC 27 35 55 28
9 Al-Shamal Al-Shamal 27 22 67 15
10 Al Kharitiyath Kharitiyath 27 24 81 10

  USO DE MEMORIA  
7,002,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0021
Controller Execution Time ( Home / Category )  0.2411
Total Execution Time  0.2432
  CADENA URL  
/historico/Al-Rayyan/2021
  GET DATOS  
$_GET['/historico/Al-Rayyan/2021']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (53)  
0.0035  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-Rayyan' AND l.year = 2021 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.0030  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=5774 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=5774 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0032  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=5774 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=5774 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=5774 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0032  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=5774 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=5774 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0027  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 = 61153
0.0026  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 = 61101
0.0026  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 = 59360
0.0078  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 = 60067
0.0025  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 = 61343
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=5774 AND type_rel = 2
0.0021  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 5774 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0045  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 (833,867,869,995,1023) ORDER BY n.cover_points DESC, update_date DESC
0.0039  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 = '5774' AND l.year = 2021 ORDER BY l.year DESC,cat.coefficient DESC
0.0038  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 = '5774' 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 = 61153 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 = 61343 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 = 61101 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 = 59360 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0021  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 = 58561 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0033  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=5774 AND l.year in (2020,2021,2022) ORDER BY l.id DESC, l.year DESC ;
0.0019  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 (67473,66291,66186,63292,62807,61343,53469) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 63292 AND teamId = 5774
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 67473 AND teamId = 5774
0.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 53469 AND teamId = 5774
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 66291 AND teamId = 5774
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 66186 AND teamId = 5774
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 61343 AND teamId = 5774
0.0130  SELECT count(id) as num_players from rel_players WHERE league_id = 62807 AND teamId = 5774
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 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 = 58561 AND t.round = 22 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0039  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 events2021 e ON e.player_id = p.id AND e.league_id = 58561 WHERE rp.league_id = 58561 AND rp.teamId = 5774 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.0032  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 events2021 e ON e.player_id = p.id AND e.league_id = 58561 WHERE rp.league_id = 58561 AND rp.teamId = 5774 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 events2021 e ON e.player_id = p.id AND e.league_id = 58561 WHERE rp.league_id = 58561 AND rp.teamId = 5774 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0033  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 = 5774 AND l.year <= 2021 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 49874 AND t.round = 22 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 = 43560 AND t.round = 22 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 `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 = 29153 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 `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 = 15717 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 `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 = 8470 AND t.round = 17 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 `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 = 3253 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 = 2263 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 `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 = 15694 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 `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 = 15693 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 `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 = 15692 AND t.round = 22 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 `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 = 15691 AND t.round = 27 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 `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 = 15690 AND t.round = 27 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 `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 = 15689 AND t.round = 27 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 `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 = 15688 AND t.round = 27 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 `tables2005` 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 = 15687 AND t.round = 27 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 58561 ORDER BY nameShow LIMIT 100