4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del ASPL 2000
TEMPORADA 2023/2024
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Cercle de Joachim SC Cercle 8 23 5 20
2 ASPL 2000 ASPL 2000 8 15 8 16
3 Grande Riviere Sud Est Grande 7 12 7 15
4 Petite Rivière Noire Petite 8 12 10 12
5 Pamplemousses Pamplemousse 7 8 4 11
6 AS de Vacoas-Phoenix Vacoas-Phoen 7 8 10 8
7 Chebel Citizens Chebel 7 7 11 7
8 Entente Boulet Entente 8 15 23 7
9 Savanne Savanne 8 11 21 6
10 Rivière du Rempart Rivière 8 4 16 2
TEMPORADA 2022/2023
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Grande Riviere Sud Est Grande 18 30 10 42
2 Pamplemousses Pamplemousse 18 26 8 40
3 ASPL 2000 ASPL 2000 18 37 11 39
4 Cercle de Joachim SC Cercle 18 24 15 30
5 AS de Vacoas-Phoenix Vacoas-Phoen 18 21 17 27
6 Petite Rivière Noire Petite 18 26 30 21
7 Entente Boulet Entente 18 26 33 18
8 Savanne Savanne 18 13 34 16
9 La Cure Sylvester Cure 18 14 37 14
10 Bolton City Bolton City 18 6 28 7
TEMPORADA 2020/2021
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Grande Riviere Sud Est Grande 13 25 4 37
2 ASPL 2000 ASPL 2000 13 19 11 22
3 Pamplemousses Pamplemousse 13 20 19 19
4 AS de Vacoas-Phoenix Vacoas-Phoen 12 13 11 17
5 Entente Boulet Entente 13 30 23 17
6 Petite Rivière Noire Petite 13 19 22 16
7 Bolton City Bolton City 13 14 17 13
8 Savanne Savanne 13 16 25 12
9 Cercle de Joachim SC Cercle 13 16 27 12
10 La Cure Sylvester Cure 12 7 20 8
TEMPORADA 2019/2020
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Grande Riviere Sud Est Grande 13 24 7 30
2 Bolton City Bolton City 13 28 12 30
3 ASPL 2000 ASPL 2000 13 20 12 21
4 AS de Vacoas-Phoenix Vacoas-Phoen 13 27 17 20
5 Petite Rivière Noire Petite 12 16 15 16
6 Pamplemousses Pamplemousse 12 15 15 15
7 Entente Boulet Entente 13 26 31 13
8 La Cure Sylvester Cure 13 14 30 12
9 Cercle de Joachim SC Cercle 13 11 24 10
10 Savanne Savanne 13 21 39 9
TEMPORADA 2018/2019
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Pamplemousses Pamplemousse 18 41 11 39
2 Bolton City Bolton City 18 33 11 36
3 AS de Vacoas-Phoenix Vacoas-Phoen 18 24 19 28
4 ASPL 2000 ASPL 2000 18 21 19 25
5 Savanne Savanne 18 26 23 24
6 Petite Rivière Noire Petite 18 29 29 24
7 La Cure Sylvester Cure 18 30 33 22
8 Cercle de Joachim SC Cercle 18 19 20 20
9 Rivière du Rempart Rivière 18 20 45 17
10 Quatre Bornes Quatre 18 7 40 8
TEMPORADA 2017/2018
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Pamplemousses Pamplemousse 26 56 30 53
2 ASPL 2000 ASPL 2000 27 51 28 53
3 Bolton City Bolton City 27 40 21 52
4 Quatre Bornes Quatre 27 32 31 43
5 Cercle de Joachim SC Cercle 27 49 40 38
6 Petite Rivière Noire Petite 27 50 42 38
7 Savanne Savanne 27 39 60 29
8 La Cure Sylvester Cure 26 34 42 28
9 Entente Boulet Entente 27 45 67 26
10 Chebel Citizens Chebel 27 20 55 10
TEMPORADA 2016/2017
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Pamplemousses Pamplemousse 36 77 40 73
2 Petite Rivière Noire Petite 36 63 40 72
3 Bolton City Bolton City 36 44 26 69
4 ASPL 2000 ASPL 2000 36 66 37 62
5 Quatre Bornes Quatre 36 42 36 54
6 La Cure Sylvester Cure 36 58 45 48
7 Cercle de Joachim SC Cercle 36 45 66 41
8 Savanne Savanne 36 51 76 35
9 Rivière du Rempart Rivière 36 40 67 34
10 Grande Riviere Sud Est Grande 36 40 93 16
TEMPORADA 2013/2014
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Cercle de Joachim SC Cercle 18 37 12 43
2 Pamplemousses Pamplemousse 18 34 24 36
3 Petite Rivière Noire Petite 18 31 19 35
4 Curepipe Starlight Curepipe 18 40 27 31
5 ASPL 2000 ASPL 2000 18 31 23 27
6 Rivière du Rempart Rivière 18 30 31 23
7 Entente Boulet Entente 18 29 31 18
8 Chamarel Chamarel 18 32 41 17
9 AS de Vacoas-Phoenix Vacoas-Phoen 18 21 37 12
10 Bolton City Bolton City 18 15 55 8
TEMPORADA 2011/2012
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 Pamplemousses Pamplemousse 18 41 20 38
2 ASPL 2000 ASPL 2000 18 31 17 35
3 Cercle de Joachim SC Cercle 18 32 19 34
4 Petite Rivière Noire Petite 18 30 20 31
5 Rivière du Rempart Rivière 18 31 21 30
6 AS de Vacoas-Phoenix Vacoas-Phoen 18 15 18 24
7 Savanne Savanne 18 24 34 23
8 Curepipe Starlight Curepipe 18 25 33 19
9 Entente Boulet Entente 18 21 48 12
10 PAS Mates PAS Mates 18 11 31 9
TEMPORADA 2010/2011
LIGA MAURICIO
Equipo PJ GF GC Puntos
1 ASPL 2000 ASPL 2000 12 30 8 30
2 AS de Vacoas-Phoenix Vacoas-Phoen 12 29 5 29
3 Savanne Savanne 12 23 17 22
4 Pamplemousses Pamplemousse 12 22 15 21
5 Cercle de Joachim SC Cercle 12 13 15 18
6 Rivière du Rempart Rivière 12 11 12 16
7 PAS Mates PAS Mates 12 20 23 16
8 Petite Rivière Noire Petite 12 16 16 15
9 Curepipe Starlight Curepipe 12 11 15 13
10 Entente Boulet Entente 12 12 23 10
11 Faucon Flacq SC Faucon Flacq 12 13 24 9
12 CTNFB U-20 CTNFB U-20 12 14 27 9
13 Highlands Highlands 12 8 22 9
14 Étoile de lOuest Étoile 0 0 0 0

  USO DE MEMORIA  
5,349,416 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0951
Total Execution Time  0.0963
  CADENA URL  
/historico/As-Port-Louis
  GET DATOS  
$_GET['/historico/As-Port-Louis']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0028  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 = 'As-Port-Louis' 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.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=87106 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=87106 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0040  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 = 75213
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=87106 AND type_rel = 2
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=493 AND type_rel = 3
0.0026  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 = '87106' 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 = '87106' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0027  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 = '87106' 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 = 75213 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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=87106 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0018  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 (75213) 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.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 75213 AND teamId = 87106
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 = '87106' 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 = '87106' and rp.type = 4
0.0022  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 = '87106' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0021  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 = 75213 WHERE rp.league_id = 75213 AND rp.teamId = 87106 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 = 75213 WHERE rp.league_id = 75213 AND rp.teamId = 87106 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0021  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 = 75213 WHERE rp.league_id = 75213 AND rp.teamId = 87106 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0022  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 = 87106 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 75213 AND t.round = 8 ORDER BY team.conference ASC,t.position 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 `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 = 75207 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 60122 AND t.round = 18 ORDER BY team.conference ASC,t.position 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 `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 = 51685 AND t.round = 13 ORDER BY team.conference ASC,t.position 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 `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 = 47983 AND t.round = 18 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 = 42097 AND t.round = 27 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 = 36899 AND t.round = 36 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 = 24990 AND t.round = 18 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 = 24991 AND t.round = 18 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 `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 = 24992 AND t.round = 13 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC