A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: controllers/match.php

Line Number: 505

A PHP Error was encountered

Severity: Warning

Message: Invalid argument supplied for foreach()

Filename: controllers/match.php

Line Number: 505

Partido Yeclano Deportivo - Real Murcia | Segunda División B G 4 2011
4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Yeclano Deportivo - Real Murcia
Jornada 8
FINALIZADO
61
71
547 Pts. Elo
20º

969 Pts. Elo
1º

1-1
Domingo, 10 Octubre 2010, 18:00
Gasparini 27'
1 - 0
1 - 1
 86' P. Sánchez

Eventos del partido

Goles

GaspariniGol de
Gasparini
minuto 27'
minuto 86'P. SánchezGol de P. Sánchez

Tarjetas

minuto 31'A. CañadasT. Amarilla A. Cañadas
Álvaro CanoT. Amarilla
Álvaro Cano
minuto 40'
ChinoT. Amarilla
Chino
minuto 53'
minuto 55'RichiT. Amarilla Richi
VilasecaTarjeta Roja a
Vilaseca
minuto 62'
San JoséT. Amarilla
San José
minuto 70'
minuto 77'J. GotorT. Amarilla J. Gotor
minuto 78'Dani AquinoT. Amarilla Dani Aquino
GaspariniT. Amarilla
Gasparini
minuto 79'
Toni BernalT. Amarilla
Toni Bernal
minuto 82'
RumboT. Amarilla
Rumbo
minuto 86'
minuto 86'Iván AmayaT. Amarilla Iván Amaya
minuto 88'J. Gotor2a Amarilla y Roja J. Gotor
minuto 89'LucianoT. Amarilla Luciano

Cambios

minuto 46'P. SánchezEntra en el partido P. Sánchez
minuto 46'A. CañadasSale del partido A. Cañadas
RumboEntra en el partido
Rumbo
minuto 62'
Álvaro CanoSale del partido
Álvaro Cano
minuto 62'
PiruSale del partido
Piru
minuto 66'
Juan CarlosEntra en el partido
Juan Carlos
minuto 66'
minuto 68'IsaacEntra en el partido Isaac
minuto 68'LucianoSale del partido Luciano
minuto 76'Kike GarcíaSale del partido Kike García
minuto 76'Dani AquinoEntra en el partido Dani Aquino
RaúlEntra en el partido
Raúl
minuto 78'
ChinoSale del partido
Chino
minuto 78'

Alineaciones

Yeclano Deportivo

Yeclano Deportivo

4-4-2
Alineación Inicial
Suplentes
Real Murcia

Real Murcia

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

Yeclano Deportivo Yeclano Real Murcia Real Murcia
132 Comentarios + 113 respuestas
‹ Primero ... ... página 1 2 3 4 5 6 7 8 9 > ... Último ›
  • Murciacapital
    Actualizado hace 13 años (Creado hace 13 años ) Murciacapital dice: Menudo futbolín que tienen estos del yecla, además el equipo es carne tercera división aunque hoy ganen. Menudo futbolín que tienen estos del yecla, además el equipo es carne tercera división aunque hoy ganen.
  • aficionadomurcia
    Actualizado hace 13 años (Creado hace 13 años ) aficionadomurcia dice: Soy de murcia y me da verguenza lo que hizo nuestra aficion, somos la capital de la region y tenemos que dar ejemplo y a lo unico que parece que hemos ido a yecla a sido a romperles el campo, quemar contenedores y unos robaron jamones en un bar (vergonzoso). Tenemos que estar ogullosos de nuestro mucia que aunque nos joda estar en 2ºb y tengamos que venir a campos como estos hay que mostrar un po Soy de murcia y me da verguenza lo que hizo nuestra aficion, somos la capital de la region y tenemos que dar ejemplo y a lo unico que parece que hemos ido a yecla a sido a romperles el campo, quemar contenedores y unos robaron jamones en un bar (vergonzoso). Tenemos que estar ogullosos de nuestro mucia que aunque nos joda estar en 2ºb y tengamos que venir a campos como estos hay que mostrar un po
  • luis_xiv
    Actualizado hace 13 años (Creado hace 13 años ) luis_xiv dice: YECLANOS, YECLANAS desde aqui quiero mandaros un mensaje...

    GRACIAS por el partido GRACIAS por tirar balones fuera GRACIAS por perder timpo desde el finales de la segunda parte, GRACIAS por escupir GRACIAS por portaros como os habeis portado, sinceramente GRACIAS
    ahora estoy mas orgulloso de pertenecer a un club y una aficion que no hace todo eso, y que por lo tanto demuestra ser YECLANOS, YECLANAS desde aqui quiero mandaros un mensaje...

    GRACIAS por el partido GRACIAS por tirar balones fuera GRACIAS por perder timpo desde el finales de la segunda parte, GRACIAS por escupir GRACIAS por portaros como os habeis portado, sinceramente GRACIAS
    ahora estoy mas orgulloso de pertenecer a un club y una aficion que no hace todo eso, y que por lo tanto demuestra ser
  • sr_soze
    Actualizado hace 13 años (Creado hace 13 años ) sr_soze dice: Me ha dado vergüenza un sector de la aficion del Yeclano, porque no creo que todos sean asi, repito VERGÜENZA.
    Los linieres tenian la camiseta llena de escupitajos, tirando balones, y lo peor ha sido lo del penalty.

    Doy por bueno el empate y a seguir sumando para lograr el ascenso y espero que se salve el Yeclano

    Y que los animales que empiecen a comportarse como person Me ha dado vergüenza un sector de la aficion del Yeclano, porque no creo que todos sean asi, repito VERGÜENZA.
    Los linieres tenian la camiseta llena de escupitajos, tirando balones, y lo peor ha sido lo del penalty.

    Doy por bueno el empate y a seguir sumando para lograr el ascenso y espero que se salve el Yeclano

    Y que los animales que empiecen a comportarse como person
  • antononas
    Actualizado hace 13 años (Creado hace 13 años ) antononas dice: Bueno, todo este cabreo yeclanista no tiene más razón de ser el que se han quedado como farolillos rojos: los últimos del grupo 4, es decir, que van a ahorrar mucho en retrovisores. Bueno, todo este cabreo yeclanista no tiene más razón de ser el que se han quedado como farolillos rojos: los últimos del grupo 4, es decir, que van a ahorrar mucho en retrovisores.
  • Yeclanocampeon
    Hace 13 años Yeclanocampeon dice: incidenciasyeclanomurcia.blogspot.com/ incidenciasyeclanomurcia.blogspot.com/
  • Yeclanocampeon
    Hace 13 años Yeclanocampeon dice: incidenciasyeclanomurcia.blogspot.com/ incidenciasyeclanomurcia.blogspot.com/
  • Yeclanocampeon
    Hace 13 años Yeclanocampeon dice: incidenciasyeclanomurcia.blogspot.com/ incidenciasyeclanomurcia.blogspot.com/
  • Yeclanocampeon
    Hace 13 años Yeclanocampeon dice: BLOGS

    incidenciasyeclanomurcia.blogspot.com/...     BLOGS

    incidenciasyeclanomurcia.blogspot.com/...
  • Yeclanocampeon
    Hace 13 años Yeclanocampeon dice: He creado un blogs para comentar y denuciar las incidencias de derbi yeclano-real murcia.
    incidenciasyeclanomurcia.blogspot.com/

    Lo...     Murcianos quieren ocultar la noticia del mal comportamiento de los aficionados del Murcia, la prensa regional miente y defiende al Murcia.
    He creado un blogs para comentar y denuciar las incidencias de derbi yeclano-real murcia.
    incidenciasyeclanomurcia.blogspot.com/

    Lo...     Murcianos quieren ocultar la noticia del mal comportamiento de los aficionados del Murcia, la prensa regional miente y defiende al Murcia.
  • raulinhoyeclano
    Actualizado hace 13 años (Creado hace 13 años ) raulinhoyeclano dice: Bueno, hemos empatado contra el murcia aunke merecimos ganar porkte el murcia no tiro a puerta en todo el parido, solo el penalti. Decir a los murcianos lo ke cuentan ke nuestros aficionados tiraban el balon al campo ya habiendo otro balon eso ke yo sepa no es delito y el aficionado es libre de hacer lo ke kiera (excepto romper el mobiliario urbano cosa ke hacen vuestros aficionados) ya ke paga s Bueno, hemos empatado contra el murcia aunke merecimos ganar porkte el murcia no tiro a puerta en todo el parido, solo el penalti. Decir a los murcianos lo ke cuentan ke nuestros aficionados tiraban el balon al campo ya habiendo otro balon eso ke yo sepa no es delito y el aficionado es libre de hacer lo ke kiera (excepto romper el mobiliario urbano cosa ke hacen vuestros aficionados) ya ke paga s
  • raticule
    Hace 13 años raticule dice: Seores me da verguenza ajena parte de su aficion desplazada a yecla . se convirtio esta nuestra ciudad en un hervidero de borrachuzos anti-futbol , que solo sabian provocar y romper lo que se les ponia a su alcance.

    en cuanto a futbol su equipo demostro muy poco , pero bueno eso se puede mejorar , cosa que dudo mucho con (como he dicho antes)parte de su depravada aficion Seores me da verguenza ajena parte de su aficion desplazada a yecla . se convirtio esta nuestra ciudad en un hervidero de borrachuzos anti-futbol , que solo sabian provocar y romper lo que se les ponia a su alcance.

    en cuanto a futbol su equipo demostro muy poco , pero bueno eso se puede mejorar , cosa que dudo mucho con (como he dicho antes)parte de su depravada aficion
  • luis_xiv
    Actualizado hace 13 años (Creado hace 13 años ) luis_xiv dice: vaya tela, cartaclanos digo yeclanos, espero que esteis orgullosos de ese futbol de toque, esos pases mortales ese juego limpio y esa aficion de primera que teneis que se a dedicado a escupir y tirar balones al campo. vaya tela, cartaclanos digo yeclanos, espero que esteis orgullosos de ese futbol de toque, esos pases mortales ese juego limpio y esa aficion de primera que teneis que se a dedicado a escupir y tirar balones al campo.
  • Murciacapital
    Actualizado hace 13 años (Creado hace 13 años ) Murciacapital dice: Al final se ha hecho justicia, el Betis tendrá que ganar al Murcia si quiere ser líder de segunda b. Respecto al yecla como no se dediquen a jugar al Futbol descienden fijo, de todas formas
    Hoy se han empleado a fondo, claro venia el líder y es comprensible que se dejen la piel. Bueno puntito y mas líderes así se asciende en esta liga. Al final se ha hecho justicia, el Betis tendrá que ganar al Murcia si quiere ser líder de segunda b. Respecto al yecla como no se dediquen a jugar al Futbol descienden fijo, de todas formas
    Hoy se han empleado a fondo, claro venia el líder y es comprensible que se dejen la piel. Bueno puntito y mas líderes así se asciende en esta liga.
  • barrabas
    Hace 13 años barrabas dice: yeclanoct eres tonto con avaricia yeclanoct eres tonto con avaricia
‹ Primero ... ... página 1 2 3 4 5 6 7 8 9 > ... Último ›

Partido televisado en...
Canal Medio Idioma País
7 R Murcia TV Castellano

  USO DE MEMORIA  
6,461,168 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  0.1923
Total Execution Time  0.1933
  CADENA URL  
/partido/Yeclano/Real-Murcia/2011
  GET DATOS  
$_GET['/partido/Yeclano/Real-Murcia/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (49)  
0.0038   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` = '1103' AND c.`match_id` = '11932' AND c.comment_id IN (504452,505498,504557,504548,504945,507322,507321,507317,507314,507311,505639,506389,504503,504525,506002) GROUP BY c.comment_id
0.0063   SELECT c.*, c.stadium as real_stadium, 2011 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 calendars2011 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 = 'Yeclano' AND dt2.basealias = 'Real-Murcia'
0.0026  SELECT c.*, 2011 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 calendars2011 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 = 'Yeclano' AND dt2.basealias = 'Real-Murcia'
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 = 1103
0.0019   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2011 AS ev WHERE ev.match_id=11932 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=1103 WHERE dp.id IN (67869,36190,35965,30909,82922,30468,67875,67865,35420,27469,259645,67871,72565,35669,67883,31363,23939,27930,67887) AND (rp.team_id=25005 OR rp.team_id=25001)
0.0018   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2011 AS ev WHERE ev.match_id=11932 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=1103 WHERE dp.id IN (67869,35965,30909,36190,82922,30468,67875,67871,67883,31363,23939,35669,67865,27930,27469,35420,67887,259645,72565) AND (rp.team_id=25005 OR rp.team_id=25001)
0.0020  SELECT data1 FROM stats2011 t WHERE league_id = 1103 AND teamId = 25001 and type = 33
0.0023  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=11932 AND rdh.league_id=1103 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0019  SELECT kit FROM kit_data_real WHERE league_id = 1103 AND id_match = 11932
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '11932' and rp.type = 2011 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 = '11932' and rp.type = 2011 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 = 1103 AND rel.team1 = 25005 AND rel.team2 = 25001 ORDER BY FIELD(m.location,'es','en') DESC
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 11932 AND year = 2011 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 11932 AND year = 2011 AND channel = 'Footters' LIMIT 1
0.0020  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 = 1103 AND rel.team1 = 25005 AND rel.team2 = 25001 ORDER BY FIELD(m.location,'es','en') DESC
0.0019  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 = 1103 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0022  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 `calendars2011` 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` = 1103 AND c.`round` = 8 ORDER BY shedule ASC LIMIT 12
0.0022  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 `tables2011` 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 = 1103 AND t.round = 8 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 `tables2011` WHERE league_id = 1103 AND round >= 38 AND round <= 38 AND team = 25005 ORDER BY round ASC
0.0023  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 `tables2011` 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 = 1103 AND t.round = 38 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0030   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` = '1103' AND c.`match_id` = '11932' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
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 = '504452' 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 = '505498' 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 = '504557' 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 = '504548' 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 = '504945' 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 = '507322' 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 = '507321' 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 = '507317' 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 = '507314' 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 = '507311' 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 = '505639' 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 = '506389' 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 = '504503' 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 = '504525' 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 = '506002' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0025  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2011 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2011 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=2011 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 25005 AND c.team2 = 25001 AND c.league_id = 1103
0.0020  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='11932' AND `active` = 1 AND year = 2011
0.0018  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='11932' AND `active` = 1 AND year = 2011
0.0023  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='1103' AND relp.team_id=25005 WHERE relp.in_squad=1 and mp.`match_id` = '11932' AND mp.year='2011' ORDER BY mp.`team` ASC, p.`role` ASC
0.0024  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='1103' AND relp.team_id=25001 WHERE relp.in_squad=1 and mp.`match_id` = '11932' AND mp.year='2011' ORDER BY mp.`team` ASC, p.`role` ASC
0.0020  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '1103' AND id_match = '11932'
0.0019  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=11932 AND extraId = 1103 AND type_rel = 4
0.0021  SELECT rating1, rating2 FROM calendars_elo WHERE id=11932 AND league_id=1103 AND year=2011
0.0023  SELECT position FROM tables2011 WHERE team=25005 AND league_id=1103 AND round=8
0.0023  SELECT position FROM tables2011 WHERE team=25001 AND league_id=1103 AND round=8
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 11932 AND league_id = 1103 AND year = 2011