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

M. Stoch

Jugador del Twente
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de M. Stoch
Nacionalidad
Eslovaquia
Nombre
Miroslav Stoch
Edad
34 Años (19-10-1989)
Altura
168
Dorsal
15
Peso
60 kilogramos
Equipo
Twente
Posición
Delantero
Liga
Eredivisie 2010
  • Jugador del Twente desde hace 14 años
    • Compañeros de equipo
    Fotos
    9
    • Foto principal de M. Stoch | Slovan Liberec
    • Foto principal de M. Stoch | Slavia Praha
    • Foto principal de M. Stoch | Fenerbahçe
    • Foto principal de M. Stoch | Eslovaquia
    • Foto principal de M. Stoch | Bursaspor
    • Foto principal de M. Stoch | PAOK
    • M. Stoch
    • M. Stoch
    • Miroslav Stoch
    2 Comentarios
    • benzema9
      Hace 14 años benzema9 dice: esta siendo una de las revelaciones de la Eredivisie.esta siendo una de las revelaciones de la Eredivisie.
    • pablomg
      Hace 14 años pablomg dice: un gran futuro tiene este jugador por delante ojala sea uno de los grands de europa algun diaun gran futuro tiene este jugador por delante ojala sea uno de los grands de europa algun dia

      USO DE MEMORIA  
    5,866,024 bytes
      BENCHMARKS  
    Loading Time Base Classes  0.0012
    Controller Execution Time ( Player / Index )  0.2043
    Total Execution Time  0.2055
      CADENA URL  
    /jugador/2010/M-Stoch-29878
      GET DATOS  
    $_GET['/jugador/2010/M-Stoch-29878']  
      POST DATOS  
    No hay datos POST existentes
      CONSULTAS (59)  
    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` = '29878' AND c.comment_id IN (137960,64963) GROUP BY c.comment_id
    0.0077  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 = 2010 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 = 'M-Stoch-29878' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
    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 = 817
    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 = 894
    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 = 962
    0.0027  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 = 976
    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 = 989
    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 = 1078
    0.0023  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 = 20638
    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 = 39416
    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 = 42906
    0.0018  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 = '29878'
    0.0036  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 = 817 AND rp.teamId = 1112 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
    0.0036  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 = 29878 ORDER BY rp.year DESC
    0.0026  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 = '29878' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
    0.0018  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '29878' and rp.type = 3
    0.0021  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 817 ORDER BY e.date ASC
    0.0089  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 817 AND rel.player_id=29878
    0.0022  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 817 AND action = 18
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 817 AND action = 19
    0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 894 ORDER BY e.date ASC
    0.0121  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 894 AND rel.player_id=29878
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 894 AND action = 18
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 894 AND action = 19
    0.0022  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 962 ORDER BY e.date ASC
    0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 962 AND rel.player_id=29878
    0.0028  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 962 AND action = 18
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 962 AND action = 19
    0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 976 ORDER BY e.date ASC
    0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 976 AND rel.player_id=29878
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 976 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 976 AND action = 19
    0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 989 ORDER BY e.date ASC
    0.0070  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 989 AND rel.player_id=29878
    0.0021  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 989 AND action = 18
    0.0019  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 989 AND action = 19
    0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 1078 ORDER BY e.date ASC
    0.0021  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1078 AND rel.player_id=29878
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 1078 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 1078 AND action = 19
    0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 20638 ORDER BY e.date ASC
    0.0069  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 20638 AND rel.player_id=29878
    0.0021  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 20638 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 20638 AND action = 19
    0.0018  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 39416 ORDER BY e.date ASC
    0.0068  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 39416 AND rel.player_id=29878
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 39416 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 39416 AND action = 19
    0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 42851 ORDER BY e.date ASC
    0.0028  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42851 AND rel.player_id=29878
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 42851 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 42851 AND action = 19
    0.0019  SELECT e.* FROM `events2010` e WHERE e.player_id = 29878 AND league_id = 42906 ORDER BY e.date ASC
    0.0064  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 42906 AND rel.player_id=29878
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 42906 AND action = 18
    0.0018  SELECT action,minute FROM events2010 WHERE player_id = 29878 AND league_id = 42906 AND action = 19
    0.0021   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` = '29878' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
    0.0020   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 = '137960' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
    0.0019   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 = '64963' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20