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

Cruce de partidos Liga Turca - Todos los partidos de la temporada

IdaVuelta
 Fenerbahçe Galatasaray SK Beşiktaş Trabzonspor Bursaspor Altay Ankaragücü Gençlerbirliği SK Eskişehirspor Antalyaspor Boluspor Denizlispor Sakaryaspor Sariyer Kocaelispor Orduspor 1967 Malatyaspor Zonguldak Kömürspor
Fenerbahçe Fenerbahçe
Galatasaray SK Galatasaray SK
Beşiktaş Beşiktaş
Trabzonspor Trabzonspor
Bursaspor Bursaspor
Altay Altay
Ankaragücü Ankaragücü
Gençlerbirliği SK Gençlerbirliği SK
Eskişehirspor Eskişehirspor
Antalyaspor Antalyaspor
Boluspor Boluspor
Denizlispor Denizlispor
Sakaryaspor Sakaryaspor
Sariyer Sariyer
Kocaelispor Kocaelispor
Orduspor 1967 Orduspor 1967
Malatyaspor Malatyaspor
Zonguldak Kömürspor Zonguldak Kömürspor

  USO DE MEMORIA  
6,568,312 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.1209
Total Execution Time  0.1229
  CADENA URL  
/turquia1985/grupo1/cruces
  GET DATOS  
$_GET['/turquia1985/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (10)  
0.0018  SELECT id,name,alias,stepParent FROM categories WHERE parentId=37 ORDER BY order_id ASC
0.0042  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars1985 AS c WHERE c.league_id='9886' ORDER BY c.id ASC
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 04:25:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 04:25:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0018  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-28 04:25:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0020  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 04:25:44' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0132  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1985 e ON e.player_id = p.id AND e.league_id = 9886 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9886 AND (e.action = 1 or e.action = 2 or e.action = 11 or e.action = 12 or e.action = 13) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0119  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1985 e ON e.player_id = p.id AND e.league_id = 9886 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9886 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0076  SELECT e.action, count(e.action) as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN events1985 e ON e.player_id = p.id AND e.league_id = 9886 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 9886 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0047  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1985` 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 = 9886 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC