| 0.0146 | SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub172007' |
| 0.0303 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub17' AND (l.group_code = 1 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1 |
| 0.0149 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1991 ORDER BY order_id ASC |
| 0.0160 | 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 = 58906 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0162 | SELECT c.team1, c.team2,c.extra,c.datateam1,c.datateam2,c.type, c.shedule, c.r1, c.r2, c.round, c.comments as total_comentarios, dt1.nameShow as team1_name, dt2.nameShow as team2_name, dt1.basealias as basealias1, dt2.basealias as basealias2, dt1.stadium as stadium_name FROM calendars2007 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 58906 ORDER BY round ASC |
| 0.0147 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-28 10:47:55' 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=2 AND last_update > '2024-04-28 10:47:55' 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=4 AND last_update > '2024-04-28 10:47:55' 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=3 AND last_update > '2024-04-28 10:47:55' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0157 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'amistosos_selecciones_sub17' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2007 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0150 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2007 |
| 0.0177 | SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (58906) 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.0160 | 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 (58906) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (29771,65784,346058,40401,21389,21516,317815,3270,14218,21292) ORDER BY rp.in_squad = 1 DESC |
| 0.0167 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2007 |
| 0.0149 | SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (58906) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0152 | 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 (58906) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (2409,15077,66381,67189,112166,136465,147063,201334,231574,327847) ORDER BY rp.in_squad = 1 DESC |
| 0.0150 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2007 |
| 0.0155 | SELECT e.action, count(e.action) as total, e.player_id FROM events2007 e WHERE e.league_id IN (58906) AND (e.action = 3 or e.action = 4) 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 (58906) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (21433,183430) ORDER BY rp.in_squad = 1 DESC |
España
Corea
Países
República
Noruega
Inglaterra
Bélgica
Portugal
Finlandia
Turquía
Gales
Dinamarca
Luxemburgo
Alemania
Hungría
Estados
Togo
Islas Feroe
Colombia
Suecia
Eslovaquia
Ucrania
Francia
Austria
Escocia
Eslovenia
Suiza
España Sub 17
Francia Sub 17
Alemania Sub 17
Portugal Sub 17
Inglaterra Sub 17
Países Bajos Sub 17
Bélgica Sub 17
Suiza Sub 17
República Checa Sub 17
Turquía Sub 17
Austria Sub 17
Suecia Sub 17
Dinamarca Sub 17
Escocia Sub 17
Irlanda Sub 17
Estados Unidos Sub 17
Noruega Sub 17
Ucrania Sub 17
Hungría Sub 17
Eslovaquia Sub 17
Finlandia Sub 17
Gales Sub 17
Eslovenia Sub 17
Luxemburgo Sub 17
Islas Feroe Sub 17
Colombia Sub 17
Corea del Sur Sub 17
Togo Sub 17