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