4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
TEMPORADA 2023/2024
PREMIER DIVISION GIBRALTAR GRUPO 2
Equipo PJ GF GC Puntos
1 St. Joseph's Joseph's 23 56 15 59
2 Lincoln Red Imps Lincoln Imps 22 77 13 58
3 FCB Magpies FCB Magpies 22 52 30 43
4 Mons Calpe Mons Calpe 22 33 32 30
5 Europa Point Europa Point 23 27 29 29
6 Manchester 62 Manchester 22 42 53 29
TEMPORADA 2022/2023
PREMIER DIVISION GIBRALTAR GRUPO 2
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 20 68 14 52
2 Europa FC Europa FC 20 48 15 44
3 FCB Magpies FCB Magpies 20 39 18 37
4 Lynx Lynx 20 33 29 33
5 St. Joseph's Joseph's 20 36 25 32
6 Glacis United Glacis 20 19 49 13
TEMPORADA 2021/2022
PREMIER DIVISION GIBRALTAR GRUPO 2
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 20 65 17 58
2 Europa FC Europa FC 20 57 21 47
3 St. Joseph's Joseph's 20 45 27 35
4 FCB Magpies FCB Magpies 20 36 25 33
5 Glacis United Glacis 20 32 36 22
6 Mons Calpe Mons Calpe 20 34 36 20
TEMPORADA 2020/2021
PREMIER DIVISION GIBRALTAR GRUPO 2
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 20 62 13 48
2 Europa FC Europa FC 20 66 14 47
3 St. Joseph's Joseph's 20 71 20 45
4 Mons Calpe Mons Calpe 20 36 35 32
5 Lynx Lynx 20 36 40 26
6 Lions Gibraltar Lions 20 13 33 16
TEMPORADA 2019/2020
PREMIER DIVISION GIBRALTAR GRUPO 2
Equipo PJ GF GC Puntos
1 Europa FC Europa FC 6 27 1 49
2 St. Joseph's Joseph's 6 15 10 44
3 Lincoln Red Imps Lincoln Imps 6 20 6 39
4 Lynx Lynx 6 9 19 29
5 FCB Magpies FCB Magpies 6 7 20 21
6 Lions Gibraltar Lions 6 8 30 15
TEMPORADA 2018/2019
PREMIER DIVISION GIBRALTAR
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 27 84 19 66
2 Europa FC Europa FC 27 84 20 64
3 St. Joseph's Joseph's 27 69 29 55
4 Mons Calpe Mons Calpe 27 63 29 49
5 Gibraltar Phoenix Gibraltar 27 42 34 43
6 Gibraltar United Gibraltar 27 48 37 39
7 Lynx Lynx 27 29 45 31
8 Glacis United Glacis 27 28 58 24
9 Lions Gibraltar Lions 27 17 77 9
10 Boca Juniors Boca Juniors 27 13 129 7
TEMPORADA 2017/2018
PREMIER DIVISION GIBRALTAR
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 27 71 19 65
2 Europa FC Europa FC 27 67 20 60
3 St. Joseph's Joseph's 27 53 30 54
4 Gibraltar United Gibraltar 27 45 27 53
5 Mons Calpe Mons Calpe 27 48 35 44
6 Gibraltar Phoenix Gibraltar 27 34 47 30
7 Glacis United Glacis 27 34 44 26
8 Lions Gibraltar Lions 27 27 63 23
9 Lynx Lynx 27 22 48 22
10 Manchester 62 Manchester 27 20 88 7
TEMPORADA 2016/2017
PREMIER DIVISION GIBRALTAR
Equipo PJ GF GC Puntos
1 Europa FC Europa FC 27 93 18 73
2 Lincoln Red Imps Lincoln Imps 27 100 16 72
3 St. Joseph's Joseph's 27 53 18 54
4 Glacis United Glacis 27 42 34 44
5 Mons Calpe Mons Calpe 27 44 35 42
6 Lynx Lynx 27 33 46 28
7 Gibraltar United Gibraltar 27 20 43 21
8 Lions Gibraltar Lions 27 17 54 21
9 Manchester 62 Manchester 27 27 60 17
10 Europa Point Europa Point 27 14 119 8
TEMPORADA 2015/2016
PREMIER DIVISION GIBRALTAR
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 23 100 8 64
2 Europa FC Europa FC 23 58 17 56
3 St. Joseph's Joseph's 23 43 27 41
4 Lynx Lynx 23 33 29 35
5 Lions Gibraltar Lions 23 32 38 32
6 Manchester 62 Manchester 23 30 38 27
7 Britannia XI Britannia 23 33 48 26
8 Glacis United Glacis 23 28 57 25
9 Gibraltar United Gibraltar 23 17 51 22
10 Angels Angels 23 17 78 9
TEMPORADA 2014/2015
PREMIER DIVISION GIBRALTAR
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 21 83 12 58
2 Europa FC Europa FC 21 42 14 42
3 Lynx Lynx 21 36 18 38
4 St. Joseph's Joseph's 21 36 18 38
5 Manchester 62 Manchester 21 22 25 27
6 Glacis United Glacis 21 14 50 15
7 Britannia XI Britannia 21 13 67 9
8 Lions Gibraltar Lions 21 9 51 8
TEMPORADA 2013/2014
PREMIER DIVISION GIBRALTAR
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 14 64 4 36
2 Manchester 62 Manchester 14 37 10 30
3 Lynx Lynx 14 36 18 29
4 Europa FC Europa FC 14 29 18 19
5 Glacis United Glacis 14 18 32 19
6 Lions Gibraltar Lions 14 23 33 14
7 St. Joseph's Joseph's 14 23 30 13
8 Gibraltar Phoenix Gibraltar 14 9 94 0

  USO DE MEMORIA  
6,108,272 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.0888
Total Execution Time  0.0900
  CADENA URL  
/historico/Lincoln-Red-Imps-Fc
  GET DATOS  
$_GET['/historico/Lincoln-Red-Imps-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0035  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 = 'Lincoln-Red-Imps-Fc' 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=18036 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=18036 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=18036 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=18036 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=18036 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=18036 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=18036 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=18036 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0031  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 = '18036' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
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 = 18036 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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 = 72205 AND t.round = 22 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 75878 AND t.round = 3 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 `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 = 68119 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 70799 AND t.round = 10 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 `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 = 63212 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 66570 AND t.round = 10 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 = 59799 AND t.round = 11 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 61684 AND t.round = 10 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 = 49914 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.0020  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 = 55285 AND t.round = 6 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 = 43690 AND t.round = 27 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 `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 = 38781 AND t.round = 27 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 `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 = 35522 AND t.round = 27 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 `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 = 15925 AND t.round = 23 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 `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 = 8571 AND t.round = 21 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 = 10448 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC