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

Cruce de partidos 2ª Andaluza Granada - Todos los partidos de la temporada

IdaVuelta
Atl. La Zubia Águilas De Zujaira Otura CF Ogijares 89 Cf CF Sierra Nevada Cenes Pinos Puente Estrellas Chana Montefrio CF Cf Cullar Medina Lauxa CF Motril B Alomartes CF CD Vegas del Genil Atletismo Padul B Churriana de la Vega B Costa Tropical
Atl. La Zubia Atl. La Zubia
Águilas De Zujaira Águilas De Zujaira
Otura CF Otura CF
Ogijares 89 Cf Ogijares 89 Cf
CF Sierra Nevada Cenes CF Sierra Nevada Cenes
Pinos Puente Pinos Puente
Estrellas Chana Estrellas Chana
Montefrio CF Montefrio CF
Cf Cullar Cf Cullar
Medina Lauxa Medina Lauxa
CF Motril B CF Motril B
Alomartes CF Alomartes CF
CD Vegas del Genil CD Vegas del Genil
Atletismo Padul B Atletismo Padul B
Churriana de la Vega B Churriana de la Vega B
Costa Tropical Costa Tropical

  USO DE MEMORIA  
6,046,008 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.2580
Total Execution Time  0.2600
  CADENA URL  
/segunda_andaluza_granada2024/grupo1/cruces
  GET DATOS  
$_GET['/segunda_andaluza_granada2024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (9)  
0.0126  SELECT id,name,alias,stepParent FROM categories WHERE parentId=272 ORDER BY order_id ASC
0.0257  SELECT c.id, c.team1, c.team2, c.datateam1, c.datateam2, c.extra, c.shedule, c.r1, c.r2, c.status FROM calendars2024 AS c WHERE c.league_id='73929' ORDER BY c.id ASC
0.0126  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-04-27 21:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-04-27 21:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0125  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-04-27 21:43:38' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0127  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 events2024 e ON e.player_id = p.id AND e.league_id = 73929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73929 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.0126  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 events2024 e ON e.player_id = p.id AND e.league_id = 73929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73929 AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC LIMIT 10
0.0126  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 events2024 e ON e.player_id = p.id AND e.league_id = 73929 AND (e.teamId=rp.teamId) INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 73929 AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC LIMIT 10