Without look at this too hard, the COALESCE expression seems suspect. Since CURDATE() is never NULL, COALESCE(CURDATE(), h.enddate) will always equal CURDATE().

I think you need to switch the arguments.