4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Mirandés - Real Zaragoza
Jornada 23
FINALIZADO
20
31
1097 Pts. Elo
19º

1644 Pts. Elo
4º

0-1
Sábado, 25 Enero 2014, 18:00
  • Asistencia: 4.920 espectadores
0 - 1
 66' Roger Martí

Eventos del partido

Goles

minuto 66'Roger MartíGol de Roger Martí

Tarjetas

minuto 55'AbrahamT. Amarilla Abraham
César CanedaT. Amarilla
César Caneda
minuto 62'
minuto 72'Diego RicoT. Amarilla Diego Rico
NagoreT. Amarilla
Nagore
minuto 74'
minuto 83'Abraham2a Amarilla y Roja Abraham

Cambios

minuto 46'BarkeroSale del partido Barkero
minuto 46'AbrahamEntra en el partido Abraham
minuto 58'Víctor RodríguezEntra en el partido Víctor Rodríguez
minuto 58'L. GarcíaSale del partido L. García
Díaz De CerioEntra en el partido
Díaz De Cerio
minuto 59'
GoiriaSale del partido
Goiria
minuto 59'
Ivan AgustinEntra en el partido
Ivan Agustin
minuto 64'
IriomeSale del partido
Iriome
minuto 64'
NagoreSale del partido
Nagore
minuto 78'
Juan MuñizEntra en el partido
Juan Muñiz
minuto 78'
minuto 85'CidonchaEntra en el partido Cidoncha
minuto 85'P. MontañésSale del partido P. Montañés

Otros

minuto 66'Víctor RodríguezAsistencia Víctor Rodríguez

Alineaciones

Mirandés

Mirandés

Alineación Inicial
Suplentes
Real Zaragoza

Real Zaragoza

4-4-2
Alineación Inicial
Suplentes

57 Comentarios + 32 respuestas
‹ Primero ... ... página 1 2 3 4 > ... Último ›
  • pachinmirandes
    Hace 10 años pachinmirandes dice: lo malo es que con casi nada han ganado tres puntos y digo casinada por no decir con nada, si con esto quire ascender lo tienen los maños muy dificil y regalo del arbitro
  • adrianmirandes
    Actualizado hace 10 años (Creado hace 10 años ) adrianmirandes dice: no me extraña que diga terrazas que se puede aspirara al play-off porqué viendo como juegan los equipos de allí arriba.... y vaya penalti es increíble
  • Hace 10 años luismaria dice: venga Mirandés venga, mientras haya puntos en juego hay que ir a por ellos,no hay que dormirse, hay que ir a por los próximos y los próximos, pero ya, hay están todos los puntos y se pueden ganar todos,y si no somos de los mejores tampoco tenemos porque descender, a luchar mucho mucho mucho y con cabeza. Saludos a los Mirandeses que en su momento han pasado por el Seminario S.José
  • estoesanduva
    Hace 10 años estoesanduva dice: Ha estado bien el histórico mirandés Zaragoza pero no ha podido ser. Venga que somos de segunda.PARA TODOS LOS MIRANDES YA SE PUEDE HACER EL CARTEL DE SAN JUAN DEL MONTE
  • estoesanduva
    Actualizado hace 10 años (Creado hace 10 años ) estoesanduva dice: Uno de los mejores, ivan malón lo da todo. Aupa malón y lo demás son tonterías. Viva la república independiente de miranda
  • paquirrin
    Hace 10 años paquirrin dice: Buen partido el que vimos ayer ....Buen ambiente , buen fútbol y un poco de mala suerte .....Desde que vino Terrazas se ve otra alegría en el equipo ...Ahora a preparar el traje de baño y a seguir luchando ..AUPA MIRANDES ....
  • mikkel
    Actualizado hace 10 años (Creado hace 10 años ) mikkel dice: Me parece muy injusto el resultado final. El Mirandés no ha merecido perder este partido. Siempre lo ha jugado con valentía y a dominado claramente al R.Zaragoza por momentos. Que injusto es el fútbol...
  • alavesitoj
    Actualizado hace 10 años (Creado hace 10 años ) alavesitoj dice: Animo MIRANDES.No siempre que se merece ganar ocurre,Así es el futbol.Mirad lo del Alaves hoy que se le ha aparecido la Virgen, otros partidos ha tenido peor suerte a pesar de haber merecido mejores resultados y en cambio hoy a sonado la flauta.ANIMO AFICION Y AUPA MIRANDES.
  • ircio
    Hace 10 años ircio dice: Hoy el Mirandes ha jugado bien dominando la mayoria del partido; se ha perdido por varios detalles que ha tenido el partido,Dani, el que otros dias nos ha dado puntos hoy nos ha quitado uno, se ha tragado un balon aparentemente facil de parar, tambien una decision incorecta de no dar un claro penalti, pues pese a no tener muy separada la mano lo que esta claro es que no deja pasar el balon en un a
  • alavesitoj
    Hace 10 años alavesitoj dice: Animo MIRANDES,a veces no siempre se gana a pesar de merecerlo , mira lo que le ha pasado hoy al Alaves, otros dias ha merecido mejor suerte y hoy se le ha aparecido la Virgen.ANIMO A LA AFICION y aupa MIRANDES
  • betimirandes
    Hace 10 años betimirandes dice: Lamentablemente no pude ver el partido por compromisos de amistad, pero por lo que aquí he leído el mirandés jugó razonablemente bien y con ocasiones, pero éstas no entraron, y, cosas del fútbol, de eso precisamente se trata.
    De nada sirve lamentarse, hay que marcar goles y no lo hacemos, el resto solo son disculpas.
    Ahora toca pensar en el siguiente partido y apoyar al equipo.
    Aup
  • george400
    Actualizado hace 10 años (Creado hace 10 años ) george400 dice: menudo robo.. resultado injusto :C
  • mikkel
    Hace 10 años mikkel dice: Final en Anduba...0-1
  • mikkel
    Hace 10 años mikkel dice: La tuvo a bocajarro el Mirandés y el balón se estrelló en el cuerpo del portero maño...
  • serenidad_blanca
    Actualizado hace 10 años (Creado hace 10 años ) serenidad_blanca dice: El Zaragoza es muy peligroso en las contras. ¿Ha sido de contra el gol?
‹ Primero ... ... página 1 2 3 4 > ... Último ›


  USO DE MEMORIA  
6,468,376 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.9374
Total Execution Time  0.9383
  CADENA URL  
/partido/Mirandes/Real-Zaragoza/2014
  GET DATOS  
$_GET['/partido/Mirandes/Real-Zaragoza/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (55)  
0.0029   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.`league_id` = '2434' AND c.`match_id` = '28160' AND c.comment_id IN (2437162,2433366,2435877,2435713,2434532,2434619,2432793,2433888,2434038,2433842,2433788,2432923,2432763,2432739,2432646) GROUP BY c.comment_id
0.0172   SELECT c.*, c.stadium as real_stadium, 2014 AS year, dt1.id AS dteam1_id, dt1.nameShow as team1_name, dt1.basealias AS team1_basealias, dt1.fullName as team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow as team2_name, dt2.basealias AS team2_basealias, dt2.fullName as team2_fullName, dt2.color1 AS team2_color1, t1.name as team1_Oname, t2.name as team2_Oname, s.id as stadium_id, rs.teamId as stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2014 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN futbol.rel_stadiums as rs ON rs.teamId=dt1.id AND rs.active=1 LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Mirandes' AND dt2.basealias = 'Real-Zaragoza'
0.0138  SELECT c.*, 2014 AS year, dt1.id AS dteam1_id, dt1.nameShow AS team1_name, dt1.basealias AS team1_basealias, dt1.fullName AS team1_fullName, dt1.color1 AS team1_color1, dt1.seats, dt1.size, dt1.yearBuilt, dt2.id AS dteam2_id, dt2.nameShow AS team2_name, dt2.basealias AS team2_basealias, dt2.fullName AS team2_fullName, dt2.color1 AS team2_color1, t1.name AS team1_Oname, t2.name AS team2_Oname, s.id AS stadium_id, dt1.id AS stadium_team_id, s.name AS stadium_name, s.size AS stadium_size, s.seats AS stadium_seats, s.yearBuilt AS stadium_yearBuilt, dt1.managerNow AS manager1, dt2.managerNow AS manager2 FROM calendars2014 AS c INNER JOIN teams AS t1 ON c.team1 = t1.id INNER JOIN datateams AS dt1 ON t1.teamId = dt1.id INNER JOIN teams AS t2 ON c.team2 = t2.id INNER JOIN datateams AS dt2 ON t2.teamId = dt2.id LEFT JOIN datastadiums AS s ON s.id = c.stadium WHERE c.extra != 1 AND dt1.basealias = 'Mirandes' AND dt2.basealias = 'Real-Zaragoza'
0.0126   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2014 AS ev WHERE ev.match_id=28160 ORDER BY (ev.action=1 OR ev.action=2 OR ev.action=6 OR ev.action=11 OR ev.action=12 OR ev.action=13) DESC,(ev.action=3 OR ev.action=4 OR ev.action=5) DESC,(ev.action=14 OR ev.action=15 OR ev.action=16 OR ev.action=17 OR ev.action=21) DESC,(ev.action=18 OR ev.action=19) DESC,(ev.action=20 OR ev.action=22) DESC, minute ASC, ev.real_date ASC, ev.id DESC, ev.action DESC
0.0129   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=2434 WHERE dp.id IN (58724,36140,67747,137176,7451,10861,35921,23364,29978,23552,67749,29281,107446,36810,28147) AND (rp.team_id=51110 OR rp.team_id=51105)
0.0125   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2014 AS ev WHERE ev.match_id=28160 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0128   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=2434 WHERE dp.id IN (10861,36140,35921,23364,29978,23552,67747,67749,29281,58724,137176,7451,107446,36810,28147) AND (rp.team_id=51110 OR rp.team_id=51105)
0.0125  SELECT data1 FROM stats2014 t WHERE league_id = 2434 AND teamId = 51110 and type = 33
0.0125  SELECT data1 FROM stats2014 t WHERE league_id = 2434 AND teamId = 51105 and type = 33
0.0126  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 2434 AND id_match = 28160
0.0132  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='2434' AND relp.team_id = drea.team_id WHERE rel.team_number=2436197 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0128  SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='2434' AND relp.team_id = drea.team_id WHERE rel.team_number=2436195 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0164  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='2434' AND relp.team_id=51110 WHERE mp.`match_id` = '28160' AND mp.year='2014' AND p.id NOT IN (28115,34338,23400,137176,23510,16724,71820,23364,10861,58724,28147,52028,99856,67747,40798,31691,67751,7451,30846,29281,23552,99870) ORDER BY mp.`team` ASC, p.`role` ASC
0.0187  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='2434' AND relp.team_id=51105 WHERE mp.`match_id` = '28160' AND mp.year='2014' AND p.id NOT IN (28115,34338,23400,137176,23510,16724,71820,23364,10861,58724,28147,52028,99856,67747,40798,31691,67751,7451,30846,29281,23552,99870) ORDER BY mp.`team` ASC, p.`role` ASC
0.0126  SELECT kit FROM kit_data_real WHERE league_id = 2434 AND id_match = 28160
0.0127  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '28160' and rp.type = 2014 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0128  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '28160' and rp.type = 2014 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0131  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='10' AND rel.active = 1 AND rel.league_id = 2434 AND rel.team1 = 51110 AND rel.team2 = 51105 ORDER BY FIELD(m.location,'es','en') DESC
0.0128  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 28160 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 28160 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0138  SELECT *,rel.id as rel_id FROM `rel_media_match` rel LEFT JOIN media m ON m.id = rel.media_id WHERE m.type='11' AND rel.active = 1 AND rel.league_id = 2434 AND rel.team1 = 51110 AND rel.team2 = 51105 ORDER BY FIELD(m.location,'es','en') DESC
0.0136  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 2434 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0147  SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2, c.shedule,c.id, c.r1, c.r2, c.round, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2,c.comments,c.league_id FROM `calendars2014` as c INNER JOIN teams t1 ON t1.id = c.team1 AND t1.league_id = c.league_id INNER JOIN teams t2 ON t2.id = c.team2 AND t2.league_id = c.league_id INNER JOIN datateams as dt1 ON dt1.id = t1.teamId INNER JOIN datateams as dt2 ON dt2.id = t2.teamId WHERE c.`league_id` = 2434 AND c.`round` = 23 ORDER BY shedule ASC LIMIT 12
0.0146  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2434 AND t.round = 23 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0132  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2014` WHERE league_id = 2434 AND round >= 42 AND round <= 42 AND team = 51110 ORDER BY round ASC
0.0131  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2014` as t INNER JOIN teams as team ON team.id = t.team INNER JOIN datateams as dt ON team.teamId = dt.id WHERE t.league_id = 2434 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0137   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.`league_id` = '2434' AND c.`match_id` = '28160' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0127   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 = '2437162' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '2433366' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '2435877' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '2435713' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0135   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 = '2434532' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0138   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 = '2434619' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0135   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 = '2432793' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0131   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 = '2433888' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0131   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 = '2434038' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0134   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 = '2433842' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0133   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 = '2433788' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0135   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 = '2432923' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0135   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 = '2432763' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '2432739' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '2432646' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0142  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2014 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2014 and r.role=1 INNER JOIN datareferees dr on dr.id=r.referee_id INNER JOIN rel_calendars_referee as r2 ON c.id = r2.match_id and r2.year=2014 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 51110 AND c.team2 = 51105 AND c.league_id = 2434
0.0129  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='28160' AND `active` = 1 AND year = 2014
0.0128  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='28160' AND `active` = 1 AND year = 2014
0.0345  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='2434' AND relp.team_id=51110 WHERE relp.in_squad=1 and mp.`match_id` = '28160' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0391  SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias, relp.squadNumber as num, p.CountryCode FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id` INNER JOIN rel_players AS relp ON relp.player_id=p.id AND relp.league_id='2434' AND relp.team_id=51105 WHERE relp.in_squad=1 and mp.`match_id` = '28160' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0130  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '2434' AND id_match = '28160'
0.0129   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '2436197' ORDER BY rating DESC LIMIT 1
0.0130   SELECT rel.*, dp.name, dp.nick, dp.last_name, dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dataplayers dp ON dp.id = rel.player_id WHERE rel.team_number = '2436195' ORDER BY rating DESC LIMIT 1
0.0128  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=28160 AND extraId = 2434 AND type_rel = 4
0.0128  SELECT rating1, rating2 FROM calendars_elo WHERE id=28160 AND league_id=2434 AND year=2014
0.0128  SELECT position FROM tables2014 WHERE team=51110 AND league_id=2434 AND round=23
0.0128  SELECT position FROM tables2014 WHERE team=51105 AND league_id=2434 AND round=23
0.0128  SELECT * FROM futbol.calendars_lineups WHERE id = 28160 AND league_id = 2434 AND year = 2014