SELECT id,userimage,name,employment,city,state,company,plan FROM mlm_registration  WHERE country='Malaysia' AND state='Negeri sembilan' AND city='directory' AND status=1  and showindirctry='Y' and blockeduser='N'  ORDER BY joindate DESC