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

Polokwane City

Entrenador: Phuti Mohafe

Temporada 2023/2024
TEMPORADA 2023/2024
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 24 47 9 62
2 Stellenbosch FC Stellenbosch 26 38 19 49
3 Orlando Pirates Orlando 26 41 23 46
4 Sekhukhune United FC Sekhukhune 26 29 22 40
5 TS Galaxy TS Galaxy 25 26 20 38
6 SuperSport United SuperSport 26 31 31 38
7 Cape Town City FC Cape Town C. 26 25 24 35
8 Kaizer Chiefs Kaizer 26 22 25 33
9 Polokwane City Polokwane 26 20 27 33
10 Chippa United Chippa 26 25 25 32
11 Golden Arrows Golden 26 28 41 32
12 AmaZulu AmaZulu 26 21 26 31
13 Swallows FC Swallows FC 26 21 30 29
14 Royal AM Royal AM 25 22 38 29
15 Richards Bay Richards 26 20 33 23
16 Cape Town Spurs Cape Town S. 26 19 42 15
TEMPORADA 2022/2023
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Polokwane City Polokwane 30 44 24 57
2 Cape Town Spurs Cape Town S. 30 42 27 57
3 Casric Stars Casric Stars 30 37 25 56
4 Cape Town All Stars Cape Town S. 30 37 25 48
5 Hungry Lions Hungry Lions 30 30 28 47
6 JDR Stars JDR Stars 30 40 25 45
7 Uthongathi Uthongathi 30 33 30 41
8 Pretoria University Pretoria 30 32 31 40
9 Baroka Baroka 30 37 37 39
10 Pretoria Callies FC Pretoria 30 27 29 39
11 Venda Venda 30 26 33 38
12 Magesi Magesi 30 22 32 37
13 NB La Masia NB La Masia 30 33 39 32
14 Platinum City Rovers Platinum 30 21 37 30
15 TTM TTM 30 25 46 23
16 Black Leopards Black 30 21 39 22
TEMPORADA 2021/2022
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Richards Bay Richards 30 39 22 54
2 Pretoria University Pretoria 30 40 26 52
3 Cape Town All Stars Cape Town S. 30 37 26 48
4 JDR Stars JDR Stars 30 32 28 45
5 Venda Venda 30 26 24 44
6 Polokwane City Polokwane 30 42 37 41
7 Free State Stars Free State. 30 26 24 41
8 Uthongathi Uthongathi 30 27 25 39
9 Black Leopards Black 30 30 29 39
10 Platinum City Rovers Platinum 30 30 46 38
11 Hungry Lions Hungry Lions 30 27 27 36
12 Pretoria Callies FC Pretoria 30 33 32 35
13 TTM TTM 30 26 45 34
14 Cape Town Spurs Cape Town S. 30 27 32 33
15 Jomo Cosmos Jomo Cosmos 30 27 34 28
16 TS Sporting TS Sporting 30 22 34 28
TEMPORADA 2020/2021
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Royal AM Royal AM 30 34 25 51
2 Sekhukhune United FC Sekhukhune 30 38 21 50
3 Richards Bay Richards 30 41 27 49
4 TS Sporting TS Sporting 30 41 28 49
5 Free State Stars Free State. 30 37 32 45
6 JDR Stars JDR Stars 30 33 32 44
7 Cape Umoya United Cape Umoya. 29 31 24 41
8 Pretoria Callies FC Pretoria 30 24 26 41
9 Polokwane City Polokwane 30 26 27 38
10 Jomo Cosmos Jomo Cosmos 30 25 27 38
11 Cape Town All Stars Cape Town S. 30 28 32 37
12 Uthongathi Uthongathi 30 28 33 37
13 Pretoria University Pretoria 30 27 30 35
14 Steenberg United Steenberg 30 27 41 30
15 Cape Town Spurs Cape Town S. 29 22 38 30
16 Bizana Pondo Bizana Pondo 30 24 43 23
TEMPORADA 2019/2020
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 30 43 22 59
2 Kaizer Chiefs Kaizer 30 48 27 57
3 Orlando Pirates Orlando 30 40 29 52
4 Bidvest Wits Bidvest Wits 30 33 22 52
5 SuperSport United SuperSport 30 43 26 50
6 Cape Town City FC Cape Town C. 30 40 37 42
7 Maritzburg United Maritzburg 30 29 27 42
8 Bloemfontein Celtic Bloemfontein 30 43 39 39
9 Highlands Park Highlands 30 31 35 39
10 Stellenbosch FC Stellenbosch 30 26 34 36
11 Chippa United Chippa 30 18 26 34
12 Golden Arrows Golden 30 23 35 34
13 AmaZulu AmaZulu 30 20 33 30
14 Baroka Baroka 30 19 28 29
15 Black Leopards Black 30 27 44 29
16 Polokwane City Polokwane 30 25 44 25
TEMPORADA 2018/2019
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 30 40 24 59
2 Orlando Pirates Orlando 30 44 24 57
3 Bidvest Wits Bidvest Wits 30 45 29 54
4 Cape Town City FC Cape Town C. 30 47 35 48
5 Polokwane City Polokwane 30 38 35 44
6 SuperSport United SuperSport 30 29 29 44
7 Highlands Park Highlands 30 35 32 41
8 Bloemfontein Celtic Bloemfontein 30 35 37 40
9 Kaizer Chiefs Kaizer 30 33 29 39
10 Golden Arrows Golden 30 27 31 36
11 AmaZulu AmaZulu 30 33 41 31
12 Chippa United Chippa 30 27 35 30
13 Black Leopards Black 30 30 46 30
14 Baroka Baroka 30 27 37 29
15 Maritzburg United Maritzburg 30 22 32 27
16 Free State Stars Free State. 30 31 47 27
TEMPORADA 2017/2018
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 30 49 24 60
2 Orlando Pirates Orlando 30 41 26 55
3 Kaizer Chiefs Kaizer 30 27 22 48
4 Maritzburg United Maritzburg 30 36 23 44
5 Cape Town City FC Cape Town C. 30 26 27 40
6 Free State Stars Free State. 30 29 31 40
7 Golden Arrows Golden 30 36 34 38
8 AmaZulu AmaZulu 30 30 35 38
9 Chippa United Chippa 30 27 26 37
10 Bloemfontein Celtic Bloemfontein 30 25 32 37
11 SuperSport United SuperSport 30 25 30 36
12 Bidvest Wits Bidvest Wits 30 27 36 36
13 Polokwane City Polokwane 30 31 34 34
14 Baroka Baroka 30 32 38 34
15 Cape Town Spurs Cape Town S. 30 27 33 31
16 Platinum Stars Platinum 30 21 38 24
TEMPORADA 2016/2017
LIGA SUDAFRICANA GRUPO 1
Equipo PJ GF GC Puntos
1 Bidvest Wits Bidvest Wits 30 47 22 60
2 Mamelodi Sundowns Mamelodi 30 52 20 57
3 Cape Town City FC Cape Town C. 30 47 35 55
4 Kaizer Chiefs Kaizer 30 39 28 50
5 SuperSport United SuperSport 30 42 29 48
6 Polokwane City Polokwane 30 36 34 43
7 Maritzburg United Maritzburg 30 31 35 38
8 Golden Arrows Golden 30 32 44 38
9 Platinum Stars Platinum 30 33 32 37
10 Cape Town Spurs Cape Town S. 30 29 35 36
11 Orlando Pirates Orlando 30 29 40 33
12 Bloemfontein Celtic Bloemfontein 30 16 28 29
13 Chippa United Chippa 30 27 32 28
14 Free State Stars Free State. 30 26 37 28
15 Baroka Baroka 30 26 43 28
16 Highlands Park Highlands 30 26 44 27
TEMPORADA 2015/2016
LIGA SUDAFRICANA GRUPO 1
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 30 55 20 71
2 Bidvest Wits Bidvest Wits 30 44 24 57
3 Platinum Stars Platinum 30 41 33 47
4 Cape Town City FC Cape Town C. 30 37 29 47
5 Kaizer Chiefs Kaizer 30 38 30 46
6 Chippa United Chippa 30 42 39 45
7 Orlando Pirates Orlando 30 38 30 41
8 SuperSport United SuperSport 30 36 38 40
9 Golden Arrows Golden 30 28 35 40
10 Cape Town Spurs Cape Town S. 30 34 41 37
11 Bloemfontein Celtic Bloemfontein 30 30 26 36
12 Free State Stars Free State. 30 28 37 35
13 Polokwane City Polokwane 30 31 44 31
14 Maritzburg United Maritzburg 30 35 53 27
15 Pretoria University Pretoria 30 25 42 25
16 Jomo Cosmos Jomo Cosmos 30 20 41 25
TEMPORADA 2014/2015
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 Kaizer Chiefs Kaizer 30 41 14 69
2 Mamelodi Sundowns Mamelodi 30 44 24 57
3 Bidvest Wits Bidvest Wits 30 34 25 52
4 Orlando Pirates Orlando 30 46 29 50
5 Cape Town Spurs Cape Town S. 30 34 35 44
6 SuperSport United SuperSport 30 39 40 41
7 Bloemfontein Celtic Bloemfontein 30 34 27 40
8 Maritzburg United Maritzburg 30 30 25 40
9 Free State Stars Free State. 30 34 39 38
10 Cape Town City FC Cape Town C. 30 35 39 34
11 Platinum Stars Platinum 30 30 38 34
12 Polokwane City Polokwane 30 42 60 34
13 Pretoria University Pretoria 30 28 32 32
14 Chippa United Chippa 30 23 37 30
15 Swallows FC Swallows FC 30 30 47 30
16 AmaZulu AmaZulu 30 31 44 27
TEMPORADA 2013/2014
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 Mamelodi Sundowns Mamelodi 31 51 26 65
2 Kaizer Chiefs Kaizer 31 43 17 64
3 Bidvest Wits Bidvest Wits 31 35 20 59
4 Orlando Pirates Orlando 31 31 22 49
5 Bloemfontein Celtic Bloemfontein 33 38 35 47
6 SuperSport United SuperSport 30 38 36 44
7 Cape Town City FC Cape Town C. 31 34 35 43
8 Platinum Stars Platinum 30 32 32 42
9 Maritzburg United Maritzburg 32 37 38 42
10 AmaZulu AmaZulu 30 27 35 42
11 Cape Town Spurs Cape Town S. 33 30 40 38
12 Pretoria University Pretoria 30 25 28 35
13 Swallows FC Swallows FC 31 30 40 32
14 Free State Stars Free State. 30 32 43 29
15 Polokwane City Polokwane 30 31 43 28
16 Golden Arrows Golden 30 26 50 21
TEMPORADA 2012/2013
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Polokwane City Polokwane 30 45 33 49
2 Engen Santos Engen Santos 28 38 28 49
3 Cape Town City FC Cape Town C. 27 32 22 48
4 Thanda Royal Zulu Thanda Royal 27 40 28 47
5 Witbank Spurs Witbank 28 48 37 45
6 Marumo Gallants FC Marumo 28 35 28 42
7 African Warriors African 28 38 34 42
8 Bay United Bay United 28 34 28 41
9 Vasco da Gama RSA Vasco Gama 27 35 34 40
10 Blackburn Rovers RSA Blackburn 27 34 35 35
11 FC Cape Town Cape Town 27 31 32 35
12 Roses United Roses United 27 29 37 30
13 Royal Eagles Royal Eagles 27 37 42 29
14 Jomo Cosmos Jomo Cosmos 27 29 34 28
15 AK Johannesburg Johannesburg 28 24 50 18
16 Dynamos Giyani Dynamos 30 17 44 17
TEMPORADA 2011/2012
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Pretoria University Pretoria 30 45 25 55
2 Chippa United Chippa 30 46 29 51
3 Thanda Royal Zulu Thanda Royal 30 34 28 50
4 Blackburn Rovers RSA Blackburn 30 44 37 49
5 AK Johannesburg Johannesburg 30 45 43 45
6 African Warriors African 30 43 36 43
7 Vasco da Gama RSA Vasco Gama 30 51 45 43
8 FC Cape Town Cape Town 30 38 36 39
9 Bay United Bay United 30 46 45 39
10 Carara Kicks Carara Kicks 30 42 46 38
11 Polokwane City Polokwane 30 32 40 35
12 Witbank Spurs Witbank 29 32 39 34
13 Royal Eagles Royal Eagles 30 39 47 34
14 Cape Town City FC Cape Town C. 30 33 41 33
15 Dynamos Giyani Dynamos 29 34 49 29
16 Atlie Atlie 30 24 42 28
TEMPORADA 2010/2011
SEGUNDA SUDÁFRICA GRUPO 1
Equipo PJ GF GC Puntos
1 Polokwane City Polokwane 21 29 13 40
2 Thanda Royal Zulu Thanda Royal 21 38 27 39
3 Carara Kicks Carara Kicks 21 32 31 32
4 African Warriors African 21 29 25 30
5 FC Cape Town Cape Town 21 23 20 23
6 Blackburn Rovers RSA Blackburn 21 21 32 23
7 Atlie Atlie 21 27 31 18
8 Hanover Park Hanover Park 21 23 43 17
TEMPORADA 2009/2010
SEGUNDA SUDÁFRICA GRUPO 2
Equipo PJ GF GC Puntos
1 Vasco da Gama RSA Vasco Gama 21 31 20 38
2 Atlie Atlie 21 31 19 36
3 Polokwane City Polokwane 21 20 19 35
4 Carara Kicks Carara Kicks 21 30 30 27
5 Thanda Royal Zulu Thanda Royal 21 29 29 27
6 FC Cape Town Cape Town 21 21 26 25
7 Hanover Park Hanover Park 21 18 28 20
8 Ikapa Sporting Ikapa 21 23 32 18
TEMPORADA 2008/2009
LIGA SUDAFRICANA
Equipo PJ GF GC Puntos
1 SuperSport United SuperSport 28 44 21 53
2 Orlando Pirates Orlando 28 33 18 51
3 Kaizer Chiefs Kaizer 28 34 32 44
4 AmaZulu AmaZulu 28 32 29 42
5 Free State Stars Free State. 28 32 23 41
6 Golden Arrows Golden 28 40 27 40
7 Mamelodi Sundowns Mamelodi 28 28 25 40
8 Bidvest Wits Bidvest Wits 28 35 33 40
9 Cape Town Spurs Cape Town S. 28 29 32 40
10 Santos Cape Town Santos Cape 28 27 28 38
11 Swallows FC Swallows FC 28 31 34 37
12 Platinum Stars Platinum 28 35 36 35
13 Thanda Royal Zulu Thanda Royal 28 38 53 32
14 Maritzburg United Maritzburg 28 31 52 32
15 Bloemfontein Celtic Bloemfontein 28 31 33 30
16 Polokwane City Polokwane 28 26 50 21
TEMPORADA 2007/2008
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Maritzburg United Maritzburg 21 31 13 47
2 Polokwane City Polokwane 21 30 10 45
3 Atlie Atlie 21 22 13 34
4 FC Cape Town Cape Town 21 24 24 26
5 Ikapa Sporting Ikapa 21 25 30 21
6 Durban Stars Durban Stars 21 19 31 21
7 Hanover Park Hanover Park 21 22 32 19
8 Western Province Western 21 20 40 14
9 AK Johannesburg Johannesburg 21 21 19 37
10 Dynamos Giyani Dynamos 21 31 23 31
11 Winnerspark Winnerspark 21 25 24 31
12 African Warriors African 21 20 21 29
13 Cape Town City FC Cape Town C. 21 26 23 28
14 Witbank Spurs Witbank 21 21 21 26
15 Pretoria University Pretoria 21 23 27 25
16 Garankuwa United Garankuwa 21 22 31 21
TEMPORADA 2006/2007
SEGUNDA SUDÁFRICA
Equipo PJ GF GC Puntos
1 Free State Stars Free State. 30 74 26 70
2 Winnerspark Winnerspark 30 51 34 52
3 Pretoria University Pretoria 30 44 28 51
4 AK Johannesburg Johannesburg 30 42 30 48
5 Cape Town City FC Cape Town C. 29 50 39 46
6 Dynamos Giyani Dynamos 30 45 36 45
7 Durban Stars Durban Stars 30 39 46 42
8 Witbank Spurs Witbank 30 39 44 41
9 Ikapa Sporting Ikapa 30 43 42 40
10 Atlie Atlie 30 33 37 38
11 Garankuwa United Garankuwa 30 35 38 35
12 FC Cape Town Cape Town 30 39 51 35
13 Polokwane City Polokwane 30 32 43 33
14 PJ Stars Kings Stars Kings 29 32 45 32
15 Western Province Western 29 33 60 22
16 OR Tambo District Tambo 29 29 61 22

  USO DE MEMORIA  
7,291,024 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.1535
Total Execution Time  0.1548
  CADENA URL  
/historico/Polokwane-City
  GET DATOS  
$_GET['/historico/Polokwane-City']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (41)  
0.0039  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 = 'Polokwane-City' 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=13929 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=13929 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=13929 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=13929 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0039  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 = 74364
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=13929 AND type_rel = 2
0.0020  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 13929 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0022  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 (362485,482022) ORDER BY n.cover_points DESC, update_date DESC
0.0032  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 = '13929' ORDER BY l.year DESC,cat.coefficient DESC
0.0025  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 = '13929' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0024  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 = '13929' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0024  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=13929 AND l.year in (2023,2024,2025) 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 (74688,74364,72835,69237) 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.0029  SELECT count(id) as num_players from rel_players WHERE league_id = 72835 AND teamId = 13929
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 69237 AND teamId = 13929
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 74688 AND teamId = 13929
0.0021  SELECT count(id) as num_players from rel_players WHERE league_id = 74364 AND teamId = 13929
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 = '13929' 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 = '13929' 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 = '13929' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0042  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 = 72835 WHERE rp.league_id = 72835 AND rp.teamId = 13929 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.0051  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 = 72835 WHERE rp.league_id = 72835 AND rp.teamId = 13929 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
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 = 72835 WHERE rp.league_id = 72835 AND rp.teamId = 13929 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 = 13929 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 `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 = 69237 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 `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 = 64061 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.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 `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 = 60194 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.0031  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 = 50150 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.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 `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 = 43607 AND t.round = 24 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 `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 = 39262 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030  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 = 15575 AND t.round = 30 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 = 3872 AND t.round = 30 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 `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 = 2953 AND t.round = 30 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 `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 = 14093 AND t.round = 28 ORDER BY team.conference 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 `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 = 14094 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 `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 = 14095 AND t.round = 21 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 = 14099 AND t.round = 21 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 `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 = 462 AND t.round = 28 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 `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 = 14103 AND t.round = 21 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0028  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 = 14105 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC