| 0.0147 | SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub172008' |
| 0.0304 | 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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1 |
| 0.0148 | 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 = 43864 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0152 | 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 calendars2008 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 43864 ORDER BY round ASC |
| 0.0145 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-03 20:49:19' 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-03 20:49:19' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0144 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=4 AND last_update > '2024-05-03 20:49:19' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0144 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=3 AND last_update > '2024-05-03 20:49:19' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0150 | 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 = 2008 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0148 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2008 |
| 0.0153 | SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (43864) 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.0148 | 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 (43864) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (218126,64944,472451,83981,120053,130088,161825,232123,29928,49733) ORDER BY rp.in_squad = 1 DESC |
| 0.0148 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2008 |
| 0.0150 | SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (43864) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0150 | 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 (43864) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (108556,148340,186705,2409,39845,49733,50808,67243,79374,83046) ORDER BY rp.in_squad = 1 DESC |
| 0.0147 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2008 |
| 0.0150 | SELECT e.action, count(e.action) as total, e.player_id FROM events2008 e WHERE e.league_id IN (43864) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
Bélgica
Gales
Turquía
China
Corea
Macedonia
Estonia
Mozambique
Islas Feroe
Escocia
Austria
Francia
Portugal
Italia
Inglaterra
Guinea
Israel
Suecia
Polonia
Eslovaquia
Suiza
Dinamarca
Ucrania
República
Hungría
Alemania
España
Rumanía
Lituania
Países
Rusia
Argelia
Timor
Brasil
España Sub 17
Francia Sub 17
Alemania Sub 17
Portugal Sub 17
Inglaterra Sub 17
Países Bajos Sub 17
Italia Sub 17
Bélgica Sub 17
Suiza Sub 17
República Checa Sub 17
Turquía Sub 17
Austria Sub 17
Polonia Sub 17
Suecia Sub 17
Dinamarca Sub 17
Escocia Sub 17
Rusia Sub 17
Ucrania Sub 17
Brasil Sub 17
Hungría Sub 17
Eslovaquia Sub 17
Israel Sub 17
Rumanía Sub 17
Gales Sub 17
Estonia Sub 17
Islas Feroe Sub 17
Lituania Sub 17
Macedonia del Norte Sub 17
Corea del Sur Sub 17
China Sub 17
Argelia Sub 17
Mozambique Sub 17
Timor Oriental Sub 17
Guinea Bissau Sub 17