4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Granada - RC Deportivo
FINALIZADO
10
30
1838 Pts. Elo

2022 Pts. Elo
17º

2-1
Sábado, 23 Agosto 2014, 21:00
  • Asistencia: 14.800 espectadores
0 - 1
20' Ivan Cavaleiro
Ruben Rochina 55'
1 - 1
J. Babin 77'
2 - 1

Eventos del partido

Goles

minuto 20'ArrayGol de Ivan Cavaleiro
ArrayGol de
Ruben Rochina
minuto 55'
ArrayGol de
J. Babin
minuto 77'

Tarjetas

minuto 41'ArrayT. Amarilla Luisinho
minuto 56'ArrayT. Amarilla A. Lopo
ArrayT. Amarilla
Y. El-Arabi
minuto 66'
minuto 76'ArrayT. Amarilla José Rodriguez

Cambios

ArrayEntra en el partido
Iturra
minuto 45'
ArraySale del partido
Héctor Yuste
minuto 45'
ArrayEntra en el partido
Alfredo Ortuño
minuto 45'
ArraySale del partido
Juankar
minuto 45'
minuto 58'ArrayEntra en el partido H. Medunjanin
minuto 58'ArraySale del partido Luisinho
minuto 66'ArrayEntra en el partido I. Cuenca
minuto 66'ArraySale del partido Toché
ArrayEntra en el partido
D. Foulquier
minuto 82'
ArraySale del partido
Ruben Rochina
minuto 82'
minuto 85'ArrayEntra en el partido Álex Bergantiños
minuto 85'ArraySale del partido José Rodriguez

Otros

ArrayAsistencia
Alfredo Ortuño
minuto 55'
ArrayAsistencia
Fran Rico
minuto 77'
59 Comentarios + 53 respuestas
‹ Primero ... ... página 1 2 3 4 > ... Último ›
  • christiian3
    Hace 9 años christiian3 dice: VAMOS GRANADA!!! A callar unas cuantas bocas...
  • Actualizado hace 9 años (Creado hace 9 años ) alba4depor dice: Comenzamos una nueva temporada con caras nuevas, un equipo aún por cerrarse y con mucha ilusión. Espero que este año logremos alcanzar nuestro objetivo principal y nos dejen unos añitos sin este sufrimiento aunque si es por ti Depor, se sufre lo que haga falta. Mucha suerte a todos mis compañeros deportivistas para este año, espero que no tengan que renovarnos el marcapasos. Ojalá veamos buen fútbol por ambas partes. Forza!
  • dieguikp
    Hace 9 años dieguikp dice: Serio partido de un Granada que supo darle la vuelta al marcador. Gran partido de Rochina y otra vez decir que Joaquín Caparrós es un gran entrenador, sabe siempre motivar a los jugadores y hacer que sean eficaces. Me gustó mucho el intento de mover la pelota aunque todavía falta mucho rodaje.
  • Actualizado hace 9 años (Creado hace 9 años ) franciscooooo dice: Va , por mi amigo YULTRE la primera victoria GRANAINA . 1-0 .pal GRANA .
  • midnightblue
    Hace 9 años midnightblue dice: La primera parte fue buena y competimos bien, si hubiéramos metido la oportunidad clara que tuvo Fariña no hubiéramos perdido el partido. La segunda parte fue mala, tuvimos un bajón físico considerable y demasiados fallos en la defensa, el segundo gol del Granada es un regalo que llega precedida de una falta inexistente de José Rodríguez, hay mucho por mejorar.
  • Drako
    Hace 9 años Drako dice: Muy mal el planteamiento del Deportivo. En todo el partido sólo tiraron una vez entre los tres palos y fue gol por la cantada del portero rival !!!. Pero lo más triste es que Víctor Fernández tiene las narices de decir que merecieron el empate, ¿en base a qué? si no jugaron a nada. No puede desaparecer el equipo de ese modo en la segunda parte. En cuanto al Granada, bien, nunca dieron el partido por perdido y por lo menos le pusieron ganas.
  • Actualizado hace 9 años (Creado hace 9 años ) alba4depor dice: No pudo ser, me quedo con una primera parte positiva y a seguir mejorando. Forza Depor!
  • elcherm
    Actualizado hace 9 años (Creado hace 9 años ) elcherm dice:
    Mi pronóstico para el partido en La Porra es 2-1:

    "Victoria sufrida del Granada."
  • unsko
    Hace 9 años unsko dice: Remontada para empezar de un Granada que con la incorporación de Rochina ha ganado en liderazgo y talento. El Depor arrancó con el tanto de Iván Cavaleiro en el primer tiempo. Ya en la segunda parte Rochina tiró de calidad para el 1-1. Babin dio la puntilla con el 2-1.
  • grannadino
    Actualizado hace 9 años (Creado hace 9 años ) grannadino dice: Partidazo en los Carmenes, aunque la sensacion el la presentacion del trofeo diputacion fue muy buena hemos de tener en cuenta que el rival no nos dio demasiados problemas,. Hemos perdido a Brahimi y parece que Iturra no es del gusto del nuevo entrenador, creo que el unico fichaje importante que hemos hecho es "Caparros", y esta noche tiene el escaparate perfecto en los carmenes para ilusionar a la aficion con este nuevo Granada...VAMOS ¡¡¡
  • unsko
    Actualizado hace 9 años (Creado hace 9 años ) unsko dice:
    Mi pronóstico para el partido en La Porra es 2-0:

    "Esta temporada el Granada tiene una plantilla muy equilibrada y potente"
  • grannadino
    Actualizado hace 9 años (Creado hace 9 años ) grannadino dice: magnifico este Granada, solventando un partido que se nos puso complicado y que con un depor muy bien posicionado nos podia perfectamente arrebatar los 3 puntos iniciales, pero fue un Granada muy distinto con la incorporacion de Iturra el que hizo a ver a los gallegos lo que es jugar en primera....VAMOS GRANADA ¡¡¡
  • grannadino
    Hace 9 años grannadino dice: Al loro chavales, o algo falla en RF, o el Granada es lider de primera
  • grannadino
    Hace 9 años grannadino dice: Al loro chavales, o algo falla en RF, o el Granada es lider de primera
  • gol_alex
    Hace 9 años gol_alex dice: Pleno :)
‹ Primero ... ... página 1 2 3 4 > ... Último ›

Partido televisado en...
Canal Medio Idioma País
Cuatro TV Castellano

  USO DE MEMORIA  
6,993,488 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.2465
Total Execution Time  0.2474
  CADENA URL  
/partido/Granada/Deportivo/2015
  GET DATOS  
$_GET['/partido/Granada/Deportivo/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (52)  
0.0079   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` = '3775' AND c.`match_id` = '19626' AND c.comment_id IN (3087028,3067529,3077877,3021923,3072038,3071782,3070230,3067199,3071262,3067025,3044294,3070740,3070778,3070773,3070532) GROUP BY c.comment_id
0.0076   SELECT c.*, c.stadium as real_stadium, 2015 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 calendars2015 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 = 'Granada' AND dt2.basealias = 'Deportivo'
0.0032  SELECT c.*, 2015 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 calendars2015 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 = 'Granada' AND dt2.basealias = 'Deportivo'
0.0018   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2015 AS ev WHERE ev.match_id=19626 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.0023   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=3775 WHERE dp.id IN (147839,29478,34742,111223,23574,44193,124283,73835,29741,75879,33531,31549,75128,27521,125601,27268,33527) AND (rp.team_id=69604 OR rp.team_id=69705)
0.0018   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2015 AS ev WHERE ev.match_id=19626 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id 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=3775 WHERE dp.id IN (147839,111223,73835,29741,75879,33531,29478,23574,31549,44193,75128,27521,124283,34742,33527,125601,27268) AND (rp.team_id=69604 OR rp.team_id=69705)
0.0019  SELECT data1 FROM stats2015 t WHERE league_id = 3775 AND teamId = 69705 and type = 33
0.0019  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 3775 AND id_match = 19626
0.0024  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='3775' AND relp.team_id = drea.team_id WHERE rel.team_number=60112 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='3775' AND relp.team_id = drea.team_id WHERE rel.team_number=60122 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0028  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='3775' AND relp.team_id=69604 WHERE mp.`match_id` = '19626' AND mp.year='2015' AND p.id NOT IN (13240,74166,23574,23492,23576,111223,124283,40476,54891,147839,27521,160042,34742,34297,34269,29741,33531,24790,33527,29478,44193,121657) ORDER BY mp.`team` ASC, p.`role` ASC
0.0036  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='3775' AND relp.team_id=69705 WHERE mp.`match_id` = '19626' AND mp.year='2015' AND p.id NOT IN (13240,74166,23574,23492,23576,111223,124283,40476,54891,147839,27521,160042,34742,34297,34269,29741,33531,24790,33527,29478,44193,121657) ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT kit FROM kit_data_real WHERE league_id = 3775 AND id_match = 19626
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '19626' and rp.type = 2015 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0022  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '19626' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0024  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 = 3775 AND rel.team1 = 69604 AND rel.team2 = 69705 ORDER BY FIELD(m.location,'es','en') DESC
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 19626 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 19626 AND year = 2015 AND channel = 'Footters' LIMIT 1
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='11' AND rel.active = 1 AND rel.league_id = 3775 AND rel.team1 = 69604 AND rel.team2 = 69705 ORDER BY FIELD(m.location,'es','en') DESC
0.0028  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 `calendars2015` 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` = 3775 AND c.`round` = 1 ORDER BY shedule ASC LIMIT 12
0.0027  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 `tables2015` 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 = 3775 AND t.round = 1 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0021  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2015` WHERE league_id = 3775 AND round >= 38 AND round <= 38 AND team = 69604 ORDER BY round ASC
0.0077   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` = '3775' AND c.`match_id` = '19626' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0022   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 = '3087028' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0034   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 = '3067529' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0029   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 = '3077877' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0032   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 = '3021923' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0032   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 = '3072038' 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 = '3071782' 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 = '3070230' 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 = '3067199' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0022   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 = '3071262' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0026   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 = '3067025' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0022   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 = '3044294' 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 = '3070740' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
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 = '3070778' 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 = '3070773' 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 = '3070532' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0020  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2015 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2015 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=2015 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 69604 AND c.team2 = 69705 AND c.league_id = 3775
0.0021  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='19626' AND `active` = 1 AND year = 2015
0.0018  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='19626' AND `active` = 1 AND year = 2015
0.0041  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='3775' AND relp.team_id=69604 WHERE relp.in_squad=1 and mp.`match_id` = '19626' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0032  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='3775' AND relp.team_id=69705 WHERE relp.in_squad=1 and mp.`match_id` = '19626' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '3775' AND id_match = '19626'
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 = '60112' 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 = '60122' ORDER BY rating DESC LIMIT 1
0.0017  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=19626 AND extraId = 3775 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=19626 AND league_id=3775 AND year=2015
0.0018  SELECT position FROM tables2015 WHERE team=69604 AND league_id=3775 AND round=1
0.0019  SELECT position FROM tables2015 WHERE team=69705 AND league_id=3775 AND round=1
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 19626 AND league_id = 3775 AND year = 2015