4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Imagen de Olimpic Xátiva

Rafa Gimeno

Jugador del Olimpic Xátiva
Liga
  • Competición
  • Partidos jugados
  • Minutos jugados
  • Asistencia
  • Goles marcados
  • Tarjetas amarillas
  • Tarjetas rojas
  • info
Ficha de Rafa Gimeno
Nacionalidad
España
Nombre
Rafael Gimeno Miravalls
Edad
37 Años (01-07-1986)
Altura
182
Dorsal
18
Peso
75 kilogramos
Equipo
Olimpic Xátiva
Posición
Defensa
Liga
Tercera Federación 2022 G 6
Compañeros de equipo
Fotos
2
  • Foto principal de Rafa Gimeno | Ontinyent CF
  • Rafa
1 Comentarios
  • udalzira
    Hace 13 años udalzira dice: Su nombre deportivo es Rafa Gimeno. Lleva el nº 18 Su nombre deportivo es Rafa Gimeno. Lleva el nº 18

  USO DE MEMORIA  
7,902,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Player / Index )  2.1528
Total Execution Time  2.1539
  CADENA URL  
/jugador/rafa-gimeno-28141
  GET DATOS  
$_GET['/jugador/rafa-gimeno-28141']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (132)  
0.0003   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.`playerId` = '28141' AND c.comment_id IN (660086) GROUP BY c.comment_id
0.0151  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id AND rp.year = 2024 INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'rafa-gimeno-28141' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0360  SELECT p.*,rp.*,dt.*,p.id as playerId,c.Name,'' as buy_url, p.twitter AS player_twitter FROM `dataplayers` p INNER JOIN `rel_players` rp ON rp.player_id = p.id INNER JOIN `datateams` dt ON dt.id = rp.teamId LEFT JOIN country c ON c.code2 = p.CountryCode INNER JOIN categories AS ct ON rp.category_id=ct.id WHERE p.alias = 'rafa-gimeno-28141' ORDER BY rp.year DESC, ct.troncal DESC, rp.in_squad DESC
0.0150  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 = 50274
0.0150  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 = 38808
0.0151  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 = 41169
0.0151  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 = 33904
0.0151  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 = 15447
0.0150  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 = 27283
0.0150  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 = 3916
0.0150  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 = 2556
0.0150  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 = 3674
0.0150  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 = 1946
0.0150  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 = 2340
0.0150  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 = 1413
0.0152  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 = 1104
0.0154  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 = 967
0.0146  SELECT man.action_value, man.stocks, man.sparks, man.points, man.variation, man.valor, man.ini_valor, man.wage FROM games.manager_players man WHERE man.playerId = '28141'
0.0178  SELECT p.id,p.nick,p.role,p.side,p.alias,rp.squadNumber FROM `rel_players` rp INNER JOIN `dataplayers` p ON p.id = rp.player_id WHERE rp.league_id = 62390 AND rp.teamId = 1854 AND rp.in_squad=1 ORDER BY p.role>0 DESC, p.role ASC, rp.squadNumber ASC
0.0163  SELECT t.nameShow,t.basealias,rp.year,c.name FROM `rel_players` rp INNER JOIN `datateams` t ON t.id = rp.teamId INNER JOIN categories c ON c.id = rp.category_id WHERE rp.player_id = 28141 ORDER BY rp.year DESC
0.0154  SELECT p.* FROM `rel_pictures` as rp INNER JOIN `pictures` as p ON p.id = rp.id_picture INNER JOIN fa_user u ON u.id = p.author_id WHERE rp.id_content = '28141' and rp.type = 3 GROUP BY p.id ORDER BY p.id DESC LIMIT 0, 18
0.0151  SELECT count(id_content) as cuenta FROM `rel_pictures` as rp WHERE rp.id_content = '28141' and rp.type = 3
0.0153  SELECT e.* FROM `events2022` e WHERE e.player_id = 28141 AND league_id = 62390 ORDER BY e.date ASC
0.0225  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 62390 AND rel.player_id=28141
0.0150  SELECT action,minute FROM events2022 WHERE player_id = 28141 AND league_id = 62390 AND action = 18
0.0150  SELECT action,minute FROM events2022 WHERE player_id = 28141 AND league_id = 62390 AND action = 19
0.0145  SELECT e.* FROM `events2022` e WHERE e.player_id = 28141 AND league_id = 64171 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 64171 AND rel.player_id=28141
0.0145  SELECT action,minute FROM events2022 WHERE player_id = 28141 AND league_id = 64171 AND action = 18
0.0148  SELECT action,minute FROM events2022 WHERE player_id = 28141 AND league_id = 64171 AND action = 19
0.0147  SELECT e.* FROM `events2021` e WHERE e.player_id = 28141 AND league_id = 58584 ORDER BY e.date ASC
0.0163  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 58584 AND rel.player_id=28141
0.0154  SELECT action,minute FROM events2021 WHERE player_id = 28141 AND league_id = 58584 AND action = 18
0.0155  SELECT action,minute FROM events2021 WHERE player_id = 28141 AND league_id = 58584 AND action = 19
0.0147  SELECT e.* FROM `events2021` e WHERE e.player_id = 28141 AND league_id = 61791 ORDER BY e.date ASC
0.0157  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 61791 AND rel.player_id=28141
0.0153  SELECT action,minute FROM events2021 WHERE player_id = 28141 AND league_id = 61791 AND action = 18
0.0150  SELECT action,minute FROM events2021 WHERE player_id = 28141 AND league_id = 61791 AND action = 19
0.0152  SELECT e.* FROM `events2020` e WHERE e.player_id = 28141 AND league_id = 50274 ORDER BY e.date ASC
0.0180  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 50274 AND rel.player_id=28141
0.0151  SELECT action,minute FROM events2020 WHERE player_id = 28141 AND league_id = 50274 AND action = 18
0.0149  SELECT action,minute FROM events2020 WHERE player_id = 28141 AND league_id = 50274 AND action = 19
0.0147  SELECT e.* FROM `events2019` e WHERE e.player_id = 28141 AND league_id = 44394 ORDER BY e.date ASC
0.0161  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 44394 AND rel.player_id=28141
0.0153  SELECT action,minute FROM events2019 WHERE player_id = 28141 AND league_id = 44394 AND action = 18
0.0155  SELECT action,minute FROM events2019 WHERE player_id = 28141 AND league_id = 44394 AND action = 19
0.0148  SELECT e.* FROM `events2019` e WHERE e.player_id = 28141 AND league_id = 43475 ORDER BY e.date ASC
0.0231  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 43475 AND rel.player_id=28141
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 28141 AND league_id = 43475 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 28141 AND league_id = 43475 AND action = 19
0.0145  SELECT e.* FROM `events2019` e WHERE e.player_id = 28141 AND league_id = 49761 ORDER BY e.date ASC
0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 49761 AND rel.player_id=28141
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 28141 AND league_id = 49761 AND action = 18
0.0145  SELECT action,minute FROM events2019 WHERE player_id = 28141 AND league_id = 49761 AND action = 19
0.0147  SELECT e.* FROM `events2018` e WHERE e.player_id = 28141 AND league_id = 38808 ORDER BY e.date ASC
0.0173  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 38808 AND rel.player_id=28141
0.0166  SELECT action,minute FROM events2018 WHERE player_id = 28141 AND league_id = 38808 AND action = 18
0.0164  SELECT action,minute FROM events2018 WHERE player_id = 28141 AND league_id = 38808 AND action = 19
0.0146  SELECT e.* FROM `events2018` e WHERE e.player_id = 28141 AND league_id = 41169 ORDER BY e.date ASC
0.0149  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 41169 AND rel.player_id=28141
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 28141 AND league_id = 41169 AND action = 18
0.0145  SELECT action,minute FROM events2018 WHERE player_id = 28141 AND league_id = 41169 AND action = 19
0.0146  SELECT e.* FROM `events2017` e WHERE e.player_id = 28141 AND league_id = 33380 ORDER BY e.date ASC
0.0159  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33380 AND rel.player_id=28141
0.0151  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 33380 AND action = 18
0.0149  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 33380 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 28141 AND league_id = 30386 ORDER BY e.date ASC
0.0162  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 30386 AND rel.player_id=28141
0.0148  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 30386 AND action = 18
0.0149  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 30386 AND action = 19
0.0149  SELECT e.* FROM `events2017` e WHERE e.player_id = 28141 AND league_id = 33904 ORDER BY e.date ASC
0.0182  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 33904 AND rel.player_id=28141
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 33904 AND action = 18
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 33904 AND action = 19
0.0145  SELECT e.* FROM `events2017` e WHERE e.player_id = 28141 AND league_id = 37067 ORDER BY e.date ASC
0.0149  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 37067 AND rel.player_id=28141
0.0146  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 37067 AND action = 18
0.0145  SELECT action,minute FROM events2017 WHERE player_id = 28141 AND league_id = 37067 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 28141 AND league_id = 15447 ORDER BY e.date ASC
0.0158  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 15447 AND rel.player_id=28141
0.0150  SELECT action,minute FROM events2016 WHERE player_id = 28141 AND league_id = 15447 AND action = 18
0.0149  SELECT action,minute FROM events2016 WHERE player_id = 28141 AND league_id = 15447 AND action = 19
0.0146  SELECT e.* FROM `events2016` e WHERE e.player_id = 28141 AND league_id = 27283 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 27283 AND rel.player_id=28141
0.0146  SELECT action,minute FROM events2016 WHERE player_id = 28141 AND league_id = 27283 AND action = 18
0.0148  SELECT action,minute FROM events2016 WHERE player_id = 28141 AND league_id = 27283 AND action = 19
0.0148  SELECT e.* FROM `events2015` e WHERE e.player_id = 28141 AND league_id = 3916 ORDER BY e.date ASC
0.0160  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3916 AND rel.player_id=28141
0.0154  SELECT action,minute FROM events2015 WHERE player_id = 28141 AND league_id = 3916 AND action = 18
0.0152  SELECT action,minute FROM events2015 WHERE player_id = 28141 AND league_id = 3916 AND action = 19
0.0156  SELECT e.* FROM `events2014` e WHERE e.player_id = 28141 AND league_id = 2556 ORDER BY e.date ASC
0.0156  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2556 AND rel.player_id=28141
0.0152  SELECT action,minute FROM events2014 WHERE player_id = 28141 AND league_id = 2556 AND action = 18
0.0145  SELECT action,minute FROM events2014 WHERE player_id = 28141 AND league_id = 2556 AND action = 19
0.0146  SELECT e.* FROM `events2014` e WHERE e.player_id = 28141 AND league_id = 3674 ORDER BY e.date ASC
0.0160  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 3674 AND rel.player_id=28141
0.0147  SELECT action,minute FROM events2014 WHERE player_id = 28141 AND league_id = 3674 AND action = 18
0.0150  SELECT action,minute FROM events2014 WHERE player_id = 28141 AND league_id = 3674 AND action = 19
0.0145  SELECT e.* FROM `events2013` e WHERE e.player_id = 28141 AND league_id = 1946 ORDER BY e.date ASC
0.0147  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1946 AND rel.player_id=28141
0.0149  SELECT action,minute FROM events2013 WHERE player_id = 28141 AND league_id = 1946 AND action = 18
0.0150  SELECT action,minute FROM events2013 WHERE player_id = 28141 AND league_id = 1946 AND action = 19
0.0150  SELECT e.* FROM `events2013` e WHERE e.player_id = 28141 AND league_id = 2340 ORDER BY e.date ASC
0.0169  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 2340 AND rel.player_id=28141
0.0153  SELECT action,minute FROM events2013 WHERE player_id = 28141 AND league_id = 2340 AND action = 18
0.0145  SELECT action,minute FROM events2013 WHERE player_id = 28141 AND league_id = 2340 AND action = 19
0.0145  SELECT e.* FROM `events2012` e WHERE e.player_id = 28141 AND league_id = 1413 ORDER BY e.date ASC
0.0148  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1413 AND rel.player_id=28141
0.0145  SELECT action,minute FROM events2012 WHERE player_id = 28141 AND league_id = 1413 AND action = 18
0.0146  SELECT action,minute FROM events2012 WHERE player_id = 28141 AND league_id = 1413 AND action = 19
0.0151  SELECT e.* FROM `events2011` e WHERE e.player_id = 28141 AND league_id = 1104 ORDER BY e.date ASC
0.0154  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 1104 AND rel.player_id=28141
0.0153  SELECT action,minute FROM events2011 WHERE player_id = 28141 AND league_id = 1104 AND action = 18
0.0144  SELECT action,minute FROM events2011 WHERE player_id = 28141 AND league_id = 1104 AND action = 19
0.0147  SELECT e.* FROM `events2010` e WHERE e.player_id = 28141 AND league_id = 828 ORDER BY e.date ASC
0.0146  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 828 AND rel.player_id=28141
0.0146  SELECT action,minute FROM events2010 WHERE player_id = 28141 AND league_id = 828 AND action = 18
0.0148  SELECT action,minute FROM events2010 WHERE player_id = 28141 AND league_id = 828 AND action = 19
0.0149  SELECT e.* FROM `events2010` e WHERE e.player_id = 28141 AND league_id = 967 ORDER BY e.date ASC
0.0195  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 967 AND rel.player_id=28141
0.0150  SELECT action,minute FROM events2010 WHERE player_id = 28141 AND league_id = 967 AND action = 18
0.0150  SELECT action,minute FROM events2010 WHERE player_id = 28141 AND league_id = 967 AND action = 19
0.0150  SELECT e.* FROM `events2009` e WHERE e.player_id = 28141 AND league_id = 129 ORDER BY e.date ASC
0.0153  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 129 AND rel.player_id=28141
0.0150  SELECT action,minute FROM events2009 WHERE player_id = 28141 AND league_id = 129 AND action = 18
0.0152  SELECT action,minute FROM events2009 WHERE player_id = 28141 AND league_id = 129 AND action = 19
0.0152  SELECT e.* FROM `events2009` e WHERE e.player_id = 28141 AND league_id = 807 ORDER BY e.date ASC
0.0150  SELECT rel.id FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real dr ON dr.id = rel.team_number WHERE dr.league_id = 807 AND rel.player_id=28141
0.0148  SELECT action,minute FROM events2009 WHERE player_id = 28141 AND league_id = 807 AND action = 18
0.0148  SELECT action,minute FROM events2009 WHERE player_id = 28141 AND league_id = 807 AND action = 19
0.0148   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.`playerId` = '28141' ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0,15
0.0147   SELECT c.id, c.author_name, c.comment, c.comment_id, c.author_id, c.creation_date, c.votes_up, c.device, fau.user_name, fau.adm AS user_adm, fau.role AS user_role, fau.adm_type AS user_adm_type, template, NOW() AS difference_time FROM comments AS c LEFT JOIN fa_user_mini AS fau ON fau.id = c.author_id WHERE c.`active`=1 AND c.to_review=0 AND c.device = 'web' AND c.comment_id = '660086' AND c.lang = '1' ORDER BY creation_date DESC LIMIT 20