| 0.0216 | 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.top = 1 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 30 |
| 0.0145 | 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.top = 1 AND lm.creation_date > '2024-04-26 10:00:10' ORDER BY lm.creation_date DESC LIMIT 8 |
| 0.0146 | 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.top = 1 AND lm.creation_date > '2024-04-20 10:00:10' ORDER BY lm.creation_date DESC LIMIT 15 |
| 0.0232 | 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.top = '1' AND c.date = '2024-04-28' GROUP BY cat.location ORDER BY coefficient DESC |
| 0.0229 | 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.top = '1' AND c.date = '2024-04-28' GROUP BY l.id ORDER BY coefficient DESC,group_code ASC LIMIT 70 |
| 0.0316 | 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.top = '1' AND cat.ctype IN (1,3,12,34,36) AND c.shedule >= '2024-04-28 00:00:00' AND c.shedule < '2024-04-28 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 100 |
| 0.0313 | 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.top = '1' AND cat.ctype IN (1,3,12,34,36) AND c.id IN (30564,30567,30571,29271,12959,12965,12964,103432,103431,103430,103437,103429,61175,61155,61172,61179,61182,61154,75398,75401,75409,70811,70801,70806,70809,70802,70808,70804,193266,193338,193351,193355,193276,193341,193343,193370,193347,193274,193360,193367,728095,58739,58740,58741,58742,107841,58743,107837,107839,196897,198017,197115,197740,196901,198020,197118,197748,196905,198024,197456,197755,196908,198028,197461,197761,197098,198029,197464,197765,197100,198030,197468,196881,197769,197103,198031,197470,196884,197771,197105,206332,197474,196888,197774,197107,197477,196890,197777,197110,197480,196893,198011,197113,197482,706695,706700,706696,706697,706699,706701) AND c.shedule >= '2024-04-28 00:00:00' AND c.shedule < '2024-04-28 23:59:59' GROUP BY c.id ORDER BY coefficient DESC,shedule ASC LIMIT 200 |
| 0.0164 | SELECT name,eventId,odds,id_,live_id, link FROM bet_relations WHERE eventId IN (153577921, 153577933, 153577938, 153577940, 153577858, 153577849, 153577868, 154053137, 154053114, 154053109, 154053149, 154053123, 154139311, 154139316, 154139313, 154139321, 154139319, 154139324, 153577890, 153577893, 153577898, 153577949, 153577957, 153577951, 153577954, 153577962, 153577964, 154448272, 153577968, 153577987, 153577975, 153578007, 153577993, 153578009, 153578011, 154139319, 153790915, 154149830, 154149833, 154149840, 154149836, 154149846, 154149855) AND typeId=40 AND site='bet365' ORDER BY eventId ASC |
| 0.0698 | 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.0698 | 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.0698 | 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.0698 | 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.0698 | 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.0698 | (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.top = '1' AND c.shedule >= '2024-04-28 00:00:00' AND c.shedule < '2024-04-28 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.top = '1' AND c.shedule >= '2024-04-28 00:00:00' AND c.shedule < '2024-04-28 23:59:59') ORDER BY field(lang,'es') DESC, shedule ASC |
