4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Deportivo Alavés - Barça Atlètic
Jornada 4
FINALIZADO
30
20
1226 Pts. Elo
10º

1148 Pts. Elo
4º

2-3
Sábado, 13 Septiembre 2014, 18:30
0 - 1
 13' Goku
0 - 2
 32' Manu García
0 - 3
 38' A. Grimaldo
Toti 72'
1 - 3
Juli 77'
2 - 3

Eventos del partido

Goles

minuto 13'GokuGol de Goku
minuto 32' Manu García Gol de (p.p)
Manu García
minuto 38'A. GrimaldoGol de falta A. Grimaldo
TotiGol de
Toti
minuto 72'
JuliGol de
Juli
minuto 77'

Tarjetas

minuto 13'GokuT. Amarilla Goku
minuto 38'A. GrimaldoT. Amarilla A. Grimaldo
Raúl CarneroT. Amarilla
Raúl Carnero
minuto 55'
LaguardiaT. Amarilla
Laguardia
minuto 60'
Unai MedinaT. Amarilla
Unai Medina
minuto 78'

Ocasiones

JuliPenalti fallado
Juli
minuto 88'

Cambios

Manu BarreiroSale del partido
Manu Barreiro
minuto 45'
JuliEntra en el partido
Juli
minuto 45'
R. DespotovicEntra en el partido
R. Despotovic
minuto 46'
TotiSale del partido
Toti
minuto 46'
RafaEntra en el partido
Rafa
minuto 60'
Manu GarcíaSale del partido
Manu García
minuto 60'

Otros

minuto 13'Adama TraoréAsistencia Adama Traoré
I. VélezAsistencia
I. Vélez
minuto 72'

Alineaciones

Deportivo Alavés

Deportivo Alavés

4-4-2
Alineación Inicial
Suplentes
Barça Atlètic

Barça Atlètic

4-5-1
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

Deportivo Alavés Deportivo Barça Atlètic Barça
45 Comentarios + 27 respuestas
‹ Primero ... ... página 1 2 3 > ... Último ›
  • sarucha
    Hace 9 años sarucha dice: Me quedo con la buena sensación que nos dio el Alavés. Les mueve un nuevo espíritu: No se rinden,se rehacen. una lástima el penalti fallido. Los que estuvimos en Mendizorroza lo pasamos bien. Si el árbitro hubiera pitado los dos penaltis, quizá ahora estariamos hablando de otra cosa. Ahora hay que ir a Zaragoza con ganas de ganar. TE QUIERO ALAVÉS
  • balicata
    Actualizado hace 9 años (Creado hace 9 años ) balicata dice: grande filial!!!
  • glorioso1990
    Actualizado hace 9 años (Creado hace 9 años ) glorioso1990 dice: Estoy muy orgulloso del equipo, con 0-3 hemos salido a remontar y creo que lo mereciamos,una pena el penalti pero eso por lo menos tiene que ir a porteria...., a por el Zaragoza AUPA ALAVESSSS
  • antonox
    Hace 9 años antonox dice: Una pena la derrota, pero animos al Alaves desde Jaen.
  • jooon
    Hace 9 años jooon dice:
    Mi pronóstico para el partido en La Porra es 1-5:

    "los 5 de dognu"
  • Hace 9 años natalbacete dice: goooooooooooooooool
  • patatero
    Actualizado hace 9 años (Creado hace 9 años ) patatero dice: Otra vez 2-3, otra vez el Farsa B, otra vez después de un partido de copa....esperemos que lo que venga no sea lo mismo que lo que vino el año pasado. la verdad es que teníamos una bonita oportunidad para meternos arriba de inicio pero, honestamente, el filial blaugrana nos ha pintado la cara como ha querido en los primeros 45 minutos. la prueba de que solo con cojones no se ganan partidos, como pollos sin cabeza nosotros. quizás haya sido un error haber salido con 2 puntas en vez de con más gente en el centro del campo, nos han bailado en el manejo del centro como han querido. en la 2ª parte
  • lopeziego
    Hace 9 años lopeziego dice: Me gustaria conocer las opiniones del alavesismo y que me deis un sistema y un once:
    4-2-3-1
    Manu - Medina / Laguardia / Migue / R.Garcia - Beobide / Toribio - Toti / Juli /Sangalli - Velez

    La razón por la que pongo a Beobide es porque aunque Manu me encanta su espiritu, garra y sacrificio, le veo un poco lento de pensamientos y ultimamanete pierde balones tontos, en cuanto a la delantera estoy de acuerdo en que Barreiro tiene mucha calidad, pero para mi Velez lo tiene todo y representa lo que es este equipo, pura pelea. A tejera lo siento pero con esos 3 no le encuentro
  • gol_alex
    Actualizado hace 9 años (Creado hace 9 años ) gol_alex dice: Quiero felicitar al Alaves que ha tenido lo que muchos equipos no tendrían después de recibir 3 goles en la primera mitad, que es reaccion, de verdad han tenido una segunda mitad buena. Ustedes seguidores del Alaves deben sentirse orgullosos de su equipo, y pensar en grande para esta temporada. Un saludo a todos!
  • lopeziego
    Hace 9 años lopeziego dice: Y de paso preguntaros que os ha parecido el debut de nuestro ultimo fichaje, Rafa Garcia, que pensais que puede apostar al equipo
  • alavesitoj
    Actualizado hace 9 años (Creado hace 9 años ) alavesitoj dice: Sin intención de quitarle merito al Barc,a .yo creo que se le ha aparecido la virgen .Bravo por nuestro GLORIOSO, así creo que la afición disfrutará este año si se ponen los "huevos " de hoy. una pena lo del penalty,lo siento por Juli que con lo que lucha había merecido entrar.Quizá alguna laguna en el primer tiempo, pero compensado con el 2º que casi lo hemos bordado, una pena el resultado.En fin otra vez será, si seguimos con la implcación de la 2ª parte conseguiremos grandes logros.GORA GLORIOSO y fuerza a nuestra AFICION
  • adurtza
    Hace 9 años adurtza dice: ORGULLOSOS DE ESTE EQUIPO!!! FUTBOL CON GARRA Y ACTITUD !! SOBRE TODO EN LA SEGUNDA PARTE. COMO OPINION PERSONAL, PARA EL FUTBOL QUE PRACTICA NUESTRO ALAVES, BARREIRO RALENTIZA MUCHO EL JUEGO, EL FUTBOL DE PATADON DESDE LA DEFENSA BUSCANDOLE NO FUNCIONA . MEJOR MUCHO MEJOR LA SEGUNDA PARTE SIN EL.
  • betty123
    Hace 9 años betty123 dice: partido bonito y de una parte para cada equipo.el empate seria lo mas justo sin duda...pero esto es futbol y hay que meter las ocasiones....esto hace que tengamos que puntuar en la romareda y despues sacar 4 puntos en los 2 partidos de casa....una anecdota el traspaso de un jugador del barca b vale como toda la plantilla del alaves....tela, nunca mejor dicho
  • chaba
    Hace 9 años chaba dice: Para mí el equipo como digo ha estado muy bien todo el tiempo y mejor todavía la segunda parte por eso no creo que se repita lo del año pasado y si por lo menos los puntos para la permanencia en la segunda.
    Creo que este año a este equipo no se le va a ganar tan fácilmente y el que lo haga sudara sangre y lagrimas para llevarse la victoria la prueba hoy.
    Aúpa Alavés este año si.
  • chaba
    Hace 9 años chaba dice: Pues yo para ser sincero creo que el Alavés ha hecho un buen partido tanto en la primera como en la segunda parte pero con la diferencia que la calidad de los jugadores del Barca B para mi ha sido excelente y en la que los tres goles que hemos recibido del Barca B ha sido fruto de la calidad que tienen pero en el que han cometido un gran error dejarnos totalmente el balón y el Alavés ya se sabe cuando le hecha garra como le ha echado y con un par de .......y con el empuje de la afición se pudo haber empatado e incluso ganado.
‹ Primero ... ... página 1 2 3 > ... Último ›

Partido televisado en...
Canal Medio Idioma País
ETB1ETB1 TV Castellano es
Esport 3Esport 3 TV Castellano es
La Liga TVLa Liga TV TV Castellano es

  USO DE MEMORIA  
6,455,632 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0009
Controller Execution Time ( Match / Index )  4.0482
Total Execution Time  4.0491
  CADENA URL  
/partido/Alaves/Barcelona-B/2015
  GET DATOS  
$_GET['/partido/Alaves/Barcelona-B/2015']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (59)  
0.0081   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` = '3803' AND c.`match_id` = '20088' AND c.comment_id IN (3166369,3155240,3152638,3162785,3150943,3151870,3152803,3154523,3154024,3154560,3152983,3155329,3155050,3154361,3154258) GROUP BY c.comment_id
0.0172   SELECT c.*, c.stadium as real_stadium, 2015 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 calendars2015 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 = 'Alaves' AND dt2.basealias = 'Barcelona-B'
0.0135  SELECT c.*, 2015 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 calendars2015 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 = 'Alaves' AND dt2.basealias = 'Barcelona-B'
0.0253  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 = 3803
0.0126   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2015 AS ev WHERE ev.match_id=20088 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.0129   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=3803 WHERE dp.id IN (138564,28993,118948,27187,61591,59865,34097,30784,54624,4310,37970,147301,29983) AND (rp.team_id=69905 OR rp.team_id=69912)
0.0126   SELECT ev.id AS event_id, ev.player_id, ev.action, ev.minute, ev.teamId AS event_teamId FROM events2015 AS ev WHERE ev.match_id=20088 ORDER BY ev.minute ASC, ev.real_date ASC, ev.id DESC
0.0128   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=3803 WHERE dp.id IN (138564,147301,28993,118948,54624,61591,4310,27187,59865,37970,34097,29983,30784) AND (rp.team_id=69905 OR rp.team_id=69912)
0.0125  SELECT data1 FROM stats2015 t WHERE league_id = 3803 AND teamId = 69905 and type = 33
0.0130  SELECT data1 FROM stats2015 t WHERE league_id = 3803 AND teamId = 69912 and type = 33
0.0126  SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 3803 AND id_match = 20088
0.0131  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='3803' AND relp.team_id = drea.team_id WHERE rel.team_number=2435018 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0131  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='3803' AND relp.team_id = drea.team_id WHERE rel.team_number=2435017 GROUP BY dp.id ORDER BY role ASC, pos ASC
0.0149  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='3803' AND relp.team_id=69905 WHERE mp.`match_id` = '20088' AND mp.year='2015' AND p.id NOT IN (107188,139210,147304,118948,81647,125858,145261,179464,138564,147301,81659,32679,34097,27374,59865,30784,28993,32855,27187,108413,29983,54624) ORDER BY mp.`team` ASC, p.`role` ASC
0.0169  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='3803' AND relp.team_id=69912 WHERE mp.`match_id` = '20088' AND mp.year='2015' AND p.id NOT IN (107188,139210,147304,118948,81647,125858,145261,179464,138564,147301,81659,32679,34097,27374,59865,30784,28993,32855,27187,108413,29983,54624) ORDER BY mp.`team` ASC, p.`role` ASC
0.0136  SELECT kit FROM kit_data_real WHERE league_id = 3803 AND id_match = 20088
0.0134  SELECT p.* FROM `pictures` as p INNER JOIN `rel_pictures` as rp ON p.id = rp.id_picture WHERE rp.id_content = '20088' and rp.type = 2015 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0136  SELECT p.* FROM `videos` as p INNER JOIN `rel_videos` as rp ON p.id = rp.id_video WHERE rp.id_content = '20088' and rp.type = 2015 and p.revised = 1 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 16
0.0148  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 = 3803 AND rel.team1 = 69905 AND rel.team2 = 69912 ORDER BY FIELD(m.location,'es','en') DESC
0.0129  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 20088 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0127  SELECT iframe, title FROM futbol.match_videos WHERE matchId = 20088 AND year = 2015 AND channel = 'Footters' LIMIT 1
0.0136  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 = 3803 AND rel.team1 = 69905 AND rel.team2 = 69912 ORDER BY FIELD(m.location,'es','en') DESC
0.0127  SELECT teamId FROM teams WHERE id = 69912
0.0128  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2015 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2015 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 = 430 OR c.datateam2 = 430) ORDER BY shedule DESC LIMIT 10
0.0146  SELECT teamId FROM teams WHERE id = 69912
0.0146  SELECT c.id,c.r1,r2,c.shedule,comments,c.team1,c.team2,c.datateam1,c.datateam2,c.league_id,2015 as year,dt1.basealias as basealias1,dt2.basealias as basealias2,dt1.nameShow as team1_name,dt2.nameShow as team2_name, c.extra FROM calendars2015 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 = 430 OR c.datateam2 = 430) ORDER BY shedule ASC LIMIT 10
0.0129  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 `calendars2015` 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` = 3803 AND c.`round` = 4 ORDER BY shedule ASC LIMIT 12
0.0136  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 `tables2015` 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 = 3803 AND t.round = 4 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0176  SELECT points,gf,ga,win_h,win_a,draw_h,draw_a,lose_h,lose_a FROM `tables2015` WHERE league_id = 3803 AND round >= 42 AND round <= 42 AND team = 69905 ORDER BY round ASC
0.0130  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 `tables2015` 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 = 3803 AND t.round = 42 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC
0.0129   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` = '3803' AND c.`match_id` = '20088' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0126   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 = '3166369' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '3155240' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '3152638' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130   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 = '3162785' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0141   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 = '3150943' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0137   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 = '3151870' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0137   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 = '3152803' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0133   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 = '3154523' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0137   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 = '3154024' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0133   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 = '3154560' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0130   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 = '3152983' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0128   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 = '3155329' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0126   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 = '3155050' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0177   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 = '3154361' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0125   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 = '3154258' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20
0.0125  SELECT dr.name as showName, dr2.name as referee_var FROM calendars2015 as c INNER JOIN rel_calendars_referee as r ON c.id = r.match_id and r.year=2015 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=2015 and r2.role=2 INNER JOIN datareferees dr2 on dr2.id=r2.referee_id WHERE c.team1 = 69905 AND c.team2 = 69912 AND c.league_id = 3803
0.0136  SELECT `id`, `text` FROM `matchs_news_keys` WHERE `match_id`='20088' AND `active` = 1 AND year = 2015
0.0137  SELECT `id`, `text`, `link`, `media` FROM `matchs_news_headlines` WHERE `match_id`='20088' AND `active` = 1 AND year = 2015
0.0126  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='3803' AND relp.team_id=69905 WHERE relp.in_squad=1 and mp.`match_id` = '20088' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0127  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='3803' AND relp.team_id=69912 WHERE relp.in_squad=1 and mp.`match_id` = '20088' AND mp.year='2015' ORDER BY mp.`team` ASC, p.`role` ASC
0.0126  SELECT id, team_id FROM dreamteam_data_real WHERE league_id = '3803' AND id_match = '20088'
0.0125   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 = '2435018' ORDER BY rating DESC LIMIT 1
0.0125   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 = '2435017' ORDER BY rating DESC LIMIT 1
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=20088 AND extraId = 3803 AND type_rel = 4
0.0125  SELECT rating1, rating2 FROM calendars_elo WHERE id=20088 AND league_id=3803 AND year=2015
0.0125  SELECT position FROM tables2015 WHERE team=69905 AND league_id=3803 AND round=4
0.0125  SELECT position FROM tables2015 WHERE team=69912 AND league_id=3803 AND round=4
0.0125  SELECT * FROM futbol.calendars_lineups WHERE id = 20088 AND league_id = 3803 AND year = 2015