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

Antwerp

Entrenador: Mark van Bommel

Temporada 2003/2004

Estadísticas

ENTRA
Colin Heath12
Marcos Pereira10
Patrick Goots8
Steven Ribus8
Mohammed Cissé7
Arthur Gomez7
Asanda Sishuba6
Souleymane Mamam5
Pivaljevic5
C. Bernáth5
W. Verbeeck4
Arkadiusz Kubik3
Alex Yi2
Gunter Ribus2
Tony Sergeant2
D. Fangzhuo2
Bukran2
Omar Mussa2
Faruk Atalay2
H. Yasser2
Champara2
E. Ouon1
Philippe Snelders1
P. Bardsley1
Govert Boyen1
Pindado1
SALE
Patrick Goots10
E. Ouon9
Pivaljevic8
D. Fangzhuo7
Souleymane Mamam7
Bukran7
Marcos Pereira7
Tony Sergeant5
Omar Mussa4
E. Johnson4
W. Verbeeck3
Steven Ribus3
Asanda Sishuba3
Arkadiusz Kubik3
Stefan Leleu2
Arthur Gomez2
Mohammed Cissé2
L. Ciobotariu2
C. Bernáth2
Gennady Tumilovich1
Champara1
Yves Feys1
Alex Yi1
H. Yasser1
Harald Pinxten1
N. Yattara1
B. Evens1

  USO DE MEMORIA  
5,229,096 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0013
Controller Execution Time ( Home / Category )  0.2054
Total Execution Time  0.2067
  CADENA URL  
/estadisticas/Antwerp/2004
  GET DATOS  
$_GET['/estadisticas/Antwerp/2004']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (7)  
0.0126  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=7512 AND type_rel = 2
0.0130  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 2 AND rel.typeId = 7512 AND rel.ln = 'es' ORDER BY rel.cover_points DESC LIMIT 5
0.0130  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 (147178,260603,261210,266750,278273) ORDER BY n.cover_points DESC, update_date DESC
0.0168  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 = '7512' AND ct.ctype!=12 GROUP BY ct.id ORDER BY ct.troncal DESC, ct.coefficient DESC) res WHERE res.year > 2020
0.0160  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 events2004 e ON e.player_id = p.id AND e.league_id = 358 WHERE rp.league_id = 358 AND rp.teamId = 7512 AND (e.action = 22) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0179  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 events2004 e ON e.player_id = p.id AND e.league_id = 358 WHERE rp.league_id = 358 AND rp.teamId = 7512 AND (e.action = 19) GROUP BY p.id ORDER BY total DESC LIMIT 30
0.0181  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 events2004 e ON e.player_id = p.id AND e.league_id = 358 WHERE rp.league_id = 358 AND rp.teamId = 7512 AND (e.action = 18) GROUP BY p.id ORDER BY total DESC LIMIT 30