{stash:embed:global-v4:base} {!--stash:embed:data-v4:list-items stash:list_entry_id="86469|102273|29265|29273" stash:list_layout="" stash:list_name="cr_block-{cr_block_count}" stash:list_ratio="111" stash:list_columns="1" stash:max_entries="" stash:wrapper="show" stash:utm_status="" stash:list_height="def"--} {exp:stash:set name="{stash:entry_id}_body"} BLOCK ITEM TILES AKA ADBLOCKS - 102273|86469|148017|146798 102273 - AdBlock - Kona Kozys Comedy and Magic Show 86469 - (AdBlock - Big Island Luaus (HT-White Label)) 148017 - AdBlock - Aston Waikiki Beach Hotel 146798 - AdBlock - South Big Island Hotels & Resorts HYBRID - 29273|29265 29273 - Big Island - Golf Packages 29265 - Big Island - Museums ELSE/ENTRIES - 28885|146 28885 - Which Hawaii Island to Visit? 146 - Hawaii Must See & Do
{exp:stash:set_list name="list-testing" parse_tags="yes" parse_conditionals="yes" trim="yes"} {exp:channel:entries dynamic="no" entry_id="102273|86469|148017|146798|29273|29265|28885|146" disable="categories|member_data|pagination" status="not Closed" require_entry="no"} {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: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} {stash:icon-affiliate} {/stash:icon-affiliate} {stash:nofollow}{/stash:nofollow} {stash:newwindow}{/stash:newwindow} {stash:emblem_icon}{/stash:emblem_icon} {stash:emblem_title}{page_emblem limit="1"}{emblem_heading}{/page_emblem}{/stash:emblem_title} {stash:emblem_code}{page_emblem limit="1"}{emblem_code}{/page_emblem}{/stash:emblem_code} {stash:emblem_code2}{page_emblem limit="1" offset="1"}{emblem_code}{/page_emblem}{/stash:emblem_code2} {stash:affiliate-count}{/stash:affiliate-count} {stash:watermark_button} {if '{page_button_watermark}'!=''}{page_button_watermark}{if:else}learn-more-v8.png{/if} {/stash:watermark_button} {stash:call_to_action_button} {exp:switchee variable="{page_button_watermark}"} {case value="explore-now-v8.png"}explore now →{/case} {case value="learn-more-v8-ext.png"} learn more{/case} {case value="book-online-v8.png"} book online{/case} {case value="learn-more-ta-v8.png"} learn more{/case} {case value="book-now-ta-v8.png"} book now{/case} {case value="book-now-v8.png"} book now{/case} {case value="buy-online-amz-v8.png"} buy online{/case} {case value="buy-now-v8.png"} buy online{/case} {case value="shop-now-v8.png"} shop now{/case} {case default="yes"}learn more →{/case} {/exp:switchee} {/stash:call_to_action_button} {stash:guidereview-letter} {/stash:guidereview-letter} {stash:tile-ribbon}{/stash:tile-ribbon} {stash:canon_url} {if page_canonical} {page_canonical} {if:else} {exp:query sql="SELECT field_id_587 as section_url 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=580 ORDER BY pr.rel_id ASC LIMIT 1 "}/{section_url}{/exp:query}{exp:query sql="SELECT field_id_544 as type_url 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=784 ORDER BY pr.rel_id ASC LIMIT 1 "}/{type_url}{/exp:query}/{url_title} {/if} {/stash:canon_url} {stash:region_name} {/stash:region_name} {if:elseif '{channel_short_name}'=='workflow_ads_blocks' || '{channel_short_name}'=='affiliate_blocks' || '{channel_short_name}'=='affiliate_hotels' || '{channel_short_name}'=='store_blocks'} {stash:theid}{entry_id}{/stash:theid} {stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date} {stash:heading}{if ad_cta_long}{ad_cta_long}{if:else}{ad_cta}{/if}{/stash:heading} {stash:heading_url}{ad_url}{/stash:heading_url} {stash:icon}{ad_graphic}{/stash:icon} {stash:icon-affiliate} {if ('{channel_short_name}'=='affiliate_blocks' || '{channel_short_name}'=='affiliate_hotels') && '{ad_image_override}'!='' && '{ad_image_directory}'!=''} //cdn.hawaii-guide.com/ta/{ad_image_directory}/{ad_image_override} {/if} {if '{channel_short_name}'=='store_blocks' && '{ad_image_override}'!=''} //cdn.hawaii-guide.com/store/{ad_image_override} {/if} {/stash:icon-affiliate} {stash:nofollow}{ad_nofollow}{/stash:nofollow} {stash:newwindow}{ad_new_window}{/stash:newwindow} {stash:emblem_icon} {exp:jcogs_img:pair hide_relative_path="yes" src="{ad_emblem_icon}" width="90" height="74"}{made}{/exp:jcogs_img:pair} {/stash:emblem_icon} {stash:emblem_title}{ad_emblem limit="1"}{emblem_heading}{/ad_emblem}{/stash:emblem_title} {stash:emblem_code}{ad_emblem limit="1"}{emblem_code}{/ad_emblem}{/stash:emblem_code} {stash:emblem_code2}{ad_emblem limit="1" offset="1"}{emblem_code}{/ad_emblem}{/stash:emblem_code2} {stash:emblem_heading}{ad_cta}{/stash:emblem_heading} {stash:website}{/stash:website} {stash:direct-link}{/stash:direct-link} {stash:tile-ribbon}{ad_ribbon}{/stash:tile-ribbon} {stash:ad-link} {if '{ad_url_hc}'!=''} {ad_url_hc} {if:elseif '{ad_url}'!=''} {ad_url}{if '{ad_utm}'!='off' && '{stash:utm_status}'!='off'}?utm_source=www.hawaii-guide.com&utm_medium=referral&utm_campaign=ad-block{/if} {/if} {/stash:ad-link} {stash:cj-ta} {if '{ad_url_hc}'!='' && '{ad_url}'!=''} {ad_url}{if '{ad_utm}'!='off' && '{stash:utm_status}'!='off'}?utm_source=www.hawaii-guide.com&utm_medium=referral&utm_campaign=ad-block{/if} {/if} {/stash:cj-ta} {stash:cj-hc}{/stash:cj-hc} {stash:hc}{/stash:hc} {stash:commission-links} {/stash:commission-links} {stash:watermark_button} {if '{ad_button_watermark}'!=''}{ad_button_watermark}{if:else}learn-more-v8.png{/if} {/stash:watermark_button} {stash:call_to_action_button} {exp:switchee variable="{ad_button_watermark}"} {case value="explore-now-v8.png"}explore now →{/case} {case value="learn-more-v8-ext.png"} learn more{/case} {case value="book-online-v8.png"} book online{/case} {case value="learn-more-ta-v8.png"} learn more{/case} {case value="book-now-ta-v8.png"} book now{/case} {case value="book-now-v8.png"} book now{/case} {case value="buy-online-amz-v8.png"} buy online{/case} {case value="buy-now-v8.png"} buy online{/case} {case value="shop-now-v8.png"} shop now{/case} {case default="yes"}learn more →{/case} {/exp:switchee} {/stash:call_to_action_button} {stash:guidereview-letter} {/stash:guidereview-letter} {stash:affiliate-count}{ad_affiliate_links:total_rows}{/stash:affiliate-count} {stash:canon_url}{/stash:canon_url} {stash:region_name} {/stash:region_name} {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: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} {stash:icon-affiliate} {/stash:icon-affiliate} {stash:nofollow}{/stash:nofollow} {stash:newwindow}{/stash:newwindow} {stash:website}{/stash:website} {stash:direct-link}{/stash:direct-link} {stash:tile-ribbon}{/stash:tile-ribbon} {stash:ad-link} {if custom_white_label} {custom_white_label}{!--?utm_source=www.hawaii-guide.com&utm_medium=referral&utm_campaign=ad-block--} {/if} {/stash:ad-link} {stash:cj-ta}{/stash:cj-ta} {stash:cj-hc}{/stash:cj-hc} {stash:hc}{/stash:hc} {stash:commission-links} {/stash:commission-links} {stash:emblem_icon}{/stash:emblem_icon} {stash:emblem_title}{custom_emblem limit="1"}{emblem_heading}{/custom_emblem}{/stash:emblem_title} {stash:emblem_code}{custom_emblem limit="1"}{emblem_code}{/custom_emblem}{/stash:emblem_code} {stash:emblem_code2}{custom_emblem limit="1" offset="1"}{emblem_code}{/custom_emblem}{/stash:emblem_code2} {stash:watermark_button} {if '{custom_button_watermark}'!=''}{custom_button_watermark}{if:else}learn-more-v8.png{/if} {/stash:watermark_button} {stash:call_to_action_button} {exp:switchee variable="{custom_button_watermark}"} {case value="explore-now-v8.png"}explore now →{/case} {case value="learn-more-v8-ext.png"} learn more{/case} {case value="book-online-v8.png"} book online{/case} {case value="learn-more-ta-v8.png"} learn more{/case} {case value="book-now-ta-v8.png"} book now{/case} {case value="book-now-v8.png"} book now{/case} {case value="buy-online-amz-v8.png"} buy online{/case} {case value="buy-now-v8.png"} buy online{/case} {case value="shop-now-v8.png"} shop now{/case} {case default="yes"}learn more →{/case} {/exp:switchee} {/stash:call_to_action_button} {stash:guidereview-letter} {/stash:guidereview-letter} {stash:affiliate-count}{/stash:affiliate-count} {stash:canon_url} {if custom_canonical} {custom_canonical} {if:else} {exp:query sql="SELECT field_id_587 as section_url 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=541 ORDER BY pr.rel_id ASC LIMIT 1 "}/{section_url}{/exp:query}{exp:query sql="SELECT field_id_544 as type_url 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=595 ORDER BY pr.rel_id ASC LIMIT 1 "}/{type_url}{/exp:query}{exp:query sql="SELECT field_id_544 as class_url 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=543 ORDER BY pr.rel_id ASC LIMIT 1 "}/{class_url}{/exp:query}/{url_title} {/if} {/stash:canon_url} {stash:region_name} {/stash:region_name} {if:else} {stash:theid}{entry_id}{/stash:theid} {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_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} {stash:icon-affiliate} {/stash:icon-affiliate} {stash:website}{entry_website}{if '{entry_utm_codes}'!='off' && '{stash:utm_status}'!='off'}?utm_source=www.hawaii-guide.com&utm_medium=referral{/if}{/stash:website} {stash:direct-link}{entry_direct_link}{/stash:direct-link} {stash:tile-ribbon}{/stash:tile-ribbon} {stash:ad-link} {if entry_white_label} {entry_white_label}{!--?utm_source=www.hawaii-guide.com&utm_medium=referral&utm_campaign=ad-block--} {/if} {/stash:ad-link} {stash:icon-cj}{cj_photo}{/stash:icon-cj} {stash:cj-ta}{cj_ta_deep_link}{/stash:cj-ta} {stash:cj-hc}{cj_ad_deep_link}{/stash:cj-hc} {stash:hc}{/stash:hc} {stash:nofollow}{/stash:nofollow} {stash:newwindow}{/stash:newwindow} {stash:watermark_button} {if '{entry_button_watermark}'!=''}{entry_button_watermark}{if:else}learn-more-v8.png{/if} {/stash:watermark_button} {stash:call_to_action_button} {exp:switchee variable="{entry_button_watermark}"} {case value="explore-now-v8.png"}explore now →{/case} {case value="learn-more-v8-ext.png"} learn more{/case} {case value="book-online-v8.png"} book online{/case} {case value="learn-more-ta-v8.png"} learn more{/case} {case value="book-now-ta-v8.png"} book now{/case} {case value="book-now-v8.png"} book now{/case} {case value="buy-online-amz-v8.png"} buy online{/case} {case value="buy-now-v8.png"} buy online{/case} {case value="shop-now-v8.png"} shop now{/case} {case default="yes"}learn more →{/case} {/exp:switchee} {/stash:call_to_action_button} {stash:guidereview-letter}{entry_guidereview_grade}{/stash:guidereview-letter} {stash:emblem_title}{entry_emblem limit="1"}{emblem_heading}{/entry_emblem}{/stash:emblem_title} {stash:emblem_code}{entry_emblem limit="1"}{emblem_code}{/entry_emblem}{/stash:emblem_code} {stash:emblem_code2}{entry_emblem limit="1" offset="1"}{emblem_code}{/entry_emblem}{/stash:emblem_code2} {stash:emblem_icon}{entry_emblem limit="1"}{emblem_icon}{/entry_emblem}{/stash:emblem_icon} {stash:commission-links}{entry_disable_commission_links}{/stash:commission-links} {stash:affiliate-count}{/stash:affiliate-count} {stash:canon_url} {if entry_canonical_url} {entry_canonical_url} {if:else} {exp:query sql="SELECT field_id_587 as section_url 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 ORDER BY pr.rel_id ASC LIMIT 1 "}/{section_url}{/exp:query}{exp:query sql="SELECT field_id_544 as type_url 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=591 ORDER BY pr.rel_id ASC LIMIT 1 "}/{type_url}{/exp:query}{exp:query sql="SELECT field_id_544 as class_url 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=535 ORDER BY pr.rel_id ASC LIMIT 1 "}/{class_url}{/exp:query}/{url_title} {/if} {/stash:canon_url} {stash:region_name} {exp:query sql="SELECT field_id_548 as region_name, field_id_593 as region_name_short, 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=536 ORDER BY pr.rel_id ASC LIMIT 3 "}{if '{the_count}'=='1'} {region_name}{if:else}{/if}{/exp:query} {/stash:region_name} {/if} {/exp:channel:entries} {/exp:stash:set_list} {/exp:stash:set}