| 0.0313 | SELECT dt.nameShow,dt.basealias,t.id,t.teamId FROM teams t INNER JOIN datateams dt ON t.teamId = dt.id INNER JOIN leagues l ON l.id = t.league_id INNER JOIN categories c ON c.id = l.categoryId WHERE dt.main_image = 1 AND c.troncal = 1 AND l.year=c.active_year AND c.continent = 'as' GROUP BY t.teamId ORDER BY c.coefficient*dt.relations DESC LIMIT 30 |
| 0.0126 | 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_history 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 = 'as' AND lm.creation_date > '2024-04-26 12:01:19' ORDER BY lm.creation_date DESC LIMIT 8 |
| 0.0126 | 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_history 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 = 'as' AND lm.creation_date > '2024-04-20 12:01:19' ORDER BY lm.creation_date DESC LIMIT 15 |
| 0.0218 | SELECT l.id FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE c.active_year = l.year AND c.continent = 'as' ORDER BY c.coefficient |
| 0.0203 | SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date<'2024-05-07' AND l.end_date >'2024-05-02' AND c.active_year = l.year AND c.continent = 'as' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.location ASC,c.coefficient DESC |
| 0.0126 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 97 |
| 0.0126 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 370 |
| 0.0126 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 1570 |
| 0.0127 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 2439 |
| 0.0126 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 1887 |
| 0.0126 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 403 |
| 0.0125 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 477 |
| 0.0125 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 1704 |
| 0.0128 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 265 |
| 0.0127 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 589 |
| 0.0126 | SELECT MIN(next_shedule) as next_shedule FROM leagues WHERE next_shedule > '2024-04-26' AND categoryId = 122 |
| 0.0347 | SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.end_date <'2024-05-02' AND c.active_year = l.year AND c.continent = 'as' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.location ASC,c.coefficient DESC |
| 0.0220 | SELECT c.troncal,l.id,c.name,l.group_code,l.total_group,c.location,c.CountryCode,c.logo,l.current_round,l.start_date,l.end_date,l.total_rounds,l.next_shedule,c.alias,l.categoryId FROM leagues l INNER JOIN categories c ON c.id = l.categoryId WHERE l.start_date >'2024-05-02' AND c.active_year = l.year AND c.continent = 'as' GROUP BY l.categoryId ORDER BY c.troncal = 1 DESC,c.location ASC,c.coefficient DESC |
| 0.0125 | SELECT MIN(start_date) as start_date FROM leagues WHERE start_date > '2024-04-26' AND categoryId = 1887 |
| 0.0164 | 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 = 'as' or cat.continent = 'oc') AND c.date = '2024-04-26' GROUP BY cat.location ORDER BY coefficient DESC |
| 0.0163 | 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 = 'as' or cat.continent = 'oc') AND c.date = '2024-04-26' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70 |
| 0.0181 | SELECT c.id AS mid, l.year,cat.coefficient,l.id 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 WHERE (cat.continent = 'as' or cat.continent = 'oc') AND cat.ctype IN (1,3,12,34,36) 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.0174 | 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.betId_bwin,c.betId_marca,c.betId_888,c.betId_sportium, c.betId_marathon, 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 = 'as' or cat.continent = 'oc') AND cat.ctype IN (1,3,12,34,36) AND c.id IN (690940,690941,690937,690938,690942,690943,690939,37074,37076,37075,37077,177744,177750,177745,722920,722921,722914,722918,722919,521093,7987,7988,7989,728625,728626,717343,717344,709198,728330,728331,727071,727072,727097,727098,727099,727100,727069,727070,723189,613517,613518,613516,613525,613526,613527,613528,613529,636629,641884,641885,629756,629757,673516,548158,547914,548159,547915,548160,547916,548161,547917,547918,547919,547920,548155,548156,548157,548154,612506,612509,612504,612505,717222,717224,717220,717223,717225,717226,717221,716341,716343,716338,716238,716239,716246,716337,716339,716347,716348,716231,716232,716233,716237,716351,716349,716234,716242,716340,719556,719557) 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 200 |
| 0.0128 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (154200473, 154200477, 154200481, 154200485, 154200479, 154200483, 154200489, 153793704) AND typeId=40 AND site='bet365' ORDER BY eventId ASC |
| 0.0182 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='bwin' ORDER BY eventId ASC |
| 0.0182 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='marca' ORDER BY eventId ASC |
| 0.0182 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='b888sport' ORDER BY eventId ASC |
| 0.0182 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='sportium' ORDER BY eventId ASC |
| 0.0182 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN () AND typeId=40 AND site='mbet' ORDER BY eventId ASC |
| 0.0182 | (SELECT c.id,rel.media_id,rel.data,c.shedule, med.lang 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 = 'as' or cat.continent = 'oc') 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, med.lang 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 = 'as' or cat.continent = 'oc') AND c.shedule >= '2024-04-26 00:00:00' AND c.shedule < '2024-04-26 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC |
