Shiva Query for Email Information

SELECT

DISTINCT m.id AS memberid,
m.display_name AS full_name,
m.email AS email,
dl.gender AS gender,
sum(p.amount) as amount,
r.srid as total_res

FROM members m

LEFT JOIN driver_licenses dl
ON dl.member_id = m.id

LEFT  JOIN payments p
ON p.member_id = m.id

LEFT JOIN (
select
count(reservations.id) as srid,
reservations.member_id as mid,
reservations.state as state
from reservations
group by mid
) as r on r.mid = m.id

WHERE
m.imaginary = 'Normal'
AND m.state = 'Normal'
#AND dl.gender != ''
AND m.email NOT IN ('%socar.my', '%sk.com')
and p.paid_type = 'card'
and r.state = 'completed'
GROUP BY m.id , m.display_name