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

Cruce de partidos Clasificación Europeo Sub 19 - Todos los partidos de la temporada

IdaVuelta
 España Sub 19 Inglaterra Sub 19 Alemania Sub 19 Francia Sub 19 Italia Sub 19 República Checa Sub 19 Turquia Sub 19 Austria Sub 19 Bélgica Sub 19 Grecia Sub 19 Noruega Sub 19 Países Bajos Sub 19 Serbia Sub 19 Irlanda Sub 19 Croacia Sub 19 Dinamarca Sub 19 Ucrania Sub 19 Eslovaquia Sub 19 Escocia Sub 19 Polonia Sub 19 Suiza Sub 19 Hungria Sub 19 Israel Sub 19 Suecia Sub 19 Rumanía Sub 19 Georgia Sub 19 Eslovenia Sub 19 Bulgaria Sub 19 Bosnia Sub 19 Macedonia del Norte Sub 19 Estonia Sub 19 Finlandia Sub 19 Lituania Sub 19 Chipre Sub 19 Gales Sub 19 Letonia Sub 19 Bielorrusia Sub 19 Islandia Sub 19 Armenia Sub 19 Azerbaiyán Sub 19 Montenegro Sub 19 Moldavia Sub 19 Albania Sub 19 Luxemburgo Sub 19 Malta Sub 19 Kazajistán Sub 19 Islas Feroe Sub 19 San Marino Sub 19 Andorra Sub 19 Liechtenstein Sub 19
España Sub 19 España Sub 19
Inglaterra Sub 19 Inglaterra Sub 19
Alemania Sub 19 Alemania Sub 19
Francia Sub 19 Francia Sub 19
Italia Sub 19 Italia Sub 19
República Checa Sub 19 República Checa Sub 19
Turquia Sub 19 Turquia Sub 19
Austria Sub 19 Austria Sub 19
Bélgica Sub 19 Bélgica Sub 19
Grecia Sub 19 Grecia Sub 19
Noruega Sub 19 Noruega Sub 19
Países Bajos Sub 19 Países Bajos Sub 19
Serbia Sub 19 Serbia Sub 19
Irlanda Sub 19 Irlanda Sub 19
Croacia Sub 19 Croacia Sub 19
Dinamarca Sub 19 Dinamarca Sub 19
Ucrania Sub 19 Ucrania Sub 19
Eslovaquia Sub 19 Eslovaquia Sub 19
Escocia Sub 19 Escocia Sub 19
Polonia Sub 19 Polonia Sub 19
Suiza Sub 19 Suiza Sub 19
Hungria Sub 19 Hungria Sub 19
Israel Sub 19 Israel Sub 19
Suecia Sub 19 Suecia Sub 19
Rumanía Sub 19 Rumanía Sub 19
Georgia Sub 19 Georgia Sub 19
Eslovenia Sub 19 Eslovenia Sub 19
Bulgaria Sub 19 Bulgaria Sub 19
Bosnia Sub 19 Bosnia Sub 19
Macedonia del Norte Sub 19 Macedonia del Norte Sub 19
Estonia Sub 19 Estonia Sub 19
Finlandia Sub 19 Finlandia Sub 19
Lituania Sub 19 Lituania Sub 19
Chipre Sub 19 Chipre Sub 19
Gales Sub 19 Gales Sub 19
Letonia Sub 19 Letonia Sub 19
Bielorrusia Sub 19 Bielorrusia Sub 19
Islandia Sub 19 Islandia Sub 19
Armenia Sub 19 Armenia Sub 19
Azerbaiyán Sub 19 Azerbaiyán Sub 19
Montenegro Sub 19 Montenegro Sub 19
Moldavia Sub 19 Moldavia Sub 19
Albania Sub 19 Albania Sub 19
Luxemburgo Sub 19 Luxemburgo Sub 19
Malta Sub 19 Malta Sub 19
Kazajistán Sub 19 Kazajistán Sub 19
Islas Feroe Sub 19 Islas Feroe Sub 19
San Marino Sub 19 San Marino Sub 19
Andorra Sub 19 Andorra Sub 19
Liechtenstein Sub 19 Liechtenstein Sub 19

  USO DE MEMORIA  
7,912,200 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0019
Controller Execution Time ( Home / Category )  0.4855
Total Execution Time  0.4874
  CADENA URL  
/clasificacion_europeo_sub_192024/grupo1/cruces
  GET DATOS  
$_GET['/clasificacion_europeo_sub_192024/grupo1/cruces']  
  POST DATOS  
No hay datos POST existentes
  CONSULTAS (22)  
0.0144  SELECT type FROM routes WHERE alias = 'clasificacion_europeo_sub_192024'
0.0294  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_19' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1
0.0145  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1841 AND type_rel = 3
0.0148  SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1841 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5
0.0148  SELECT /*53 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 (1308149,1308075,1307769,1307757,1306188) ORDER BY n.cover_points DESC, update_date DESC
0.0154  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 = 70719 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50
0.0158  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='70719' ORDER BY c.id ASC
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 02:16:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0145  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-04 02:16:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0146  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-04 02:16:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0149  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-04 02:16:15' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0163  SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'clasificacion_europeo_sub_19' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2024 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1
0.0176  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2024
0.0176  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (70719,74806) 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, e.player_id ASC LIMIT 10
0.0167  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (70719,74806) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (976041,3178249,3333400,928177,3144861,1031063,3176533,3189523,3191101,907765) ORDER BY rp.in_squad = 1 DESC
0.0153  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2024
0.0156  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (70719,74806) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0156  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (70719,74806) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3168104,849095,907776,3157499,3157740,3168532,3193793,3206126,3206137,3207945) ORDER BY rp.in_squad = 1 DESC
0.0156  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2024
0.0154  SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (70719,74806) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10
0.0166  SELECT dp.name, dp.last_name, dp.nick,dp.CountryCode,dp.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,dp.role FROM dataplayers AS dp INNER JOIN rel_players AS rp ON rp.player_id=dp.id AND rp.league_id IN (70719,74806) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (892789,907776,999892,3168104,3170823,3190190,3191901,3197596,3210092,3212911) ORDER BY rp.in_squad = 1 DESC
0.0170  SELECT *,(cast(t.gf as signed) - cast(t.ga as signed) + 100) as diff,team.teamId FROM `tables2024` 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 = 70719 AND t.round = 3 ORDER BY team.conference ASC,t.position ASC,t.points DESC,t.priority DESC, diff DESC, t.gf DESC, dt.nameShow ASC