Ver originalSELECT * FROM `tabla` WHERE (fecha = ADDDATE(CURDATE(), INTERVAL -1 DAY) AND hora >= '07:00:00') OR (fecha = CURDATE() AND hora <= '04:00:00')