SELECT MYSQL_locationstesting.*, MYSQL_locations.sitenumb

FROM MYSQL_locationstesting

INNER JOIN MYSQL_locations
ON MYSQL_locationstesting.siteid=MYSQL_locations.id

WHERE MYSQL_locationstesting.display = 1
AND (CONVERT(DATE, MYSQL_locationstesting.duedate) < CAST(GETDATE() AS DATE)
AND MYSQL_locations.active = 1
OR CONVERT(DATE, MYSQL_locationstesting.duedate) BETWEEN DATEADD(DAY, -1, CAST(GETDATE() AS DATE))
AND DATEADD(DAY, 5, CAST(GETDATE() AS DATE)))