0.0021 | SELECT c.id, c.name, c.alias, c.stepParent, l.year FROM categories AS c INNER JOIN leagues AS l ON c.id=l.categoryId AND l.year='2024' WHERE c.parentId=94 GROUP BY c.id ORDER BY c.order_id ASC |
0.0018 | SELECT type,rule FROM rules WHERE categoryId = 94 ORDER BY type = 'tables_draw' DESC,type != 'extra' DESC, `order` ASC |
0.0019 | SELECT url,page_views,page_title FROM rf_statcounter_popular_pages_hourly WHERE type=1 AND last_update > '2024-05-04 12:07:50' 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 12:07:50' 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-05-04 12:07:50' 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 12:07:50' GROUP BY url ORDER BY page_views DESC LIMIT 5 |
0.0038 | SELECT c.*, l.*, '' as namec FROM leagues_webci l INNER JOIN categories_webci c ON l.categoryId = c.id WHERE c.alias = 'bundesliga_3' 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.0031 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72129) 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.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 (72129) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (303818,358573,392465,227510,200112,281558,58918,277224,296066,477989,399660,109756,202030,230371,321345,477684,627432,376757,391036,426941) ORDER BY rp.in_squad = 1 DESC |
0.0039 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72129) AND (e.action IN (4,5) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
0.0027 | 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 (72129) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (185776,386788,281363,340980,754625,146730,199806,244152,282943,286246,393530,754551,25184,93221,110511,290095,305358,336760,622200,867584) ORDER BY rp.in_squad = 1 DESC |
0.0019 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72129) AND (e.action IN (3,4) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
0.0027 | 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 (72129) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (281363,199806,317245,335084,451188,754551,25184,113889,127224,128239,128375,146730,199571,199626,199959,200418,201146,201708,202088,210700) ORDER BY rp.in_squad = 1 DESC |
0.0027 | SELECT e.action, count(e.action) as total, e.player_id FROM events2024 e WHERE e.league_id IN (72129) AND (e.action IN (22) ) GROUP BY e.player_id ORDER BY total DESC, e.player_id ASC LIMIT 20 |
0.0027 | 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 (72129) INNER JOIN datateams AS dt ON rp.teamId=dt.id WHERE dp.id IN (209485,477989,426941,622236,985821,183259,244165,477684,281558,376757,446406,700363,888112,25552,127225,202088,216545,363422,406399,431088) ORDER BY rp.in_squad = 1 DESC |
0.0022 | 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 = 72129 AND rp.lineup > 0 ORDER BY rp.lineup DESC,p.pod DESC LIMIT 20 |
0.0204 | 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 = 72129 AND rp.events > 0 ORDER BY rp.events DESC,p.pod DESC LIMIT 20 |
0.0018 | 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 = 72129 AND esl.points > 0 |
0.0023 | SELECT distinct(shedule), round FROM `calendars2024` as c WHERE c.`league_id` = 72129 AND shedule >= '2024/05/01' AND shedule < '2024/06/01' ORDER BY shedule ASC |
0.0018 | SELECT data1, data2 FROM services_tags WHERE categoryId=94 |
0.0020 | SELECT group_code, extraName from `leagues` WHERE categoryId=94 AND year=2024 |