| 0.0020 | SELECT type FROM routes WHERE alias = 'copa_rey_juvenil2022' |
| 0.0048 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'copa_rey_juvenil' AND (l.group_code = 0 OR l.group_code = 1 OR l.group_code = 0) AND l.year = 2022 ORDER BY l.year=c.active_year DESC,l.year DESC, l.group_code=0 DESC LIMIT 1 |
| 0.0018 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1776 AND type_rel = 3 |
| 0.0022 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1776 AND rel.ln = 'es' AND rel.status=1 ORDER BY rel.creation_date desc,rel.cover_points DESC LIMIT 5 |
| 0.0021 | 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 (1236708,1236715,1236706,1235909,1235833) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0017 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1776 ORDER BY order_id ASC |
| 0.0020 | 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 = 66323 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0021 | 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 calendars2022 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 66323 ORDER BY round ASC |
| 0.0018 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-24 08:19:00' 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=2 AND last_update > '2024-04-24 08:19:00' 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=4 AND last_update > '2024-04-24 08:19:00' 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-24 08:19:00' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0018 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1776 AND l.year = 2022 |
| 0.0020 | SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66323) 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.0024 | 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 (66323) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (879609,902067,1006181,1024465,3216645,885940,901426,901445,907159,950091) ORDER BY rp.in_squad = 1 DESC |
| 0.0018 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1776 AND l.year = 2022 |
| 0.0019 | SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66323) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0021 | 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 (66323) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (885925,951155,988728,993384,993479,1001514,1005244,3179696,870966,879606) ORDER BY rp.in_squad = 1 DESC |
| 0.0018 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1776 AND l.year = 2022 |
| 0.0018 | SELECT e.action, count(e.action) as total, e.player_id FROM events2022 e WHERE e.league_id IN (66323) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0019 | 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 (66323) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (885925,993479,1001514,1005244) ORDER BY rp.in_squad = 1 DESC |
Sevilla
Real Betis
Espanyol
Mallorca
Barcelona
Damm
Atlético
Leonesa
Real Madrid
Rayo
Celta
Deportivo
Racing
Atlético
Osasuna
Deportivo
Athletic
Eibar
Málaga
Cádiz
Palmas
Huracán
Tenerife
José
Valencia
Levante
Alboraya
Alzira
Villarreal
Tudelano
Granada
Leganés
Real Madrid Sub 19
Atlético Sub 19
Barcelona Sub 19
Sevilla Sub 19
Valencia Sub 19
Las Palmas Sub 19
Málaga Sub 19
Villarreal Sub 19
Athletic Sub 19
RC Celta Sub 19
Levante Sub 19
Deportivo Sub 19
Tenerife Sub 19
Rayo Vallecano Sub 19
Leganés Sub 19
Real Betis Sub 19
Espanyol Sub 19
Racing Sub 19
CF Damm Sub 19
Mallorca Sub 19
Osasuna Sub 19
CD Tudelano Sub 19
Deportivo Alavés Sub 19
Cádiz Sub 19
Granada CF Sub 19
Eibar Sub 19
AD Huracán Sub 19
Alzira Sub 19
Atlético Perines Sub 19
CD Leonesa Sub 19
SD San José Sub 19
Alboraya Sub 19