4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Real Jaén - Lorca FC
Jornada 14
FINALIZADO
30
60
861 Pts. Elo
7º

588 Pts. Elo
6º

0-0
Domingo, 22 Noviembre 2015, 12:15

Eventos del partido

Tarjetas

minuto 31'Roberto AlarcónT. Amarilla Roberto Alarcón
minuto 32'G. PoleyT. Amarilla G. Poley
MolinaT. Amarilla
Molina
minuto 42'
Fran NoT. Amarilla
Fran No
minuto 42'
minuto 64'Grego SierraT. Amarilla Grego Sierra
minuto 74'Carlos AlcántaraT. Amarilla Carlos Alcántara
minuto 75'PinaT. Amarilla Pina
minuto 83'PardoT. Amarilla Pardo
Mario GómezT. Amarilla
Mario Gómez
minuto 89'

Cambios

MolinaSale del partido
Molina
minuto 58'
Nuno MiguelEntra en el partido
Nuno Miguel
minuto 58'
minuto 65'Carlos MartínezSale del partido Carlos Martínez
minuto 65'Dani CarballoEntra en el partido Dani Carballo
Álex CruzEntra en el partido
Álex Cruz
minuto 69'
SutilSale del partido
Sutil
minuto 69'
minuto 70'JuliánEntra en el partido Julián
minuto 70'Álex BernalSale del partido Álex Bernal
Óscar QuesadaEntra en el partido
Óscar Quesada
minuto 77'
Fran NoSale del partido
Fran No
minuto 77'
minuto 80'Airam BenitoEntra en el partido Airam Benito
minuto 80'G. PoleySale del partido G. Poley

Alineaciones

Real Jaén

Real Jaén

Alineación Inicial
Suplentes
Lorca FC

Lorca FC

4-3-3
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 Jaén Real Jaén Lorca FC Lorca FC
31 Comentarios + 83 respuestas
‹ Primero ... ... página 1 2 3 > ... Último ›
  • Actualizado hace 8 años (Creado hace 8 años ) lahoyanews0 dice: Bueno amigos de Jaen, aceituneros altivos, como canto el poeta Federico Garcia Lorca, me retiro hasta mañana, me retiro que mañana me tengo que levantar a las 5 de la mañana para recoger miles de olivas. Que buena gente son ustedes los de Jaen, quien me iba a decir que mi equipo de la hoya estaria jugando de tu a tu con un equipo historico como el Real Jaen. Un saludo, Buenas Noches y Buena Suerte.
  • rafavalverde
    Hace 8 años rafavalverde dice: Yo voy a decir 3-1para Jaén!!!!!!
  • yuraiza
    Hace 8 años yuraiza dice: mi pronostico es 2-0-
  • rafavalverde
    Hace 8 años rafavalverde dice: compañeros sabeis si televisan mañana el partido'?
  • Actualizado hace 8 años (Creado hace 8 años ) lahoyanews0 dice: Otra pregunta incomoda. Mis paisanos que entran aqui, que parece que se han quedao destrozaos sicologicamente con la noticia que el chino a conprao la hoya y no participan, bueno decia que mis paisanos la mayoria son del real madris menos yo que considero que este equipo es un cancer para el futbol de este pais, me parece que al barsa se le considera como un apestado por lo de la independencia de Catalunya y si acaso me simpatiza el Athletic ya que juega con la cantera y sin fichajes extranjeros aguanta como puede. Que pensais en Jaen, hay mas madridistas o del basra?
  • Actualizado hace 8 años (Creado hace 8 años ) lahoyanews0 dice: Teneis rivalidad con algun equipo de la Provincia de Jaen? Que tal os llevais con los otros equipos de Andalucia: Sevilla, Betis, Cadiz, Granada, Cordoba, Huelva, Malaga, Almeria, etc.
  • totalfutbol
    Hace 8 años totalfutbol dice: Real Jaén 2-1 Hoya Lorca
  • joseherranzl
    Actualizado hace 8 años (Creado hace 8 años ) joseherranzl dice: 0-1
  • Actualizado hace 8 años (Creado hace 8 años ) lahoyanews0 dice: Morillas, este jugador de Aguilas que gran defensa, participó en las dos mejores temporadas de la hoya 12-13 y 13-14, está siendo entrevistado ahora mismo por Onda Regional de Murcia, de su equipo actual el Huesca donde es titular junto con otro ex de la hoya de esa epoca, Manolin, les han renovado por dos temporadas a los dos con un buen contrato. Buena suerte en Huesca para Morillas y Manolin.
  • Hace 8 años lahoyanews0 dice: En que año decis que se construyó el estadio? Como se notan los años locos de la construccion y la especulacion urbanistica, se compraban terrenos rusticos lejanos por amigos de los politicos, se recalificaban, se construian estadios por constructoras de amigos del alcalde de turno y se repartian el 3 ó el 30 por ciento con unos presupuesto super inflados, si luego la lejania del estadio y la mala calidad de la construccion era un impedimento para que el publico acudiese masivamente, que mas da, algunos ya se habian forrao a ganar billetes verdes, billetes billetes verdes pero que bonicos son.
  • Hace 8 años lahoyanews0 dice: Jaén Paraíso Interior. Se sigue llamando así el equipo de fútbol sala? Como disfruté hace apenas unos meses con la Copa del Rey de fútbol sala que gano vuestro equipo ante el favorito el Barsa. Que tal va esta temporada?
  • Hace 8 años lahoyanews0 dice: vamos que ya es viernes dentro de poco ya tendrán que salir los jugadores de la Hoya Lorca con destino a Jaén
  • Hace 8 años lahoyanews0 dice: Bon día Xavi. Moltes Gracies. Amunt Sant Andreu.
  • Hace 8 años lahoyanews0 dice: Yo no soy católico pero tampoco soy partidario de quemar las iglesias, si acaso a algún cura que "abusa" de la confianza. Dicen que afición al fútbol es sinónimo de incultura, demostrar que no es así amigos de Jaén e ilustrarnos al mundo entero de las joyas culturales que se pueden visitar en Jaén. Recordar que el dueño de la hoya Xu Gibao fue seleccionador de China y su aventura en Lorca es seguida por 1.200.000.000 de posibles turistas. Seguro que vendrán muchos en el futuro siguiendo a la hoya. De momento los todo a 1€ y los Lestaulantes Chinos de Jaén van con la hoya seguro.
  • Actualizado hace 8 años (Creado hace 8 años ) lahoyanews0 dice: Bueno amigos de Jaen, cuales son los puntos flojos de vuestro equipo? por donde hay que lanzarle al portero para hacerle gol, por alto o rasa y pegado al poste? que parte de la defensa es un coladero, que central es mas debil, que banda es mejor para entrar, izquierda o derecha? a que delantero deberiamos atar en corto para que no nos la lie? Gracias amigos de Jaen por la informacion.
‹ Primero ... ... página 1 2 3 > ... Último ›


  USO DE MEMORIA  
6,558,056 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2644
Total Execution Time  0.2654
  CADENA URL  
/partido/Real-Jaen/Hoya-Lorca-Cf/2016
  GET DATOS  
$_GET['/partido/Real-Jaen/Hoya-Lorca-Cf/2016']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
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` = '15378' AND c.`match_id` = '43017' AND c.comment_id IN (8342644,8386313,8385243,8372273,8342438,8341776,8353097,8338492,8340890,8340224,8345362,8345990,8345349,8345053,8342091) GROUP BY c.comment_id
0.0080   SELECT c.*, c.stadium as real_stadium, 2016 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 calendars2016 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-Jaen' AND dt2.basealias = 'Hoya-Lorca-Cf'
0.0028  SELECT c.*, 2016 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 calendars2016 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-Jaen' AND dt2.basealias = 'Hoya-Lorca-Cf'
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 = 15378
0.0021   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2016 AS ev WHERE ev.match_id=43017 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.0029   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=15378 WHERE dp.id IN (81657,73849,89147,189270,117453,80326,35063,78245,196953,243028,69672,152557,29111,29834,44608,82137,34393,36635) AND (rp.team_id=214705 OR rp.team_id=214701)
0.0020   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2016 AS ev WHERE ev.match_id=43017 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0027   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=15378 WHERE dp.id IN (81657,73849,89147,189270,243028,117453,69672,152557,29111,29834,44608,82137,80326,35063,34393,36635,78245,196953) AND (rp.team_id=214705 OR rp.team_id=214701)
0.0019  SELECT data1 FROM stats2016 t WHERE league_id = 15378 AND teamId = 214705 and type = 33
0.0019  SELECT data1 FROM stats2016 t WHERE league_id = 15378 AND teamId = 214701 and type = 33
0.0021  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 15378 AND id_match = 43017
0.0033  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='15378' AND relp.team_id = drea.team_id WHERE rel.team_number=140133 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0035  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='15378' AND relp.team_id = drea.team_id WHERE rel.team_number=140134 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0049  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='15378' AND relp.team_id=214705 WHERE mp.`match_id` = '43017' AND mp.year='2016' AND p.id NOT IN (33513,189270,109864,145860,193558,196953,29834,44610,89147,44458,48233,30161,73570,78245,80326,35063,117453,82137,73849,81657,69672,108927) ORDER BY mp.`team` ASC, p.`role` ASC
0.0050  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='15378' AND relp.team_id=214701 WHERE mp.`match_id` = '43017' AND mp.year='2016' AND p.id NOT IN (33513,189270,109864,145860,193558,196953,29834,44610,89147,44458,48233,30161,73570,78245,80326,35063,117453,82137,73849,81657,69672,108927) ORDER BY mp.`team` ASC, p.`role` ASC
0.0030  SELECT kit FROM kit_data_real WHERE league_id = 15378 AND id_match = 43017
0.0026  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '43017' and rp.type = 2016 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0030  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '43017' and rp.type = 2016 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0032  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 = 15378 AND rel.team1 = 214705 AND rel.team2 = 214701 ORDER BY FIELD(m.location,'es','en') DESC
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 43017 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0022  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 43017 AND year = 2016 AND channel = 'Footters' LIMIT 1
0.0027  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 = 15378 AND rel.team1 = 214705 AND rel.team2 = 214701 ORDER BY FIELD(m.location,'es','en') DESC
0.0028  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 = 15378 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0056  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 `calendars2016` 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` = 15378 AND c.`round` = 14 ORDER BY shedule ASC LIMIT 12
0.0029  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 `tables2016` 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 = 15378 AND t.round = 14 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0022  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2016` WHERE league_id = 15378 AND round >= 38 AND round <= 38 AND team = 214705 ORDER BY round ASC
0.0032  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 `tables2016` 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 = 15378 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0046   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` = '15378' AND c.`match_id` = '43017' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
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 = '8342644' 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 = '8386313' 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 = '8385243' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0023   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 = '8372273' 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 = '8342438' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0023   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 = '8341776' 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 = '8353097' 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 = '8338492' 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 = '8340890' 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 = '8340224' 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 = '8345362' 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 = '8345990' 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 = '8345349' 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 = '8345053' 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 = '8342091' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0033  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2016 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2016 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=2016 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 214705 AND c.team2 = 214701 AND c.league_id = 15378
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='43017' AND `active` = 1 AND year = 2016
0.0019  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='43017' AND `active` = 1 AND year = 2016
0.0082  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='15378' AND relp.team_id=214705 WHERE relp.in_squad=1 and mp.`match_id` = '43017' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0061  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='15378' AND relp.team_id=214701 WHERE relp.in_squad=1 and mp.`match_id` = '43017' AND mp.year='2016' ORDER BY mp.`team` ASC, p.`role` ASC
0.0025  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '15378' AND id_match = '43017'
0.0021   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 = '140133' ORDER BY rating DESC LIMIT 1
0.0021   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 = '140134' ORDER BY rating DESC LIMIT 1
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=43017 AND extraId = 15378 AND type_rel = 4
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=3 AND type_rel = 3
0.0234  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 3 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0024  SELECT /*53 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (1307952,1269904,1267798,1247262,1200661) ORDER BY n.cover_points DESC, update_date DESC
0.0020  SELECT rating1, rating2 FROM calendars_elo WHERE id=43017 AND league_id=15378 AND year=2016
0.0018  SELECT position FROM tables2016 WHERE team=214705 AND league_id=15378 AND round=14
0.0018  SELECT position FROM tables2016 WHERE team=214701 AND league_id=15378 AND round=14
0.0017  SELECT * FROM futbol.calendars_lineups WHERE id = 43017 AND league_id = 15378 AND year = 2016