Join two tables using period and interval between two dates

This is a secondary table (dotable2) for each user a time interval is stored in which the user was blocked.

Read at SitePoint Forums | Web Development & Design Community