4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
UD Melilla - AgD Ceuta
Jornada 18
FINALIZADO
20
30
732 Pts. Elo
8º

813 Pts. Elo
4º

0-2
Domingo, 19 Diciembre 2010, 12:00
0 - 1
 52' Sandro Mendes
0 - 2
 83' Guzmán Casaseca

Eventos del partido

Goles

minuto 52'Sandro MendesGol de Sandro Mendes
minuto 83'Guzmán CasasecaGol de Guzmán Casaseca

Tarjetas

Carlos RuizT. Amarilla
Carlos Ruiz
minuto 29'
minuto 30'MansillaT. Amarilla Mansilla
minuto 54'Pepe MartinezT. Amarilla Pepe Martinez
minuto 81'VillatoroT. Amarilla Villatoro
ZamoranoT. Amarilla
Zamorano
minuto 82'

Cambios

minuto 61'CañasEntra en el partido Cañas
minuto 61'Pepe MartinezSale del partido Pepe Martinez
Nacho AznarEntra en el partido
Nacho Aznar
minuto 67'
EnguixSale del partido
Enguix
minuto 67'
minuto 75'J. BerrocalEntra en el partido J. Berrocal
minuto 75'David TorresSale del partido David Torres

Alineaciones

UD Melilla

UD Melilla

4-4-2
Alineación Inicial
Suplentes
AgD Ceuta

AgD Ceuta

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

UD Melilla UD Melilla AgD Ceuta AgD Ceuta
225 Comentarios + 77 respuestas
‹ Primero ... ... página 1 2 3 4 5 6 7 ... 14 15 > ... Último ›
  • isimelilla
    Hace 13 años isimelilla dice: el melilla tiene 2 partidos fuera de casa, que mal se nos puede poner la clasificacion si no conseguimos sacar aunque sea un empate, porque a este equipillo que nos han hecho con el dinero de todos no se puede pedir nada más. Nos espera el San Roque . el melilla tiene 2 partidos fuera de casa, que mal se nos puede poner la clasificacion si no conseguimos sacar aunque sea un empate, porque a este equipillo que nos han hecho con el dinero de todos no se puede pedir nada más. Nos espera el San Roque .
  • melillense
    Hace 13 años melillense dice: señores no nos engañemos mas,esto es lo que hay,no hay otra cosa,terminar la temporada en mitad de la tabla y san seacabo,no hay mas cera de la que arde,mantenernos y la temporada que viene dios dira,lo mismo digo al melilla baloncesto,no tiene ni la mitad de equipo que tuvo la temporada pasada,solo le pido al bueno de gonzalo garcia de vitoria que ganemos 12 partidos para salvarnos matematicame señores no nos engañemos mas,esto es lo que hay,no hay otra cosa,terminar la temporada en mitad de la tabla y san seacabo,no hay mas cera de la que arde,mantenernos y la temporada que viene dios dira,lo mismo digo al melilla baloncesto,no tiene ni la mitad de equipo que tuvo la temporada pasada,solo le pido al bueno de gonzalo garcia de vitoria que ganemos 12 partidos para salvarnos matematicame
  • javichu123
    Hace 13 años javichu123 dice: No me ha dolito esta derrota tanto como la del Roquetsa,pues el Ceuta es un equipo hecho para ascender,y por supuesto este no es el camino,asi probablemente nos olvidemos siquiera de jugar liguilla pues ya hay 4 equipos muy preclaros para ello.
    Lo que podriamos hacer es echar a Tebar y traernos a un entrenador de 1ª. No me ha dolito esta derrota tanto como la del Roquetsa,pues el Ceuta es un equipo hecho para ascender,y por supuesto este no es el camino,asi probablemente nos olvidemos siquiera de jugar liguilla pues ya hay 4 equipos muy preclaros para ello.
    Lo que podriamos hacer es echar a Tebar y traernos a un entrenador de 1ª.
  • sufian
    Hace 13 años sufian dice: Tebar fueraa yaa joder!!! Tebar fueraa yaa joder!!!
  • melillacefe
    Hace 13 años melillacefe dice: No nos queda otro remedio que confiar en el equipo. También a principios de temporada la cosa estaba floja y en unas cuantas jornadas nos pusimos en puestos de play-off. Y encima llegamos a presenciar uno de los mejores encuentros que yo recuerde en Alvarez Claro 4 / 4 frente al Sevilla At._____________________ _Así que esto debe cambiar y retomar el buen rumbo que llevábamos.____________ _ La v No nos queda otro remedio que confiar en el equipo. También a principios de temporada la cosa estaba floja y en unas cuantas jornadas nos pusimos en puestos de play-off. Y encima llegamos a presenciar uno de los mejores encuentros que yo recuerde en Alvarez Claro 4 / 4 frente al Sevilla At._____________________ _Así que esto debe cambiar y retomar el buen rumbo que llevábamos.____________ _ La v
  • socotoro
    Hace 13 años socotoro dice: decepcion del melilla ,este equipo es muy irregular ,hoy no ha hecho nada de importancia,no se le puede negar el trabajo,pero ante un ceuta muy fisico y ordenado ha faltado profundidad veo a algunos jugadores bastante bajo.andres ramos,enguix, se ha notado la falta de vazquez,pero bueno esperemos que resurja el melilla de este gran bache,si puede que se refuerce con un delantero que el melilla ha decepcion del melilla ,este equipo es muy irregular ,hoy no ha hecho nada de importancia,no se le puede negar el trabajo,pero ante un ceuta muy fisico y ordenado ha faltado profundidad veo a algunos jugadores bastante bajo.andres ramos,enguix, se ha notado la falta de vazquez,pero bueno esperemos que resurja el melilla de este gran bache,si puede que se refuerce con un delantero que el melilla ha
  • CANTARRANAS
    Hace 13 años CANTARRANAS dice: Vaya decepcion. este entrenador ha ido de listo pensando que iva a descubrir la polvora.
    si una cosa va bien por que cambiarla?. este seor ha sido un inconciente cambiando el 70 % de una plantilla que funcionaba de maravilla y que posiblemente tendran que transcurrir otros 15 aos para poderla ver, un trabajo que inicio pastelero y que andres garcia tebar le puso la guinda, y ahora coge y se Vaya decepcion. este entrenador ha ido de listo pensando que iva a descubrir la polvora.
    si una cosa va bien por que cambiarla?. este seor ha sido un inconciente cambiando el 70 % de una plantilla que funcionaba de maravilla y que posiblemente tendran que transcurrir otros 15 aos para poderla ver, un trabajo que inicio pastelero y que andres garcia tebar le puso la guinda, y ahora coge y se
  • toromelilla
    Hace 13 años toromelilla dice: el entrenador de melilla ostenta todo los poderes de la direccion tecnica.........tipo ferguson en el manchester. el entrenador de melilla ostenta todo los poderes de la direccion tecnica.........tipo ferguson en el manchester.
  • LoboAfricano
    Actualizado hace 13 años (Creado hace 13 años ) LoboAfricano dice: El resultado es justo, el Melilla tuvo una gran ocasión quedándose sólo e numero 10 con el portero y la tira fuera y mal, desde ese momento ya no tuvo ocasiones y ademas jugó muy mal, muchos fallos, patadón arriba y así no se puede jugar al futbolo ni mucho menos ganar un partido como es contra un equipo sólido como es el Ceuta, mucho tiene que cambiar éste Melilla si quiere estar ahí arriba y Ju El resultado es justo, el Melilla tuvo una gran ocasión quedándose sólo e numero 10 con el portero y la tira fuera y mal, desde ese momento ya no tuvo ocasiones y ademas jugó muy mal, muchos fallos, patadón arriba y así no se puede jugar al futbolo ni mucho menos ganar un partido como es contra un equipo sólido como es el Ceuta, mucho tiene que cambiar éste Melilla si quiere estar ahí arriba y Ju
  • granadacf
    Actualizado hace 13 años (Creado hace 13 años ) granadacf dice: alguien del ceuta como esta este año berrocal? alguien del ceuta como esta este año berrocal?
  • muxomelilla
    Hace 13 años muxomelilla dice: enhorabuena al ceuta por la victoria merecidisima,estais haciendo una temporada extraordinaria!! seguid asi!!Nosotros tenemos que reflexionar el porque el Alvarez Claro ya no es el fortin de antaño!!. enhorabuena al ceuta por la victoria merecidisima,estais haciendo una temporada extraordinaria!! seguid asi!!Nosotros tenemos que reflexionar el porque el Alvarez Claro ya no es el fortin de antaño!!.
  • ML5757
    Actualizado hace 13 años (Creado hace 13 años ) ML5757 dice: www.rtvce.es/ www.rtvce.es/
  • gesaceuta
    Hace 13 años gesaceuta dice: no me lo puedo creer el ceuta gana en melilla ya e leido el comentario de lobo ,ha echo efecto el cambio de entrenador suerte al melilla no me lo puedo creer el ceuta gana en melilla ya e leido el comentario de lobo ,ha echo efecto el cambio de entrenador suerte al melilla
  • isimelilla
    Hace 13 años isimelilla dice: bueno ya estoy cansado de este cantamañanas que se dedica a denunciar abusos cuando ..se opina que no gusta el equipo, o la directva y alguna cosa más. el melilla de esta temporada es para media tabla, te guste o no porque estamos pagando la incompetencia de un presidente y de su junta y la incompetencia de su entrenador, vale.
    Una pregunta el despido de los jugadores que largaron porque no bueno ya estoy cansado de este cantamañanas que se dedica a denunciar abusos cuando ..se opina que no gusta el equipo, o la directva y alguna cosa más. el melilla de esta temporada es para media tabla, te guste o no porque estamos pagando la incompetencia de un presidente y de su junta y la incompetencia de su entrenador, vale.
    Una pregunta el despido de los jugadores que largaron porque no
  • negro_8
    Hace 13 años negro_8 dice: Teniamos que haber seguido la dinamica de la 1º parte, y el gol del ceuta tan pronto nos ha desbaratado la jugada. ya a 6 puntos del ceuta Teniamos que haber seguido la dinamica de la 1º parte, y el gol del ceuta tan pronto nos ha desbaratado la jugada. ya a 6 puntos del ceuta
‹ Primero ... ... página 1 2 3 4 5 6 7 ... 14 15 > ... Último ›


  USO DE MEMORIA  
6,191,872 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0010
Controller Execution Time ( Match / Index )  0.2466
Total Execution Time  0.2476
  CADENA URL  
/partido/Melilla/Ad-Ceuta/2011
  GET DATOS  
$_GET['/partido/Melilla/Ad-Ceuta/2011']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (47)  
0.0177   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` = '12233' AND c.comment_id IN (652218,651514,644167,643869,643656,643503,642864,642823,641728,642551,641977,641519,641844,641821,641707) GROUP BY c.comment_id
0.0078   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 = 'Melilla' AND dt2.basealias = 'Ad-Ceuta'
0.0030  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 = 'Melilla' AND dt2.basealias = 'Ad-Ceuta'
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=12233 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.0028   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 (258430,29059,35562,17003,196910,35361,259999,29272,34330,257971,27561,36158) AND (rp.team_id=25014 OR rp.team_id=25013)
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=12233 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0024   SELECT dp.id AS player_id, dp.nick, dp.alias, dp.name, dp.last_name, rp.team_id, rp.teamId, rp.squadNumber AS num FROM dataplayers AS dp INNER JOIN rel_players AS rp ON dp.id=rp.player_id AND league_id=1103 WHERE dp.id IN (35562,17003,258430,196910,29272,34330,257971,27561,36158,35361,259999,29059) AND (rp.team_id=25014 OR rp.team_id=25013)
0.0019  SELECT data1 FROM stats2011 t WHERE league_id = 1103 AND teamId = 25013 and type = 33
0.0025  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=12233 AND rdh.league_id=1103 ORDER BY rdh.team ASC, rdh.pos ASC, dp.nick ASC
0.0020  SELECT kit FROM kit_data_real WHERE league_id = 1103 AND id_match = 12233
0.0019  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '12233' 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 = '12233' and rp.type = 2011 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
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='10' AND rel.active = 1 AND rel.league_id = 1103 AND rel.team1 = 25014 AND rel.team2 = 25013 ORDER BY FIELD(m.location,'es','en') DESC
0.0019  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12233 AND year = 2011 AND channel = 'Footters' LIMIT 1
0.0018  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 12233 AND year = 2011 AND channel = 'Footters' LIMIT 1
0.0023  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 = 25014 AND rel.team2 = 25013 ORDER BY FIELD(m.location,'es','en') DESC
0.0026  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` = 18 ORDER BY shedule ASC LIMIT 12
0.0026  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 = 18 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0020  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 = 25014 ORDER BY round ASC
0.0028  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.0041   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` = '12233' 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 = '652218' 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 = '651514' 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 = '644167' 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 = '643869' 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 = '643656' 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 = '643503' 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 = '642864' 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 = '642823' 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 = '641728' 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 = '642551' 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 = '641977' 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 = '641519' 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 = '641844' 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 = '641821' 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 = '641707' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0033  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 = 25014 AND c.team2 = 25013 AND c.league_id = 1103
0.0023  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='12233' AND `active` = 1 AND year = 2011
0.0021  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='12233' AND `active` = 1 AND year = 2011
0.0053  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=25014 WHERE relp.in_squad=1 and mp.`match_id` = '12233' AND mp.year='2011' ORDER BY mp.`team` ASC, p.`role` ASC
0.0046  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=25013 WHERE relp.in_squad=1 and mp.`match_id` = '12233' AND mp.year='2011' ORDER BY mp.`team` ASC, p.`role` ASC
0.0023  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '1103' AND id_match = '12233'
0.0021  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12233 AND extraId = 1103 AND type_rel = 4
0.0022  SELECT rating1, rating2 FROM calendars_elo WHERE id=12233 AND league_id=1103 AND year=2011
0.0033  SELECT position FROM tables2011 WHERE team=25014 AND league_id=1103 AND round=18
0.0030  SELECT position FROM tables2011 WHERE team=25013 AND league_id=1103 AND round=18
0.0019  SELECT * FROM futbol.calendars_lineups WHERE id = 12233 AND league_id = 1103 AND year = 2011