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

Cruce de partidos Segunda División - Todos los partidos de la temporada

IdaVuelta
 Celta RC Deportivo Real Sporting Racing Deportivo Alavés CE Sabadell Barakaldo Racing Ferrol Cultural Leonesa Real Avilés Industrial Terrassa FC CD Ourense CD Basconia Sestao Sport Club SD Indautxu Condal CD
Celta Celta
RC Deportivo RC Deportivo
Real Sporting Real Sporting
Racing Racing
Deportivo Alavés Deportivo Alavés
CE Sabadell CE Sabadell
Barakaldo Barakaldo
Racing Ferrol Racing Ferrol
Cultural Leonesa Cultural Leonesa
Real Avilés Industrial Real Avilés Industrial
Terrassa FC Terrassa FC
CD Ourense CD Ourense
CD Basconia CD Basconia
Sestao Sport Club Sestao Sport Club
SD Indautxu SD Indautxu
Condal CD Condal CD

  USO DE MEMORIA  
6,118,224 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0026
Controller Execution Time ( Home / Category )  0.2570
Total Execution Time  0.2596
  CADENA URL  
/segunda1960/grupo1/cruces
  GET DATOS  
$_GET['/segunda1960/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0113  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars1960 AS c WHERE c.league_id='5456' ORDER BY c.id ASC
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-08 15:00:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0106  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-08 15:00:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0107  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-08 15:00:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0112  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-08 15:00:04' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0461  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 events1960 e ON e.player_id = p.id AND e.league_id = 5456 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5456 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.0140  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 events1960 e ON e.player_id = p.id AND e.league_id = 5456 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5456 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0131  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 events1960 e ON e.player_id = p.id AND e.league_id = 5456 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 5456 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0225  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables1960` 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 = 5456 AND t.round = 30 ORDER BY team.conference ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC