4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias

¿Falta algún dato de este equipo?

Si tienes datos del equipo que no se encuentran en la página nos encantaría que los compartas con nosotros. Un editor de la página validará los datos y en el plazo de tiempo más breve posible completarán los datos actuales con los enviados.

Información sobre Queen of the South

Enviar Datos
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
95 veces
(2024, 2023, 2023, 2022, 2021, 2020, 2019, 2019, 2018, 2017, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2004, 2003, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995, 1994, 1993, 1992, 1991, 1990, 1989, 1988, 1987, 1986, 1985, 1984, 1983, 1982, 1982, 1981, 1981, 1980, 1979, 1978, 1977, 1976, 1976, 1975, 1975, 1974, 1974, 1973, 1972, 1971, 1970, 1969, 1968, 1967, 1966, 1966, 1965, 1964, 1964, 1963, 1963, 1962, 1962, 1961, 1961, 1960, 1960, 1959, 1958, 1958, 1957, 1957, 1956, 1956, 1955, 1954, 1953, 1952, 1951, 1950, 1950, 1949, 1949, 1948, 1948, 1947, 1946)
Copa Escocia
26 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2005, 2004, 2003, 2002, 2001, 2000, 1999, 1998)
Challenge Cup Escocia
24 veces
(2024, 2023, 2022, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2013, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003, 2002, 2001, 2000)
Liga Escocia
20 veces
(1964, 1963, 1959, 1958, 1957, 1956, 1955, 1954, 1953, 1952, 1950, 1949, 1948, 1947, 1939, 1938, 1937, 1936, 1935, 1934)
Championship Escocia
19 veces
(2022, 2021, 2020, 2019, 2018, 2017, 2016, 2015, 2014, 2012, 2011, 2010, 2009, 2008, 2007, 2006, 2005, 2004, 2003)
League One Escocia
11 veces
(2024, 2023, 2013, 2002, 2001, 2000, 1999, 1998, 1997, 1996, 1995)
Partidos Amistosos
9 veces
(2024, 2023, 2022, 2021, 2020, 2019, 2018, 2017, 2011)
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
Championship Escocia Championship Escocia »
06 May 17  Finalizado Queen of the South
0 - 1
 Dunfermline Athletic FC 0
29 Abr 17  Finalizado Falkirk
2 - 2
 Queen of the South 1
22 Abr 17  Finalizado Queen of the South
1 - 2
 Dumbarton 0
15 Abr 17  Finalizado Hibernian FC
3 - 0
 Queen of the South 0
08 Abr 17  Finalizado Ayr United
0 - 2
 Queen of the South 0
01 Abr 17  Finalizado Queen of the South
4 - 2
 Dundee United 0
25 Mar 17  Finalizado Raith Rovers
1 - 1
 Queen of the South 0
18 Mar 17  Finalizado Queen of the South
0 - 2
 St. Mirren 0
11 Mar 17  Finalizado Greenock Morton
1 - 0
 Queen of the South 0
07 Mar 17  Finalizado Tarjeta RojaDunfermline Athletic FC
1 - 1
 Queen of the South 1
04 Mar 17  Finalizado Queen of the South
0 - 2
 Falkirk 0
25 Feb 17  Finalizado Queen of the South
2 - 1
 Raith Rovers 0
04 Feb 17  Finalizado Queen of the South
3 - 0
 Greenock Morton 0
28 Ene 17  Finalizado Queen of the South
0 - 1
 Hibernian FCTarjeta RojaTarjeta Roja 0
21 Ene 17  Finalizado Dumbarton
1 - 2
 Queen of the South 0
14 Ene 17  Finalizado Dundee United
3 - 3
 Queen of the South 4
07 Ene 17  Finalizado St. Mirren
0 - 3
 Queen of the South 0
31 Dic 16  Finalizado Queen of the South
0 - 0
 Ayr United 1
24 Dic 16  Finalizado Greenock Morton
1 - 0
 Queen of the South 0
17 Dic 16  Finalizado Queen of the South
2 - 2
 Dunfermline Athletic FC 0
10 Dic 16  Finalizado Falkirk
2 - 2
 Queen of the South 0
06 Dic 16  Finalizado Queen of the South
2 - 3
 St. Mirren 0
03 Dic 16  Finalizado Queen of the South
1 - 2
 Dumbarton 0
19 Nov 16  Finalizado Hibernian FC
4 - 0
 Queen of the South 0
05 Nov 16  Finalizado Queen of the South
1 - 4
 Dundee United 0
29 Oct 16  Finalizado Raith Rovers
1 - 0
 Queen of the South 0
22 Oct 16  Finalizado Ayr United
1 - 0
 Queen of the South 0
15 Oct 16  Finalizado Queen of the South
0 - 5
 Greenock Morton 0
01 Oct 16  Finalizado Dumbarton
0 - 0
 Queen of the South 0
24 Sep 16  Finalizado Queen of the South
0 - 0
 Hibernian FCTarjeta RojaTarjeta Roja 0
17 Sep 16  Finalizado Queen of the South
3 - 1
 Raith Rovers 0
10 Sep 16  Finalizado St. Mirren
1 - 3
 Queen of the South 0
27 Ago 16  Finalizado Tarjeta RojaDunfermline Athletic FC
0 - 1
 Queen of the South 0
20 Ago 16  Finalizado Queen of the South
2 - 0
 Falkirk 0
13 Ago 16  Finalizado Queen of the South
4 - 1
 Ayr United 0
06 Ago 16  Finalizado Dundee United
1 - 1
 Queen of the South 1

Plantilla del Queen of the South Temporada 2016/2017

Jugador Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
34 25 ss - - - - -
20 29 gb 180 72 - - -
21 26 ss 176 - - - -
1 37 gb 180 76 - - 3
Defensa
26 25 ss 190 - - - -
4 41 ss 185 70 - - 9
6 38 ss 185 68 - - 5
39 35 gb - - - - -
- ss - - - - -
5 30 ss 191 84 - - 6
2 37 ss 173 70 - - 6
3 27 gb 181 74 - - 4
30 ss 180 - - - -
43 ss 183 70 - - -
16 29 ss 181 - - - -
24 28 ss 183 - - - 1
Centrocampista
17 28 ss 186 79 - - -
22 30 ss 178 70 - - 1
23 28 ss 171 59 3 - 1
- ss - - - - -
32 ss - - - - -
15 27 ss 177 68 6 - 3
14 32 za 178 62 1 - 6
27 ss - - - - -
29 25 gb - - - - -
19 26 gb 186 76 - - -
32 27 ss - - - - -
31 26 gb - - - - -
38 ss - - - - -
12 31 gb 183 80 - - -
Delantero
26 ss 171 - - - -
27 27 ss 173 - - - -
35 26 ss - - 1 - -
39 33 ss 173 67 - - -
9 43 ss 173 66 10 - 1
10 31 ss 172 65 1 - 3
41 ss 178 73 - - -
17 27 gb 181 70 - - 2
27 ss 175 68 - - -
25 28 ss 188 80 2 - -
11 41 ss 173 65 17 - 2
12 27 gb 175 72 - - -

Noticias del Queen of the South

Ver últimas noticias

El curioso caso de Stephen Dobbie

Ismael Touat - Martes, 01 Enero 2019
0 1.192

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

BeSoccer - Viernes, 11 Agosto 2017
0 271

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

BeSoccer - Martes, 08 Noviembre 2016
0 82

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

BeSoccer - Jueves, 03 Marzo 2016
0 115

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

Ver más noticias del equipo»



  USO DE MEMORIA  
6,987,608 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0020
Controller Execution Time ( Home / Category )  0.2249
Total Execution Time  0.2270
  CADENA URL  
/queen-of-the-south/2017
  GET DATOS  
$_GET['/queen-of-the-south/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (30)  
0.0047  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 = 2017 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.0033  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.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.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.0035  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.0025  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.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.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.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 = 33316
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 = 33924
0.0024  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 = 31269
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 = 33376
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 = 34078
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=4444 AND type_rel = 2
0.0020  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.0022  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.0050  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.0021  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 = 33376 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 = 33316 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 = 34078 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0023  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 = 33924 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  (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 calendars2017 as c ON c.league_id = l.id WHERE (c.datateam1 = 4444 or c.datateam2 = 4444) AND l.year = 2017 GROUP BY cat.id) ORDER BY coefficient DESC,group_code ASC
0.0028  (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 calendars2017 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 = 4444 or c.datateam2 = 4444) AND l.year = 2017 GROUP BY c.id) ORDER BY shedule DESC LIMIT 120
0.0026  (SELECT c.id, rel.team_id FROM leagues l INNER JOIN calendars2017 as c ON c.league_id = l.id INNER JOIN events2017 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 = 4444 or c.datateam2 = 4444) AND l.year = 2017)