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

Cruce de partidos 3. Lig - Todos los partidos de la temporada

IdaVuelta
İskenderunspor Nazilli Belediyespor Batman Petrolspor Artvin Hopaspor Gebzespor Tepecik Belediyespor Silivrispor Kulübü Nevşehir Belediyespor Erbaaspor 1461 Trabzon FK Korfez FK Karaköprü Bld. Yomraspor Ergene Velimese Spor Buca FK Kozanspor Sile Yildizspor
İskenderunspor İskenderunspor
Nazilli Belediyespor Nazilli Belediyespor
Batman Petrolspor Batman Petrolspor
Artvin Hopaspor Artvin Hopaspor
Gebzespor Gebzespor
Tepecik Belediyespor Tepecik Belediyespor
Silivrispor Kulübü Silivrispor Kulübü
Nevşehir Belediyespor Nevşehir Belediyespor
Erbaaspor Erbaaspor
1461 Trabzon FK 1461 Trabzon FK
Korfez FK Korfez FK
Karaköprü Bld. Karaköprü Bld.
Yomraspor Yomraspor
Ergene Velimese Spor Ergene Velimese Spor
Buca FK Buca FK
Kozanspor Kozanspor
Sile Yildizspor Sile Yildizspor

  USO DE MEMORIA  
6,294,880 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0035
Controller Execution Time ( Home / Category )  0.2253
Total Execution Time  0.2288
  CADENA URL  
/3_lig_turquia2019/grupo1/cruces
  GET DATOS  
$_GET['/3_lig_turquia2019/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (11)  
0.0019  SELECT id,name,alias,stepParent FROM categories WHERE parentId=360 ORDER BY order_id ASC
0.0022  SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id WHERE t.league_id = 44489 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0046  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2019 AS c WHERE c.league_id='44489' ORDER BY c.id ASC
0.0026  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 17:50:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-28 17:50:17' 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 17:50:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-28 17:50:17' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0275  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 events2019 e ON e.player_id = p.id AND e.league_id = 44489 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44489 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.0546  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 events2019 e ON e.player_id = p.id AND e.league_id = 44489 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44489 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0058  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 events2019 e ON e.player_id = p.id AND e.league_id = 44489 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 44489 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0053  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2019` 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 = 44489 AND t.round = 34 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC