4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Simba SC

Simba SC

Entrenador: Abdelhak Benchikha

Temporada 2023/2024
TEMPORADA 2023/2024
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 24 55 12 62
2 Azam FC Azam FC 24 50 16 54
3 Simba SC Simba SC 21 41 21 46
4 Coastal Union Coastal 24 18 18 33
5 KMC KMC 24 25 33 32
6 Tanzania Prisons Tanzania 24 25 26 31
7 Kagera Sugar Kagera Sugar 24 17 21 29
8 Dodoma Dodoma 23 17 22 28
9 Namungo Namungo 23 18 21 26
10 Singida Big Stars Singida 24 22 31 26
11 Ihefu Ihefu 24 20 32 25
12 Geita Gold Geita Gold 24 16 26 24
13 JKT Tanzania Tanzania 23 16 24 23
14 Mashujaa FC Mashujaa FC 24 19 28 23
15 Kitayosce FC Kitayosce 24 16 29 23
16 Mtibwa Sugar Mtibwa Sugar 22 22 37 17
TEMPORADA 2022/2023
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 30 61 18 78
2 Simba SC Simba SC 30 75 17 73
3 Azam FC Azam FC 30 55 29 59
4 Singida Big Stars Singida 30 35 26 55
5 Namungo Namungo 30 29 33 40
6 Ihefu Ihefu 30 31 32 39
7 Geita Gold Geita Gold 30 35 44 37
8 Tanzania Prisons Tanzania 30 29 38 37
9 Dodoma Dodoma 30 26 37 37
10 Mtibwa Sugar Mtibwa Sugar 30 34 45 35
11 Kagera Sugar Kagera Sugar 30 23 36 35
12 Coastal Union Coastal 30 25 35 33
13 KMC KMC 30 25 31 32
14 Mbeya City Mbeya City 30 34 44 31
15 AS Polisi AS Polisi 30 25 54 25
16 Ruvu Shooting Ruvu 30 19 42 20
TEMPORADA 2021/2022
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 30 49 8 74
2 Simba SC Simba SC 30 41 14 61
3 Azam FC Azam FC 30 41 28 49
4 Geita Gold Geita Gold 30 32 26 46
5 Namungo Namungo 30 42 34 41
6 Kagera Sugar Kagera Sugar 30 20 25 39
7 Coastal Union Coastal 30 22 31 38
8 AS Polisi AS Polisi 30 21 23 37
9 Mbeya City Mbeya City 30 25 29 37
10 KMC KMC 30 34 35 35
11 Dodoma Dodoma 30 25 37 35
12 Ruvu Shooting Ruvu 30 28 39 34
13 Mtibwa Sugar Mtibwa Sugar 30 25 34 31
14 Tanzania Prisons Tanzania 30 21 34 29
15 Biashara United Biashara 30 23 35 28
16 Mbeya Kwanza Mbeya Kwanza 30 22 39 25
TEMPORADA 2020/2021
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Simba SC Simba SC 34 78 14 83
2 Young Africans Young 34 52 21 74
3 Azam FC Azam FC 34 50 22 68
4 Biashara United Biashara 34 28 32 50
5 KMC KMC 34 39 27 48
6 AS Polisi AS Polisi 34 29 27 45
7 Tanzania Prisons Tanzania 34 25 25 44
8 Dodoma Dodoma 34 28 31 44
9 Namungo Namungo 34 24 31 43
10 Mbeya City Mbeya City 34 30 33 42
11 Ruvu Shooting Ruvu 34 34 38 41
12 Kagera Sugar Kagera Sugar 34 34 38 40
13 Coastal Union Coastal 34 29 46 40
14 Mtibwa Sugar Mtibwa Sugar 34 21 31 39
15 JKT Tanzania Tanzania 34 34 47 39
16 Gwambina Gwambina 34 29 37 35
17 Ihefu Ihefu 34 22 41 35
18 Mwadui Mwadui 34 24 69 19
TEMPORADA 2019/2020
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Simba SC Simba SC 38 78 21 88
2 Young Africans Young 38 45 28 72
3 Azam FC Azam FC 38 52 26 70
4 Namungo Namungo 38 46 37 64
5 AS Polisi AS Polisi 38 37 35 55
6 JKT Tanzania Tanzania 38 34 32 54
7 Coastal Union Coastal 38 33 30 53
8 Kagera Sugar Kagera Sugar 38 44 41 52
9 Biashara United Biashara 38 29 27 50
10 Tanzania Prisons Tanzania 38 35 30 49
11 Mwadui Mwadui 38 39 45 47
12 Ruvu Shooting Ruvu 38 34 42 47
13 KMC KMC 38 35 47 46
14 Mtibwa Sugar Mtibwa Sugar 38 30 34 45
15 Mbeya City Mbeya City 38 33 42 45
16 Mbao Mbao 38 33 43 45
17 Alliance Alliance 38 36 48 45
18 Lipuli Lipuli 38 43 51 44
19 Ndanda Ndanda 38 28 35 41
20 Singida United Singida 38 23 73 18
TEMPORADA 2018/2019
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 31 50 21 76
2 Simba SC Simba SC 29 58 12 71
3 Azam FC Azam FC 31 46 21 62
4 KMC KMC 30 32 20 42
5 Mtibwa Sugar Mtibwa Sugar 29 29 24 41
6 Lipuli Lipuli 30 24 26 39
7 Ruvu Shooting Ruvu 31 33 37 38
8 JKT Tanzania Tanzania 30 18 23 38
9 Coastal Union Coastal 31 28 33 37
10 Alliance Alliance 31 23 31 37
11 Mbao Mbao 30 19 29 37
12 Mwadui Mwadui 31 36 43 36
13 Kagera Sugar Kagera Sugar 31 26 33 36
14 Stand United Stand United 31 30 40 36
15 Ndanda Ndanda 30 18 31 36
16 Mbeya City Mbeya City 30 29 35 34
17 Singida United Singida 28 20 26 33
18 Tanzania Prisons Tanzania 29 20 25 32
19 Biashara United Biashara 30 21 30 29
20 African Lyon African Lyon 29 18 38 21
TEMPORADA 2017/2018
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Simba SC Simba SC 30 62 15 69
2 Azam FC Azam FC 30 35 16 58
3 Young Africans Young 30 44 23 52
4 Tanzania Prisons Tanzania 30 27 21 48
5 Singida United Singida 30 30 27 46
6 Mtibwa Sugar Mtibwa Sugar 30 22 20 41
7 Lipuli Lipuli 30 22 23 38
8 Ruvu Shooting Ruvu 30 31 37 38
9 Kagera Sugar Kagera Sugar 30 23 27 37
10 Mwadui Mwadui 30 32 38 36
11 Stand United Stand United 30 22 36 32
12 Mbeya City Mbeya City 30 23 31 31
13 Mbao Mbao 30 26 36 31
14 Ndanda Ndanda 30 23 31 29
15 Maji Maji Maji Maji 30 28 42 24
16 Njombe Mji Njombe Mji 30 16 43 22
TEMPORADA 2016/2017
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 30 57 14 68
2 Simba SC Simba SC 30 50 17 68
3 Kagera Sugar Kagera Sugar 30 33 26 53
4 Azam FC Azam FC 30 36 20 52
5 Mtibwa Sugar Mtibwa Sugar 30 34 32 44
6 Stand United Stand United 30 25 26 38
7 Ruvu Shooting Ruvu 30 28 34 36
8 Tanzania Prisons Tanzania 30 17 24 35
9 Maji Maji Maji Maji 30 27 38 35
10 Mwadui Mwadui 30 32 45 35
11 Mbeya City Mbeya City 30 27 32 33
12 Mbao Mbao 30 30 38 33
13 Ndanda Ndanda 30 23 38 33
14 African Lyon African Lyon 30 19 28 32
15 Toto Africans Toto 30 22 34 29
16 JKT Ruvu Stars Ruvu Stars 30 15 29 23
TEMPORADA 2015/2016
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 30 70 20 73
2 Simba SC Simba SC 30 45 17 62
3 Azam FC Azam FC 30 47 24 61
4 Tanzania Prisons Tanzania 30 29 22 51
5 Mtibwa Sugar Mtibwa Sugar 30 33 21 50
6 Mwadui Mwadui 30 29 29 41
7 Stand United Stand United 30 28 30 40
8 Mbeya City Mbeya City 30 32 34 35
9 Ndanda Ndanda 30 28 31 35
10 Maji Maji Maji Maji 30 22 40 35
11 JKT Ruvu Stars Ruvu Stars 30 31 43 32
12 Kagera Sugar Kagera Sugar 30 23 34 31
13 Toto Africans Toto 30 26 40 30
14 JKT Mgambo JKT Mgambo 30 24 36 28
15 African Sports African 30 13 34 26
16 Coastal Union Coastal 30 16 41 22
TEMPORADA 2014/2015
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 26 52 18 55
2 Azam FC Azam FC 26 36 18 49
3 Simba SC Simba SC 26 38 19 47
4 Mbeya City Mbeya City 26 22 22 34
5 Coastal Union Coastal 26 21 25 34
6 Kagera Sugar Kagera Sugar 26 22 26 32
7 Mtibwa Sugar Mtibwa Sugar 26 25 26 31
8 JKT Ruvu Stars Ruvu Stars 26 20 25 31
9 Ndanda Ndanda 26 21 29 31
10 Stand United Stand United 26 23 34 31
11 Tanzania Prisons Tanzania 26 18 22 29
12 JKT Mgambo JKT Mgambo 26 18 28 29
13 Ruvu Shooting Ruvu 26 16 29 29
14 AS Polisi AS Polisi 26 16 27 25
TEMPORADA 2013/2014
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Azam FC Azam FC 26 51 15 62
2 Young Africans Young 26 61 19 56
3 Mbeya City Mbeya City 26 33 20 49
4 Simba SC Simba SC 26 41 27 38
5 Kagera Sugar Kagera Sugar 26 23 20 38
6 Ruvu Shooting Ruvu 26 28 32 38
7 Mtibwa Sugar Mtibwa Sugar 26 30 31 31
8 JKT Ruvu Stars Ruvu Stars 26 23 40 31
9 Coastal Union Coastal 26 16 20 29
10 Tanzania Prisons Tanzania 26 25 32 28
11 JKT Mgambo JKT Mgambo 26 18 35 26
12 Ashanti United SC Ashanti 26 20 39 25
13 JKT Oljoro FC Oljoro 26 19 37 19
14 Rhino Rangers Rhino 26 17 38 16
TEMPORADA 2012/2013
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 26 47 14 60
2 Azam FC Azam FC 26 46 20 54
3 Simba SC Simba SC 26 38 25 45
4 Kagera Sugar Kagera Sugar 26 28 20 44
5 Mtibwa Sugar Mtibwa Sugar 26 29 25 39
6 Coastal Union Coastal 26 25 24 35
7 Ruvu Shooting Ruvu 26 23 26 32
8 JKT Oljoro FC Oljoro 26 22 29 29
9 Tanzania Prisons Tanzania 26 16 23 29
10 JKT Ruvu Stars Ruvu Stars 26 22 39 29
11 JKT Mgambo JKT Mgambo 26 16 27 28
12 AS Polisi AS Polisi 26 15 23 25
13 Toto Africans Toto 26 24 33 25
14 African Lyon African Lyon 26 16 39 19
TEMPORADA 2011/2012
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Simba SC Simba SC 26 47 12 62
2 Azam FC Azam FC 26 40 15 56
3 Young Africans Young 26 41 30 49
4 Mtibwa Sugar Mtibwa Sugar 26 34 25 42
5 Coastal Union Coastal 26 27 28 39
6 JKT Oljoro FC Oljoro 26 20 25 35
7 Kagera Sugar Kagera Sugar 26 26 27 32
8 JKT Ruvu Stars Ruvu Stars 26 27 34 32
9 Ruvu Shooting Ruvu 26 24 24 31
10 African Lyon African Lyon 26 23 30 27
11 Toto Africans Toto 26 24 31 26
12 Villa Squad Villa Squad 26 29 46 26
13 Moro United Moro United 26 28 46 19
14 Polisi Dodoma Polisi 26 20 37 17
TEMPORADA 2010/2011
PREMIER LEAGUE TANZANIA
Equipo PJ GF GC Puntos
1 Young Africans Young 22 32 7 49
2 Simba SC Simba SC 22 40 17 49
3 Azam FC Azam FC 22 41 18 43
4 Mtibwa Sugar Mtibwa Sugar 22 24 21 36
5 Kagera Sugar Kagera Sugar 22 22 18 35
6 JKT Ruvu Stars Ruvu Stars 22 21 21 28
7 African Lyon African Lyon 22 18 29 25
8 Polisi Dodoma Polisi 22 13 22 21
9 Toto Africans Toto 22 19 29 21
10 Ruvu Shooting Ruvu 22 17 25 20
11 Maji Maji Maji Maji 22 14 26 16
12 Arusha Arusha 22 13 41 13

  USO DE MEMORIA  
7,060,888 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1696
Total Execution Time  0.1708
  CADENA URL  
/historico/Simba-Sc
  GET DATOS  
$_GET['/historico/Simba-Sc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0049  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 = 'Simba-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.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=15969 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=15969 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=15969 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=15969 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=15969 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=15969 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0045  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 = 73542
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 = 73978
0.0024  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 = 74299
0.0028  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 = 75534
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15969 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 15969 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (639559,639505,639622,766464) ORDER BY n.cover_points DESC, update_date DESC
0.0046  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 = '15969' ORDER BY l.year DESC,cat.coefficient DESC
0.0037  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 = '15969' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 73978 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 = 75534 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 = 73542 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0029  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=15969 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0020  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 (75534,75287,73978,73542,73331,67320) 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.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73542 AND teamId = 15969
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 73978 AND teamId = 15969
0.0026  SELECT count(id) as num_players from rel_players WHERE league_id = 75534 AND teamId = 15969
0.0027  SELECT count(id) as num_players from rel_players WHERE league_id = 73331 AND teamId = 15969
0.0018  SELECT count(id) as num_players from rel_players WHERE league_id = 75287 AND teamId = 15969
0.0028  SELECT count(id) as num_players from rel_players WHERE league_id = 67320 AND teamId = 15969
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 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 = 73542 AND t.round = 24 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0021  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 = '15969' 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 = '15969' 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 = '15969' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0031  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 = 73542 WHERE rp.league_id = 73542 AND rp.teamId = 15969 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.0020  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 = 73542 WHERE rp.league_id = 73542 AND rp.teamId = 15969 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0020  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 = 73542 WHERE rp.league_id = 73542 AND rp.teamId = 15969 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0028  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 = 15969 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 73542 AND t.round = 24 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 `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 = 68658 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.0035  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 = 64317 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.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 `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 = 58694 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.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 `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 = 50032 AND t.round = 38 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.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 = 44972 AND t.round = 30 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 `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 = 39714 AND t.round = 30 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 `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 = 34732 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0026  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 = 15604 AND t.round = 30 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 = 4839 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 = 3190 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 `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 = 16012 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 `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 = 16013 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 `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 = 16014 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC