{exp:stash:set name="list_entry_id" parse_tags="yes" parse_conditionals="yes" trim="yes"}

	{exp:query sql="SELECT entry_id as the_id FROM exp_channel_titles WHERE pr.parent_entry_id={stash:entry_id} AND pr.parent_field_id=562 AND ct.status!='closed' AND ct.status!='To Delete' AND ct.status!='Archived' AND ct.status!='draft' && ct.status!='To Monetize' && ct.status!='Needs Kids' && ct.status!='Quiz' && ct.status!='Quiz-Retake' && ct.status!='Visitor Guide' ORDER BY pr.rel_id ASC "}

	{/exp:query}

{/exp:stash:set}


{exp:stash:set_list name="list-{stash:list_name}" parse_tags="yes" parse_conditionals="yes" trim="yes" parse_depth="2"}

	{exp:channel:entries dynamic="no" entry_id="{stash:list_entry_id}" fixed_order="{stash:list_entry_id}" disable="categories|member_data|pagination" status="not Closed|To Delete|Archived|To Monetize|Needs Kids|Quiz|Visitor Guide|Quiz-Retake" require_entry="yes" }
			
		{if '{channel_short_name}'=='pages' || '{channel_short_name}'=='pages_no_search' || '{channel_short_name}'=='sections' || '{channel_short_name}'=='authority_pages'}
		
				{stash:theid}{entry_id}{/stash:theid}
				{stash:thechannel}{channel_short_name}{/stash:thechannel}
				{stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date}
				{stash:heading}{exp:ce_str:ing truncate="50"}{title}{/exp:ce_str:ing}{/stash:heading}
				{stash:heading}{exp:ce_str:ing truncate="80"}{page_heading}{/exp:ce_str:ing}{/stash:heading}
				{stash:heading_url}{page_url_segment}{/stash:heading_url}
				{stash:singular}{page_short_heading}{/stash:singular}
				{stash:icon}
					{if page_icon_block}{page_icon_block}{if:else}{page_icon}{/if}
				{/stash:icon}

				
			{if:elseif '{channel_short_name}'=='hub' || '{channel_short_name}'=='classification' || '{channel_short_name}'=='subclassification' || '{channel_short_name}'=='type' || '{channel_short_name}'=='regions' || '{channel_short_name}'=='hybrid' || '{channel_short_name}'=='store_classification' || '{channel_short_name}'=='store_subclassification'}
			
				{stash:theid}{entry_id}{/stash:theid}
				{stash:thechannel}{channel_short_name}{/stash:thechannel}
				{stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date}
				{stash:heading}{exp:ce_str:ing truncate="80"}{custom_heading}{/exp:ce_str:ing}{/stash:heading}
				{stash:heading_url}{custom_url_segment}{/stash:heading_url}
				{stash:singular}{custom_name_singular}{/stash:singular}
				{stash:icon}
					{if custom_icon_block}{custom_icon_block}{if:else}{custom_icon}{/if}
				{/stash:icon}

					
			{if:else}
			
				{stash:theid}{entry_id}{/stash:theid}
				{stash:thechannel}{channel_short_name}{/stash:thechannel}
				{stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date}
				{stash:heading}{if entry_heading}{exp:ce_str:ing truncate="50"}{entry_heading}{/exp:ce_str:ing}{if:else}{exp:ce_str:ing truncate="50"}{title}{/exp:ce_str:ing}{/if}{/stash:heading}
				{stash:heading_url}{url_title}{/stash:heading_url}
				{stash:icon}
					{if '{entry_image_override}'!=''}//cdn.hawaii-guide.com/spots_icons/{entry_image_override}{if:elseif entry_icon_block}{entry_icon_block}{if:else}{entry_icon}{/if}
				{/stash:icon}
				
			{/if}

	{/exp:channel:entries}

{/exp:stash:set_list}



{exp:stash:get_list name="list-{stash:list_name}" unique="theid" backspace="0" parse_tags="yes"}
<p>
	{heading}<br />
	<img src="https://www.hawaii-guide.com{exp:jcogs_img:pair src='{icon}' crop='yes|center,center|0,0' width='750' allow_scale_larger='yes' height='400' quality='90'}{made}{/exp:jcogs_img:pair}">
</p>

{/exp:stash:get_list}