4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Murcia - Recreativo
Jornada 1
FINALIZADO
50
51
1085 Pts. Elo
15º

1354 Pts. Elo
8º

2-3
Domingo, 18 Agosto 2013, 21:00
  • Asistencia: 6.232 espectadores
0 - 1
 44' Linares
0 - 2
 49' Linares
Kike García 54'
1 - 2
Acciari 76'
2 - 2
2 - 3
 87' J. Larena

Eventos del partido

Goles

minuto 44'LinaresGol de Linares
minuto 49'LinaresGol de Linares
Kike GarcíaGol de
Kike García
minuto 54'
AcciariGol de
Acciari
minuto 76'
minuto 87'J. LarenaGol de falta J. Larena

Tarjetas

Dani BautistaT. Amarilla
Dani Bautista
minuto 13'
AcciariT. Amarilla
Acciari
minuto 24'
CastoT. Amarilla
Casto
minuto 32'
minuto 34'MorcilloT. Amarilla Morcillo
minuto 40'CórcolesT. Amarilla Córcoles
minuto 61'ZamoraT. Amarilla Zamora
minuto 66'LinaresT. Amarilla Linares
minuto 71'RuymánTarjeta Roja a Ruymán
W. SilvaT. Amarilla
W. Silva
minuto 80'
minuto 81'J. LarenaT. Amarilla J. Larena
MolineroT. Amarilla
Molinero
minuto 86'

Cambios

Iván MorenoEntra en el partido
Iván Moreno
minuto 53'
Eddy SilvestreSale del partido
Eddy Silvestre
minuto 53'
minuto 65'J. LarenaEntra en el partido J. Larena
minuto 65'AranaSale del partido Arana
W. SilvaEntra en el partido
W. Silva
minuto 67'
Saúl BerjónSale del partido
Saúl Berjón
minuto 67'
minuto 70'ZamoraSale del partido Zamora
minuto 70'Fernando VegaEntra en el partido Fernando Vega
minuto 77'J. ValleEntra en el partido J. Valle
minuto 77'LinaresSale del partido Linares

Otros

minuto 44'CórcolesAsistencia Córcoles
minuto 49'Ángel MontoroAsistencia Ángel Montoro
A. DorcaAsistencia
A. Dorca
minuto 54'
MauroAsistencia
Mauro
minuto 76'

Alineaciones

Real Murcia

Real Murcia

4-3-3
Alineación Inicial
Suplentes
Recreativo

Recreativo

4-5-1
Alineación Inicial
Suplentes

809 Comentarios + 1201 respuestas
‹ Primero ... ... página 1 2 3 4 5 6 7 ... 53 54 > ... Último ›
  • Actualizado hace 10 años (Creado hace 10 años ) granasur dice: Lo mas probable esque se pierda en Malloca, porque, porque el Real Murcia esta todavia de pretemporada, faltan jugadores, la mayoria acaban de llegar, se estan adaptando, hasta la jornafda 6 o 7 o un poquito antes, el Real Murcia no va a demostrar su verdadero potencial
  • Actualizado hace 10 años (Creado hace 10 años ) goraeh dice: me alegro ke aya perdido el murcia se lo merece
  • Antbull
    Actualizado hace 10 años (Creado hace 10 años ) Antbull dice: No entiendo como se puede decir que el R. Murcia es tramposo. Soy grana desde que nací y seguiré siéndolo, y soy el primero en decir que por sus méritos el año pasado el R. Murcia sería equipo de 2ªB, pero al quedar cuarto por la cola y la LFP descender al Guadalajara nos hicieron el gran favor de quedarnos otro año más en la Categoria donde más veces hemos estado.
    El R.Murcia no es culpable
  • Actualizado hace 10 años (Creado hace 10 años ) Marclleida dice: Grande recre ganando a un equipo que el año pasado descendió a la segunda b
  • peperm97
    Actualizado hace 10 años (Creado hace 10 años ) peperm97 dice: El Murcia se va al hoyo, menuda plantilla mas mala.
  • deportivisimo
    Actualizado hace 10 años (Creado hace 10 años ) deportivisimo dice: Siempre es el mismo cuento con el Murcia , parece que promete siempre y nunca hace nada
  • guasch
    Hace 10 años guasch dice: Sin novedad. Es normal que un equipo de Segunda B pierda ante un Segunda.
  • Hace 10 años granasur dice: Yo creo que cuando e acople ele quipo y lleguen los 2 fichajes o 3 si da tiempo y se acople, vamos a disfrutar
  • luis_xiv
    Actualizado hace 10 años (Creado hace 10 años ) luis_xiv dice: El aplauso al recre, tímido, y solo por una parte del foco de animación, prácticamente nadie se dio cuenta. Me alegro.

    Por otra parte, Casto os devolvió el favor por ayudarnos a la permanencia.
  • colchonero
    Actualizado hace 10 años (Creado hace 10 años ) colchonero dice: finallllllllllllllllll,l a condomina campo talisman
  • colchonero
    Actualizado hace 10 años (Creado hace 10 años ) colchonero dice: viendo las puntuaciones de los jugadores parece ke ganó el murcia,jeje
  • Actualizado hace 10 años (Creado hace 10 años ) xxmurciaxx dice: Este partido lo ganamos 2 - 0 goles Kike x2
  • luis_xiv
    Actualizado hace 10 años (Creado hace 10 años ) luis_xiv dice: El primer gol de Linares si es fuera de juego, bastante claro. Ahora el de Acciari, que yo no celebre de golpe porque pensaba que era anulado, también lo parece, pero justo.... falta una cámara decente pues es cosa de centimetros.
  • luis_xiv
    Actualizado hace 10 años (Creado hace 10 años ) luis_xiv dice: Casto es mal portero, no me gustaba antes, y ahora menos, recordando a Elia, terrible con los pies, no se impone por arriba, protestón y tirándose todo el partido gesticulando, creo que ha venido con la idea de hacerse notar, se equivoca, aquí se le pide trabajo no espectáculo.

    Ahora la presa le quita hierro, pero los 3 goles tiene parte de culpa, en el primero pese al fuera de juego, q
  • Hace 10 años granasur dice: Dani Bautista: "La afición está orgullosa con nuestra entrega"

    Kike García: “El equipo ha tirado de casta”

    Kike García, jugador del Real Murcia, afirmó que el equipo grana apeló a la casta a pesar del cúmulo de despropósitos: “Después del golpe del primer gol antes del descanso, que ha sido un disparate de gol por los rechaces, hemos tirado de casta. Hemos empujado, hemos te
‹ Primero ... ... página 1 2 3 4 5 6 7 ... 53 54 > ... Último ›


  USO DE MEMORIA  
7,025,904 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  1.0240
Total Execution Time  1.0251
  CADENA URL  
/partido/Real-Murcia/Recreativo/2014
  GET DATOS  
$_GET['/partido/Real-Murcia/Recreativo/2014']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (54)  
0.0036   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` = '44608' AND c.comment_id IN (2162478,2164195,2163362,2161398,2162906,2162826,2162840,2162283,2161076,2160252,2161950,2137211,2161458,2161068,2161404) GROUP BY c.comment_id
0.0173   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 = 'Real-Murcia' AND dt2.basealias = 'Recreativo'
0.0151  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 = 'Real-Murcia' AND dt2.basealias = 'Recreativo'
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=44608 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.0130   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 (27956,27930,61593,27431,29228,23325,30629,7205,28935,74760,89906,29351,34177,103289,23662,30716,23331,28078,27456,27383,54442) AND (rp.team_id=53480 OR rp.team_id=51114)
0.0129   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=44608 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0131   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 (29228,61593,23325,30629,7205,27956,27456,34177,103289,27383,27930,28935,27431,23662,89906,30716,23331,74760,54442,28078,29351) AND (rp.team_id=53480 OR rp.team_id=51114)
0.0125  SELECT data1 FROM stats2014 t WHERE league_id = 2434 AND teamId = 53480 and type = 33
0.0126  SELECT data1 FROM stats2014 t WHERE league_id = 2434 AND teamId = 51114 and type = 33
0.0126  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 2434 AND id_match = 44608
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=2434534 GROUP BY dp.id ORDER BY role ASC, pos ASC
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=2434533 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0149  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=53480 WHERE mp.`match_id` = '44608' AND mp.year='2014' AND p.id NOT IN (27458,74760,28935,30629,7205,27456,23549,23412,23662,229244,27956,23325,54442,23370,29228,29351,61593,103289,27383,36715,27930,30716) ORDER BY mp.`team` ASC, p.`role` ASC
0.0431  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=51114 WHERE mp.`match_id` = '44608' AND mp.year='2014' AND p.id NOT IN (27458,74760,28935,30629,7205,27456,23549,23412,23662,229244,27956,23325,54442,23370,29228,29351,61593,103289,27383,36715,27930,30716) ORDER BY mp.`team` ASC, p.`role` ASC
0.0126  SELECT kit FROM kit_data_real WHERE league_id = 2434 AND id_match = 44608
0.0126  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '44608' and rp.type = 2014 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0126  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '44608' and rp.type = 2014 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0127  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 = 53480 AND rel.team2 = 51114 ORDER BY FIELD(m.location,'es','en') DESC
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 44608 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0125  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 44608 AND year = 2014 AND channel = 'Footters' LIMIT 1
0.0127  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 = 53480 AND rel.team2 = 51114 ORDER BY FIELD(m.location,'es','en') DESC
0.0130  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` = 1 ORDER BY shedule ASC LIMIT 12
0.0134  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 = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0127  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 = 53480 ORDER BY round ASC
0.0270  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.0221   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` = '44608' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
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 = '2162478' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0129   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 = '2164195' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
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 = '2163362' 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 = '2161398' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0136   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 = '2162906' 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 = '2162826' 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 = '2162840' 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 = '2162283' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0132   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 = '2161076' 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 = '2160252' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0129   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 = '2161950' 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 = '2137211' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
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 = '2161458' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
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 = '2161068' 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 = '2161404' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130  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 = 53480 AND c.team2 = 51114 AND c.league_id = 2434
0.0127  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='44608' AND `active` = 1 AND year = 2014
0.0131  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='44608' AND `active` = 1 AND year = 2014
0.0161  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=53480 WHERE relp.in_squad=1 and mp.`match_id` = '44608' AND mp.year='2014' ORDER BY mp.`team` ASC, p.`role` ASC
0.0435  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=51114 WHERE relp.in_squad=1 and mp.`match_id` = '44608' 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 = '44608'
0.0127   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 = '2434534' ORDER BY rating DESC LIMIT 1
0.0127   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 = '2434533' ORDER BY rating DESC LIMIT 1
0.0125  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=44608 AND extraId = 2434 AND type_rel = 4
0.0126  SELECT rating1, rating2 FROM calendars_elo WHERE id=44608 AND league_id=2434 AND year=2014
0.0126  SELECT position FROM tables2014 WHERE team=53480 AND league_id=2434 AND round=1
0.0126  SELECT position FROM tables2014 WHERE team=51114 AND league_id=2434 AND round=1
0.0126  SELECT * FROM futbol.calendars_lineups WHERE id = 44608 AND league_id = 2434 AND year = 2014