SELECT `bookingafx_appointments`.*, `bookingafx_services`.`title`, `bookingafx_services`.`duration`, `bookingafx_services`.`color`, `bookingafx_customers`.`full_name`
FROM `bookingafx_appointments`
JOIN `bookingafx_services` ON `bookingafx_services`.`id`=`bookingafx_appointments`.`service_id`
JOIN `bookingafx_customers` ON `bookingafx_customers`.`id`=`bookingafx_appointments`.`customer_id`
WHERE `bookingafx_appointments`.`status` = 'Confirmed'
AND date(bookingafx_appointments.start_datetime)="2025-10-09"

IAA Center

Managed Solution by

Brother Mohammed Ahmed Managing Director at IASHINE ENTERPRISES INC P 833-427-4463 ext 1 ● M 469-288-2466 ● W https://iashine.com For any assistance do contact us on above mentioned details.