SELECT hr.RSLID, hr.NAME, hr.HEADOFFICE, hr.ADDRESS, hr.ADD1, hr.ADD2, hr.ADD3, hr.TOWN, hr.COUNTY, hr.COUNTRY, hr.POSTCODE, hr.TYPE, hr.WEB, hr.EMAIL, hr.PHONE, hr.FAX, hr.CONTACTNAME, hr.CONTACTMAIL, hr.PROPMAINTAIN, hr.DETAILS, hr.LOGO, hr.RSL_TYPE2, hr.reg_no, hr.updated, hr.DXNUMBER, hr.NEWCONTACT, hr.countryid, hr.bldgname, hr.address1, hr.address2, hr.citytown, hr.countyid, hr.pcode, hr.countryiddb, hr.countyiddb, hr.towndb, hr.UpdFlag, hr.export_flag FROM	hnet_rslmaster hr INNER JOIN rsl_parent rp ON  (hr.TYPE=rp.name_id) INNER JOIN rsl_type2 rt  ON (hr.RSL_TYPE2=rt.name_id) LEFT OUTER JOIN hnet_county_city hc ON  (hr.countyid=hc.countyid) WHERE (hr.export_flag = 'Y') AND (hr.TYPE!='A') AND (hr.countryid = ~) AND (hr.countyid = 37)  ORDER BY hr.NAME ASC