4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Spartans
Información

Partidos del Spartans

Ir al LIVESCORE
26 Abr 22  Finalizado Spartans
2 - 1
Gala Fairydean Rovers 0
16 Abr 22  Finalizado Spartans
0 - 1
Bo'ness United 0
09 Abr 22  Finalizado Berwick Rangers
0 - 0
Spartans 0
25 Feb 22  Finalizado East Stirlingshire
0 - 0
Spartans 0
19 Feb 22  Finalizado Spartans
0 - 3
East Kilbride 0
12 Feb 22  Finalizado Spartans
2 - 1
Gretna 2008 0
29 Ene 22  Finalizado Broomhill FC
3 - 3
Spartans 0
22 Ene 22  Finalizado Spartans
4 - 2
Civil Service Strollers 0
15 Ene 22  Finalizado Spartans
8 - 0
Vale of Leithen 0
08 Ene 22  Finalizado Bonnyrigg Rose
2 - 2
Spartans 0
28 Dic 21  Finalizado Edinburgh University
1 - 2
Spartans 0
17 Dic 21  Finalizado Cumbernauld Colts
0 - 1
Spartans 0
11 Dic 21  Finalizado Spartans
5 - 2
Dalbeattie Star 0
04 Dic 21  Finalizado Rangers FC II
7 - 1
Spartans 0
13 Nov 21  Finalizado Vale of Leithen
1 - 2
Spartans 0
09 Nov 21  Finalizado Spartans
2 - 1
Celtic II 0
06 Nov 21  Finalizado Spartans
1 - 1
Stirling University 0
30 Oct 21  Finalizado Caledonian Braves
1 - 1
Spartans 0
09 Oct 21  Finalizado Spartans
1 - 2
Bonnyrigg Rose 0
06 Oct 21  Finalizado Celtic II
0 - 1
Spartans 1
02 Oct 21  Finalizado Gretna 2008
1 - 4
Spartans 0
25 Sep 21  Finalizado Spartans
2 - 1
Berwick Rangers 0
11 Sep 21  Finalizado East Kilbride
3 - 1
Spartans 0
04 Sep 21  Finalizado Civil Service Strollers
1 - 2
Spartans 0
31 Ago 21  Finalizado Spartans
1 - 0
Cumbernauld Colts 0
28 Ago 21  Finalizado Spartans
1 - 2
Caledonian Braves 0
21 Ago 21  Finalizado Spartans
2 - 3
East Stirlingshire 0
18 Ago 21  Finalizado Bo'ness United
2 - 3
Spartans 0
14 Ago 21  Finalizado Dalbeattie Star
1 - 3
Spartans 0
07 Ago 21  Finalizado Spartans
2 - 0
Broomhill FC 0
31 Jul 21  Finalizado Stirling University
0 - 2
Spartans 0
27 Jul 21  Finalizado Gala Fairydean Rovers
0 - 4
Spartans 0
24 Jul 21  Finalizado Spartans
4 - 0
Edinburgh University 0
20 Jul 21  Finalizado Spartans
0 - 2
Rangers FC II 0

Estadísticas

Plantilla del Spartans Temporada 2021/2022

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
28 ss - - - - -
- ss - - - - -
Defensa
31 ss - - - - -
20 ss - - - - -
30 ss 188 74 - - -
25 ss - - - - -
25 ss 184 - - - -
34 ss 183 - - - -
Centrocampista
38 ss - - - - -
20 ss 184 - - - -
33 ss - - - - -
27 ss - - 1 - -
33 ss 185 - - - -
26 ss 181 - - - -
Delantero
28 ss - - - - -
29 ss 193 72 1 - -
26 ss 176 - - - -
26 ss - - - - -
22 ss 176 - - - -

Noticias de Liga Lowland Escocia

Ver últimas noticias

¡Un equipo escocés bate el récord de victorias del Ajax de Cruyff!

El equipo holandés se tomó elegantemente el hecho de haber perdido el récord y ayudó al modesto club de la 'Lowland League' a celebrar el último triunfo con cerveza.




  USO DE MEMORIA  
5,732,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.3048
Total Execution Time  0.3068
  CADENA URL  
/spartans/2022
  GET DATOS  
$_GET['/spartans/2022']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (13)  
0.0157  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 = 'spartans' AND l.year = 2022 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.0145  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0145  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  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=30747 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=30747 AND type_rel = 2
0.0144  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1590 AND type_rel = 3
0.0146  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1590 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0145  SELECT /*53 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 (130169) ORDER BY n.cover_points DESC, update_date DESC
0.0150  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 = '30747' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020