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

Sunshine Stars

Entrenador: Edith Agoye

Información

Partidos del Sunshine Stars

Ir al LIVESCORE
07 Jul 10  Finalizado Sunshine Stars
2 - 0
Warri Wolves FC 0
28 Jun 10  Finalizado Gateway FC
1 - 2
Sunshine Stars 0
25 Jun 10  Finalizado Sunshine Stars
3 - 1
Enyimba 0
13 Jun 10  Finalizado Sunshine Stars
2 - 1
Kano Pillars 0
06 Jun 10  Finalizado Dolphin Port Harcourt
1 - 1
Sunshine Stars 0
23 May 10  Finalizado Bayelsa United
1 - 0
Sunshine Stars 0
16 May 10  Finalizado Sunshine Stars
1 - 0
Niger Tornadoes 0
12 May 10  Finalizado Ranchers Bees
0 - 0
Sunshine Stars 0
02 May 10  Finalizado Sunshine Stars
2 - 0
Gombe United 0
29 Abr 10  Finalizado Heartland Owerri
3 - 0
Sunshine Stars 0
11 Abr 10  Finalizado Sunshine Stars
3 - 1
Sharks 0
04 Abr 10  Finalizado Zamfara United
1 - 0
Sunshine Stars 0
28 Mar 10  Finalizado Sunshine Stars
1 - 0
Kwara United 0
20 Mar 10  Finalizado Shooting Stars
2 - 0
Sunshine Stars 0
14 Mar 10  Finalizado Sunshine Stars
1 - 0
Ocean Boys 0
10 Mar 10  Finalizado Lobi Stars
2 - 0
Sunshine Stars 0
07 Mar 10  Finalizado Sunshine Stars
2 - 1
Kaduna United FC 0
28 Feb 10  Finalizado Enugu Rangers
0 - 0
Sunshine Stars 0
20 Feb 10  Finalizado Wikki Tourist
1 - 1
Sunshine Stars 0
14 Feb 10  Finalizado Sunshine Stars
4 - 0
Wikki Tourist 0
07 Feb 10  Finalizado Enyimba
2 - 1
Sunshine Stars 0
31 Ene 10  Finalizado Sunshine Stars
1 - 0
Dolphin Port Harcourt 0
27 Ene 10  Finalizado Kano Pillars
1 - 0
Sunshine Stars 0
24 Ene 10  Finalizado Sunshine Stars
2 - 1
Gateway FC 0
17 Ene 10  Finalizado Warri Wolves FC
2 - 0
Sunshine Stars 0
14 Ene 10  Finalizado Sunshine Stars
1 - 0
Bayelsa United 0
10 Ene 10  Finalizado Sunshine Stars
1 - 0
Ranchers Bees 0
19 Dic 09  Finalizado Niger Tornadoes
1 - 0
Sunshine Stars 0
12 Dic 09  Finalizado Gombe United
2 - 1
Sunshine Stars 0
06 Dic 09  Finalizado Sunshine Stars
0 - 0
Heartland Owerri 0
28 Nov 09  Finalizado Sharks
0 - 1
Sunshine Stars 0
22 Nov 09  Finalizado Sunshine Stars
2 - 0
Zamfara United 0
18 Nov 09  Finalizado Kwara United
2 - 0
Sunshine Stars 0
18 Oct 09  Finalizado Sunshine Stars
1 - 0
Shooting Stars 0
10 Oct 09  Finalizado Ocean Boys
1 - 0
Sunshine Stars 0
04 Oct 09  Finalizado Sunshine Stars
0 - 0
Lobi Stars 0
28 Sep 09  Finalizado Kaduna United FC
1 - 1
Sunshine Stars 0
20 Sep 09  Finalizado Sunshine Stars
2 - 1
Enugu Rangers 0

Noticias de Premier League Nigeria

Ver últimas noticias

¿Era amaño? El famoso penalti de Nigeria fue una protesta... ¡contra el arbitraje!

La polémica saltó por los aires con la tanda de penaltis que se dio en Nigeria y que apuntaba a ser un claro caso de amaño, pero fue una protesta en contra del arbitraje de ese mismo partido.

El amaño más descarado: un penalti en Nigeria acabó... ¡en la banda!

Remo Stars y Ijebu United se enfrentaron y protagonizaron la tanda de penaltis más increíble de la historia, con un portero hecho estatua y un lanzamiento que acabó en saque de banda.

Escándalo en Nigeria: anulan un gol legal... ¡tras un puñetazo al linier!

La Liga Nigeriana dejó una imagen negativa para el deporte. En el encuentro entre el Kano Pillars y el Dakkada, el juez de línea fue agredido por el presidente del conjunto local tras dar gol en una acción que, en principio, pareció fuera de juego. El cuerpo arbitral se arrepintió y acabó anulándolo.

El directivo que amañó partidos, de sancionado de por vida a solo cinco años

El TAS decidió reducir la sanción a Samson Siasia, que violó el artículo número uno de su código ético al aceptar sobornos para amañar partidos, a cinco años. El primer castigo que se había decidido era apartarle de los terrenos de juego de por vida.

Un día nefasto para el fútbol nigeriano

La tragedia se ha cebado con el fútbol nigeriano estos días. El pasado domingo Ifeanyi George y Emmanuel Ogbu, ambos del Enugu Rangers, fallecieron en un accidente de tráfico. Ese mismo día, Dayo Ojo era secuestrado a punta de pistola.




  USO DE MEMORIA  
5,046,712 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.3282
Total Execution Time  0.3302
  CADENA URL  
/Sunshine-Stars/2010
  GET DATOS  
$_GET['/Sunshine-Stars/2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (17)  
0.0125  SELECT type FROM routes WHERE alias = 'sunshine-stars'
0.0256  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 = 10752
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=15887 AND type_rel = 2
0.0130  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 = '15887' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0127  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 = 10752 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0129  (SELECT cat.id as category_id, cat.logo, l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2010 as c ON c.league_id = l.id WHERE (c.datateam1 = 15887 or c.datateam2 = 15887) AND l.year = 2010 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0134  (SELECT cat.id as category_id, l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2010 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE (c.datateam1 = 15887 or c.datateam2 = 15887) AND l.year = 2010 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0128  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2010 as c ON c.league_id = l.id INNER JOIN events2010 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.in_squad = 1 AND rel.league_id = e.league_id AND rel.in_squad = 1 WHERE (c.datateam1 = 15887 or c.datateam2 = 15887) AND l.year = 2010)
0.0129  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=15887 AND l.year in (2009,2010,2011) ORDER BY l.id DESC, l.year DESC ;
0.0126  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 (27386,10753) 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.0125  SELECT count(id) as num_players from rel_players WHERE league_id = 10753 AND teamId = 15887
0.0129  SELECT count(id) as num_players from rel_players WHERE league_id = 27386 AND teamId = 15887
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff FROM `tables2010` 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 = 10752 AND t.round = 38 ORDER BY t.position ASC,dt.id = 2125 DESC, diff DESC, t.ga DESC, dt.nameShow ASC
0.0141  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 events2010 e ON e.player_id = p.id AND e.league_id = 10752 WHERE rp.league_id = 10752 AND rp.teamId = 15887 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.0126  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 events2010 e ON e.player_id = p.id AND e.league_id = 10752 WHERE rp.league_id = 10752 AND rp.teamId = 15887 AND (e.action = 4 or e.action = 5) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  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 events2010 e ON e.player_id = p.id AND e.league_id = 10752 WHERE rp.league_id = 10752 AND rp.teamId = 15887 AND (e.action = 3 or e.action = 4) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0126  SELECT rp.team_id as teamId FROM rel_players AS rp inner join datateams as dt on rp.teamId=dt.id and rp.in_squad=1 INNER JOIN leagues as l ON l.id = rp.league_id WHERE dt.id = 15887 AND rp.league_id = 10752 AND l.year= 2010 GROUP BY rp.team_id ORDER BY l.end_date DESC LIMIT 1