| 0.0017 | SELECT type FROM routes WHERE alias = 'coppa_italia_primavera2024' |
| 0.0040 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'coppa_italia_primavera' 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.0018 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=2071 AND type_rel = 3 |
| 0.0022 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 2071 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 (1281521,748241) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0024 | 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 = 74005 ORDER BY dt.relations DESC, dt.nameShow ASC LIMIT 50 |
| 0.0023 | 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 calendars2024 c INNER JOIN datateams dt1 ON dt1.id = c.datateam1 INNER JOIN datateams dt2 ON dt2.id = c.datateam2 WHERE c.league_id = 74005 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-05-04 08:18:56' 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-05-04 08:18:56' 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-05-04 08:18:56' 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-05-04 08:18:56' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0019 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2071 AND l.year = 2024 |
| 0.0021 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74005) 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.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 (74005) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (3190776,3193530,3323136,3358362,3460781,884635,908171,936991,937145,976125) ORDER BY rp.in_squad = 1 DESC |
| 0.0019 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2071 AND l.year = 2024 |
| 0.0023 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74005) 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 (74005) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (936991,886659,3192200,3192254,3201429,3205267,3288877,3307162,3317550,3355313) ORDER BY rp.in_squad = 1 DESC |
| 0.0018 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 2071 AND l.year = 2024 |
| 0.0019 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (74005) 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 (74005) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (936991,3144413,3363802) ORDER BY rp.in_squad = 1 DESC |
Alessandria
Renate
Feralpisal
Cittadella
Padova
Bari
Monopoli
Palermo
Salernitana
Brescia
Milan
Virtus
Atalanta
SPAL
Bologna
Cremonese
Cagliari
Ascoli
Cesena
Parma
Frosinone
Crotone
Lazio
Nuova
Napoli
Benevento
Sampdoria
Spezia
Udinese
Venezia
Hellas
Vicenza
Genoa
Monza
Pisa
Perugia
AlbinoLeffe
Südtirol
Pescara
Ternana
Como
Reggiana
Empoli
Sassuolo
Roma
Juventus
Inter
Lecce
Fiorentina
Torino
Juventus Sub 19
Inter Sub 19
Roma Sub 19
Fiorentina Sub 19
Milan Sub 19
Atalanta Sub 19
Empoli Sub 19
Torino Sub 19
Genoa Sub 19
Lazio Sub 19
Napoli Sub 19
Sampdoria Sub 19
Parma Sub 19
Sassuolo Sub 19
Palermo Sub 19
Udinese Sub 19
Bologna Sub 19
Cagliari Sub 19
Spezia Sub 19
Hellas Verona Sub 19
Ascoli Sub 19
Brescia Sub 19
Cesena Sub 19
Pescara Sub 19
Crotone Sub 19
Virtus Entella Sub 19
Frosinone Sub 19
Lecce Sub 19
Vicenza Sub 19
SSC Bari Sub 19
Cittadella Sub 19
Perugia Sub 19
Benevento Sub 19
Salernitana Sub 19
SPAL Sub 19
Pisa SC Sub 19
Venezia Sub 19
Cremonese Sub 19
Ternana Sub 19
Padova Sub 19
Nuova Cosenza Sub 19
AlbinoLeffe Sub 19
AC Monza Sub 19
Reggiana Sub 19
Como Sub 19
Monopoli Sub 19
US Alessandria Sub 19
Feralpisalò Sub 19
Südtirol Sub 19
Renate Sub 19