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

Raúl Albiol

Jugador del Villarreal
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Raúl Albiol
Nacionalidad
España
Nombre
Raúl Albiol Tortajada
Edad
38 Años (04-09-1985)
Altura
190
Dorsal
3
Peso
82 kilogramos
Equipo
Villarreal
Posición
Defensa
Liga
Primera División
Compañeros de equipo
Fotos
19
  • Foto principal de R. Albiol | Napoli
  • Foto principal de R. Albiol | Napoli
  • Foto principal de R. Albiol | Napoli
  • Foto principal de R. Albiol | Napoli
  • Foto principal de R. Albiol | Napoli
  • Foto principal de R. Albiol | España
  • Foto principal de R. Albiol | Napoli
  • Albiol
  • R. Albiol
  • Albiol
  • Albiol
  • Albiol
  • Albiol
  • Albiol  o  marsella vs real madrid
  • Albiol
  • joseherranzl
    Hace 11 años joseherranzl dice: gran central de la selecion
  • unsko
    Hace 11 años unsko dice: Campeón del Mundo, bicampeón de Europa con España, campeón de Copa y campeón de Liga con el Real Madrid. Cinco títulos de importancia suprema conseguidos sin adquirir una preponderancia básica en las alineaciones de sendos conjuntos, pero aportando gran fiabilidad en sus participaciones.
  • nepz_01
    Hace 12 años nepz_01 dice: Albiol es un super central ojala que no se valle del madrid D: me gustaria verlo trabjar con Carvalho.Albiol es un super central ojala que no se valle del madrid D: me gustaria verlo trabjar con Carvalho.
  • Hace 12 años abonado dice: defensa expectacular defensa expectacular
  • AdRiAlCoRcOn
    Hace 13 años AdRiAlCoRcOn dice: ¡Gran central! Cuando se recupere Pepe, y se ponga en forma, van a ser una de las mejores parejas de centrales del mundo, si los dos juegan al máximo nivel. ¡Gran central! Cuando se recupere Pepe, y se ponga en forma, van a ser una de las mejores parejas de centrales del mundo, si los dos juegan al máximo nivel.
  • benzema9
    Hace 13 años benzema9 dice: Esta siendo un gran fichaje.Muy seguro atrás. Esta siendo un gran fichaje.Muy seguro atrás.
  • benzema9
    Hace 14 años benzema9 dice: Es un magnífico central.Es un magnífico central.
  • warnet
    Hace 14 años warnet dice: vino a demostrar porke el madrid lo compro...esperemos ke como defensa ayude a ganar partidosvino a demostrar porke el madrid lo compro...esperemos ke como defensa ayude a ganar partidos
  • warnet
    Hace 14 años warnet dice: vino a demostrar porke el madrid lo compro...esperemos ke como defensa ayude a ganar partidosvino a demostrar porke el madrid lo compro...esperemos ke como defensa ayude a ganar partidos
Uso de cookies: Utilizamos "cookies" propias y de terceros para mejorar nuestros servicios, elaborar información estadística, analizar sus hábitos de navegación e inferir grupos de interés. Esto nos permite personalizar el contenido que ofrecemos y mostrarle publicidad relacionada con sus preferencias. Adicionalmente, compartimos los análisis de navegación y los grupos de interés inferidos con terceros. Si continúa navegando acepta su uso. Más información y cambio de configuración. Aceptar

  USO DE MEMORIA  
5,357,472 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0014
Controller Execution Time ( Player / Index )  0.2521
Total Execution Time  0.2535
  CADENA URL  
/jugador/R-Albiol-7342
  GET DATOS  
$_GET['/jugador/R-Albiol-7342']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (37)  
0.0007   SELECT c.comment_id, COUNT(DISTINCT c.`id`) AS num FROM comments AS c WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id!=0 AND c.lang = '1' AND c.`playerId` = '7342' AND c.comment_id IN (1887827,1866604,1042131,864213,225004,225000,185522,142857,142854) GROUP BY c.comment_id
0.0111  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'R-Albiol-7342' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0035  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '7342'
0.0064  SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 72116 AND rp.teamId = 2716 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0056  SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 7342 ORDER BY rp.year DESC
0.0051  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '7342' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0038  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '7342' and rp.type = 3
0.0041  SELECT e.* FROM `events2024` e WHERE e.player_id = 7342 AND league_id = 72116 ORDER BY e.date ASC
0.0364  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 72116 AND rel.player_id=7342
0.0047  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 72116 AND action = 18
0.0041  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 72116 AND action = 19
0.0034  SELECT e.* FROM `events2024` e WHERE e.player_id = 7342 AND league_id = 71432 ORDER BY e.date ASC
0.0174  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71432 AND rel.player_id=7342
0.0035  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 71432 AND action = 18
0.0035  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 71432 AND action = 19
0.0035  SELECT e.* FROM `events2024` e WHERE e.player_id = 7342 AND league_id = 71759 ORDER BY e.date ASC
0.0103  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 71759 AND rel.player_id=7342
0.0034  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 71759 AND action = 18
0.0034  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 71759 AND action = 19
0.0036  SELECT e.* FROM `events2024` e WHERE e.player_id = 7342 AND league_id = 73876 ORDER BY e.date ASC
0.0038  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 73876 AND rel.player_id=7342
0.0036  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 73876 AND action = 18
0.0037  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 73876 AND action = 19
0.0038  SELECT e.* FROM `events2024` e WHERE e.player_id = 7342 AND league_id = 74791 ORDER BY e.date ASC
0.0053  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 74791 AND rel.player_id=7342
0.0035  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 74791 AND action = 18
0.0034  SELECT action,minute FROM events2024 WHERE player_id = 7342 AND league_id = 74791 AND action = 19
0.0040   SELECT c.comment,c.id,c.author_id,c.author_name,c.last_update,c.creation_date,c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, c.template, NOW() AS difference_time, fau.changeA AS changeA FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active` = 1 AND c.device = 'web' AND c.to_review=0 AND c.comment_id=0 AND c.lang = '1' AND c.language = 'es' AND c.`playerId` = '7342' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0036   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1887827' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0036   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1866604' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0037   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '1042131' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0036   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '864213' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0038   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '225004' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0037   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '225000' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0037   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '185522' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0037   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '142857' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0038   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '142854' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20