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