4.793.283 resultados, 29.450.556 comentarios, 1.037.175 imágenes, 80.044 vídeos, 86.434 noticias
Escudo del Yeni Malatyaspor

Estadísticas

ASISTENCIAS
O. Özçiçek3
Haqi Osman2
B. Çağıran2
Jospin Nshimirimana2
D. Emeksiz2
T. Gur1
C. Akgün1
N. Aydın1
Aly Malle1
ENTRA
M. Altıntaş16
Y. Alkan9
Jospin Nshimirimana7
C. Akgün6
Aly Malle6
Atakan Müjde6
O. Özçiçek5
N. Aydın5
Yiğit Ulaş4
A. Sengul4
Ersan Yasa4
Hüseyin Ekici4
Alperen Arslan3
Berat Yaman3
T. Gur3
D. Emeksiz3
Haqi Osman3
B. Kavlak2
Berat Mert2
Mehmet Günes2
B. Çağıran1
Philip Awuku1
SALE
Aly Malle14
D. Emeksiz14
B. Çağıran12
C. Akgün12
Jospin Nshimirimana10
A. Sengul5
Haqi Osman5
O. Özçiçek5
Y. Alkan5
Hüseyin Ekici3
T. Gur3
G. Donsah2
B. Basdas2
Philip Awuku2
Ersan Yasa2
Berat Yaman1
N. Aydın1
Yiğit Ulaş1
M. Altıntaş1

  USO DE MEMORIA  
5,100,568 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0012
Controller Execution Time ( Home / Category )  0.2232
Total Execution Time  0.2244
  CADENA URL  
/estadisticas/Yeni-Malatyaspor
  GET DATOS  
$_GET['/estadisticas/Yeni-Malatyaspor']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (8)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=12925 AND type_rel = 2
0.0134  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 12925 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0134  SELECT /*35 bs_news_model*/ n.id, n.author_id, n.headline, n.external_headline, n.live_headline, n.creation_date, n.update_date, n.pub_date, n.alias, n.subheadline, n.teaser, n.media, n.tags, n.views, n.screens, n.clicks, n.relations, n.comments, n.power_cover, n.cover_points, u.name as user_name FROM bs_news n INNER JOIN bs_editors u ON u.id = n.author_id AND u.ln = 'es' WHERE n.status = 1 AND n.ln = 'es' AND n.id IN (242574,268424,269389,272421,274821) ORDER BY n.cover_points DESC, update_date DESC
0.0152  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '12925' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0160  SELECT SQL_NO_CACHE res.id as id, res.group_code, res.total_group, res.logo, res.alias FROM (SELECT ct.active_year, ct.id as id, l.year, l.end,l.group_code, l.total_group, ct.logo, ct.alias FROM categories AS ct INNER JOIN leagues AS l ON ct.id=l.categoryId AND ct.active_year=l.year INNER JOIN teams AS t ON l.id=t.league_id WHERE t.teamId = '12925' AND ct.ctype=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0178  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68073 WHERE rp.league_id = 68073 AND rp.teamId = 12925 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0190  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68073 WHERE rp.league_id = 68073 AND rp.teamId = 12925 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0194  SELECT e.action,rp.player_id, count(e.action) as total, p.nick,p.name,p.last_name,p.alias,rp.team_id FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events2023 e ON e.player_id = p.id AND e.league_id = 68073 WHERE rp.league_id = 68073 AND rp.teamId = 12925 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30