MySQL Error : BIGINT UNSIGNED value is out of range in '`easy-aidech`.`courses`.`part1_starthour` - 1'
Query:
SELECT
*,
courses.id as course_id,
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 schools.statute = 1
AND schools.canton_id LIKE '%'
AND schools.city LIKE BINARY '%'
AND schools.id LIKE '%'
AND 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