SELECT id,userimage,name,employment,city,state,company,plan FROM mlm_registration WHERE FIND_IN_SET('5',immlm) > 0 AND country='New zealand' AND state='registration' AND status=1 and showindirctry='Y' and blockeduser='N' ORDER BY joindate DESC