Ver originalSELECT *FROM tuTablaWHERE TIMESTAMP(fecha,hora) >= TIMESTAMP(CURDATE(),'18:00:00') AND TIMESTAMP(fecha,hora) <=TIMESTAMP(ADDDATE(CURDATE() , INTERVAL 1 DAY),'07:00:00')
Ver originalSELECT *FROM tuTablaWHERE TIMESTAMP(fecha,hora) >= TIMESTAMP(DATE_SUB(CURDATE() , INTERVAL 1 DAY),'18:00:00') AND TIMESTAMP(fecha,hora) <=TIMESTAMP(CURDATE(),'07:00:00')