4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Murcia - CD Lugo
Cuartos
FINALIZADO
20
30
1022 Pts. Elo

685 Pts. Elo

2-0
Domingo, 22 Mayo 2011, 20:30
Chando 48'
1 - 0
Isaac 64'
2 - 0

Eventos del partido

Goles

ChandoGol de
Chando
minuto 48'
IsaacGol de
Isaac
minuto 64'

Tarjetas

minuto 27'C. PitaT. Amarilla C. Pita
RichiT. Amarilla
Richi
minuto 33'
minuto 63'M. RodríguezT. Amarilla M. Rodríguez
Óscar SánchezT. Amarilla
Óscar Sánchez
minuto 70'
minuto 71'CristóbalT. Amarilla Cristóbal

Cambios

IsaacEntra en el partido
Isaac
minuto 39'
Miguel AlbiolSale del partido
Miguel Albiol
minuto 39'
minuto 65'Iván GonzálezSale del partido Iván González
minuto 65'TorneroEntra en el partido Tornero
Kike GarcíaSale del partido
Kike García
minuto 76'
Dani AquinoEntra en el partido
Dani Aquino
minuto 76'
minuto 78'Claudio MontiSale del partido Claudio Monti
minuto 78'Yago GonzálezEntra en el partido Yago González
J. AguileraSale del partido
J. Aguilera
minuto 86'
CámaraEntra en el partido
Cámara
minuto 86'

Alineaciones

Real Murcia

Real Murcia

4-4-2
Alineación Inicial
Suplentes
CD Lugo

CD Lugo

4-4-2
Alineación Inicial
Suplentes

Estadísticas del partido

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: comment/main_view.php

Line Number: 2065

Real Murcia Real Murcia CD Lugo CD Lugo
250 Comentarios + 107 respuestas
‹ Primero ... ... página 1 2 3 4 5 6 7 ... 16 17 > ... Último ›
  • Hace 10 años xxmurciaxx dice: Voy a seguir este partido en resultados-Futbol.com:

    ""
  • this
    Hace 12 años this dice: felicidades al murcia por el ascenso.felicidades al murcia por el ascenso.
  • aficionlorca
    Hace 12 años aficionlorca dice: Gol del Lugo, esto se pone calentitoGol del Lugo, esto se pone calentito
  • Actualizado hace 12 años (Creado hace 12 años ) pepiko_gr dice: Tengo muchos amigos del Real Murcia así que mi corazón está con ellos y mi deseo de que asciendan a Segunda de forma directa tras esta eliminatoria. ARRIBA ESOS PIMENTONEROS!!!!!!!!! Muchísma suerte!!!!!!! 2-0 en La Condomina!! Tengo muchos amigos del Real Murcia así que mi corazón está con ellos y mi deseo de que asciendan a Segunda de forma directa tras esta eliminatoria. ARRIBA ESOS PIMENTONEROS!!!!!!!!! Muchísma suerte!!!!!!! 2-0 en La Condomina!!
  • vivaasturias
    Hace 12 años vivaasturias dice: pasa el murcia animommurciapasa el murcia animommurcia
  • josiito
    Actualizado hace 12 años (Creado hace 12 años ) josiito dice: Acabo de llegar de murcia, balance... pues primera parte bastante buena, controlamos al murcia perfectamente, pero la segunda no se que pasó, parecian todos cansados, no llegaban a un balón, pero bueno, en el Anxo Carro se puede dar la sorpresa, como dicen varios del murcia por lo que lei asi por encima aun no está acabado. Sobre la afición del Murcia, toda muy correcta, excepto los descerebrados Acabo de llegar de murcia, balance... pues primera parte bastante buena, controlamos al murcia perfectamente, pero la segunda no se que pasó, parecian todos cansados, no llegaban a un balón, pero bueno, en el Anxo Carro se puede dar la sorpresa, como dicen varios del murcia por lo que lei asi por encima aun no está acabado. Sobre la afición del Murcia, toda muy correcta, excepto los descerebrados
  • Hace 12 años pompero dice: lugo remontaralugo remontara
  • Hace 12 años miguel72cf dice: vamos murcia a segunda y el año que viene ojala subais a primera vamos murcia a segunda y el año que viene ojala subais a primera
  • rmurcia1908
    Hace 12 años rmurcia1908 dice: me gusta tu comentario josiito, eres totalmente sincero. respecto a nuestra aficion has dicho una gran verdad, fuimos respetuosos y somos buena gente pero en todos sitios hay energúmenos. espero ver a murcia y lugo los dos en segunda aunque uno de los dos tenga que hacerlo por el camino mas largo, un saludo me gusta tu comentario josiito, eres totalmente sincero. respecto a nuestra aficion has dicho una gran verdad, fuimos respetuosos y somos buena gente pero en todos sitios hay energúmenos. espero ver a murcia y lugo los dos en segunda aunque uno de los dos tenga que hacerlo por el camino mas largo, un saludo
  • pericoraul
    Hace 12 años pericoraul dice: buen partido ayer del murcia y espectacular jugada en el segundo gol espectacular!!! tiki taka buen partido ayer del murcia y espectacular jugada en el segundo gol espectacular!!! tiki taka
  • papillon88
    Actualizado hace 12 años (Creado hace 12 años ) papillon88 dice: bueno ahora a escuchar a setien quejarse del campo bueno ahora a escuchar a setien quejarse del campo
  • Hace 12 años jonanro dice: vamos lugo ke murcia nos roba el aguaa xD vamos lugo ke murcia nos roba el aguaa xD
  • elcok
    Hace 12 años elcok dice: pese a quien le pese el murcia izo ayer un buen partido,nada del otro mundo,pero se notaba que jugaba contra un equipo muy inferior,aunque todavia queda un partido,la aficion murciana espectacular y lo de acer la ola me parecio un poco pronto pese a quien le pese el murcia izo ayer un buen partido,nada del otro mundo,pero se notaba que jugaba contra un equipo muy inferior,aunque todavia queda un partido,la aficion murciana espectacular y lo de acer la ola me parecio un poco pronto
  • Antelo-Nieto7
    Hace 12 años Antelo-Nieto7 dice: Lugo te quiero ver en Segunda para ver un derbi contra el Depor. Lugo te quiero ver en Segunda para ver un derbi contra el Depor.
  • luis_xiv
    Actualizado hace 12 años (Creado hace 12 años ) luis_xiv dice: el barcenola de que? resumo el partido en decepcion, crei que encontraria a un lugo peleon, crei que atacaria, que me sorprenderian sus cambios de banda, que crearia ocasiones, y que seria un equipo digno, pero para nada, lamento que un equipo que queria ganar perdiera tiempo desde el minuto 1, lamento que el arbitro no parara al calvo que machaco sin limite, el partido a sido solo un 2-0 aunque el barcenola de que? resumo el partido en decepcion, crei que encontraria a un lugo peleon, crei que atacaria, que me sorprenderian sus cambios de banda, que crearia ocasiones, y que seria un equipo digno, pero para nada, lamento que un equipo que queria ganar perdiera tiempo desde el minuto 1, lamento que el arbitro no parara al calvo que machaco sin limite, el partido a sido solo un 2-0 aunque
‹ Primero ... ... página 1 2 3 4 5 6 7 ... 16 17 > ... Último ›

Partido televisado en...
Canal Medio Idioma País
TVG TV Castellano
7 R Murcia TV Castellano

  USO DE MEMORIA  
6,368,032 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2957
Total Execution Time  0.2968
  CADENA URL  
/partido/Real-Murcia/Lugo/2011
  GET DATOS  
$_GET['/partido/Real-Murcia/Lugo/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0041   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` = '1307' AND c.`match_id` = '101779' AND c.comment_id IN (2091454,954735,945839,927210,939865,936840,938157,938127,937891,937295,936277,937184,937182,937149,936506) GROUP BY c.comment_id
0.0073   SELECT c.*, c.stadium as real_stadium, 2011 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 calendars2011 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 = 'Real-Murcia' AND dt2.basealias = 'Lugo'
0.0046  SELECT c.*, 2011 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 calendars2011 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 = 'Real-Murcia' AND dt2.basealias = 'Lugo'
0.0041  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 = 1307
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2011 AS ev WHERE ev.match_id=101779 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.0024   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=1307 WHERE dp.id IN (28149,23939,34176,30468,31181,23370,31174,27279,30937,116810,27930,27469,88798,147787,35422,34300) AND (rp.team_id=28624 OR rp.team_id=28625)
0.0021   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2011 AS ev WHERE ev.match_id=101779 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0025   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=1307 WHERE dp.id IN (34176,30468,23939,27279,28149,31181,30937,116810,23370,31174,27930,27469,88798,147787,35422,34300) AND (rp.team_id=28624 OR rp.team_id=28625)
0.0018  SELECT data1 FROM stats2011 t WHERE league_id = 1307 AND teamId = 28624 and type = 33
0.0020  SELECT data1 FROM stats2011 t WHERE league_id = 1307 AND teamId = 28625 and type = 33
0.0019  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 1307 AND id_match = 101779
0.0023  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='1307' AND relp.team_id = drea.team_id WHERE rel.team_number=1572792 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0022  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='1307' AND relp.team_id = drea.team_id WHERE rel.team_number=1572793 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0027  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='1307' AND relp.team_id=28624 WHERE mp.`match_id` = '101779' AND mp.year='2011' AND p.id NOT IN (11103,23370,72565,35669,31140,27279,30468,35422,36190,27930,28149,31162,43426,77873,31180,31174,34176,31181,88798,31186,27185,30937) ORDER BY mp.`team` ASC, p.`role` ASC
0.0024  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='1307' AND relp.team_id=28625 WHERE mp.`match_id` = '101779' AND mp.year='2011' AND p.id NOT IN (11103,23370,72565,35669,31140,27279,30468,35422,36190,27930,28149,31162,43426,77873,31180,31174,34176,31181,88798,31186,27185,30937) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT kit FROM kit_data_real WHERE league_id = 1307 AND id_match = 101779
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '101779' and rp.type = 2011 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '101779' and rp.type = 2011 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  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 = 1307 AND rel.team1 = 28624 AND rel.team2 = 28625 ORDER BY FIELD(m.location,'es','en') DESC
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 101779 AND year = 2011 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 101779 AND year = 2011 AND channel = 'Footters' LIMIT 1
0.0023  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 = 1307 AND rel.team1 = 28624 AND rel.team2 = 28625 ORDER BY FIELD(m.location,'es','en') DESC
0.0020  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 = 1307 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0019  SELECT teamId FROM teams WHERE id = 28625
0.0018  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2011 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2011 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 1598 OR c.datateam2 = 1598) ORDER BY shedule DESC LIMIT 10
0.0026  SELECT teamId FROM teams WHERE id = 28625
0.0020  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2011 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2011 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 1598 OR c.datateam2 = 1598) ORDER BY shedule ASC LIMIT 10
0.0019  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 `calendars2011` 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` = 1307 AND c.`round` = 1 ORDER BY c.type ASC,((c.team1*c.team1)+(c.team2*c.team2)) ASC,shedule ASC LIMIT 12
0.0038  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2011` WHERE league_id = 1307 AND round >= 3 AND round <= 3 AND team = 28624 ORDER BY round ASC
0.0019  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 `tables2011` 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 = 1307 AND t.round = 3 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020   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` = '1307' AND c.`match_id` = '101779' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
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 = '2091454' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   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 = '954735' 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 = '945839' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0024   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 = '927210' 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 = '939865' 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 = '936840' 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 = '938157' 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 = '938127' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   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 = '937891' 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 = '937295' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   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 = '936277' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0021   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 = '937184' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0025   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 = '937182' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0065   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 = '937149' 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 = '936506' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0017  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2011 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2011 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=2011 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 28624 AND c.team2 = 28625 AND c.league_id = 1307
0.0036  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='101779' AND `active` = 1 AND year = 2011
0.0048  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='101779' AND `active` = 1 AND year = 2011
0.0019  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='1307' AND relp.team_id=28624 WHERE relp.in_squad=1 and mp.`match_id` = '101779' AND mp.year='2011' ORDER BY mp.`team` ASC, p.`role` ASC
0.0020  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='1307' AND relp.team_id=28625 WHERE relp.in_squad=1 and mp.`match_id` = '101779' AND mp.year='2011' ORDER BY mp.`team` ASC, p.`role` ASC
0.0018  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '1307' AND id_match = '101779'
0.0017   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 = '1572792' ORDER BY rating DESC LIMIT 1
0.0018   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 = '1572793' ORDER BY rating DESC LIMIT 1
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=101779 AND extraId = 1307 AND type_rel = 4
0.0019  SELECT rating1, rating2 FROM calendars_elo WHERE id=101779 AND league_id=1307 AND year=2011
0.0018  SELECT position FROM tables2011 WHERE team=28624 AND league_id=1307 AND round=1
0.0018  SELECT position FROM tables2011 WHERE team=28625 AND league_id=1307 AND round=1
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 101779 AND league_id = 1307 AND year = 2011