4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Elmina Sharks
TEMPORADA 2023/2024
SEGUNDA GHANA
Equipo PJ GF GC Puntos
1 Techiman Heroes Techiman 25 32 17 50
2 VC Warriors VC Warriors 25 30 20 43
3 Tamale City Tamale City 25 35 16 42
4 Northern City Northern 25 32 34 36
5 Wa Suntaa Wa Suntaa 25 25 30 29
6 Wa Power Wa Power 25 24 38 29
7 Maana Maana 25 26 40 27
8 Steadfast Steadfast 25 23 32 26
9 Young Apostles Young 25 24 18 46
10 Wamanafo Mighty Royals Wamanafo 25 28 18 44
11 Techiman Liberty Techiman 25 24 17 44
12 Debibi United Debibi 25 31 24 39
13 Baffour Academy Baffour 25 24 24 33
14 Eleven Wonders Eleven 25 20 24 30
15 Berekum City Berekum City 25 20 21 27
16 Brong Ahafo Stars Brong Ahafo 25 13 38 16
17 New Edubiase FC Edubiase 25 25 14 41
18 Basake Holy Stars Basake Holy 25 24 17 41
19 PAC Academy PAC Academy 25 25 21 40
20 Soccer Intellectuals Soccer 25 22 19 40
21 Ebusua Dwarfs Ebusua 25 26 18 38
22 Skyy FC Skyy FC 25 26 21 38
23 Sefwi All Stars Sefwi Stars 25 28 24 37
24 Elmina Sharks Elmina 25 28 27 36
25 Swedru All Blacks Swedru 25 19 17 34
26 Future Stars Future Stars 25 22 27 34
27 Nzema Kotoko Nzema Kotoko 25 24 24 32
28 Rospak Rospak 25 22 22 32
29 Asekem Asekem 25 24 28 32
30 King Faisal King Faisal 25 19 25 30
31 Venomous Vipers Venomous 25 23 31 25
32 Young Redbull Young 25 17 39 22
33 Vision Vision 25 39 21 48
34 Hohoe United Hohoe United 25 37 16 45
35 Na God Na God 25 31 25 40
36 Okwawu Okwawu 25 22 16 40
37 Attram de Visser Attram 25 26 21 40
38 Golden Kicks Golden Kicks 25 30 31 38
39 Home Stars Home Stars 25 19 16 36
40 Nania Nania 25 24 26 36
41 Kings Palace Kings Palace 25 25 30 32
42 Koforidua Semper Fi Koforidua 25 29 25 30
43 Uncle T Uncle T 25 31 33 30
44 Accra Athletic Accra 25 16 25 30
45 Akatsi All Stars Akatsi Stars 25 30 39 27
46 Kotoku Royals Kotoku 25 15 25 27
47 Susubiribi Susubiribi 25 18 29 25
48 Still Believe Still 25 20 34 21
TEMPORADA 2021/2022
LIGA GHANA
Equipo PJ GF GC Puntos
1 Asante Kotoko Asante 34 48 20 67
2 Medeama Medeama 34 28 25 56
3 Bechem United Bechem 34 37 24 54
4 Karela Karela 34 43 33 52
5 Accra Great Olympics Accra Great 34 36 31 48
6 Hearts of Oak Hearts 34 33 29 48
7 Ashanti Gold Ashanti Gold 34 46 37 47
8 Berekum Chelsea Berekum 34 29 30 47
9 Legon Cities Legon Cities 34 34 26 46
10 Bibiani Gold Stars Bibiani Gold 34 34 40 46
11 Aduana Stars Aduana Stars 34 33 28 45
12 Accra Lions FC Accra Lions 34 26 38 45
13 Dreams FC Dreams FC 34 47 44 44
14 King Faisal King Faisal 34 30 34 42
15 Real Tamale Real Tamale 34 40 48 41
16 Eleven Wonders Eleven 34 29 38 40
17 West African Football West African 34 27 42 35
18 Elmina Sharks Elmina 34 24 57 23
TEMPORADA 2020/2021
LIGA GHANA
Equipo PJ GF GC Puntos
1 Hearts of Oak Hearts 34 45 23 61
2 Asante Kotoko Asante 34 37 22 57
3 West African Football West African 34 46 38 56
4 Aduana Stars Aduana Stars 34 44 42 55
5 Medeama Medeama 34 38 34 54
6 Accra Great Olympics Accra Great 34 37 33 52
7 Dreams FC Dreams FC 34 45 35 49
8 Karela Karela 34 42 41 46
9 Ashanti Gold Ashanti Gold 34 50 36 45
10 Berekum Chelsea Berekum 34 38 46 43
11 Legon Cities Legon Cities 34 34 35 42
12 Eleven Wonders Eleven 34 33 38 42
13 Bechem United Bechem 34 38 47 42
14 Ebusua Dwarfs Ebusua 34 40 44 41
15 Elmina Sharks Elmina 34 34 45 41
16 King Faisal King Faisal 34 32 45 41
17 Liberty Professionals FC Liberty 34 33 45 40
18 Inter Allies FC Inter Allies 34 28 45 26
TEMPORADA 2019/2020
LIGA GHANA
Equipo PJ GF GC Puntos
1 Aduana Stars Aduana Stars 15 17 11 28
2 Berekum Chelsea Berekum 15 17 14 26
3 Asante Kotoko Asante 14 14 7 25
4 Elmina Sharks Elmina 15 19 14 25
5 Ashanti Gold Ashanti Gold 15 12 10 25
6 Medeama Medeama 15 18 11 24
7 West African Football West African 15 17 12 22
8 Bechem United Bechem 15 15 14 22
9 Hearts of Oak Hearts 14 15 12 21
10 Accra Great Olympics Accra Great 15 17 19 20
11 Inter Allies FC Inter Allies 14 22 21 19
12 Eleven Wonders Eleven 15 11 15 19
13 Dreams FC Dreams FC 15 10 11 16
14 Liberty Professionals FC Liberty 15 21 23 16
15 Legon Cities Legon Cities 15 12 18 16
16 Ebusua Dwarfs Ebusua 15 13 20 15
17 Karela Karela 15 10 16 11
18 King Faisal King Faisal 14 17 29 6
TEMPORADA 2017/2018
LIGA GHANA
Equipo PJ GF GC Puntos
1 Medeama Medeama 14 19 12 27
2 Ashanti Gold Ashanti Gold 15 15 9 27
3 Karela Karela 15 17 10 25
4 Asante Kotoko Asante 15 15 13 24
5 Inter Allies FC Inter Allies 15 15 15 24
6 Dreams FC Dreams FC 15 13 15 24
7 West African Football West African 15 22 17 20
8 Elmina Sharks Elmina 14 14 12 20
9 Berekum Chelsea Berekum 15 14 14 19
10 Bechem United Bechem 15 17 20 19
11 Liberty Professionals FC Liberty 15 15 18 17
12 Eleven Wonders Eleven 15 13 16 17
13 Hearts of Oak Hearts 14 13 16 17
14 Aduana Stars Aduana Stars 12 18 16 14
15 Ebusua Dwarfs Ebusua 14 13 20 14
16 Legon Cities Legon Cities 14 8 18 10
TEMPORADA 2016/2017
LIGA GHANA
Equipo PJ GF GC Puntos
1 Aduana Stars Aduana Stars 30 45 25 57
2 West African Football West African 30 40 19 51
3 Hearts of Oak Hearts 30 42 33 48
4 Ebusua Dwarfs Ebusua 30 39 33 44
5 Asante Kotoko Asante 30 23 22 43
6 Legon Cities Legon Cities 30 36 32 42
7 Medeama Medeama 30 35 32 42
8 Berekum Chelsea Berekum 30 37 35 42
9 Elmina Sharks Elmina 30 29 29 42
10 Ashanti Gold Ashanti Gold 30 38 36 41
11 Liberty Professionals FC Liberty 30 34 34 41
12 Bechem United Bechem 30 30 31 41
13 Inter Allies FC Inter Allies 30 24 26 40
14 Tema Youth Tema Youth 30 30 33 37
15 Accra Great Olympics Accra Great 30 27 32 36
16 Bolga All Stars Bolga Stars 30 21 78 12

  USO DE MEMORIA  
6,267,544 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.1029
Total Execution Time  0.1041
  CADENA URL  
/historico/Elmina-Sharks-Fc
  GET DATOS  
$_GET['/historico/Elmina-Sharks-Fc']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (27)  
0.0027  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 = 'Elmina-Sharks-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=100531 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=100531 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=100531 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0041  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 = 75352
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=100531 AND type_rel = 2
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2953 AND type_rel = 3
0.0021  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 = '100531' ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '100531' AND l.year = 2024 ORDER BY l.year DESC,cat.coefficient DESC
0.0021  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 = '100531' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0021  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=100531 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 (75352,74613) 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.0019  SELECT count(id) as num_players from rel_players WHERE league_id = 75352 AND teamId = 100531
0.0020  SELECT count(id) as num_players from rel_players WHERE league_id = 74613 AND teamId = 100531
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 = '100531' 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 = '100531' 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 = '100531' and rp.type = 4 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0024  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 = 75352 WHERE rp.league_id = 75352 AND rp.teamId = 100531 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.0024  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 = 75352 WHERE rp.league_id = 75352 AND rp.teamId = 100531 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0024  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 = 75352 WHERE rp.league_id = 75352 AND rp.teamId = 100531 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0026  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 = 100531 AND l.year <= 2024 AND total_num_tablesR >= 1 ORDER BY l.year DESC LIMIT 20
0.0046  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 = 75352 AND t.round = 25 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 = 65295 AND t.round = 34 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 `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 = 59642 AND t.round = 34 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0034  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 = 53584 AND t.round = 15 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 `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 = 42547 AND t.round = 15 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 `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 = 37863 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC