Login using your booking system credentials to reserve block-booked courts
Login
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 >= '2024-05-08'
and courtdate <= adddate('2024-05-08', 7)
order by time, court, courtdate
Invalid query: Column 'court' in field list is ambiguous