| 0.0124 | SELECT type FROM routes WHERE alias = 'amistosos_selecciones_sub172009' |
| 0.0253 | 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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=1 DESC LIMIT 1 |
| 0.0125 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1991 AND type_rel = 3 |
| 0.0133 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1991 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0128 | 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 (1279115,1185480,1129476,883585,791361) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0124 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1991 ORDER BY order_id ASC |
| 0.0128 | 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 = 41341 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0154 | 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 calendars2009 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 41341 ORDER BY round ASC |
| 0.0125 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-05 14:11:39' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0126 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=2 AND last_update > '2024-05-05 14:11:39' 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-05-05 14:11:39' 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-05-05 14:11:39' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0130 | 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 = 2009 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0129 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2009 |
| 0.0134 | SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (41341) 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.0131 | 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 (41341) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (119431,227699,235535,47639,90092,111303,144258,218126,40603,50803) ORDER BY rp.in_squad = 1 DESC |
| 0.0130 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2009 |
| 0.0137 | SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (41341) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0133 | 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 (41341) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (208168,231088,3160273,14088,34905,49733,64923,81546,89108,92385) ORDER BY rp.in_squad = 1 DESC |
| 0.0130 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1991 AND l.year = 2009 |
| 0.0135 | SELECT e.action, count(e.action) as total, e.player_id FROM events2009 e WHERE e.league_id IN (41341) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0130 | 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 (41341) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (70839,101371,183425,191740,208168,229161,231088,314069,3160273) ORDER BY rp.in_squad = 1 DESC |
Ucrania
Bielorrusia
Lituania
Finlandia
Rusia
Luxemburgo
España
Estados
Rumanía
Georgia
Grecia
Suecia
Bulgaria
Nigeria
Corea
Emiratos
Zambia
Escocia
Inglaterra
Noruega
Islas Feroe
Dinamarca
Austria
Bélgica
Suiza
Francia
Hungría
Portugal
Italia
Croacia
Eslovaquia
República
Alemania
Chipre
Serbia
Israel
Montenegro
Países
Bosnia
Brasil
Corea
Colombia
Feyenoord
Turquía
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
Suecia Sub 17
Dinamarca Sub 17
Escocia Sub 17
Croacia Sub 17
Estados Unidos Sub 17
Noruega Sub 17
Ucrania Sub 17
Hungría Sub 17
Serbia Sub 17
Brasil Sub 17
Eslovaquia Sub 17
Grecia Sub 17
Finlandia Sub 17
Israel Sub 17
Rumanía Sub 17
Georgia Sub 17
Bielorrusia Sub 17
Bosnia Sub 17
Bulgaria Sub 17
Nigeria Sub 17
Chipre Sub 17
Azerbaiyán Sub 17
Luxemburgo Sub 17
Rusia Sub 16
Islas Feroe Sub 17
Lituania Sub 17
Feyenoord Sub 19
Montenegro Sub 17
Colombia Sub 17
Corea del Sur Sub 17
Corea del Sur Sub 15
Emiratos Árabes Sub 17
Zambia Sub 17