4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Información
Otros Datos
  • Año de Fundación 1919
Internet

Información sobre el estadio

  • Nombre del estadio Palmerston Park
  • Capacidad 6412
  • Dirección Terregles Street
  • Año de construcción 1919
Palmerston Park

Histórico de participación

Copa de la Liga de Escocia
Copa Escocia
Challenge Cup Escocia
Liga Escocia
Championship Escocia
League One Escocia
11 veces
Partidos Amistosos
9 veces
Liga Escocia - Play Offs Ascenso
2 veces
(2015, 2014)
Championship Escocia - Play Offs Ascenso
1 vez
(2019)
Fase Previa Europa League Grupo 2
1 vez
(2009)

Partidos del Queen of the South

Ir al LIVESCORE
04 May 24  en 7 días Montrose
16:00
Queen of the South 0
27 Abr 24  en 4 h Queen of the South
16:00
Cove Rangers 0
20 Abr 24  Finalizado Stirling Albion
0 - 0
Queen of the South 0
13 Abr 24  Finalizado Queen of the South
2 - 0
Edinburgh City 0
06 Abr 24  Finalizado Queen of the South
1 - 2
Kelty Hearts 0
30 Mar 24  Finalizado Tarjeta RojaHamilton Academical
0 - 0
Queen of the SouthTarjeta Roja 0
23 Mar 24  Finalizado Alloa Athletic
0 - 2
Queen of the South 1
16 Mar 24  Finalizado Queen of the South
1 - 4
Falkirk 0
09 Mar 24  Finalizado Annan Athletic
2 - 1
Queen of the South 0
02 Mar 24  Finalizado Queen of the South
2 - 2
Stirling Albion 0
24 Feb 24  Finalizado Queen of the South
2 - 3
Montrose 0
17 Feb 24  Finalizado Edinburgh City
1 - 1
Queen of the SouthTarjeta Roja 0
10 Feb 24  Finalizado Kelty Hearts
0 - 0
Queen of the South 0
03 Feb 24  Finalizado Queen of the South
0 - 2
Hamilton Academical 0
27 Ene 24  Finalizado Tarjeta RojaCove Rangers
0 - 2
Queen of the SouthTarjeta Roja 0
13 Ene 24  Finalizado Queen of the South
1 - 1
Alloa Athletic 0
06 Ene 24  Finalizado Falkirk
1 - 0
Queen of the South 0
30 Dic 23  Finalizado Queen of the South
2 - 1
Annan AthleticTarjeta Roja 1

Plantilla del Queen of the South Temporada 2023/2024

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
30 20 ss - - - - -
1 26 gb 197 - - 1 -
31 22 ss 191 - - - 1
41 20 nz - - - - -
21 19 ss 189 - - - -
Defensa
23 22 ss 176 - - - 1
3 23 ss 188 - - - 2
24 35 ng 190 70 - - 3
35 20 ss 184 - 1 - 3
2 24 ss 178 73 - - -
29 18 ss - - - - -
15 22 i1 180 70 1 1 9
32 18 ss - - - - -
4 20 gb 182 76 - - 2
34 18 ss - - - - -
19 19 ss - - - - 2
5 27 ss 191 82 2 - 1
Centrocampista
17 20 ss - - 3 - 7
28 19 ss - - - - -
11 26 ss 176 - 3 - 1
26 19 ss - - - - -
33 17 ss - - - - -
6 23 ss 176 71 1 - 4
4 25 ss 188 67 - - -
8 29 gb 183 78 2 - 2
7 23 ss 173 - 2 - 5
39 - si - - - - -
18 22 ss 173 65 1 - 2
Delantero
9 30 ss 181 73 9 - 3
30 22 gb - - 2 - 3
14 21 gb - - 1 - 2
22 25 se 188 88 3 - 4
25 22 ss 182 - 2 1 4
27 18 ss - - 2 - 2
10 24 ss 170 - 4 - 8
20 22 ss 174 - - - 1
41 - ss - - - - -
22 - ss - - - - -

Noticias del Queen of the South

Ver últimas noticias

El curioso caso de Stephen Dobbie

Stephen Dobbie es una de las sensaciones de Escocia. Juega en el Queen of the South y lleva más goles que Cristiano Ronaldo y Leo Messi. Acaba de cumplir 36 años.

El Queen of the South obtiene la cesión de Kane

El delantero abandona temporalmente el St. Johnstone para incorporarse en calidad de préstamo al Queen of the South.

Gavin Skelton deja el banquillo del Queen of the South

El técnico inglés dejó la entidad por su propia voluntad aludiendo a motivos personales como razón principal a su renuncia en el cargo.

Jake Pickard renueva su contrato con el Queen of the South

El delantero continuará disputando el Championship Escocés con el Queen of the South lo que resta de temporada.




  USO DE MEMORIA  
6,567,120 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Home / Category )  0.1320
Total Execution Time  0.1338
  CADENA URL  
/queen-of-the-south
  GET DATOS  
$_GET['/queen-of-the-south']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (19)  
0.0053  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 = 'queen-of-the-south' 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.0019  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=4444 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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0020  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0022  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0019  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0021  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=4444 AND role_id=1 ORDER BY rp.date_ini DESC LIMIT 1
0.0032  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 = 72523
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4444 AND type_rel = 2
0.0023  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 4444 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0026  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 (47627,131227,273783,560835) ORDER BY n.cover_points DESC, update_date DESC
0.0134  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 = '4444' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0025  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 = 72523 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0038  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 = 73404 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50