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

Europa FC

Entrenador: Michele Di Piedi

Temporada 2023/2024
TEMPORADA 2023/2024
PREMIER DIVISION GIBRALTAR GRUPO 1
Equipo PJ GF GC Puntos
1 Lincoln Red Imps Lincoln Imps 20 63 12 52
2 St. Joseph's Joseph's 20 49 15 50
3 FCB Magpies FCB Magpies 20 52 28 42
4 Mons Calpe Mons Calpe 20 31 28 29
5 Europa Point Europa Point 20 27 22 28
6 Manchester 62 Manchester 20 39 41 28
7 Lynx Lynx 20 29 31 27
8 Europa FC Europa FC 20 25 34 20
9 Glacis United Glacis 20 21 47 16
10 Lions Gibraltar Lions 20 16 50 13
11 College 1975 College 1975 20 21 65 11
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 1
Equipo PJ GF GC Puntos
1 Europa FC Europa FC 11 58 8 31
2 St. Joseph's Joseph's 11 43 5 29
3 Lincoln Red Imps Lincoln Imps 11 48 9 27
4 Lynx Lynx 11 28 11 23
5 FCB Magpies FCB Magpies 11 22 21 18
6 Lions Gibraltar Lions 11 22 25 15
7 Mons Calpe Mons Calpe 11 24 27 14
8 Manchester 62 Manchester 11 10 29 10
9 Boca Juniors Boca Juniors 11 16 29 9
10 Europa Point Europa Point 11 12 25 8
11 Glacis United Glacis 11 15 47 6
12 College 1975 College 1975 11 5 67 0
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  
5,939,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0015
Controller Execution Time ( Home / Category )  0.1377
Total Execution Time  0.1393
  CADENA URL  
/historico/College-Europa
  GET DATOS  
$_GET['/historico/College-Europa']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (39)  
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 = 72205
0.0026  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 = 72099
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 = 75139
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=18039 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 18039 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0023  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 (21885,96572,100288,229868,651954) ORDER BY n.cover_points DESC, update_date DESC
0.0033  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 = '18039' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0022  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 = 72099 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  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 = 72205 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 = 75139 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0031  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=18039 AND l.year in (2023,2024,2025) ORDER BY l.id DESC, l.year DESC ;
0.0022  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 (75139,72205,72099,71432,69226) 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.0022  SELECT count(id) as num_players from rel_players WHERE league_id = 72205 AND teamId = 18039
0.0025  SELECT count(id) as num_players from rel_players WHERE league_id = 72099 AND teamId = 18039
0.0023  SELECT count(id) as num_players from rel_players WHERE league_id = 75139 AND teamId = 18039
0.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 69226 AND teamId = 18039
0.0024  SELECT count(id) as num_players from rel_players WHERE league_id = 71432 AND teamId = 18039
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 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 t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0027  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 = '18039' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0019  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '18039' and rp.type = 4
0.0027  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 = '18039' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0037  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 = 72205 WHERE rp.league_id = 72205 AND rp.teamId = 18039 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.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 = 72205 WHERE rp.league_id = 72205 AND rp.teamId = 18039 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0027  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 = 72205 WHERE rp.league_id = 72205 AND rp.teamId = 18039 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0029  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 = 18039 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
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 `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.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 `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.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 = 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.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 `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.0033  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.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 = 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.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 `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.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 = 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.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.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 = 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.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 `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.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 `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