Check if two datetimes are between two others
To check for overlaps, you only need 2 conditions, the start or interval A with the end of interval B, and vice versa:

WHERE
      '2019-04-08 13:30:00.000' &lt; Stop 
  AND Start &lt; '2019-04-08 15:30:00.000'