Referrals_rahil_very_basic

select
date(m.created_at + interval '8' hour) as date,
m.id as mid,
ifnull(m.email,0) as email,
IFNULL(ma.recommender,"") as referral
from members m
left join member_appendixes ma
on m.id = ma.member_id
where m.imaginary = 'normal'