4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Al Fujairah
TEMPORADA 2023/2024
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Urooba Al Urooba 27 49 21 70
2 Dibba Al Fujairah Dibba 27 46 15 55
3 Dibba Al Hisn Dibba Hisn 26 44 20 54
4 United FC United FC 27 52 35 46
5 Al Dhafra Al Dhafra 28 52 37 46
6 Al Fujairah Al Fujairah 28 47 35 46
7 Al Taawon SC Taawon 27 38 29 39
8 Masafi Masafi 27 40 34 39
9 Al Jazira Al Hamra Jazira Hamra 27 42 51 39
10 Al Arabi SC Al Arabi SC 26 42 38 38
11 Al Dhaid Al Dhaid 27 40 45 33
12 Al Hamriyah Al Hamriyah 26 32 39 30
13 Gulf Heroes Gulf Heroes 28 30 40 29
14 Masfut Masfut 27 31 47 26
15 Gulf United Gulf United 28 25 44 23
16 Dubai City Dubai City 27 27 63 11
17 Al Ramms Al Ramms 25 25 69 10
TEMPORADA 2022/2023
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Hatta Club Hatta Club 32 75 37 75
2 Emirates Club Emirates 32 85 33 71
3 Dibba Al Hisn Dibba Hisn 32 72 37 67
4 Masfut Masfut 32 49 40 56
5 Al Hamriyah Al Hamriyah 32 53 45 49
6 Al Arabi SC Al Arabi SC 32 55 42 48
7 Masafi Masafi 32 46 43 47
8 Gulf Heroes Gulf Heroes 32 51 60 44
9 Al Fujairah Al Fujairah 32 48 39 43
10 Al Jazira Al Hamra Jazira Hamra 32 66 64 43
11 Al Taawon SC Taawon 32 44 48 42
12 Al Dhaid Al Dhaid 32 39 50 40
13 Al Urooba Al Urooba 32 51 49 39
14 Al Ramms Al Ramms 32 39 51 32
15 Dubai City Dubai City 32 31 57 24
16 Fursan Hispania Fursan 32 26 81 19
17 Baynounah Baynounah 32 33 87 15
TEMPORADA 2021/2022
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Dibba Al Fujairah Dibba 28 73 15 75
2 Al Bataeh Al Bataeh 28 58 21 67
3 Dibba Al Hisn Dibba Hisn 28 56 26 63
4 Al Arabi SC Al Arabi SC 28 48 24 63
5 Al Hamriyah Al Hamriyah 28 56 34 52
6 Hatta Club Hatta Club 28 44 38 47
7 Al Fujairah Al Fujairah 28 38 32 43
8 Masfut Masfut 28 34 38 35
9 Al Jazira Al Hamra Jazira Hamra 28 41 57 30
10 Masafi Masafi 28 30 42 27
11 Gulf Heroes Gulf Heroes 28 39 64 24
12 Al Ramms Al Ramms 28 29 65 20
13 Al Taawon SC Taawon 28 32 52 19
14 Al Dhaid Al Dhaid 28 28 52 19
15 Dubai City Dubai City 28 26 72 12
TEMPORADA 2020/2021
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Jazira Al-Jazira 26 64 29 57
2 Baniyas Baniyas 26 50 22 54
3 Shabab Al Ahli Dubai Shabab Ahli 26 52 30 50
4 Sharjah FC Sharjah FC 26 48 29 48
5 Al Nasr Dubai Nasr Dubai 26 47 33 46
6 Al-Ain Al-Ain 26 39 33 41
7 Al-Wahda Al-Wahda 26 48 33 40
8 Al Ittihad Kalba Ittihad 26 29 39 39
9 Al-Wasl Al-Wasl 26 49 47 37
10 Khorfakkan Khorfakkan 26 35 50 25
11 Al Dhafra Al Dhafra 26 31 58 21
12 Ajman Ajman 26 24 57 18
13 Al Fujairah Al Fujairah 26 31 57 15
14 Hatta Club Hatta Club 26 19 49 12
TEMPORADA 2019/2020
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Shabab Al Ahli Dubai Shabab Ahli 19 41 13 43
2 Al-Ain Al-Ain 19 46 21 37
3 Al-Jazira Al-Jazira 19 29 17 36
4 Al-Wahda Al-Wahda 19 33 30 35
5 Sharjah FC Sharjah FC 19 38 23 35
6 Al Nasr Dubai Nasr Dubai 19 24 19 31
7 Al-Wasl Al-Wasl 19 31 33 29
8 Al Dhafra Al Dhafra 19 25 24 29
9 Baniyas Baniyas 19 21 27 23
10 Ajman Ajman 19 25 39 18
11 Al Ittihad Kalba Ittihad 19 24 39 16
12 Khorfakkan Khorfakkan 19 18 32 15
13 Hatta Club Hatta Club 19 15 32 13
14 Al Fujairah Al Fujairah 19 15 36 12
TEMPORADA 2018/2019
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Sharjah FC Sharjah FC 26 57 30 59
2 Shabab Al Ahli Dubai Shabab Ahli 26 57 36 53
3 Al-Wahda Al-Wahda 26 63 40 46
4 Al-Ain Al-Ain 26 45 35 46
5 Al-Jazira Al-Jazira 26 66 41 45
6 Baniyas Baniyas 26 50 40 40
7 Ajman Ajman 26 41 40 37
8 Al Nasr Dubai Nasr Dubai 26 42 41 36
9 Al-Wasl Al-Wasl 26 45 54 34
10 Al Dhafra Al Dhafra 26 37 49 29
11 Al Ittihad Kalba Ittihad 26 41 51 25
12 Al Fujairah Al Fujairah 26 36 63 21
13 Emirates Club Emirates 26 30 62 18
14 Dibba Al Fujairah Dibba 26 34 62 17
TEMPORADA 2017/2018
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Baniyas Baniyas 21 52 16 49
2 Al Ittihad Kalba Ittihad 22 44 22 46
3 Al Fujairah Al Fujairah 22 37 21 44
4 Al Hamriyah Al Hamriyah 22 43 40 33
5 Khorfakkan Khorfakkan 21 36 29 30
6 Al Urooba Al Urooba 22 26 28 28
7 Al Dhaid Al Dhaid 22 30 28 26
8 Dibba Al Hisn Dibba Hisn 22 36 37 25
9 Masafi Masafi 22 36 41 25
10 Masfut Masfut 22 23 42 20
11 Al Arabi SC Al Arabi SC 22 20 40 14
12 Ras Al Khaima Khaima 22 18 57 12
TEMPORADA 2016/2017
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Ajman Ajman 22 40 23 45
2 Dubai Dubai 22 37 22 43
3 Al Urooba Al Urooba 22 50 27 37
4 Al Fujairah Al Fujairah 22 38 30 34
5 Dibba Al Hisn Dibba Hisn 22 27 26 33
6 Al Shaab CSC Shaab 22 41 38 28
7 Khorfakkan Khorfakkan 22 29 35 27
8 Masfut Masfut 22 37 47 25
9 Al Dhaid Al Dhaid 22 20 28 24
10 Al Hamriyah Al Hamriyah 22 25 30 23
11 Al Arabi SC Al Arabi SC 22 31 52 23
12 Ras Al Khaima Khaima 22 29 46 20
TEMPORADA 2015/2016
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ahli Dubai Ahli Dubai 26 60 20 66
2 Al-Ain Al-Ain 26 53 24 57
3 Al-Wahda Al-Wahda 26 45 28 43
4 Al Nasr Dubai Nasr Dubai 26 47 36 41
5 Al Shabab Dubai Shabab Dubai 26 34 27 40
6 Al-Wasl Al-Wasl 26 42 36 39
7 Al-Jazira Al-Jazira 26 51 50 37
8 Al Dhafra Al Dhafra 26 37 39 34
9 Baniyas Baniyas 26 41 47 33
10 Dibba Al Fujairah Dibba 26 32 46 29
11 Sharjah FC Sharjah FC 26 32 40 28
12 Emirates Club Emirates 26 34 47 27
13 Al Fujairah Al Fujairah 26 43 62 26
14 Al Shaab CSC Shaab 26 22 71 7
TEMPORADA 2014/2015
LIGA EMIRATOS
Equipo PJ GF GC Puntos
1 Al-Ain Al-Ain 26 62 19 60
2 Al-Jazira Al-Jazira 26 66 46 51
3 Al Shabab Dubai Shabab Dubai 26 49 35 49
4 Al-Wahda Al-Wahda 26 44 32 47
5 Al Nasr Dubai Nasr Dubai 26 43 32 39
6 Al-Wasl Al-Wasl 26 53 45 39
7 Al Ahli Dubai Ahli Dubai 26 35 27 38
8 Baniyas Baniyas 26 42 37 35
9 Al Fujairah Al Fujairah 26 23 45 32
10 Emirates Club Emirates 26 34 45 30
11 Al Dhafra Al Dhafra 26 31 33 27
12 Sharjah FC Sharjah FC 26 36 43 26
13 Ajman Ajman 26 27 60 15
14 Al Ittihad Kalba Ittihad 26 17 63 10
TEMPORADA 2013/2014
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ittihad Kalba Ittihad 24 58 16 59
2 Al Fujairah Al Fujairah 24 64 25 55
3 Dibba Al Fujairah Dibba 24 60 27 55
4 Al Dhaid Al Dhaid 24 52 33 47
5 Dibba Al Hisn Dibba Hisn 24 44 31 42
6 Khorfakkan Khorfakkan 24 32 32 27
7 Al Jazira Al Hamra Jazira Hamra 24 38 52 26
8 Hatta Club Hatta Club 24 48 53 25
9 Al Urooba Al Urooba 24 30 35 24
10 Masafi Masafi 24 25 46 19
11 Al Arabi SC Al Arabi SC 24 34 58 19
12 Al Taawon SC Taawon 24 25 65 19
13 Al Ramms Al Ramms 24 28 65 18
TEMPORADA 2012/2013
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Emirates Club Emirates 26 81 36 59
2 Sharjah FC Sharjah FC 26 58 25 59
3 Hatta Club Hatta Club 26 62 51 46
4 Al Fujairah Al Fujairah 26 63 35 45
5 Dibba Al Hisn Dibba Hisn 26 56 32 43
6 Al Urooba Al Urooba 26 60 36 42
7 Al Dhaid Al Dhaid 26 48 38 39
8 Khorfakkan Khorfakkan 26 44 49 36
9 Al Arabi SC Al Arabi SC 26 43 54 36
10 Masafi Masafi 26 36 39 29
11 Al Taawon SC Taawon 26 36 64 25
12 Al Jazira Al Hamra Jazira Hamra 26 33 65 25
13 Al Ramms Al Ramms 26 37 65 19
14 Masfut Masfut 26 29 97 7
TEMPORADA 2011/2012
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ittihad Kalba Ittihad 21 53 28 43
2 Dibba Al Fujairah Dibba 21 46 28 40
3 Al Shaab CSC Shaab 21 42 38 35
4 Al Dhafra Al Dhafra 21 52 47 34
5 Khorfakkan Khorfakkan 21 35 33 27
6 Al Fujairah Al Fujairah 21 33 30 26
7 Masafi Masafi 21 23 34 22
8 Al Urooba Al Urooba 21 16 62 5
TEMPORADA 2010/2011
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Ajman Ajman 21 48 29 40
2 Emirates Club Emirates 21 44 31 37
3 Dibba Al Fujairah Dibba 21 36 29 32
4 Al Urooba Al Urooba 21 23 23 31
5 Al Fujairah Al Fujairah 21 25 31 31
6 Khorfakkan Khorfakkan 21 41 44 28
7 Al Shaab CSC Shaab 21 27 33 25
8 Al Dhaid Al Dhaid 21 16 40 9
TEMPORADA 2009/2010
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Al Ittihad Kalba Ittihad 14 30 24 27
2 Dubai Dubai 14 32 20 25
3 Al Shaab CSC Shaab 14 21 18 24
4 Al Fujairah Al Fujairah 14 25 21 20
5 Al Urooba Al Urooba 14 23 23 19
6 Khorfakkan Khorfakkan 14 23 25 19
7 Hatta Club Hatta Club 14 20 24 15
8 Dibba Al Hisn Dibba Hisn 14 17 36 7
TEMPORADA 2008/2009
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Baniyas Baniyas 30 80 25 70
2 Emirates Club Emirates 30 84 39 62
3 Al Fujairah Al Fujairah 30 64 50 61
4 Al Urooba Al Urooba 30 54 33 55
5 Al Ittihad Kalba Ittihad 30 63 37 52
6 Hatta Club Hatta Club 30 59 43 52
7 Dubai Dubai 30 56 48 51
8 Dibba Al Hisn Dibba Hisn 30 50 47 43
9 Al Jazira Al Hamra Jazira Hamra 30 45 46 42
10 Ras Al Khaima Khaima 30 51 62 37
11 Al Dhaid Al Dhaid 30 40 51 31
12 Al Ramms Al Ramms 30 43 54 30
13 Dibba Al Fujairah Dibba 30 40 63 29
14 Al Arabi SC Al Arabi SC 30 39 72 29
15 Masafi Masafi 30 28 60 18
16 Al Hamriyah Al Hamriyah 30 33 99 15
TEMPORADA 2007/2008
SEGUNDA EMIRATOS
Equipo PJ GF GC Puntos
1 Khorfakkan Khorfakkan 30 66 23 75
2 Ajman Ajman 30 85 40 65
3 Al Ittihad Kalba Ittihad 30 67 39 62
4 Dibba Al Hisn Dibba Hisn 30 75 42 61
5 Al Fujairah Al Fujairah 30 86 36 59
6 Baniyas Baniyas 30 68 35 54
7 Al Urooba Al Urooba 30 76 54 47
8 Ras Al Khaima Khaima 30 56 56 42
9 Dibba Al Fujairah Dibba 30 43 52 42
10 Dubai Dubai 30 52 43 41
11 Al Arabi SC Al Arabi SC 30 52 54 37
12 Al Dhaid Al Dhaid 30 45 85 24
13 Al Hamriyah Al Hamriyah 30 46 88 24
14 Al Jazira Al Hamra Jazira Hamra 30 34 83 23
15 Masafi Masafi 30 27 71 14
16 Al Ramms Al Ramms 30 23 100 8
TEMPORADA 2000/2001
LIGA EMIRATOS GRUPO 1
Equipo PJ GF GC Puntos
1 Al-Wahda Al-Wahda 22 62 34 50
2 Al Ahli Dubai Ahli Dubai 22 47 36 42
3 Al-Jazira Al-Jazira 22 47 33 38
4 Al-Ain Al-Ain 22 33 27 34
5 Al-Wasl Al-Wasl 22 42 32 32
6 Al-Shaab Sharjah Al-Shaab 22 32 26 32
7 Al Nasr Dubai Nasr Dubai 22 40 41 31
8 Al Shabab Dubai Shabab Dubai 22 33 36 29
9 Al Ittihad Kalba Ittihad 22 29 39 28
10 Emirates Club Emirates 22 29 38 22
11 Sharjah FC Sharjah FC 22 27 38 22
12 Al Fujairah Al Fujairah 22 15 56 6

  USO DE MEMORIA  
6,817,912 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.7847
Total Execution Time  0.7859
  CADENA URL  
/historico/Al-Fujairah-Sc
  GET DATOS  
$_GET['/historico/Al-Fujairah-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (42)  
0.0206  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-Fujairah-Sc' 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.0150  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=64640 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0152  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=64640 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0150  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=64640 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0302  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 = 73800
0.0177  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 = 74207
0.0149  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=64640 AND type_rel = 2
0.0164  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 64640 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0159  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 (112001,221298,225711,226304,226733) ORDER BY n.cover_points DESC, update_date DESC
0.0174  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 = '64640' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0158  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 = '64640' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0148  SELECT t.id,t.teamId,t.total_players,dt.nameShow,dt.basealias FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 74207 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0146  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 = 73800 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0148  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=64640 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0148  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 (74207,73800) 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.0153  SELECT count(id) as num_players from rel_players WHERE league_id = 73800 AND teamId = 64640
0.0152  SELECT count(id) as num_players from rel_players WHERE league_id = 74207 AND teamId = 64640
0.0162  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 = 73800 AND t.round = 30 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0153  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 = '64640' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '64640' and rp.type = 4
0.0155  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 = '64640' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0178  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 = 73800 WHERE rp.league_id = 73800 AND rp.teamId = 64640 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.0149  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 = 73800 WHERE rp.league_id = 73800 AND rp.teamId = 64640 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0156  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 = 73800 WHERE rp.league_id = 73800 AND rp.teamId = 64640 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0150  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 = 64640 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73800 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.0151  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 = 69435 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.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 65184 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.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 = 56840 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.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 `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 = 49876 AND t.round = 19 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 43562 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 41047 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  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 = 37471 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0166  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15741 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0163  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 = 4458 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0149  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15232 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2012` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 15233 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0150  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 15234 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0154  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 = 15235 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0157  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 = 15236 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0165  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 = 15237 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0148  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2001` 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 = 23818 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC