SELECT distinct(cnid) as cnid,mapi, cat from cmcities WHERE rid= and status=1 and cat=1