0.0022 | SELECT c.id, c.name, c.alias, l.id AS league_id, l.year, l.group_code, l.total_group, c.id AS categoryId, c.stepParent FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND c.active_year=l.year WHERE c.id=1 ORDER BY l.group_code ASC |
0.0018 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-04-27 21:46:17' 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-27 21:46:17' 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-27 21:46:17' 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-27 21:46:17' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
0.0029 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72116) AND (e.action IN (1,2,11,12,13) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
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 (72116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (296111,839567,86790,232186,234630,40603,242155,32465,53536,358618,323688,397999,342937,48594,107189,283717,365923,174483,185985,281680) ORDER BY rp.in_squad = 1 DESC |
0.0038 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72116) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
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 (72116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (159799,101033,162193,227896,192553,280863,384918,36074,81239,192474,339335,471030,44027,322609,772933,872213,3004,75800,76168,137176) ORDER BY rp.in_squad = 1 DESC |
0.0020 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72116) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
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 (72116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (161131,102322,117235,197274,229430,384918,556626,45,7408,23341,27050,32016,36074,40603,48594,71934,74892,75798,75845,78301) ORDER BY rp.in_squad = 1 DESC |
0.0026 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72116) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
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 (72116) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (872213,7408,53536,307127,851717,904951,914743,2100,137176,281486,32465,44874,216079,427813,739892,879174,139714,205429,232186,242155) ORDER BY rp.in_squad = 1 DESC |
0.0023 | SELECT rp.lineup as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72116 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20 |
0.0095 | SELECT rp.events as total,p.name, p.last_name, p.nick,p.CountryCode,p.alias,rp.team_id,dt.nameShow,dt.short_name,dt.basealias,rp.player_id,rp.teamId,p.role FROM `rel_players` rp INNER JOIN dataplayers p ON p.id = rp.player_id INNER JOIN datateams dt ON dt.id = rp.teamId WHERE rp.league_id = 72116 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20 |
0.0020 | SELECT count(esl.user_id) as cuenta FROM editor_stats_leagues esl INNER JOIN fa_user u ON u.id = esl.user_id INNER JOIN fa_user_profile up ON up.id = esl.user_id WHERE esl.league_id = 72116 AND esl.points > 0 |
0.0017 | SELECT data1, data2 FROM services_tags WHERE categoryId=1 |
0.0020 | SELECT group_code, extraName from `leagues` WHERE categoryId=1 AND year=2024 |