{exp:query sql="SELECT field_id_548 as region_name, field_id_593 as region_short_name, field_id_544 as region_url, field_id_955 as region_canon_url, count(*) as the_count FROM exp_channel_data cd JOIN exp_playa_relationships pr WHERE cd.entry_id = (SELECT pr.child_entry_id as child_id FROM exp_playa_relationships pr WHERE pr.parent_entry_id={segment_3} AND pr.parent_field_id='536' ORDER BY pr.rel_order ASC LIMIT 1) LIMIT 1"}
		{stash:region}{if '{region_short_name}'!=''}{region_short_name}{if:else}{region_name}{/if}{/stash:region}
		{stash:region_url}{if '{region_url}'}/{region_url}{/if}{/stash:region_url}
		{stash:region_canon_url}{region_canon_url}{/stash:region_canon_url}
		{stash:region_primary}{if '{region_short_name}'!=''}{region_short_name}{if:else}{region_name}{/if}{/stash:region_primary}
	{/exp:query}