4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Recreativo - Elche
Jornada 28
FINALIZADO
50
30
1691 Pts. Elo
9º

1224 Pts. Elo
8º

2-1
Domingo, 14 Marzo 2010, 17:00
Álvaro Antón 47'
1 - 0
C. Carmona 84'
2 - 0
2 - 1
 90' Usero

Eventos del partido

Goles

Álvaro AntónGol de
Álvaro Antón
minuto 47'
C. CarmonaGol de
C. Carmona
minuto 84'
minuto 90'UseroGol de Usero

Tarjetas

minuto RipaT. Amarilla Ripa
minuto M. WakasoT. Amarilla M. Wakaso
Óscar DíazT. Amarilla
Óscar Díaz
minuto
Raúl CámaraT. Amarilla
Raúl Cámara
minuto
minuto PatriT. Amarilla Patri
Javi FuegoT. Amarilla
Javi Fuego
minuto
Iago BouzónT. Amarilla
Iago Bouzón
minuto
Jesús VázquezT. Amarilla
Jesús Vázquez
minuto

Cambios

J. BarralesEntra en el partido
J. Barrales
minuto 42'
DaniSale del partido
Dani
minuto 42'
Óscar DíazSale del partido
Óscar Díaz
minuto 45'
C. CarmonaEntra en el partido
C. Carmona
minuto 45'
minuto 57'M. WakasoSale del partido M. Wakaso
minuto 57'Óscar TrejoEntra en el partido Óscar Trejo
minuto 68'Martí CrespíEntra en el partido Martí Crespí
minuto 68'TenaSale del partido Tena
BraulioSale del partido
Braulio
minuto 68'
Aitor TornavacaEntra en el partido
Aitor Tornavaca
minuto 68'
minuto 78'JuliSale del partido Juli
minuto 78'PatriEntra en el partido Patri

Alineaciones

Recreativo

Recreativo

4-4-2
Alineación Inicial
Suplentes
Elche

Elche

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

Recreativo Recreativo Elche Elche
60 Comentarios + 13 respuestas
‹ Primero ... ... página 1 2 3 4 > ... Último ›
  • xifo
    Hace 14 años xifo dice: Aunque los franjiverdes lo intentaron y cercaron el portal recreativista, apenas quedaba tiempo y la defensa local supo defender su portería para que se quedaran los tres puntos en Huelva.Aunque los franjiverdes lo intentaron y cercaron el portal recreativista, apenas quedaba tiempo y la defensa local supo defender su portería para que se quedaran los tres puntos en Huelva.
  • xifo
    Hace 14 años xifo dice: Fruto de una de esas acciones, a falta de siete minutos, Carmona sentenció el partido a pase de Javi Fuego, batiendo por bajo a Caballero y poniendo el 2-0 que pareció el definitivo. Sin embargo, ya en la prolongación, un buen pase de Jorge Molina a Usero permitió al centrocampista ilicitano acortar distancias.Fruto de una de esas acciones, a falta de siete minutos, Carmona sentenció el partido a pase de Javi Fuego, batiendo por bajo a Caballero y poniendo el 2-0 que pareció el definitivo. Sin embargo, ya en la prolongación, un buen pase de Jorge Molina a Usero permitió al centrocampista ilicitano acortar distancias.
  • xifo
    Hace 14 años xifo dice: Los ilicitanos movieron el banquillo pero los cambios sólo sirvieron para disponer del balón, por cuanto apenas crearon peligro ante el portal onubense, mientras los recreativistas, al contragolpe, buscaron aumentar el marcador.Los ilicitanos movieron el banquillo pero los cambios sólo sirvieron para disponer del balón, por cuanto apenas crearon peligro ante el portal onubense, mientras los recreativistas, al contragolpe, buscaron aumentar el marcador.
  • xifo
    Hace 14 años xifo dice: Comenzó muy bien la segunda parte para los onubenses, ya que a los dos minutos un buen pase de Javi Fuego fue aprovechado por Braulio para cruzar al palo contrario. El gol dio nuevos aires a los recreativistas, que dominaron con facilidad ante un Elche que no fue capaz de reaccionar.Comenzó muy bien la segunda parte para los onubenses, ya que a los dos minutos un buen pase de Javi Fuego fue aprovechado por Braulio para cruzar al palo contrario. El gol dio nuevos aires a los recreativistas, que dominaron con facilidad ante un Elche que no fue capaz de reaccionar.
  • xifo
    Hace 14 años xifo dice: Precisamente el ex verdiblanco y poco antes del descanso, tuvo que dejar su puesto por unas molestias musculares a Barrales y, cuando se recuperaba el tiempo perdido, llegó el primer disparo a puerta de los ilicitanos, pero el envío de Wakaso se marchó junto al poste derecho.Precisamente el ex verdiblanco y poco antes del descanso, tuvo que dejar su puesto por unas molestias musculares a Barrales y, cuando se recuperaba el tiempo perdido, llegó el primer disparo a puerta de los ilicitanos, pero el envío de Wakaso se marchó junto al poste derecho.
  • xifo
    Hace 14 años xifo dice: Así, a los 20 minutos, un desvío de Tena estuvo cerca de sorprender a su compañero Willy Caballero, quien reaccionó rápido y pudo enviar el balón a córner. Un saque de esquina que sirvió para que Dani, prácticamente en la boca de gol, rematara al poste izquierdo, en la ocasión más clara para abrir el marcador.Así, a los 20 minutos, un desvío de Tena estuvo cerca de sorprender a su compañero Willy Caballero, quien reaccionó rápido y pudo enviar el balón a córner. Un saque de esquina que sirvió para que Dani, prácticamente en la boca de gol, rematara al poste izquierdo, en la ocasión más clara para abrir el marcador.
  • xifo
    Hace 14 años xifo dice: Los locales, conscientes de la importancia del triunfo, quisieron imponer su ritmo pero se encontraron con una buena disposición de los ilicitanos, más preocupados que el balón no llegara a su área que de buscar el peligro en la rival.Los locales, conscientes de la importancia del triunfo, quisieron imponer su ritmo pero se encontraron con una buena disposición de los ilicitanos, más preocupados que el balón no llegara a su área que de buscar el peligro en la rival.
  • xifo
    Hace 14 años xifo dice: La primera parte se caracterizó por la falta de calidad del juego desplegado por ambos equipos así como por la ausencia de ocasiones de peligro en ambas áreas debido, fundamentalmente, al excesivo centrocampismo impuesto por los dos bandos.La primera parte se caracterizó por la falta de calidad del juego desplegado por ambos equipos así como por la ausencia de ocasiones de peligro en ambas áreas debido, fundamentalmente, al excesivo centrocampismo impuesto por los dos bandos.
  • xifo
    Hace 14 años xifo dice: El triunfo onubense se basó en las ganas puestas en la segunda parte, donde el equipo se mostró muy superior al visitante, que sólo reaccionó en los minutos finales cuando ya no disponía de tiempo para mejorar el marcador, sólo para maquillarlo.El triunfo onubense se basó en las ganas puestas en la segunda parte, donde el equipo se mostró muy superior al visitante, que sólo reaccionó en los minutos finales cuando ya no disponía de tiempo para mejorar el marcador, sólo para maquillarlo.
  • patrullero82
    Hace 14 años patrullero82 dice: Ya lo dice el refrán: DE UN ALICANTINO Y UN MURCIANO.....NACIÓ EL PRIMER ILICITANO JEJEJEJE QUE BUENO.Ya lo dice el refrán: DE UN ALICANTINO Y UN MURCIANO.....NACIÓ EL PRIMER ILICITANO JEJEJEJE QUE BUENO.
  • ElMalvis
    Hace 14 años ElMalvis dice: A pesar de la derrota, el Elche sigue en la zona templaza, ni frío ni calor o lo que es lo mismo ni aspira a nada ni tampoco va a pasar ningún apuro.A pesar de la derrota, el Elche sigue en la zona templaza, ni frío ni calor o lo que es lo mismo ni aspira a nada ni tampoco va a pasar ningún apuro.
  • ElMalvis
    Hace 14 años ElMalvis dice: Este triunfo es como un sedante para el Recreativo que supera en la tabla a su adversario, el Elche y ninguno de los dos corres ningún peligroEste triunfo es como un sedante para el Recreativo que supera en la tabla a su adversario, el Elche y ninguno de los dos corres ningún peligro
  • colchonero
    Hace 14 años colchonero dice: conchi calla y no hables mas, el decano del futbol español se ha pasado por la piedra a tu elcheconchi calla y no hables mas, el decano del futbol español se ha pasado por la piedra a tu elche
  • Servaya
    Hace 14 años Servaya dice: una putada lo del chabal fallecido en el terreno de juego una pena perder la vida practicando el depote que mas te gustauna putada lo del chabal fallecido en el terreno de juego una pena perder la vida practicando el depote que mas te gusta
  • Servaya
    Hace 14 años Servaya dice: Incidencias: Partido de la vigésimo octava jornada de la Liga Adelante de Segunda división, disputado en el Estadio Nuevo Colombino, con terreno de juego en buenas condiciones y tarde primaveral, ante cerca de 10.000 espectadores. Se guardó un minuto de silencio en recuerdo de un joven fallecido el pasado viernes en la provincia de Huelva mientras disputaba un encuentroIncidencias: Partido de la vigésimo octava jornada de la Liga Adelante de Segunda división, disputado en el Estadio Nuevo Colombino, con terreno de juego en buenas condiciones y tarde primaveral, ante cerca de 10.000 espectadores. Se guardó un minuto de silencio en recuerdo de un joven fallecido el pasado viernes en la provincia de Huelva mientras disputaba un encuentro
‹ Primero ... ... página 1 2 3 4 > ... Último ›


  USO DE MEMORIA  
6,214,304 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Match / Index )  0.2234
Total Execution Time  0.2246
  CADENA URL  
/partido/Recreativo/Elche/2010
  GET DATOS  
$_GET['/partido/Recreativo/Elche/2010']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (58)  
0.0015   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` = '812' AND c.`match_id` = '1443' AND c.comment_id IN (200479,200478,200477,200476,200475,200474,200472,200471,200470,200307,200293,200274,199887,199720,199703) GROUP BY c.comment_id
0.0076   SELECT c.*, c.stadium as real_stadium, 2010 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 calendars2010 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 = 'Recreativo' AND dt2.basealias = 'Elche'
0.0038  SELECT c.*, 2010 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 calendars2010 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 = 'Recreativo' AND dt2.basealias = 'Elche'
0.0039  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 = 812
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2010 AS ev WHERE ev.match_id=1443 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.0025   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=812 WHERE dp.id IN (13273,75105,61596,61588,61592,27300,23490,61597,23408,23402,23412,16701,43430,7576,34909,61586,24033,23411,61591) AND (rp.team_id=19458 OR rp.team_id=19445)
0.0018   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2010 AS ev WHERE ev.match_id=1443 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id 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=812 WHERE dp.id IN (61588,61592,27300,23490,61597,23408,23402,23412,16701,43430,75105,13273,7576,34909,61586,24033,23411,61591,61596) AND (rp.team_id=19458 OR rp.team_id=19445)
0.0019  SELECT data1 FROM stats2010 t WHERE league_id = 812 AND teamId = 19458 and type = 33
0.0019  SELECT data1 FROM stats2010 t WHERE league_id = 812 AND teamId = 19445 and type = 33
0.0022  SELECT rdh.pos, rdh.playerId AS player_id, rdh.team, dp.alias, dp.role, dp.name, dp.nick, dp.last_name, '' AS num FROM rel_dreamteam_historical AS rdh INNER JOIN dataplayers AS dp ON rdh.playerId=dp.id WHERE rdh.match_id=1443 AND rdh.league_id=812 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0019  SELECT kit FROM kit_data_real WHERE league_id = 812 AND id_match = 1443
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '1443' and rp.type = 2010 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0020  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '1443' and rp.type = 2010 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0021  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 = 812 AND rel.team1 = 19458 AND rel.team2 = 19445 ORDER BY FIELD(m.location,'es','en') DESC
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 1443 AND year = 2010 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 1443 AND year = 2010 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 = 812 AND rel.team1 = 19458 AND rel.team2 = 19445 ORDER BY FIELD(m.location,'es','en') DESC
0.0021  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 = 812 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0017  SELECT teamId FROM teams WHERE id = 19458
0.0017  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2010 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2010 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 2141 OR c.datateam2 = 2141) ORDER BY shedule DESC LIMIT 10
0.0018  SELECT teamId FROM teams WHERE id = 19445
0.0018  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2010 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2010 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 != 99 or c.r2 != 99) AND (c.datateam1 = 975 OR c.datateam2 = 975) ORDER BY shedule DESC LIMIT 10
0.0023  SELECT teamId FROM teams WHERE id = 19458
0.0027  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2010 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2010 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 2141 OR c.datateam2 = 2141) ORDER BY shedule ASC LIMIT 10
0.0023  SELECT teamId FROM teams WHERE id = 19445
0.0026  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2010 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2010 as c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE (c.r1 = 99 or c.r2 = 99) AND (c.datateam1 = 975 OR c.datateam2 = 975) ORDER BY shedule ASC LIMIT 10
0.0031  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 `calendars2010` 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` = 812 AND c.`round` = 28 ORDER BY shedule ASC LIMIT 12
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 812 AND t.round = 28 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2010` WHERE league_id = 812 AND round >= 42 AND round <= 42 AND team = 19458 ORDER BY round ASC
0.0019  SELECT t.*,dt.nameShow,dt.basealias,dt.id as teamId,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2010` 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 = 812 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0019   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` = '812' AND c.`match_id` = '1443' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0019   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '200479' 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 = '200478' 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 = '200477' 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 = '200476' 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 = '200475' 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 = '200474' 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 = '200472' 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 = '200471' 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 = '200470' 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 = '200307' 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 = '200293' 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 = '200274' 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 = '199887' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0018   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 = '199720' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0091   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 = '199703' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0084  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2010 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2010 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=2010 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 19458 AND c.team2 = 19445 AND c.league_id = 812
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='1443' AND `active` = 1 AND year = 2010
0.0018  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='1443' AND `active` = 1 AND year = 2010
0.0018  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='812' AND relp.team_id=19458 WHERE relp.in_squad=1 and mp.`match_id` = '1443' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0021  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='812' AND relp.team_id=19445 WHERE relp.in_squad=1 and mp.`match_id` = '1443' AND mp.year='2010' ORDER BY mp.`team` ASC, p.`role` ASC
0.0019  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '812' AND id_match = '1443'
0.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1443 AND extraId = 812 AND type_rel = 4
0.0018  SELECT rating1, rating2 FROM calendars_elo WHERE id=1443 AND league_id=812 AND year=2010
0.0018  SELECT position FROM tables2010 WHERE team=19458 AND league_id=812 AND round=28
0.0018  SELECT position FROM tables2010 WHERE team=19445 AND league_id=812 AND round=28
0.0018  SELECT * FROM futbol.calendars_lineups WHERE id = 1443 AND league_id = 812 AND year = 2010