1 2 3 4 5 6 7 8 9 10 11 12
| INSERT INTO footballpredictionproject.odds ( idOdds, idHomeTeam, idAwayTeam, nameHomeTeam, nameAwayTeam, oddsType, odds, date, description)
(
SELECT NULL,e.Participant_ID_1, e.Participant_ID_2, p1.Primary_Name, p2.Primary_Name, b.Bet_Style_ID, b.Best_Odds, e.Event_Start_Timestamp, e.Event_Description
FROM `bet_types` b
JOIN events e ON b.Event_ID = e.Event_ID
JOIN participants p1 ON e.Participant_ID_1 = p1.Participant_ID
JOIN participants p2 ON e.Participant_ID_2 = p2.Participant_ID
WHERE (b.Bet_Style_ID =14
OR b.Bet_Style_ID =15)
AND b.Bet_Style_Mutator = 2.5
) |
Partager