4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Lorca FC - Mancha Real
Jornada 18
FINALIZADO
20
10
626 Pts. Elo
4º

434 Pts. Elo
12º

3-0
Domingo, 11 Diciembre 2016, 17:00
A. Noguera 29'
1 - 0
Chumbi 34'
2 - 0
M. Onwu 66'
3 - 0

Eventos del partido

Goles

A. NogueraGol de
A. Noguera
minuto 29'
ChumbiGol de
Chumbi
minuto 34'
M. OnwuGol de
M. Onwu
minuto 66'

Tarjetas

minuto 71'Rubén PecesT. Amarilla Rubén Peces
G. PoleyT. Amarilla
G. Poley
minuto 86'
MoloT. Amarilla
Molo
minuto 89'

Cambios

minuto 46'Manolo LeónSale del partido Manolo León
minuto 46'ÁngelEntra en el partido Ángel
minuto 51'Pedro CorralSale del partido Pedro Corral
minuto 51'Borja RomeroEntra en el partido Borja Romero
M. OnwuEntra en el partido
M. Onwu
minuto 53'
ChumbiSale del partido
Chumbi
minuto 53'
minuto 71'Airam BenitoSale del partido Airam Benito
minuto 71'Jonathan RiveraEntra en el partido Jonathan Rivera
Carlos MartínezSale del partido
Carlos Martínez
minuto 86'
J. LópezEntra en el partido
J. López
minuto 86'
SamuEntra en el partido
Samu
minuto 87'
A. NogueraSale del partido
A. Noguera
minuto 87'

Alineaciones

Lorca FC

Lorca FC

4-3-3
Alineación Inicial
Suplentes
Mancha Real

Mancha Real

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

Lorca FC Lorca FC Mancha Real Mancha Real
20 Comentarios + 28 respuestas
‹ Primero ... ... página 1 2 > ... Último ›
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Jornada Propicia para el Lorca FC. Solo ganaron Mérida y Melilla. Empataron Cartagena. Jumilla. Marbella. Villano. Y perdió el Real Murcia. Estamos 4° a 1 punto del 2° y a 5 puntos del líder.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Goooooool de Onwu. 3-0
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Esto del 2-0 me suena.
    Vamos.
    A
    No Meter la pata en la Segunda Parte.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Onda 3 Puerto Lumbreras
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Comparativa Historica de Porteros Titulares de La Hoya: Alberto Cifuentes. Raul Moreno. Salcedo. Dorronsoro. Califica del 1 al 4 . Siendo el 1 el mejor segun tu opinion y el 4 el que menos te gusta. Por ejemplo: 1 Raul Moreno. 2 Dorronsoro. 3 Salcedo 4 Alberto Cifuentes.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Hay jugadores que no cuentan para este proyecto, unos porque no rinden y otros porque no son del agrado de Genbao. Algunos de estos futbolistas se están planteando salir de la entidad y cambiar de equipo. Así, habrá bajas y llegarán otros para potenciar un plantel que se supone que no está preparado ahora para pelear por el primer puesto. Eso sí, falta saber quién realizará los fichajes ya que Genbao no conoce el fútbol español y Paco Zaragoza está apartado.
  • lahoyanewsssss
    Actualizado hace 7 años (Creado hace 7 años ) lahoyanewsssss dice: Pedro Cordero. Jugador de Futbol en Cartagena y Murcia y Director Deportivo con Pina en Ciudad de Murcia y Granada, entra a formar parte del Lorca Deportiva. Pina Controla el Granada en 1A División y el Cadiz en 2A. El Lorca sería el Filial C con el objetivo de subir a 2B y Probar Jugadores para los equipos de Arriba.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Estadio de Fútbol en San Diego Ya!!! Acabo de salir del Eroski de San Diego. Hoy Compras y te Sale al 50℅ . Todas las Cajas Abiertas y Venga entrar gente. Habrá miles de personas. Por supuesto más que en el Artes Carrasco al lado del Cementerio. Por Dios. Vamos a Plantearnos ya de hacer un estadio Centrico con un centro comercial en los bajos. Si es que queremos que vaya público a ver el fútbol. San Diego es el mejor sitio. Futura Estación AVE, etc.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Esto del Fútbol se ve que conduce al personal a un estado de conciencia alterado. Como fumarse un por.ro o chisparse. Estupefacto me quedé cuando yendo Líder La Hoya en 2B el Ayuntamiento en vez de apoyarnos va y nos sabotea. También me sorprendió que los Directivos de La Hoya en vez de rendirse, presentasen batalla, a costa de su patrimonio personal, primero, al final, buscando un inversor. Esto es la Crónica de una Mu.ere.te Anunciada. Pero. ¿Pesentarà batalla Genbao? Ò ¿Su Filosofía Budista le llevará por los Caminos de la Sabiduría? Caminos que por supuesto. No pasan por Lorca.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Maquiavelo, escritor italiano del Siglo XV. Su obra más importante. El Príncipe, inspirado en Fernando de Aragón. Desde entonces, Maquiavélico se dice de la persona manipuladora, sin conciencia ni escrúpulos, capaz de cometer los actos más su.ci.os y ruines con tal de conseguir sus objetivos. El Concejal se ve que se ha leído el libro y lo aplica con maestría. ¡¡Bravo Concejal!! Tu Ganas. Eres el Mejor.Soberbio.Grandioso . Genial Me quedo sin Adjetivos para describirte. Diría También que eres el más Guapo. Pero mis hermanas dicen que eres más feo que pegar le a un Padre con un calcetín sudao.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Maquiavelo, escritor italiano del Siglo XV. Su obra más importante. El Príncipe, inspirado en Fernando de Aragón. Desde entonces, Maquiavélico se dice de la persona manipuladora, sin conciencia ni escrúpulos, capaz de cometer los actos más su.ci.os y ruines con tal de conseguir sus objetivos. El Concejal se ve que se ha leído el libro y lo aplica con maestría. ¡¡Bravo Concejal!! Tu Ganas. Eres el Mejor. Soberbio. Grandioso. Genial!!! Me quedo sin Adjetivos para describirte. Diría También que eres el más Guapo. Pero mis hermanas dicen que eres más feo que pegar le a un Padre con un calcetín sud
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Estupor (Sorpresa Exagerada que no te esperas y que te deja inmóvil y sin capacidad de reacción) Sentimos en La Hoya cuando desde el Ayuntamiento de Lorca refundan el Lorca Deportiva en 1a Autonómica y animan a la Afición a no apoyarnos. Imagino que lo mismo sentirá Genbao en estos momentos. Estamos a falta de sus declaraciones en respuesta a los últimos acontecimientos. Se Irá de aquí. Eso Seguro. Pero ¿Hasta Cuando Seguirà en Lorca? Probablemente acabará está Temporada y... Adiós para Siempre.
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Esto de la Fusión ya es Cabe. Zoom. Ería. Del Concejal. ¿Como va a dejar su amado Lorca Deportiva en manos de La Hoya? Imposible. Antes Partía que Doblà. La cosa era. Quitarsus Vosotros que nos ponemos nosotros. Ah. ¿Que no Te Quitas? Te vas a enterar. Al final acabará quedando solo el Lorca Deportiva. Ya veréis. Si hay dos equipos. Y el Ayuntamiento apoya a uno y persigue al otro. ¿Cual Creéis que Sobrevive? Pos Eso.
  • rafavalverde
    Hace 7 años rafavalverde dice: VAMOS MANCHA ANIMOS CAMPEONES''''''''''''''' ''''''''''
  • lahoyanewsssss
    Hace 7 años lahoyanewsssss dice: Bueno paisanos. No sufrir mas. Se acabo la Intriga. NO HAY FUSIÓN. Mira que sus lo dije. Pedro Cordero y su grupo inversor traeran al Lorca Deportiva dinero y jugadores para estar como minimo en 2B. Toda Gran Ciudad tiene 2 Grandes Clubs. Real y Atletico. Barsa y Espanyol. Valencia y Levante. Real y UCAM Murcia. Betis y Sevilla. Lorca, como ciudad de Gran Categoría. No puede ser menos. Lorca FC y Lorca Deportiva.
‹ Primero ... ... página 1 2 > ... Último ›


  USO DE MEMORIA  
6,456,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  1.1909
Total Execution Time  1.1919
  CADENA URL  
/partido/Hoya-Lorca-Cf/Atletico-Mancha-Real/2017
  GET DATOS  
$_GET['/partido/Hoya-Lorca-Cf/Atletico-Mancha-Real/2017']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (57)  
0.0111   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` = '33381' AND c.`match_id` = '106804' AND c.comment_id IN (13266634,13254555,13253380,13251171,13241592,13240276,13186264,13209627,13198487,13198466,13198464,13198448,13198429,13195042,13188671) GROUP BY c.comment_id
0.0184   SELECT c.*, c.stadium as real_stadium, 2017 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 calendars2017 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 = 'Hoya-Lorca-Cf' AND dt2.basealias = 'Atletico-Mancha-Real'
0.0151  SELECT c.*, 2017 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 calendars2017 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 = 'Hoya-Lorca-Cf' AND dt2.basealias = 'Atletico-Mancha-Real'
0.0292  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 = 33381
0.0146   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2017 AS ev WHERE ev.match_id=106804 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.0155   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=33381 WHERE dp.id IN (36852,108618,67962,44721,73849,31230,189227,116642,91667,161918,36635,34579,69672,38747,180747) AND (rp.team_id=711370 OR rp.team_id=711357)
0.0145   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2017 AS ev WHERE ev.match_id=106804 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0148   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=33381 WHERE dp.id IN (36852,108618,189227,116642,91667,161918,67962,44721,36635,34579,73849,69672,38747,180747,31230) AND (rp.team_id=711370 OR rp.team_id=711357)
0.0144  SELECT data1 FROM stats2017 t WHERE league_id = 33381 AND teamId = 711370 and type = 33
0.0145  SELECT data1 FROM stats2017 t WHERE league_id = 33381 AND teamId = 711357 and type = 33
0.0149  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 33381 AND id_match = 106804
0.0163  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='33381' AND relp.team_id = drea.team_id WHERE rel.team_number=220457 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0157  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='33381' AND relp.team_id = drea.team_id WHERE rel.team_number=220507 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0246  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='33381' AND relp.team_id=711370 WHERE mp.`match_id` = '106804' AND mp.year='2017' AND p.id NOT IN (29359,31230,34335,146823,35063,36852,73849,180748,76149,108618,69672,32497,44721,189227,275298,137750,74986,111340,121419,36635,91667,116704) ORDER BY mp.`team` ASC, p.`role` ASC
0.0401  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='33381' AND relp.team_id=711357 WHERE mp.`match_id` = '106804' AND mp.year='2017' AND p.id NOT IN (29359,31230,34335,146823,35063,36852,73849,180748,76149,108618,69672,32497,44721,189227,275298,137750,74986,111340,121419,36635,91667,116704) ORDER BY mp.`team` ASC, p.`role` ASC
0.0153  SELECT kit FROM kit_data_real WHERE league_id = 33381 AND id_match = 106804
0.0147  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '106804' and rp.type = 2017 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '106804' and rp.type = 2017 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0151  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 = 33381 AND rel.team1 = 711370 AND rel.team2 = 711357 ORDER BY FIELD(m.location,'es','en') DESC
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 106804 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0145  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 106804 AND year = 2017 AND channel = 'Footters' LIMIT 1
0.0151  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 = 33381 AND rel.team1 = 711370 AND rel.team2 = 711357 ORDER BY FIELD(m.location,'es','en') DESC
0.0155  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 = 33381 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0165  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 `calendars2017` 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` = 33381 AND c.`round` = 18 ORDER BY shedule ASC LIMIT 12
0.0166  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 `tables2017` 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 = 33381 AND t.round = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0151  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2017` WHERE league_id = 33381 AND round >= 38 AND round <= 38 AND team = 711370 ORDER BY round ASC
0.0174  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 `tables2017` 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 = 33381 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0182   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` = '33381' AND c.`match_id` = '106804' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0149   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 = '13266634' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '13254555' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0150   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 = '13253380' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '13251171' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0148   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 = '13241592' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0148   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 = '13240276' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0148   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 = '13186264' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '13209627' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0152   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 = '13198487' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '13198466' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0146   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 = '13198464' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0147   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 = '13198448' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0146   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 = '13198429' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0149   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 = '13195042' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0148   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 = '13188671' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0154  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2017 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2017 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=2017 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 711370 AND c.team2 = 711357 AND c.league_id = 33381
0.0148  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='106804' AND `active` = 1 AND year = 2017
0.0146  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='106804' AND `active` = 1 AND year = 2017
0.0258  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='33381' AND relp.team_id=711370 WHERE relp.in_squad=1 and mp.`match_id` = '106804' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0241  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='33381' AND relp.team_id=711357 WHERE relp.in_squad=1 and mp.`match_id` = '106804' AND mp.year='2017' ORDER BY mp.`team` ASC, p.`role` ASC
0.0147  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '33381' AND id_match = '106804'
0.0146   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 = '220457' ORDER BY rating DESC LIMIT 1
0.0145   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 = '220507' ORDER BY rating DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=106804 AND extraId = 33381 AND type_rel = 4
0.0145  SELECT rating1, rating2 FROM calendars_elo WHERE id=106804 AND league_id=33381 AND year=2017
0.0145  SELECT avg_rating FROM elo_teams WHERE id=371
0.0145  SELECT position FROM tables2017 WHERE team=711370 AND league_id=33381 AND round=18
0.0145  SELECT position FROM tables2017 WHERE team=711357 AND league_id=33381 AND round=18
0.0145  SELECT * FROM futbol.calendars_lineups WHERE id = 106804 AND league_id = 33381 AND year = 2017