| 0.0018 | SELECT type FROM routes WHERE alias = 'copa_catalunya2024' |
| 0.0018 | SELECT total FROM bs_rel_resume_items WHERE ln = 'es' AND itemId=1832 AND type_rel = 3 |
| 0.0020 | SELECT rel.newId FROM bs_news_rel rel WHERE rel.type_rel = 3 AND rel.typeId = 1832 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 (1202977,1152228,810893,692546,687124) ORDER BY n.cover_points DESC, update_date DESC |
| 0.0018 | SELECT id,name,alias,stepParent FROM categories WHERE parentId=1832 ORDER BY order_id ASC |
| 0.0020 | 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 = 72554 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-29 20:24:38' 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-29 20:24:38' 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-29 20:24:38' 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-29 20:24:38' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
| 0.0019 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1832 AND l.year = 2024 |
| 0.0020 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72554) 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 (72554) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (993631,874008,73948,81655,120441,195773,539874,930800,993635,998281) ORDER BY rp.in_squad = 1 DESC |
| 0.0019 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1832 AND l.year = 2024 |
| 0.0020 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72554) AND (e.action = 4 or e.action = 5) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
| 0.0025 | 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 (72554) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (141919,120441,140781,170455,170564,170636,189644,993631,1007433,18014) ORDER BY rp.in_squad = 1 DESC |
| 0.0019 | SELECT l.id FROM leagues_webci l WHERE l.categoryId = 1832 AND l.year = 2024 |
| 0.0018 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72554) AND (e.action = 3 or e.action = 4) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 10 |
Cristóbal
Terrassa
L´Hospital
AE Prat
Mollerussa
Castelldefe
Vilafranca
Cornellà
Reus Reddis
CE Manresa
CE Europa
Cerdanyola
Sant Andreu
Peralada
FE Grama
Olot
Vilassar
Badalona
Tona
Sabadell
FC Andorra
CE Sabadell
UE Sant Andreu
Terrassa FC
CE Europa
L´Hospitalet
Olot
FC Andorra
CE Manresa
FC Vilafranca
CF Badalona Futur
UE Cornellà
CFJ Mollerussa
AE Prat
UE Vilassar de Mar
Castelldefels
CF Peralada
Cerdanyola FC
CP San Cristóbal
FE Grama
Reus FC Reddis
Tona