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,930,776 bytes
  BENCHMARKS  
Loading Time Base Classes  0.0025
Controller Execution Time ( Home / Category )  0.1151
Total Execution Time  0.1176
  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.0018  SELECT type FROM routes WHERE alias = 'clasificacion_europeo_sub_192024'
0.0041  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.0018  SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1841 AND type_rel = 3
0.0023  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.0024  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.0025  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.0023  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.0019  SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 06:33:18' 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-27 06:33:18' 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=4 AND last_update > '2024-04-27 06:33:18' 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=3 AND last_update > '2024-04-27 06:33:18' GROUP BY url ORDER BY page_views DESC LIMIT 5
0.0026  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.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2024
0.0026  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.0025  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.0026  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2024
0.0028  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.0026  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.0023  SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1841 AND l.year = 2024
0.0020  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.0023  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.0068  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