Fix a sql query

I am looking for a SQL expert to help me fix a syntax error in my query. I will provide more information if you need.

SELECT um.meta_value, u.user_email, acb.{number of rows of last 30days} CONVERT_TZ(aa.bookingStart,'+00:00','+08:00'){only the lastest date}, CONVERT_TZ(ab.bookingStart,'+00:00','+08:00'){only the next not started time}, ab.zoomMeeting{only get the 11 numbers}, o.option_value
FROM wp_uap_affiliate_referral_users_relations AS ur
LEFT JOIN wp_uap_affiliates AS ua ON ua.id = ur.affiliate_id
LEFT JOIN wp_users AS u ON ur.referral_wp_uid = u.ID
LEFT JOIN wp_usermeta AS um ON um.user_id = u.ID AND um.meta_key = 'digits_phone'
LEFT JOIN wp_amelia_users AS au ON au.externalId = u.ID
LEFT JOIN wp_amelia_customer_bookings AS acb ON au.id = acb.customerId
LEFT JOIN wp_amelia_appointments AS aa ON acb.appointmentId = aa.id
LEFT JOIN wp_amelia_appointments AS ab ON acb.appointmentId = ab.id
LEFT JOIN wp_options AS o ON o.option_name = au.id //the o.option_name is like 'notes_for_1234', but only the 1234 = au.id
WHERE ua.uid = %CURRENT_USER_ID%


the zoom meeting column sample:
{"id":89444958249,"startUrl":"https:\/\/us02web.zoom.us\/s\/89444958249?zak=eyJ0eXAiOiJKV1QiLCJzdiI6IjAwMDAwMSIsInptX3NrbSI6InptX28ybSIsImFsZyI6IkhTMjU2In0.eyJhdWQiOiJjbGllbnRzbSIsInVpZCI6IlpxTHJuRmN1VG5pSkZ4Y19zbDdyblEiLCJpc3MiOiJ3ZWIiLCJzayI6IjQ5ODcyNTU2NDY1ODUyOTY0NDYiLCJzdHkiOjEwMCwid2NkIjoidXMwMiIsImNsdCI6MCwibW51bSI6Ijg5NDQ0OTU4MjQ5IiwiZXhwIjoxNjQ5MDgzMDk1LCJpYXQiOjE2NDkwNzU4OTUsImFpZCI6InV3eEZwMFUzU0phUWlyN242Vm80aGciLCJjaWQiOiIifQ.QpEX0UKgPXafdtkzBFqFzv9T2xHFBVqU8CWR2zNdKAY","joinUrl":"https:\/\/us02web.zoom.us\/j\/89444958249"}