delete from betclic_game_odd_choices where betclic_game_odds_id in (select id from betclic_game_odds where betclic_game_id in (select id from betclic_games where betclic_event_id in (select id from betclic_events where betclic_sport_id in (1,2,3,4))))

delete from betclic_game_odds where betclic_game_id in (select id from betclic_games where betclic_event_id in (select id from betclic_events where betclic_sport_id in (1,2,3,4)))

delete from betclic_games where betclic_event_id in (select id from betclic_events where betclic_sport_id in (1,2,3,4))

delete from betclic_events where betclic_sport_id in (1,2,3,4)

alter table ticket_games drop foreign key ticket_games_odd_id_foreign;