starview.sql

SELECT * FROM booking 
	left join booking_room on booking.id = booking_room.booking_id 
    left join room  on booking_room.room_id=room.id 
    where checkout < "2021-04-24";
    
select * from room 
	left join booking_room on room.id = booking_room.room_id 
	LEFT join booking on booking_room.booking_id = booking.id 
	where (booking.checkout < "2021-04-24" or booking.checkout is null) or booking.checkin > "2021-04-24" order by booking.id asc;