{exp:stash:set_list name="list-{stash:entry_id}" parse_tags="yes" parse_conditionals="yes" trim="yes" parse_depth="3"} {exp:channel:entries dynamic="no" entry_id="{stash:list_ids}" fixed_order="{stash:list_ids}" disable="categories|member_data|pagination" status="not Closed"} {if '{channel_short_name}'=='pages' || '{channel_short_name}'=='pages_no_search' || '{channel_short_name}'=='sections' || '{channel_short_name}'=='authority_pages'} {stash:thechannel}{channel_short_name}{/stash:thechannel} {stash:count-no}{count}{/stash:count-no} {stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date} {stash:theid}{entry_id}{/stash:theid} {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_focus}{if '{page_icon_focus}'=='right center'}right,center{if:elseif '{page_icon_focus}'=='left center'}left,center{if:else}center,center{/if}{/stash:icon_focus} {stash:icon-affiliate} {/stash:icon-affiliate} {stash:nofollow}{/stash:nofollow} {stash:newwindow}{/stash:newwindow} {stash:author_name}{exp:member:custom_profile_data member_id='{author_id}'}{author_name}{/exp:member:custom_profile_data}{/stash:author_name} {!-- Section Data --} {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"} {stash:section}{section_name}{/stash:section} {stash:section_short_name}{if section_short_name}{section_short_name}{if:else}Hawaii Travel Guide{/if}{/stash:section_short_name} {stash:section_url}{if section_url}/{section_url}{/if}{/stash:section_url} {stash:section_id}{section_id}{/stash:section_id} {/exp:query} {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} {if '{page_button_watermark}'=='explore-now-v8.png'} explore now → {if:elseif '{page_button_watermark}'=='learn-more-v8-ext.png'} learn more {if:elseif '{page_button_watermark}'=='book-online-v8.png'} book online {if:elseif '{page_button_watermark}'=='learn-more-ta-v8.png'} learn more {if:elseif '{page_button_watermark}'=='book-now-ta-v8.png'} book now {if:elseif '{page_button_watermark}'=='book-now-v8.png'} book now {if:elseif '{page_button_watermark}'=='buy-online-amz-v8.png'} buy online {if:elseif '{page_button_watermark}'=='buy-now-v8.png'} buy online {if:elseif '{page_button_watermark}'=='shop-now-v8.png'} shop now {if:else} learn more → {/if} {/stash:call_to_action_button} {stash:guidereview-letter} {/stash:guidereview-letter} {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} {stash:region_name_short} {/stash:region_name_short} {stash:section-url} {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} {/stash:section-url} {stash:tag_line} {/stash:tag_line} {if:elseif '{channel_short_name}'=='workflow_ads_blocks' || '{channel_short_name}'=='affiliate_blocks' || '{channel_short_name}'=='affiliate_hotels' || '{channel_short_name}'=='store_blocks'} {stash:thechannel}{channel_short_name}{/stash:thechannel} {stash:count-no}{count}{/stash:count-no} {stash:nofollow}{ad_nofollow}{/stash:nofollow} {stash:newwindow}{ad_new_window}{/stash:newwindow} {stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date} {stash:theid}{entry_id}{/stash:theid} {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_focus}center,center{/stash:icon_focus} {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:emblem_icon} {exp:jcogs_img:pair 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:canon_url}{/stash:canon_url} {stash:author_name}{exp:member:custom_profile_data member_id='{author_id}'}{author_name}{/exp:member:custom_profile_data}{/stash:author_name} {stash:section}Hawaii Travel Guide{/stash:section} {stash:section_short_name}Hawaii Travel Guide{/stash:section_short_name} {stash:section_url}/{/stash:section_url} {stash:section_id}{/stash:section_id} {stash:ad-link} {if '{ad_url_hc}'!=''} {ad_url_hc} {if:elseif '{ad_url}'!=''} {ad_url} {/if} {/stash:ad-link} {stash:cj-ta} {if '{ad_url_hc}'!='' && '{ad_url}'!=''} {ad_url} {/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} {if '{ad_button_watermark}'=='explore-now-v8.png'} explore now → {if:elseif '{ad_button_watermark}'=='learn-more-v8-ext.png'} learn more {if:elseif '{ad_button_watermark}'=='book-online-v8.png'} book online {if:elseif '{ad_button_watermark}'=='learn-more-ta-v8.png'} learn more {if:elseif '{ad_button_watermark}'=='book-now-ta-v8.png'} book now {if:elseif '{ad_button_watermark}'=='book-now-v8.png'} book now {if:elseif '{ad_button_watermark}'=='buy-online-amz-v8.png'} buy online {if:elseif '{ad_button_watermark}'=='buy-now-v8.png'} buy online {if:elseif '{ad_button_watermark}'=='shop-now-v8.png'} shop now {if:else} learn more → {/if} {/stash:call_to_action_button} {stash:star_rating}{ad_star_rating}{/stash:star_rating} {stash:star_rating-text} {if '{ad_star_rating}'=='5'}Five {if:elseif '{ad_star_rating}'=='4'}Four {if:elseif '{ad_star_rating}'=='3'}Three {if:elseif '{ad_star_rating}'=='2'}Two {if:elseif '{ad_star_rating}'=='1'}One {if:elseif '{ad_star_rating}'=='0'}One {/if} {/stash:star_rating-text} {stash:guidereview-letter} {/stash:guidereview-letter} {stash:affiliate-count}{ad_affiliate_links:total_rows}{/stash:affiliate-count} {exp:stash:set_list:nested name="{entry_id}-affiliate-links" parse_tags="yes" parse_conditionals="yes" trim="yes"} {ad_affiliate_links} {stash:affiliate-name}{affiliate}{/stash:affiliate-name} {stash:affiliate-logo} {if '{affiliate}'=='Hertz'}/files/images/outbound/hertz-dark.png {if:elseif '{affiliate}'=='Avis'}/files/images/outbound/avis-dark.png {if:elseif '{affiliate}'=='Priceline'}/files/images/outbound/priceline-dark.png {if:elseif '{affiliate}'=='Expedia'}/files/images/outbound/expedia-dark.png {if:elseif '{affiliate}'=='Budget'}/files/images/outbound/budget-dark.png {/if} {/stash:affiliate-logo} {stash:affiliate-link}{deep_link}{/stash:affiliate-link} {/ad_affiliate_links} {/exp:stash:set_list:nested} {stash:region_name} {/stash:region_name} {stash:region_name_short} {/stash:region_name_short} {stash:tag_line} {/stash:tag_line} {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:thechannel}{channel_short_name}{/stash:thechannel} {stash:count-no}{count}{/stash:count-no} {stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date} {stash:theid}{entry_id}{/stash:theid} {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_focus}{if '{custom_icon_focus}'=='right center'}right,center{if:elseif '{custom_icon_focus}'=='left center'}left,center{if:else}center,center{/if}{/stash:icon_focus} {stash:icon-affiliate} {/stash:icon-affiliate} {stash:nofollow}{/stash:nofollow} {stash:newwindow}{/stash:newwindow} {stash:author_name}{exp:member:custom_profile_data member_id='{author_id}'}{author_name}{/exp:member:custom_profile_data}{/stash:author_name} {!-- Section Data --} {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 = (SELECT pr.child_entry_id as child_id FROM exp_playa_relationships pr WHERE 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_order ASC LIMIT 1) LIMIT 1"} {stash:section}{section_name}{/stash:section} {stash:section_short_name}{if section_short_name}{section_short_name}{if:else}Hawaii Travel Guide{/if}{/stash:section_short_name} {stash:section_url}{if section_url}/{section_url}{/if}{/stash:section_url} {stash:section_id}{section_id}{/stash:section_id} {/exp:query} {stash:website}{/stash:website} {stash:direct-link}{/stash:direct-link} {stash:ad-link} {if custom_white_label} {custom_white_label} {/if} {/stash:ad-link} {stash:cj-ta}{/stash:cj-ta} {stash:cj-hc}{/stash:cj-hc} {stash:hc}{/stash:hc} {stash:tag_line} {custom_tag_line} {/stash:tag_line} {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} {if '{custom_button_watermark}'=='explore-now-v8.png'} explore now → {if:elseif '{custom_button_watermark}'=='learn-more-v8-ext.png'} learn more {if:elseif '{custom_button_watermark}'=='book-online-v8.png'} book online {if:elseif '{custom_button_watermark}'=='learn-more-ta-v8.png'} learn more {if:elseif '{custom_button_watermark}'=='book-now-ta-v8.png'} book now {if:elseif '{custom_button_watermark}'=='book-now-v8.png'} book now {if:elseif '{custom_button_watermark}'=='buy-online-amz-v8.png'} buy online {if:elseif '{custom_button_watermark}'=='buy-now-v8.png'} buy online {if:elseif '{custom_button_watermark}'=='shop-now-v8.png'} shop now {if:else} learn more → {/if} {/stash:call_to_action_button} {stash:guidereview-letter} {/stash:guidereview-letter} {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:section-url} {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} {/stash:section-url} {stash:region_name} {/stash:region_name} {stash:region_name_short} {/stash:region_name_short} {if:else} {stash:thechannel}{channel_short_name}{/stash:thechannel} {stash:count-no}{count}{/stash:count-no} {stash:date}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:date} {stash:theid}{entry_id}{/stash:theid} {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} {stash:icon_focus}{if '{entry_icon_focus}'=='right center'}right,center{if:elseif '{entry_icon_focus}'=='left center'}left,center{if:else}center,center{/if}{/stash:icon_focus} {stash:icon-affiliate} {/stash:icon-affiliate} {stash:phone}{entry_phone}{/stash:phone} {stash:website}{entry_website}{/stash:website} {stash:direct-link}{entry_direct_link}{/stash:direct-link} {stash:ad-link} {if entry_white_label} {entry_white_label} {/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:star_rating} {if '{entry_star_rating}'=='5' || '{entry_rank}'=='5 - Must See'}5 {if:elseif '{entry_star_rating}'=='4' || '{entry_rank}'=='4 - Excellent'}4 {if:elseif '{entry_star_rating}'=='3' || '{entry_rank}'=='3 - Good'}3 {if:elseif '{entry_star_rating}'=='2' || '{entry_rank}'=='2 - So-So'}2 {if:elseif '{entry_star_rating}'=='1' || '{entry_rank}'=='1 - Poor'}1 {if:elseif '{entry_star_rating}'=='0' || '{entry_rank}'=='0 - Avoid or Kapu'}0 {/if} {/stash:star_rating} {stash:star_rating-text} {if '{entry_star_rating}'=='5' || '{entry_rank}'=='5 - Must See'}Five {if:elseif '{entry_star_rating}'=='4' || '{entry_rank}'=='4 - Excellent'}Four {if:elseif '{entry_star_rating}'=='3' || '{entry_rank}'=='3 - Good'}Three {if:elseif '{entry_star_rating}'=='2' || '{entry_rank}'=='2 - So-So'}Two {if:elseif '{entry_star_rating}'=='1' || '{entry_rank}'=='1 - Poor'}One {if:elseif '{entry_star_rating}'=='0' || '{entry_rank}'=='0 - Avoid or Kapu'}One {/if} {/stash:star_rating-text} {stash:nofollow}{/stash:nofollow} {stash:newwindow}{/stash:newwindow} {stash:author_name}{exp:member:custom_profile_data member_id='{author_id}'}{author_name}{/exp:member:custom_profile_data}{/stash:author_name} {!-- Section Data --} {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 = (SELECT pr.child_entry_id as child_id FROM exp_playa_relationships pr WHERE 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_order ASC LIMIT 1) LIMIT 1"} {stash:section_short_name}{if section_short_name}{section_short_name}{if:else}Hawaii Travel Guide{/if}{/stash:section_short_name} {stash:section_url}{if section_url}/{section_url}{/if}{/stash:section_url} {stash:section_id}{section_id}{/stash:section_id} {/exp:query} {stash:tag_line} {entry_tag_line} {/stash:tag_line} {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} {if '{entry_button_watermark}'=='explore-now-v8.png'} explore now → {if:elseif '{entry_button_watermark}'=='learn-more-v8-ext.png'} learn more {if:elseif '{entry_button_watermark}'=='book-online-v8.png'} book online {if:elseif '{entry_button_watermark}'=='learn-more-ta-v8.png'} learn more {if:elseif '{entry_button_watermark}'=='book-now-ta-v8.png'} book now {if:elseif '{entry_button_watermark}'=='book-now-v8.png'} book now {if:elseif '{entry_button_watermark}'=='buy-online-amz-v8.png'} buy online {if:elseif '{entry_button_watermark}'=='buy-now-v8.png'} buy online {if:elseif '{entry_button_watermark}'=='shop-now-v8.png'} shop now {if:else} learn more → {/if} {/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: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:section-url} {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} {/stash:section-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} {stash:region_name_filter} {exp:query sql="SELECT field_id_548 as region_name_filter 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 1 "}{region_name_filter}{/exp:query} {/stash:region_name_filter} {/if} {/exp:channel:entries} {/exp:stash:set_list}