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

Pretemporada Real Sociedad

Presidente: Jokin Aperribay

Fichajes Real Sociedad

No fichajes previstos

Plantilla del Real Sociedad

Jugador Posición Edad Origen Altura Peso Goles Tarjetas rojas Tarjetas amarillas
Portero
1 Portero 28 es 191 82 - - -
30 Portero 22 es 182 79 - - -
13 Portero 21 es 189 82 - - -
37 Portero 20 es 194 - - - -
Defensa
6 Lateral Derecho 29 es 180 72 - - -
25 Defensa 28 es 172 70 - - -
2 Lateral Derecho 27 es 176 74 - - -
18 Defensa 31 ml 175 64 - - -
17 Lateral Izquierdo 25 ss 180 70 - - -
24 Defensa 26 es 187 80 - - -
5 Defensa 26 es 181 79 - - -
3 Defensa 25 es 175 72 - - -
20 Defensa 22 es 184 77 - - -
39 Lateral Derecho 20 ve 176 71 - - -
41 Defensa 20 es - - - - -
36 Defensa 17 es 187 - - - -
Centrocampista
8 Centrocampista 26 es 189 78 - - -
23 Volante Izquierdo 26 es 184 76 - - -
4 Centrocampista 24 es 181 74 - - -
16 Medio Centro 22 es 176 74 - - -
22 Centrocampista 21 es 181 73 - - -
15 Medio Centro 22 es 189 80 - - -
28 Medio Centro 21 es 180 75 - - -
29 Medio Centro 19 es 178 - - - -
Delantero
21 Delantero 27 pt 185 78 - - -
9 Delantero 26 es 185 72 - - -
Delantero 27 es 176 72 - - -
11 Delantero 28 sr 180 72 - - -
19 Delantero 26 ng 191 75 - - -
10 Delantero 26 es 181 79 - - -
14 Delantero 21 jp 173 69 - - -
7 Delantero 21 es 175 74 - - -
40 Delantero 20 no 183 72 - - -
12 Delantero 19 ru 183 68 - - -
38 Extremo Derecho 20 es 170 - - - -

  USO DE MEMORIA  
5,097,248 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0018
Controller Execution Time ( Preseason / Category )  0.2457
Total Execution Time  0.2475
  CADENA URL  
/pretemporada/Real-Sociedad/1909
  GET DATOS  
$_GET['/pretemporada/Real-Sociedad/1909']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0144  SELECT type FROM routes WHERE alias = 'Real-Sociedad'
0.0175  SELECT dt.*, t.id AS team_id, ct.id AS competition_id, ct.name AS competition_name, ct.alias AS competition_alias, ct.class, ct.alias, ct.type_style FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON l.categoryId=ct.id WHERE dt.basealias='Real-Sociedad' AND ct.troncal=1 ORDER BY l.year DESC LIMIT 1
0.0147   SELECT t.id AS team_id, l.id AS league_id, ct.id as competition_id, ct.name AS competition_name FROM teams AS t INNER JOIN leagues AS l ON t.league_id=l.id INNER JOIN categories AS ct ON l.categoryId=ct.id WHERE t.teamId='2120' AND l.year='1909' AND (ct.competition_type='11' or ct.id=672)
0.0145  SELECT active_year as year from categories where id=1 order by active_year desc limit 1
0.0148  SELECT t.id, dt.id AS dtid, dt.nameShow AS name, dt.basealias 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 INNER JOIN datateams AS dt ON t.teamId=dt.id WHERE ct.id=1 AND l.year=2024 AND ct.troncal=1 AND dt.id='2120' GROUP BY dt.id ORDER BY dt.nameShow ASC
0.0160   SELECT rb.origin_team_id AS otid, rb.destination_team_id AS dtid, rb.official_budget, rb.new_id, rb.valor, rb.budget_type, dp.id, dp.nick AS name, dp.role, dt1.id AS odtid, dt1.nameShow AS odtname, dt2.id AS ddtid, dt2.nameShow AS ddtname, n.alias FROM rel_budgets AS rb INNER JOIN news AS n ON n.id=rb.new_id INNER JOIN dataplayers AS dp ON rb.player_id=dp.id LEFT JOIN datateams AS dt1 ON rb.origin_team_id=dt1.id LEFT JOIN datateams AS dt2 ON rb.destination_team_id=dt2.id WHERE rb.year=2024 AND (rb.origin_team_id IN (2120) OR rb.destination_team_id IN (2120)) AND rb.budget_date >= '2016-03-01' order by rb.budget_type!=5 desc,rb.pub_date desc
0.0310  SELECT p.*,rp.*, TIMESTAMPDIFF(YEAR,p.birthdate,CURDATE()) AS age FROM `rel_players` rp INNER JOIN `dataplayers` p ON rp.player_id = p.id WHERE rp.in_squad=1 AND rp.team_id = '6583648' ORDER BY p.role>0 DESC, p.role ASC
0.0149   SELECT dt.id, dt.nameShow, dt.basealias, l.id AS league_id, l.categoryId AS competition_id FROM datateams AS dt INNER JOIN teams AS t ON dt.id=t.teamId INNER JOIN leagues AS l ON t.league_id=l.id WHERE l.categoryId=1 AND l.year=2024 AND l.group_code='1' ORDER BY dt.nameShow ASC