mysql - Use left join with two conditions -

i trying implement left join query wherein have 2 conditions it.

below current query not display correct data. doing correctly?

  select a.date_created, u.id, case when a.status = 0 'not verified' else 'verified' end status    affiliates left join users u    on  a.referral_code =u.ref_code or  a.sub_referral_code = u.ref_code   a.referral_code = 'cx0msu3axal8' or  a.sub_referral_code = 'cx0msu3axal8'; 

here output

this must result

appreciate this. thanks!

i have fixed problem. got little confused condition part of query. here working query made:

 select a.date_created, u.id, case a.`status` when 0 'not verified' else 'verified' end `status`   affiliates left join users u   on  a.email = u.email  a.referral_code = 'cx0msu3axal8' or  a.sub_referral_code = 'cx0msu3axal8';  

still feedbacks. appreciate it!