Push Notifications for MFTs

select
members.id,
members.email,
ma.phone,
ma.phone_country,
members.display_name,
YEAR(curdate()) - YEAR(members.birthday) as age,
( select ifnull(count(reservations.id),0)
from reservations where reservations.member_id = members.id and reservations.state = 'completed'
) as srid
from members
left join driver_licenses
on driver_licenses.member_id = members.id
left join member_appendixes ma on ma.member_id = members.id
where members.state = 'normal'
and driver_licenses.state = 'approved'
and ( select ifnull(count(reservations.id),0)
from reservations where reservations.member_id = members.id and reservations.state = 'completed'
) = 0
and convert_tz(members.created_at, '+00:00', '+8:00') > '2019-1-1'
group by members.id