SELECT a.id AS booking1,

   b.id AS booking2,

   a.start_date, a.end_date,

   b.start_date, b.end_date

FROM bookings a

JOIN bookings b

ON a.id < b.id

AND a.start_date <= b.end_date

AND a.end_date >= b.start_date;