{exp:stash:set trim="yes" parse_tags="yes" process="start"}
	{stash:entry_id}{segment_1}{segment_2}{segment_3}{/stash:entry_id}
{/exp:stash:set}

{exp:stash:parse process="end"}

	{stash:embed:global-v4:base}

	{exp:stash:set name="{stash:entry_id}_body"}

	{!-- ================= BEGIN BODY MAIN CORE =================  --}	
	<!-- BEGIN .content -->
	<section class="content">

		<div class="wrapper">
				
			<section class="main-content row-fluid">	
				
				<main class="main nosidebar">

					{!--exp:query sql="SELECT field_id_585 as section_name, field_id_613 as section_short_name, field_id_587 as section_url, entry_id as section_id, count(*) as the_count FROM exp_channel_data cd JOIN exp_playa_relationships pr WHERE cd.entry_id = pr.child_entry_id AND pr.parent_entry_id='{entry_id}' AND (pr.parent_field_id='569' OR pr.parent_field_id='541' OR pr.parent_field_id='580') ORDER BY pr.rel_id ASC LIMIT 1"--}

					<h6>Query</h6>
					~~exp:query sql="SELECT ebb.entry_id as the_id, ect.url_title as the_url, ect.title as the_title, ecd.field_id_878 as canon_url FROM exp_blocks_atom eba JOIN exp_blocks_block ebb ON eba.block_id = ebb.id JOIN exp_channel_titles ect ON ebb.entry_id = ect.entry_id JOIN exp_channel_data ecd ON ecd.entry_id = ect.entry_id WHERE data LIKE '%Hawaii Guide&#39;s Recommended%'   "~~<br />
						Entry {the_id} - <a href="{canon_url}" target="_blank">{the_title}</a><br />
					~~/exp:query~~

					<hr />
					
					<h6>Results</h6>
					{exp:query sql="SELECT ebb.entry_id as the_id, ect.url_title as the_url, ect.title as the_title, ecd.field_id_878 as canon_url FROM exp_blocks_atom eba JOIN exp_blocks_block ebb ON eba.block_id = ebb.id JOIN exp_channel_titles ect ON ebb.entry_id = ect.entry_id JOIN exp_channel_data ecd ON ecd.entry_id = ect.entry_id WHERE data LIKE '%Hawaii Guide&#39;s Recommended%'   "}
						Entry {the_id} - <a href="{canon_url}" target="_blank">{the_title}</a><br />
					{/exp:query}
				
				</main>

			</section><!--main-->
	
		</div><!--wrapper -->
	
	<!-- BEGIN .content -->
	</section>	
	{!-- ================= END BODY MAIN CORE =================  --}	
	
	{/exp:stash:set}

	{exp:stash:set name="{stash:entry_id}_header_tags" parse_tags="yes"}
		{if '{segment_3}'==''}<META NAME="ROBOTS" CONTENT="NOINDEX, FOLLOW">{/if}
	{/exp:stash:set}

	{!-- HEADER TAGS --}
	{exp:stash:set name="{stash:entry_id}_header_css" parse_tags="yes"}

	{/exp:stash:set}
	
	{!-- Set the Entry Title --}		
	{exp:stash:set name="{stash:entry_id}_meta_title" trim="yes"}
		Recommended Entries to Check | Hawaii Guide
	{/exp:stash:set}
	
	{exp:stash:set name="{stash:entry_id}_canonical_url" trim="yes"}
		https://www.hawaii-guide.com{if segment_1}/{segment_1}{/if}{if segment_2}/{segment_2}{/if}{if segment_3}{segment_3}{/if}
	{/exp:stash:set}

	
	{exp:stash:set name="{stash:entry_id}_footer_tags" scope="site"}

	{/exp:stash:set}

{/exp:stash:parse}