MySQL Error : BIGINT UNSIGNED value is out of range in '`easy-aidech`.`courses`.`part1_starthour` - 1'
Query:
SELECT
courses.*,
schools.school,
schools.address,
schools.zip,
schools.city,
cantons.abbr,
cantons.name,
trainers.id as trainerid
FROM courses
INNER JOIN schools ON school_id = schools.id
INNER JOIN cantons ON schools.canton_id = cantons.id
INNER JOIN trainers ON trainers.id = courses.part1_trainer_id
WHERE DATE_ADD(courses.part1_date, INTERVAL courses.part1_starthour - 1 HOUR) > NOW()
AND courses.part1_date < ADDDATE(NOW(),180)
AND courses.statute = 1
ORDER BY courses.part1_date ASC