4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Ver
TEMPORADA 2020/2021
Equipo PJ GF GC Puntos
1 Matlama Matlama 30 50 14 72
2 Lesotho Defense Force Lesotho 30 49 19 62
3 LCS LCS 30 59 19 58
4 Bantu United Bantu United 30 48 22 58
5 Lioli Lioli 30 34 17 53
6 LMPS LMPS 30 33 23 51
7 Lija-Batho Lija-Batho 30 42 30 48
8 Linare Linare 30 37 27 48
9 Kick4Life Kick4Life 30 23 30 43
10 Liphakoe FC Liphakoe FC 30 17 29 28
11 Lifofane Lifofane 30 24 42 28
12 CCX CCX 30 24 40 27
13 Manonyane Manonyane 30 25 49 27
14 Mazenod Swallows Mazenod 30 24 50 23
15 Likhopo Likhopo 30 20 54 19
16 Sefotha-fotha Sefotha-foth 30 15 59 12
Ver
TEMPORADA 2019/2020
Equipo PJ GF GC Puntos
1 Bantu United Bantu United 18 45 7 50
2 Matlama Matlama 18 31 12 34
3 LCS LCS 19 18 13 33
4 LMPS LMPS 19 19 13 31
5 Lioli Lioli 19 23 20 28
6 Lifofane Lifofane 18 16 16 27
7 Linare Linare 18 20 15 26
8 Lesotho Defense Force Lesotho 19 26 27 26
9 Kick4Life Kick4Life 19 16 24 23
10 Likhopo Likhopo 18 18 22 20
11 Liphakoe FC Liphakoe FC 18 13 20 17
12 Sefotha-fotha Sefotha-foth 19 11 20 15
13 Lija-Batho Lija-Batho 18 13 23 13
14 Mazenod Swallows Mazenod 18 7 44 6
Ver
TEMPORADA 2018/2019
Equipo PJ GF GC Puntos
1 Matlama Matlama 20 36 14 44
2 LCS LCS 21 29 13 41
3 Bantu United Bantu United 18 34 5 39
4 Lioli Lioli 21 26 18 34
5 Kick4Life Kick4Life 20 21 21 31
6 Lesotho Defense Force Lesotho 21 15 15 31
7 Likhopo Likhopo 21 21 33 29
8 Liphakoe FC Liphakoe FC 21 18 17 27
9 Sefotha-fotha Sefotha-foth 21 19 22 26
10 LMPS LMPS 21 14 16 24
11 Linare Linare 21 16 26 19
12 Galaxy Galaxy 21 14 25 18
13 Majantja FC Majantja FC 20 21 34 18
14 Mazenod Swallows Mazenod 21 12 37 15
Ver
TEMPORADA 2017/2018
Equipo PJ GF GC Puntos
1 Bantu United Bantu United 21 43 11 54
2 Lioli Lioli 20 31 19 38
3 Matlama Matlama 20 26 16 36
4 Lesotho Defense Force Lesotho 20 25 17 34
5 Kick4Life Kick4Life 21 30 18 33
6 LCS LCS 20 24 15 30
7 Liphakoe FC Liphakoe FC 22 23 29 28
8 LMPS LMPS 21 20 21 27
9 Linare Linare 21 21 29 25
10 Majantja FC Majantja FC 20 19 24 24
11 Sefotha-fotha Sefotha-foth 20 18 26 21
12 Likhopo Likhopo 23 14 32 15
13 Sandawana Sandawana 0 0 0 0
14 Sky Battalion Battalion 21 5 42 0
Ver
TEMPORADA 2016/2017
Equipo PJ GF GC Puntos
1 Bantu United Bantu United 26 50 13 62
2 Lioli Lioli 26 49 11 60
3 LCS LCS 26 38 21 47
4 Kick4Life Kick4Life 26 42 28 45
5 Sky Battalion Battalion 26 33 27 41
6 Defence Force Defence 26 28 21 36
7 LMPS LMPS 26 23 20 36
8 Matlama Matlama 26 38 25 35
9 Sandawana Sandawana 26 25 29 31
10 Liphakoe FC Liphakoe FC 26 22 33 28
11 Linare Linare 26 35 38 27
12 Likhopo Likhopo 26 20 38 17
13 Rovers FC Rovers FC 26 22 51 17
14 Butha-Buthe Warriors Butha-Buthe 26 18 88 6
Ver
TEMPORADA 2015/2016
Equipo PJ GF GC Puntos
1 Lioli Lioli 16 24 7 37
2 LCS LCS 16 17 7 32
3 Matlama Matlama 15 22 13 32
4 Likhopo Likhopo 15 21 11 26
5 Sandawana Sandawana 15 15 15 24
6 Bantu United Bantu United 16 17 11 23
7 Defence Force Defence 16 16 13 22
8 Kick4Life Kick4Life 15 10 14 19
9 Rovers FC Rovers FC 15 10 19 15
10 Linare Linare 15 17 21 14
11 Liphakoe FC Liphakoe FC 15 11 16 13
12 Qalo FC Qalo FC 15 12 21 13
13 LMPS LMPS 16 11 20 12
14 Mphatlalatsane Mphatlalatsa 16 14 29 11
Ver
TEMPORADA 2014/2015
Equipo PJ GF GC Puntos
1 Lioli Lioli 26 49 7 63
2 Bantu United Bantu United 26 45 16 56
3 LCS LCS 26 31 17 47
4 Matlama Matlama 26 36 16 46
5 Defence Force Defence 26 31 22 46
6 Qalo FC Qalo FC 26 32 27 36
7 Likhopo Likhopo 26 31 30 35
8 Sandawana Sandawana 26 24 34 29
9 LMPS LMPS 26 19 32 29
10 Linare Linare 26 18 24 28
11 Kick4Life Kick4Life 26 28 31 25
12 Mphatlalatsane Mphatlalatsa 26 18 33 25
13 Nyenye Rovers Nyenye 26 18 37 24
14 Qoaling Highlanders Qoaling 26 16 70 9
Ver
TEMPORADA 2013/2014
Equipo PJ GF GC Puntos
1 Bantu United Bantu United 13 23 4 31
2 Lioli Lioli 13 28 10 29
3 Linare Linare 12 17 10 22
4 Defence Force Defence 13 12 8 21
5 Matlama Matlama 10 12 7 20
6 Likhopo Likhopo 11 14 9 18
7 Qoaling Highlanders Qoaling 12 10 11 16
8 Nyenye Rovers Nyenye 12 11 10 15
9 Mphatlalatsane Mphatlalatsa 13 15 16 14
10 LMPS LMPS 13 12 16 14
11 LCS LCS 10 7 6 12
12 Mpharane Celtics Mpharane 13 15 30 9
13 Melele FC Melele FC 13 9 24 6
14 Joy Joy 12 6 30 4
Ver
TEMPORADA 2012/2013
Equipo PJ GF GC Puntos
1 Lioli Lioli 22 30 10 46
2 Bantu United Bantu United 22 33 20 40
3 Lesotho Defense Force Lesotho 21 25 13 37
4 LCS LCS 22 20 14 35
5 Linare Linare 22 23 15 30
6 LMPS LMPS 22 19 14 30
7 Likhopo Likhopo 22 24 22 30
8 Matlama Matlama 20 19 24 23
9 Joy Joy 20 21 32 19
10 Qoaling Highlanders Qoaling 22 16 27 19
11 Nyenye Rovers Nyenye 21 13 27 16
12 Sandawana Sandawana 22 29 54 16
Ver
TEMPORADA 2011/2012
Equipo PJ GF GC Puntos
1 LCS LCS 22 39 18 44
2 Lesotho Defense Force Lesotho 22 26 17 38
3 Bantu United Bantu United 22 25 16 35
4 Matlama Matlama 22 27 27 34
5 Lioli Lioli 22 18 15 30
6 LMPS LMPS 22 21 25 30
7 Sandawana Sandawana 22 26 30 27
8 Linare Linare 22 22 30 26
9 Joy Joy 22 20 23 24
10 Likhopo Likhopo 22 14 17 24
11 Maduma FC Maduma FC 22 27 35 20
12 Majantja FC Majantja FC 22 11 23 16
Ver
TEMPORADA 2010/2011
Equipo PJ GF GC Puntos
1 LCS LCS 26 43 17 55
2 Lesotho Defense Force Lesotho 26 39 19 55
3 Bantu United Bantu United 26 36 23 48
4 Linare Linare 26 37 24 44
5 Matlama Matlama 26 27 18 40
6 LMPS LMPS 26 34 28 38
7 Likhopo Likhopo 26 27 27 37
8 Lioli Lioli 26 25 22 36
9 Maduma FC Maduma FC 26 31 33 36
10 Joy Joy 26 24 24 33
11 Mphatlalatsane Mphatlalatsa 26 29 37 23
12 Lerotholi Polytechnic Lerotholi 26 17 34 23
13 Mazenod Swallows Mazenod 26 15 42 13
14 Mabeoana FC Mabeoana FC 26 13 49 9

  USO DE MEMORIA  
6,028,664 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.0933
Total Execution Time  0.0953
  CADENA URL  
/premier_league_lesoto2021/grupo1/historico
  GET DATOS  
$_GET['/premier_league_lesoto2021/grupo1/historico']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (26)  
0.0018  SELECT type FROM routes WHERE alias = 'premier_league_lesoto2021'
0.0040  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_lesoto' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=497 AND type_rel = 3
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=497 ORDER BY order_id ASC
0.0020  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 60769 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0020  SELECT id,year,current_round,total_teams,legend FROM leagues WHERE categoryId = 497 AND group_code = 1 and tables = 1 AND year <= 2021 AND total_num_tablesR >= 1 ORDER BY year DESC LIMIT 22
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 = 60769 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 `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 = 51114 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.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 = 44925 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 39233 AND t.round = 24 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 = 34046 AND t.round = 26 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 = 15646 AND t.round = 16 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 `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 = 4847 AND t.round = 27 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 `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 = 3245 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0036  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24075 AND t.round = 22 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0023  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `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 = 24079 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 = 24085 AND t.round = 26 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-26 10:49:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-26 10:49:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-26 10:49:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-26 10:49:32' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0023  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'premier_league_lesoto' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2021 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 60769 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60769 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 60769 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60769 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0019  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId 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 = 60769 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 60769 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0046  SELECT *,(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 = 60769 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