{stash:hc_url}
	{exp:query sql="SELECT DISTINCT(HotelID) as hotelid_hc, HotelFileName as hotelurl_hc FROM aff_hc_hotels WHERE HotelAddress LIKE '%{embed:address}%' PropertyType='Hotel' OR PropertyType='Resort' ORDER BY pl.city ASC"}{hotelurl_hc}{/exp:query}
{/stash:hc_url}