Temporary court bookings

Login using your booking system credentials to reserve block-booked courts

select book.id, courtdate, time, court, type, memberid, `desc`, forename, surname, slot.slot_id from gxsc_bookslots as slot right outer join gxsc_bookings as book on book.time = slot.timeslot left outer join gxsc_members as mem on mem.id = book.memberid where courtdate >= '2022-05-29' and courtdate <= adddate('2022-05-29', 7) order by time, court, courtdate

Invalid query: Column 'court' in field list is ambiguous