ALTER TABLE `mydb`.`lsports_fixtures` 
ADD INDEX `idx_fix_sports` (`fixture_sport_id` ASC);

ALTER TABLE `mydb`.`lsports_fixtures` 
ADD INDEX `idx_league_id` (`fixture_league_id` ASC);

ALTER TABLE `mydb`.`lsports_leagues` 
ADD INDEX `idx_bet_type` (`bet_type` ASC);