0.0125 | SELECT total FROM totals ORDER BY id ASC |
0.0125 | SELECT g.name,g.id,g.members FROM groups g ORDER BY g.members DESC LIMIT 0,12 |
0.0129 | SELECT a.*,fa.last_activity,fa.user_name,fa.karma FROM activity a INNER JOIN fa_user fa ON fa.id = a.userId INNER JOIN fa_user_profile fap ON fap.id = a.userId WHERE fap.publicActivity = 1 ORDER BY datetime DESC LIMIT 0,14 |
0.0128 | SELECT gt.*,fa.user_name ,fa.changeA FROM g_totals gt INNER JOIN fa_user fa ON fa.id = gt.userId WHERE fa.language = "spanish" ORDER BY current ASC LIMIT 0,3 |
0.0127 | SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10 |
0.0124 | SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 10,10 |
0.0124 | SELECT url,page_views,page_title,last_page_views FROM rf_statcounter_popular_pages ORDER BY page_views DESC LIMIT 20,10 |
0.0129 | SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '15m' ORDER BY hits DESC LIMIT 20 |
0.0128 | SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '1h' ORDER BY hits DESC LIMIT 20 |
0.0125 | SELECT hits,page_url,keyword FROM rf_statcounter_keyword_recent WHERE type = '1d' ORDER BY hits DESC LIMIT 20 |
0.0162 | SELECT z.name,z.alias,c.CountryCode,SUM(c.coefficient) as cuenta FROM categories c INNER JOIN leagues l ON l.categoryId = c.id INNER JOIN zones z ON z.location = c.CountryCode WHERE c.continent = 'af' AND c.troncal = 1 AND c.active_year = l.year AND l.total_num_matchs = l.total_num_matchsR GROUP BY c.CountryCode ORDER BY cuenta DESC LIMIT 40 |
0.0138 | SELECT fau.id,fau.user_name,fau.changeA FROM user_stats us INNER JOIN fa_user fau ON fau.id = us.id WHERE fau.language = "spanish" AND fau.active = 1 AND fau.banned = 0 ORDER BY fau.karma DESC LIMIT 15 |
0.0128 | SELECT id,user_name,changeA FROM fa_user WHERE language = "spanish" ORDER BY id DESC LIMIT 15 |
1.2486 |
SELECT
n.title, n.alias,
rel.valor, rel.player_id, rel.official_budget, rel.budget_type, rel.date,
dp.nick, dp.role, dp.alias as player_alias, dp.id as player_id,
dt1.nameShow as nameShow1, dt1.basealias as basealias1, dt1.id as datateam1,
dt2.nameShow as nameShow2, dt2.basealias as basealias2, dt2.id as datateam2
FROM rel_budgets AS rel INNER JOIN dataplayers AS dp ON dp.id=rel.player_id
INNER JOIN datateams AS dt1 ON rel.origin_team_id=dt1.id
INNER JOIN datateams AS dt2 ON rel.destination_team_id=dt2.id
INNER JOIN news AS n ON n.id=rel.new_id
WHERE rel.cover=1 and rel.active=1 and rel.certified=1 ORDER BY rel.id DESC LIMIT 7
|
1.6424 | SELECT SUM(total) AS total FROM api_requests_stats WHERE creation_date > NOW() - INTERVAL 1 MONTH |
0.0150 | SELECT
fau.id,fau.user_name,stats.points as cuenta, fau.changeA
FROM fa_user as fau INNER JOIN editor_stats as stats ON stats.id = fau.id WHERE fau.language = 'spanish' AND fau.active = 1 AND fau.banned_editor = 0 AND fau.banned = 0 ORDER BY stats.points DESC LIMIT 5 |
0.0183 | (SELECT p.last_pub_date,p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,0 as post,t.title as title_c,t.alias alias_c,t.total as total_c,'' as blog_name,'' as blog_alias,'' as followers FROM `news` AS p INNER JOIN rel_news rn ON rn.type=5 AND rn.id_new = p.id INNER JOIN topics t ON t.id = rn.id_content INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-04-22' AND p.cover = 1 and p.revised != 2 GROUP BY p.id) UNION (SELECT p.last_pub_date,p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,1 as post,'' as title_c,'' as alias_c,'' as total_c,b.name as blog_name,b.alias as blog_alias,b.followers FROM `blog_posts` AS p INNER JOIN blogs b ON b.id = p.blog_id INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-04-22' AND p.cover = 1 GROUP BY p.id) ORDER BY pub_date DESC,totalcomments DESC LIMIT 0, 14 |
0.0282 | (SELECT p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,0 as post,t.title as title_c,t.alias alias_c,t.total as total_c,'' as blog_name,'' as blog_alias,'' as followers FROM `news` AS p INNER JOIN rel_news rn ON rn.type=5 AND rn.id_new = p.id INNER JOIN topics t ON t.id = rn.id_content INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-04-22' GROUP BY p.id) UNION (SELECT p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,1 as post,'' as title_c,'' as alias_c,'' as total_c,b.name as blog_name,b.alias as blog_alias,b.followers FROM `blog_posts` AS p INNER JOIN blogs b ON b.id = p.blog_id INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-04-22' GROUP BY p.id) ORDER BY creation_date>='2024-04-25' DESC,karma DESC LIMIT 0, 14 |
0.0156 | (SELECT p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,0 as post,t.title as title_c,t.alias alias_c,t.total as total_c,'' as blog_name,'' as blog_alias,'' as followers FROM `news` AS p INNER JOIN rel_news rn ON rn.type=5 AND rn.id_new = p.id INNER JOIN topics t ON t.id = rn.id_content INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-04-22' GROUP BY p.id) UNION (SELECT p.content_type,p.id,p.title,p.body,p.author_id,p.pub_date,p.votes_up,p.creation_date,p.karma,p.alias,p.totalcomments,p.picture_content_id,p.video_content_id,u.user_name,pic.author_id as pauthor_id,v.author_id as vauthor_id,1 as post,'' as title_c,'' as alias_c,'' as total_c,b.name as blog_name,b.alias as blog_alias,b.followers FROM `blog_posts` AS p INNER JOIN blogs b ON b.id = p.blog_id INNER JOIN `fa_user` AS u ON u.id = p.author_id LEFT JOIN `pictures` as pic ON p.picture_content_id = pic.id LEFT JOIN `videos` as v ON p.video_content_id = v.id WHERE p.creation_date > '2024-04-22' GROUP BY p.id) ORDER BY creation_date>='2024-04-25' DESC,creation_date>='2024-04-26' DESC,karma DESC LIMIT 0, 14 |
0.6043 |
SELECT
u.user_name, u.karma, u.last_activity, u.changeA, c.comment, c.last_update, c.creation_date, c.url, c.author_name, c.id, c.votes_up, c.votes_down, c.author_id, NOW() as difference_time, c.video_content_id, c.picture_content_id, c.new_content_id, c.post_content_id, c.league_id, c.playerId, c.match_id
FROM comments AS c INNER JOIN fa_user_mini AS u ON c.author_id=u.id
WHERE c.comment_id=0 AND c.active=1 AND lang='1' AND device='web'
AND c.last_update > NOW() - INTERVAL 7 DAY ORDER BY c.last_update DESC, c.creation_date DESC LIMIT 0, 12
|
0.0125 | SELECT id, year FROM leagues WHERE id IN (1438,1438,39) |
0.0125 |
SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra
FROM calendars2012 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id
INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id
WHERE c.id IN (70815) |
0.0127 |
SELECT c.id, c.league_id, dt1.nameShow AS team1_name, dt2.nameShow AS team2_name, dt1.basealias AS basealias1, dt2.basealias AS basealias2, c.extra
FROM calendars2004 AS c INNER JOIN datateams AS dt1 ON c.datateam1=dt1.id
INNER JOIN datateams AS dt2 ON c.datateam2=dt2.id
WHERE c.id IN (684) |
0.0126 | SELECT id, comment_id, comment, author_name, author_id, votes_up, COUNT(id) AS responses FROM comments WHERE comment_id IN (1568836,1578154,921235) GROUP BY comment_id |
0.0248 |
SELECT
c.id, 2024 AS year,
IF(l.tables = 1 AND t1.points>0,((t1.points / (l.current_round * 3)) + (t2.points / (l.current_round * 3)))/2 * ct.coefficient,0.7 * ct.coefficient) as fcoef
FROM `calendars2024` AS c
INNER JOIN `leagues` AS l
ON c.`league_id` = l.`id`
INNER JOIN `categories` AS ct
ON ct.`id` = l.`categoryId`
LEFT JOIN tables2024 AS t1
ON t1.team = c.team1
AND t1.round = l.current_round
LEFT JOIN tables2024 AS t2
ON t2.team = c.team2
AND t2.round = l.current_round
WHERE c.`shedule` > '2024-04-26 00:00:00' AND c.`shedule` < '2024-04-26 23:59:59'
ORDER BY fcoef DESC
LIMIT 5
|
0.0140 |
SELECT
c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium,
s.seats, s.yearBuilt, s.size,
dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,
dt2.basealias as basealias2,c.comments as totalcomments
FROM calendars2024 c INNER JOIN leagues l
ON l.id = c.league_id
INNER JOIN categories cat
ON cat.id = l.categoryId
INNER JOIN teams t1
ON t1.id = c.team1
INNER JOIN datateams dt1
ON dt1.id = t1.teamId
INNER JOIN teams t2
ON t2.id = c.team2
INNER JOIN datateams dt2
ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1
LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id
WHERE c.id = 728145
|
0.0148 |
SELECT
c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium,
s.seats, s.yearBuilt, s.size,
dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,
dt2.basealias as basealias2,c.comments as totalcomments
FROM calendars2024 c INNER JOIN leagues l
ON l.id = c.league_id
INNER JOIN categories cat
ON cat.id = l.categoryId
INNER JOIN teams t1
ON t1.id = c.team1
INNER JOIN datateams dt1
ON dt1.id = t1.teamId
INNER JOIN teams t2
ON t2.id = c.team2
INNER JOIN datateams dt2
ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1
LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id
WHERE c.id = 727172
|
0.0162 |
SELECT
c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium,
s.seats, s.yearBuilt, s.size,
dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,
dt2.basealias as basealias2,c.comments as totalcomments
FROM calendars2024 c INNER JOIN leagues l
ON l.id = c.league_id
INNER JOIN categories cat
ON cat.id = l.categoryId
INNER JOIN teams t1
ON t1.id = c.team1
INNER JOIN datateams dt1
ON dt1.id = t1.teamId
INNER JOIN teams t2
ON t2.id = c.team2
INNER JOIN datateams dt2
ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1
LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id
WHERE c.id = 717515
|
0.0177 |
SELECT
c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium,
s.seats, s.yearBuilt, s.size,
dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,
dt2.basealias as basealias2,c.comments as totalcomments
FROM calendars2024 c INNER JOIN leagues l
ON l.id = c.league_id
INNER JOIN categories cat
ON cat.id = l.categoryId
INNER JOIN teams t1
ON t1.id = c.team1
INNER JOIN datateams dt1
ON dt1.id = t1.teamId
INNER JOIN teams t2
ON t2.id = c.team2
INNER JOIN datateams dt2
ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1
LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id
WHERE c.id = 727069
|
0.0166 |
SELECT
c.*,l.year,cat.id as categoryId,cat.name,s.name as stadium,
s.seats, s.yearBuilt, s.size,
dt1.id as dt1id,dt2.id as dt2id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,
dt2.basealias as basealias2,c.comments as totalcomments
FROM calendars2024 c INNER JOIN leagues l
ON l.id = c.league_id
INNER JOIN categories cat
ON cat.id = l.categoryId
INNER JOIN teams t1
ON t1.id = c.team1
INNER JOIN datateams dt1
ON dt1.id = t1.teamId
INNER JOIN teams t2
ON t2.id = c.team2
INNER JOIN datateams dt2
ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId = dt1.id AND rs.active = 1
LEFT JOIN datastadiums AS s ON s.id = rs.stadium_id
WHERE c.id = 727200
|
0.0178 | SELECT z.name,z.alias,cat.location,SUM(cat.coefficient) as coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.continent = 'af' AND c.date = '2024-04-26' GROUP BY cat.location ORDER BY coefficient DESC |
0.0157 | SELECT z.name as zname,z.alias as zalias,cat.location,l.id,cat.alias,cat.name,l.group_code,l.total_group,cat.CountryCode,max(c.shedule) ult_partido,min(c.shedule) ini_partido,cat.coefficient FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars_all as c ON c.league_id = l.id LEFT JOIN zones z ON z.location = cat.location WHERE cat.continent = 'af' AND c.date = '2024-04-26' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 100 |
0.0188 | (SELECT l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments,c.betId,c.penaltis1,c.penaltis2,c.prorroga,c.status,c.minute,c.finished FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'af' AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59' GROUP BY c.id) UNION (SELECT l.year,cat.coefficient,c.extra,c.datateam1,c.datateam2,c.id as mid,c.r1,c.r2,c.shedule,c.team1,c.team2,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments,c.betId,c.penaltis1,c.penaltis2,c.prorroga,c.status,c.minute,c.finished FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'af' AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100 |
0.0179 | (SELECT l.year,cat.coefficient,c.id as mid,c.r1,c.r2,c.shedule,l.id,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'af' AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59' GROUP BY c.id) UNION (SELECT l.year,cat.coefficient,c.id as mid,c.r1,c.r2,c.shedule,l.id,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE cat.continent = 'af' AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59' GROUP BY c.id) ORDER BY coefficient DESC,shedule ASC LIMIT 100,200 |
0.0179 | (SELECT c.id,rel.media_id,rel.data,c.shedule FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2025 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) INNER JOIN media AS med ON rel.media_id=med.id WHERE (med.lang='es' OR med.language='spanish') AND cat.continent = 'af' AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59') UNION (SELECT c.id,rel.media_id,rel.data,c.shedule FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) INNER JOIN media AS med ON rel.media_id=med.id WHERE (med.lang='es' OR med.language='spanish') AND cat.continent = 'af' AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59') ORDER BY shedule ASC |
0.0125 | SELECT * FROM calendars_all WHERE shedule>NOW()+INTERVAL 1 DAY AND shedule<NOW()+INTERVAL 1 MONTH AND extra_coefficient>5 ORDER BY extra_coefficient DESC, shedule ASC LIMIT 3 |
0.0126 | SELECT update_date FROM editor_stats ORDER BY update_date DESC LIMIT 1 |
0.0456 | SELECT ct.location AS location,DAY( c.`shedule`) as day, cr.Name AS name, COUNT(ct.coefficient) as coefficient FROM `calendars_all` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` INNER JOIN country AS cr ON cr.Code2=UPPER(ct.location) WHERE ct.continent = 'af' AND c.`shedule` > '2024-04-26 08:48:02' AND c.`shedule` < '2024-04-27 08:48:02' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 26 DESC,coefficient DESC,location ASC |
0.0470 | SELECT ct.location AS location,DAY( c.`shedule`) as day FROM `calendars_all` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` INNER JOIN country AS cr ON cr.Code2=UPPER(ct.location) WHERE ct.continent = 'af' AND c.`shedule` >= '2024-04-25 00:00:00' AND c.`shedule` <= '2024-04-27 23:59:59' GROUP BY ct.location,DAY( c.`shedule`) ORDER BY DAY( c.`shedule`) = 26 DESC, ct.coefficient DESC,location ASC |
0.0171 | SELECT c.id, l.year AS year, (IF(l.tables = 1 AND (t1.points + t2.points >0), (t1.points + t2.points)/(IF(l.current_round-1 > 0,l.current_round-1,1)*6) * ct.coefficient, 0.9 * ct.coefficient) + (IF(c.comments>1000,200,c.comments*0.2)) + (IF(c.`shedule`> '2024-04-26 20:33:02' AND c.`shedule`< '2024-04-26 23:03:02' AND c.r1<90 AND c.r2<90 ,ct.coefficient*2,0)))*((1-ABS(UNIX_TIMESTAMP(c.shedule)-UNIX_TIMESTAMP())/86400)) as fcoef FROM `calendars_all` AS c INNER JOIN `leagues` AS l ON c.`league_id` = l.`id` INNER JOIN `categories` AS ct ON ct.`id` = l.`categoryId` LEFT JOIN tables2024 AS t1 ON t1.team = c.team1 AND t1.round = l.current_round AND t1.league_id = c.league_id LEFT JOIN tables2024 AS t2 ON t2.team = c.team2 AND t2.round = l.current_round AND t2.league_id = c.league_id WHERE ct.continent = 'af' AND c.`shedule` > '2024-04-26 08:48:02' AND c.`shedule` < '2024-04-27 08:48:02' AND (c.r1<99 OR c.shedule>='2024-04-26 20:18:02') GROUP BY c.id ORDER BY fcoef DESC LIMIT 9 |
0.0137 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,104.2904 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 724452 |
0.0126 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 724452 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0125 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6633760
AND c.team2 = 6633762
AND c.league_id = 75534
LIMIT 1 |
0.0126 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75534 AND id_match = 724452 |
0.0132 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75534' AND relp.team_id = drea.team_id WHERE rel.team_number=5363672 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0129 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75534' AND relp.team_id = drea.team_id WHERE rel.team_number=5363673 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0133 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '724452' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0129 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6633760
AND ev.team2id = 6633762
AND ev.league_id = 75534
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0145 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,35.8038 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 724453 |
0.0127 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 724453 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0128 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6633758
AND c.team2 = 6633763
AND c.league_id = 75534
LIMIT 1 |
0.0128 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 75534 AND id_match = 724453 |
0.0138 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75534' AND relp.team_id = drea.team_id WHERE rel.team_number=5363605 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0139 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='75534' AND relp.team_id = drea.team_id WHERE rel.team_number=5363603 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0137 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '724453' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0138 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6633758
AND ev.team2id = 6633763
AND ev.league_id = 75534
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0190 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,8.1247 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 178435 |
0.0135 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 178435 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0131 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6593760
AND c.team2 = 6593754
AND c.league_id = 72835
LIMIT 1 |
0.0128 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72835 AND id_match = 178435 |
0.0133 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72835' AND relp.team_id = drea.team_id WHERE rel.team_number=5363491 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0133 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72835' AND relp.team_id = drea.team_id WHERE rel.team_number=5363490 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0136 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '178435' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0129 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6593760
AND ev.team2id = 6593754
AND ev.league_id = 72835
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0137 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,5.4879 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 617262 |
0.0126 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 617262 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0129 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6605170
AND c.team2 = 6605171
AND c.league_id = 73595
LIMIT 1 |
0.0126 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 73595 AND id_match = 617262 |
0.0126 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '617262' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0142 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6605170
AND ev.team2id = 6605171
AND ev.league_id = 73595
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0194 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,4.9459 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 617261 |
0.0135 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 617261 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0131 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6605169
AND c.team2 = 6605166
AND c.league_id = 73595
LIMIT 1 |
0.0133 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 73595 AND id_match = 617261 |
0.0132 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '617261' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0143 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6605169
AND ev.team2id = 6605166
AND ev.league_id = 73595
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0153 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,4.8984 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 617252 |
0.0128 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 617252 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0127 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6605176
AND c.team2 = 6605167
AND c.league_id = 73595
LIMIT 1 |
0.0127 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 73595 AND id_match = 617252 |
0.0134 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='73595' AND relp.team_id = drea.team_id WHERE rel.team_number=5363060 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0139 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='73595' AND relp.team_id = drea.team_id WHERE rel.team_number=5363364 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0139 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '617252' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0143 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6605176
AND ev.team2id = 6605167
AND ev.league_id = 73595
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0196 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,4.8670 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 178429 |
0.0141 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 178429 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0127 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6593759
AND c.team2 = 6593756
AND c.league_id = 72835
LIMIT 1 |
0.0127 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 72835 AND id_match = 178429 |
0.0130 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72835' AND relp.team_id = drea.team_id WHERE rel.team_number=5363470 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0130 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='72835' AND relp.team_id = drea.team_id WHERE rel.team_number=5363546 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0131 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '178429' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0131 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6593759
AND ev.team2id = 6593756
AND ev.league_id = 72835
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0158 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,4.4338 as fcoef
FROM
calendars2024 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 727836 |
0.0129 | SELECT rel.media_id,c.id FROM calendars2024 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 727836 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0126 | SELECT r.showName
FROM calendars2024 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6605117
AND c.team2 = 6605123
AND c.league_id = 73592
LIMIT 1 |
0.0131 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 73592 AND id_match = 727836 |
0.0144 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='73592' AND relp.team_id = drea.team_id WHERE rel.team_number=5363538 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0144 | SELECT rel.*,relp.squadNumber as num,dp.alias,dp.role,dp.name,dp.nick,dp.last_name,dp.id as player_id, 0 AS rating FROM rel_dreamteam_real rel INNER JOIN dreamteam_data_real drea ON drea.id = rel.team_number INNER JOIN dataplayers dp ON dp.id = rel.player_id INNER JOIN rel_players AS relp ON relp.player_id=dp.id AND relp.league_id='73592' AND relp.team_id = drea.team_id WHERE rel.team_number=5363511 GROUP BY dp.id ORDER BY role ASC, pos ASC |
0.0143 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '727836' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0141 |
SELECT *, pl.nick AS player_name
FROM events2024 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6605117
AND ev.team2id = 6605123
AND ev.league_id = 73592
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0181 | SELECT
c.*,
l.year,
cat.id AS categoryId,
cat.name,
ds.name AS stadium,
ds.name AS stadium_name,
c.stadium AS real_stadium,
ds.seats,
ds.yearBuilt,
ds.size,
dt1.id AS dt1id,
dt2.id AS dt2id,
dt1.nameShow AS nameShow1,
dt2.nameShow AS nameShow2,
dt1.basealias AS basealias1,
dt2.basealias AS basealias2,
c.comments AS totalcomments,4.4003 as fcoef
FROM
calendars2023 c
INNER JOIN leagues l ON l.id = c.league_id
INNER JOIN categories cat ON cat.id = l.categoryId
INNER JOIN teams t1 ON t1.id = c.team1
INNER JOIN datateams dt1 ON dt1.id = t1.teamId
INNER JOIN teams t2 ON t2.id = c.team2
INNER JOIN datateams dt2 ON dt2.id = t2.teamId
LEFT JOIN rel_stadiums rs ON rs.teamId=t1.teamId AND rs.active=1
LEFT JOIN datastadiums ds ON ds.id=rs.stadium_id
WHERE
c.id = 903398 |
0.0127 | SELECT rel.media_id,c.id FROM calendars2023 c INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.league_id = c.league_id AND rel.round = c.round AND rel.team2 = c.team2 AND rel.media_id < 90000 WHERE c.id = 903398 AND rel.language = 'spanish' GROUP BY rel.media_id |
0.0126 | SELECT r.showName
FROM calendars2023 as c INNER JOIN referees as r
ON c.referee = r.id
WHERE c.team1 = 6616836
AND c.team2 = 6616827
AND c.league_id = 74410
LIMIT 1 |
0.0125 | SELECT id,team_id,tactica FROM dreamteam_data_real WHERE league_id = 74410 AND id_match = 903398 |
0.0125 |
SELECT mp.`player_id`, p.`nick`, p.`name`, p.`last_name`, mp.`team`, p.role, p.alias
FROM `matchs_players_called` AS mp INNER JOIN `dataplayers` AS p ON mp.`player_id` = p.`id`
WHERE mp.`match_id` = '903398' AND mp.year='2024'
ORDER BY mp.`team` ASC, p.`role` ASC
|
0.0128 |
SELECT *, pl.nick AS player_name
FROM events2023 AS ev
INNER JOIN dataplayers as pl ON ev.player_id=pl.id
WHERE ev.team1id = 6616836
AND ev.team2id = 6616827
AND ev.league_id = 74410
AND (
ev.action = 1 OR ev.action = 2 OR ev.action = 6 OR ev.action = 11 OR ev.action = 12 OR ev.action = 13
OR ev.action = 3 OR ev.action = 4 OR ev.action = 20
)
ORDER BY ev.minute ASC
|
0.0168 | SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.continent='af' AND c.troncal = 1 AND l.year = c.active_year ORDER BY l.start_date<'2024-05-11' AND l.end_date>='2024-04-11' DESC,l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC LIMIT 12 |
0.0128 | SELECT l.id FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 < 95 AND c.r2 < 95 AND c.shedule > '2024-04-26 18:58' AND (0 OR l.id = 72835 OR l.id = 73592 OR l.id = 75148 OR l.id = 75149 OR l.id = 73595 OR l.id = 73594 OR l.id = 73611 OR l.id = 75599 OR l.id = 75600 OR l.id = 73889 OR l.id = 73593 OR l.id = 73192) AND c.shedule < '2024-04-26 22:18' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12 |
0.0128 | SELECT l.id FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2009 as c ON c.league_id = l.id AND l.current_round = c.round WHERE l.status = 1 AND c.r1 > 95 AND c.r2 > 95 AND (0 OR l.id = 72835 OR l.id = 73592 OR l.id = 75148 OR l.id = 75149 OR l.id = 73595 OR l.id = 73594 OR l.id = 73611 OR l.id = 75599 OR l.id = 75600 OR l.id = 73889 OR l.id = 73593 OR l.id = 73192) AND c.shedule != '2024/04/26 00:00:00' AND c.shedule != '2024/04/27 00:00:00' AND c.shedule > '2024/04/26 22:18' AND c.shedule < '2024/04/27 10:14' GROUP BY l.id ORDER BY cat.coefficient DESC,l.group_code ASC LIMIT 12 |
0.0126 | SELECT l.year,c.alias,c.name,l.group_code,l.id,l.current_round,l.total_group,c.location,c.CountryCode FROM `leagues` as l INNER JOIN `categories` as c ON c.id = l.categoryId WHERE l.year = c.active_year AND (0 OR l.id = 72835 OR l.id = 73592 OR l.id = 75148 OR l.id = 75149 OR l.id = 73595 OR l.id = 73594 OR l.id = 73611 OR l.id = 75599 OR l.id = 75600 OR l.id = 73889 OR l.id = 73593 OR l.id = 73192) ORDER BY l.total_num_matchs = l.total_num_matchsR DESC,l.group_code>0 DESC,c.coefficient DESC,l.group_code ASC |
0.0125 | SELECT c.id as mid,c.r1,c.r2,c.shedule,c.datateam1,c.datateam2,c.team1,c.round,c.team2,l.year,l.id,dt1.nameShow as nameShow1,dt2.nameShow as nameShow2,dt1.basealias as basealias1,dt2.basealias as basealias2,c.comments as totalcomments FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN teams t1 ON t1.id = c.team1 INNER JOIN teams t2 ON t2.id = c.team2 INNER JOIN datateams dt1 ON dt1.id = t1.teamId INNER JOIN datateams dt2 ON dt2.id = t2.teamId WHERE l.status = 1 AND c.round >= 26 AND c.round <= 27 AND c.league_id = 72835 ORDER BY c.shedule ASC |
0.0125 | SELECT c.id,rel.media_id,rel.data,c.round FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN rel_media_match as rel ON rel.team1 = c.team1 AND rel.team2 = c.team2 AND (rel.media_id < 90000 OR rel.media_id = 99001) WHERE rel.language = 'spanish' AND l.status = 1 AND c.round >= 26 AND c.round <= 27 AND c.league_id = 72835 ORDER BY c.shedule ASC |
0.0125 | SELECT c.id,rel.team_id,c.round FROM leagues l INNER JOIN categories as cat ON cat.id = l.categoryId INNER JOIN calendars2024 as c ON c.league_id = l.id INNER JOIN events2024 as e ON e.team1id = c.team1 AND e.team2id = c.team2 AND (e.action = 3 OR e.action = 4) INNER JOIN rel_players rel ON rel.player_id = e.player_id AND rel.league_id = l.id AND l.id = 72835 WHERE l.status = 1 AND c.round >= 26 AND c.round <= 27 |
0.0132 | SELECT lm.action_name,lm.creation_date,lm.dt1,lm.dt2,c.CountryCode,lm.minute,c.coefficient,c.top,dt1.basealias as basealias1,dt2.basealias as basealias2 FROM live_matches lm INNER JOIN leagues l ON lm.league_id = l.id INNER JOIN categories c ON c.id = l.categoryId INNER JOIN datateams dt1 ON dt1.id = lm.dt1 INNER JOIN datateams dt2 ON dt2.id = lm.dt2 WHERE c.continent = 'af' AND lm.creation_date > '2024-04-26 21:18:03' ORDER BY lm.creation_date DESC LIMIT 20 |