Help with preventing double bookings with variable lengths
Lets say that we have two venues A and B with both a start date/time and a end date/time. We need to check whether their time spans overlap. They overlap if:

A.end &gt; B.start AND A.start &lt; B.end