{exp:channel:entries disable="member_data|pagination|categories" show_future_entries="yes" entry_id="{stash:entry_id}" status="not Closed" dynamic="no" limit="1"} {stash:segment_1}{segment_1}{/stash:segment_1} {stash:segment_2}{segment_2}{/stash:segment_2} {stash:segment_3}{segment_3}{/stash:segment_3} {stash:segment_4}{segment_4}{/stash:segment_4} {stash:last_segment}{last_segment}{/stash:last_segment} {stash:url_title}{url_title}{/stash:url_title} {stash:allow_index}{custom_allow_index}{/stash:allow_index} {stash:entry-status}{status}{/stash:entry-status} {stash:custom_url_segment}{custom_url_segment}{/stash:custom_url_segment} {stash:custom_search_index}{custom_search_index}{/stash:custom_search_index} {stash:entry_remove_ads}{custom_remove_ads}{/stash:entry_remove_ads} {stash:entry_limited_ads}{custom_allow_limited_ads}{/stash:entry_limited_ads} {stash:entry_remove_top_ad}{custom_remove_top_ad}{/stash:entry_remove_top_ad} {stash:disable-inline-video}{custom_disable_inline_video}{/stash:disable-inline-video} {stash:allow_comments}{custom_comments}{/stash:allow_comments} {stash:show_pub_date}{custom_show_publish_date}{/stash:show_pub_date} {stash:show_pub}{custom_show_publisher}{/stash:show_pub} {stash:remove_announcements}{custom_remove_announcements}{/stash:remove_announcements} {stash:remove_promo}{custom_promo_section}{/stash:remove_promo} {stash:count_promo}{if custom_promo_count}{custom_promo_count}{if:else}3{/if}{/stash:count_promo} {stash:title_image_override}{custom_title_image_override}{/stash:title_image_override} {stash:hero_size}{custom_hero_size}{/stash:hero_size} {stash:video_status}{custom_video_status}{/stash:video_status} {stash:video_url}{custom_video_url}{/stash:video_url} {stash:video_url_hd}{custom_video_url_hd}{/stash:video_url_hd} {stash:hero_slider}{custom_hero_image_slider}{/stash:hero_slider} {stash:hero_heading_size}{custom_hero_heading_size}{/stash:hero_heading_size} {stash:style-url}{custom_island_style}{/stash:style-url} {stash:hero-video-heading}{custom_hero_video_heading}{/stash:hero-video-heading} {stash:hero-video-subheading}{custom_hero_video_subheading}{/stash:hero-video-subheading} {stash:heading} {if custom_heading}{custom_heading}{if:else}{title}{/if} {/stash:heading} {stash:meta_title}{custom_meta_title}{/stash:meta_title} {stash:disable_amp}{custom_disable_amp}{/stash:disable_amp} {stash:remove_kidentries}{if custom_remove_children_entries}{custom_remove_children_entries}{if:else}no{/if}{/stash:remove_kidentries} {stash:channel_id}{channel_id}{/stash:channel_id} {stash:allow_advertising} {if '{custom_remove_ads}'=='Yes'}No{if:else}Yes{/if} {/stash:allow_advertising} {!-- 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}{section_short_name}{/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} {!-- Classification Data --} {exp:query sql="SELECT field_id_548 as class_name, field_id_978 as class_meta_name, field_id_544 as class_url, field_id_955 as class_canonical, entry_id as class_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='543' OR pr.parent_field_id='535') ORDER BY pr.rel_order ASC LIMIT 1) LIMIT 1"} {stash:classification_count}{total_results}{/stash:classification_count} {stash:classification}{class_name}{/stash:classification} {stash:classification_meta}{class_meta_name}{/stash:classification_meta} {stash:classification_url}{if class_url}/{class_url}{/if}{/stash:classification_url} {stash:classification_id}{class_id}{/stash:classification_id} {stash:class_canon}{if class_canonical}{class_canonical}{/if}{/stash:class_canon} {/exp:query} {!-- SubClassification Data --} {exp:query sql="SELECT field_id_548 as subclass_name, field_id_978 as subclass_meta_name, field_id_544 as subclass_url, field_id_955 as subclass_canonical, 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='612' OR pr.parent_field_id='601') ORDER BY pr.rel_id ASC LIMIT 1"} {stash:subclassification}{subclass_name}{/stash:subclassification} {stash:subclassification_meta}{subclass_meta_name}{/stash:subclassification_meta} {stash:subclassification_url}{if subclass_url}/{subclass_url}{/if}{/stash:subclassification_url} {stash:subclass_canon}{if subclass_canonical}{subclass_canonical}{/if}{/stash:subclass_canon} {/exp:query} {!-- SubClassification Parent Data for Accommodations --} {exp:query sql="SELECT field_id_548 as subaccomm_name, field_id_544 as subaccomm_url, count(*) as the_count FROM exp_channel_data cd JOIN exp_playa_relationships pr WHERE cd.entry_id = pr.parent_entry_id AND pr.child_entry_id='{entry_id}' AND pr.parent_field_id='562' AND cd.channel_id='73' "} {stash:subclass_accomm}{subaccomm_name}{/stash:subclass_accomm} {stash:subclass_accomm_url}{if subaccomm_url}/{subaccomm_url}{/if}{/stash:subclass_accomm_url} {/exp:query} {!-- Type Data --} {exp:query sql="SELECT field_id_548 as type_name, field_id_544 as type_url, 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='595' OR pr.parent_field_id='591') ORDER BY pr.rel_id ASC LIMIT 1"} {stash:type_name}{if type_name}{type_name}{/if}{/stash:type_name} {stash:type_url}{if type_url}/{type_url}{/if}{/stash:type_url} {/exp:query} {!-- Region Data - v2 --} {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={entry_id} AND pr.parent_field_id='999' 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} {stash:subclass_count}{exp:playa:total_children field="custom_statewide_entries"}{/stash:subclass_count} {stash:channel_short_name}{channel_short_name}{/stash:channel_short_name} {stash:author_name}{exp:member:custom_profile_data member_id='{author_id}'}{author_name}{/exp:member:custom_profile_data}{/stash:author_name} {stash:author_id}{author_id}{/stash:author_id} {stash:contributors}{/stash:contributors} {stash:meta_description}{if custom_meta_description}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{custom_meta_description}{/exp:ce_str:ing}{if:else}{custom_content}{content_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{content}{/exp:ce_str:ing}{/if}{/content_block}{heading_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{hb_heading_text}{/exp:ce_str:ing}{/if}{/heading_block}{content_image_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{ci_body}{/exp:ce_str:ing}{/if}{/content_image_block}{content_related_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{cr_body}{/exp:ce_str:ing}{/if}{/content_related_block}{content_html_block}{/content_html_block}{premium_only_parent}{/premium_only_parent}{accordion_block}{/accordion_block}{buttons_block}{/buttons_block}{related_tiles_block}{/related_tiles_block}{table_block}{/table_block}{grid_block}{/grid_block}{summary_block}{/summary_block}{content_block_2_columns}{/content_block_2_columns}{content_block_3_columns}{/content_block_3_columns}{html_block}{/html_block}{call_to_action_block}{/call_to_action_block}{cta_button}{/cta_button}{assets_image_block}{/assets_image_block}{related_item_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{related_headline}{/exp:ce_str:ing}{/if}{/related_item_block}{content_cta_tile}{/content_cta_tile}{video_block}{/video_block}{related_block_quote}{/related_block_quote}{toggle_block}{/toggle_block}{white_label_block}{/white_label_block}{keyword_products_block}{/keyword_products_block}{cta_related_item}{/cta_related_item}{tile_block_2_columns}{/tile_block_2_columns}{author_block}{/author_block}{asset_image_2_column}{/asset_image_2_column}{asset_image_4_column}{/asset_image_4_column}{cta_related_block}{/cta_related_block}{related_html_element}{/related_html_element}{ad_1col}{/ad_1col}{bullet_block}{/bullet_block}{form_block}{/form_block}{cookie_switch_block}{/cookie_switch_block}{cookie_create_block}{/cookie_create_block}{accordion_block_parent}{/accordion_block_parent}{accordion_block_child}{/accordion_block_child}{premium_teaser_parent}{/premium_teaser_parent}{gallery_block}{/gallery_block}{form_field_two_column}{/form_field_two_column}{form_field_one_column}{/form_field_one_column}{divider_block}{/divider_block}{tab_accordion_block_parent}{/tab_accordion_block_parent}{tab_accordion_block_child}{/tab_accordion_block_child}{modal_block}{/modal_block}{fh_tour_block}{/fh_tour_block}{parallax_block}{/parallax_block}{full_image_block}{/full_image_block}{assets_content_4_column}{/assets_content_4_column}{tab_block_parent}{/tab_block_parent}{tab_block_child}{/tab_block_child}{call_to_action_block_v2}{/call_to_action_block_v2}{/custom_content}{/if}{/stash:meta_description} {stash:structured_description}{if custom_meta_description}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{custom_meta_description}{/exp:ce_str:ing}{if:else}{custom_content}{content_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{content}{/exp:ce_str:ing}{/if}{/content_block}{heading_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{hb_heading_text}{/exp:ce_str:ing}{/if}{/heading_block}{content_image_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{ci_body}{/exp:ce_str:ing}{/if}{/content_image_block}{content_related_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{cr_body}{/exp:ce_str:ing}{/if}{/content_related_block}{content_html_block}{/content_html_block}{premium_only_parent}{/premium_only_parent}{accordion_block}{/accordion_block}{buttons_block}{/buttons_block}{related_tiles_block}{/related_tiles_block}{table_block}{/table_block}{grid_block}{/grid_block}{summary_block}{/summary_block}{content_block_2_columns}{/content_block_2_columns}{content_block_3_columns}{/content_block_3_columns}{html_block}{/html_block}{call_to_action_block}{/call_to_action_block}{cta_button}{/cta_button}{assets_image_block}{/assets_image_block}{related_item_block}{if '{blocks:count:of:type}'=='1'}{exp:ce_str:ing truncate="300" remove_tags='h2|yes' remove_tags='h3|yes' remove_tags='h4|yes' remove_tags remove_html}{related_headline}{/exp:ce_str:ing}{/if}{/related_item_block}{content_cta_tile}{/content_cta_tile}{video_block}{/video_block}{related_block_quote}{/related_block_quote}{toggle_block}{/toggle_block}{white_label_block}{/white_label_block}{keyword_products_block}{/keyword_products_block}{cta_related_item}{/cta_related_item}{tile_block_2_columns}{/tile_block_2_columns}{author_block}{/author_block}{asset_image_2_column}{/asset_image_2_column}{asset_image_4_column}{/asset_image_4_column}{cta_related_block}{/cta_related_block}{related_html_element}{/related_html_element}{ad_1col}{/ad_1col}{bullet_block}{/bullet_block}{form_block}{/form_block}{cookie_switch_block}{/cookie_switch_block}{cookie_create_block}{/cookie_create_block}{accordion_block_parent}{/accordion_block_parent}{accordion_block_child}{/accordion_block_child}{premium_teaser_parent}{/premium_teaser_parent}{gallery_block}{/gallery_block}{form_field_two_column}{/form_field_two_column}{form_field_one_column}{/form_field_one_column}{divider_block}{/divider_block}{tab_accordion_block_parent}{/tab_accordion_block_parent}{tab_accordion_block_child}{/tab_accordion_block_child}{modal_block}{/modal_block}{fh_tour_block}{/fh_tour_block}{parallax_block}{/parallax_block}{full_image_block}{/full_image_block}{assets_content_4_column}{/assets_content_4_column}{tab_block_parent}{/tab_block_parent}{tab_block_child}{/tab_block_child}{call_to_action_block_v2}{/call_to_action_block_v2}{/custom_content}{/if}{/stash:structured_description} {stash:block_css} {custom_content} {white_label_block} {if '{blocks:count:of:type}'=='1'} {if wl_provider == "Priceline"} {if:elseif wl_provider == "HotelsCombined"} {if:elseif wl_provider == "Expedia"} {/if}{!--wl_provider--} {/if}{!--count-of-type--} {/white_label_block} {keyword_products_block}{/keyword_products_block} {form_freeform_block}{/form_freeform_block} {premium_swap_block}{/premium_swap_block} {accordion_block} {if '{blocks:count:of:type}'=='1'} {/if} {/accordion_block} {premium_teaser_parent} {if '{enable_premium_intro_accordion}'=='Yes'} {if '{blocks:count:of:type}'=='1'} {/if} {/if}{!--enable_intro_accordion--} {/premium_teaser_parent} {cookie_create_block}{/cookie_create_block} {cookie_switch_block}{/cookie_switch_block} {accordion_block_parent} {if '{blocks:count:of:type}'=='1'} {/if} {/accordion_block_parent} {tab_accordion_block_parent} {if '{blocks:count:of:type}'=='1'} {!----} {/if} {/tab_accordion_block_parent} {modal_block} {modal_styles} {/modal_block} {tab_accordion_block_child}{/tab_accordion_block_child} {gallery_block}{/gallery_block} {buttons_block}{/buttons_block} {plus_minus_block}{/plus_minus_block} {toggle_block}{/toggle_block} {author_block}{/author_block} {content_block}{/content_block} {summary_block}{/summary_block} {related_block_quote}{/related_block_quote} {assets_image_block}{/assets_image_block} {asset_image_2_column}{/asset_image_2_column} {asset_image_4_column}{/asset_image_4_column} {divider_block}{/divider_block} {form_block}{/form_block} {video_block}{/video_block} {content_related_block}{/content_related_block} {content_cta_tile}{/content_cta_tile} {content_image_block}{/content_image_block} {bullet_block}{/bullet_block} {cta_button}{/cta_button} {content_block_2_columns} {/content_block_2_columns} {content_block_3_columns} {/content_block_3_columns} {tile_block_2_columns} {/tile_block_2_columns} {html_block}{/html_block} {heading_block}{/heading_block} {related_html_element}{/related_html_element} {related_item_block}{/related_item_block} {cta_related_block}{/cta_related_block} {cta_related_item}{/cta_related_item} {call_to_action_block}{/call_to_action_block} {service_block}{/service_block} {ad_1col}{/ad_1col} {table_block}{/table_block} {grid_block}{/grid_block} {content_html_block}{/content_html_block} {premium_only_parent}{/premium_only_parent} {accordion_block_child}{/accordion_block_child} {fh_tour_block}{/fh_tour_block} {parallax_block}{/parallax_block} {full_image_block}{/full_image_block} {assets_content_4_column}{/assets_content_4_column} {tab_block_parent}{/tab_block_parent} {tab_block_child}{/tab_block_child} {call_to_action_block_v2}{/call_to_action_block_v2} {/custom_content} {/stash:block_css} {stash:block_scripts} {custom_content} {white_label_block} {if '{blocks:count:of:type}'=='1'} {if wl_provider == "Priceline"} {if:elseif wl_provider == "HotelsCombined"} {if:elseif wl_provider == "Expedia"} {/if}{!--wl_provider--} {/if}{!--count-of-type--} {/white_label_block} {keyword_products_block}{!--Amazon Products--} {/keyword_products_block} {form_freeform_block} {if '{blocks:count:of:type}'=='1'} {/if}{!--scripts--} {/form_freeform_block} {premium_swap_block} {/premium_swap_block} {accordion_block} {if '{blocks:count:of:type}'=='1'} {/if} {/accordion_block} {premium_teaser_parent} {if '{enable_premium_intro_accordion}'=='Yes'} {if '{blocks:count:of:type}'=='1'} {/if} {/if}{!--enable_intro_accordion--} {/premium_teaser_parent} {cookie_create_block} {/cookie_create_block} {cookie_switch_block} {/cookie_switch_block} {accordion_block_parent} {if '{blocks:count:of:type}'=='1'} {/if} {/accordion_block_parent} {gallery_block} {if '{blocks:count:of:type}'=='1'} {/if}{!--count-of-type--} {/gallery_block} {toggle_block} {if '{blocks:count:of:type}'=='1'} {/if}{!--count-of-type--} {/toggle_block} {modal_block} {modal_scripts} {/modal_block} {video_block}{/video_block} {tab_accordion_block_parent} {/tab_accordion_block_parent} {tab_accordion_block_child}{/tab_accordion_block_child} {buttons_block}{/buttons_block} {plus_minus_block}{/plus_minus_block} {author_block}{/author_block} {content_block}{/content_block} {summary_block}{/summary_block} {related_block_quote}{/related_block_quote} {assets_image_block}{/assets_image_block} {asset_image_2_column}{/asset_image_2_column} {asset_image_4_column}{/asset_image_4_column} {divider_block}{/divider_block} {form_block}{/form_block} {content_related_block}{/content_related_block} {content_cta_tile}{/content_cta_tile} {content_image_block}{/content_image_block} {bullet_block}{/bullet_block} {cta_button}{/cta_button} {content_block_2_columns} {/content_block_2_columns} {content_block_3_columns} {/content_block_3_columns} {tile_block_2_columns} {/tile_block_2_columns} {html_block}{/html_block} {heading_block}{/heading_block} {related_html_element}{/related_html_element} {related_item_block}{/related_item_block} {cta_related_block}{/cta_related_block} {cta_related_item}{/cta_related_item} {call_to_action_block}{/call_to_action_block} {service_block}{/service_block} {ad_1col}{/ad_1col} {table_block}{/table_block} {grid_block}{/grid_block} {content_html_block}{/content_html_block} {premium_only_parent}{/premium_only_parent} {accordion_block_child}{/accordion_block_child} {fh_tour_block}{/fh_tour_block} {parallax_block}{/parallax_block} {full_image_block}{/full_image_block} {assets_content_4_column}{/assets_content_4_column} {tab_block_parent}{/tab_block_parent} {tab_block_child}{/tab_block_child} {call_to_action_block_v2}{/call_to_action_block_v2} {/custom_content} {/stash:block_scripts} {stash:meta_author}{exp:member:custom_profile_data member_id="{author_id}"}{exp:ce_str:ing remove_html}{author_url}{/exp:ce_str:ing}{/exp:member:custom_profile_data}{/stash:meta_author} {stash:entry_description}{custom_description}{/stash:entry_description} {stash:entry_date}{entry_date format="%m-%d-%Y"}{/stash:entry_date} {stash:entry_date_long}{entry_date format='%Y-%m-%dT%H:%i:%s%Q'}{/stash:entry_date_long} {stash:edit_date}{edit_date format="%m-%d-%Y"}{/stash:edit_date} {stash:edit_date_long}{edit_date format="%Y-%m-%dT%H:%i:%s%Q"}{/stash:edit_date_long} {stash:footer_scripts}{/stash:footer_scripts} {stash:entry_tag_line}{custom_tag_line}{/stash:entry_tag_line} {stash:title}{if custom_heading}{custom_heading}{if:else}{title}{/if}{/stash:title} {stash:original_id}{entry_id}{/stash:original_id} {stash:list_the_kids}{custom_remove_children_entries}{/stash:list_the_kids} {stash:related_heading}{custom_related_heading}{/stash:related_heading} {stash:related_total}{exp:playa:total_children field="custom_statewide_entries" entry_id="{entry_id}" status="not Closed|To Delete|Archived|To Monetize|Needs Kids"}{/stash:related_total} {stash:related_ids}{exp:playa:child_ids field="custom_statewide_entries" entry_id="{entry_id}" status="not Closed|To Delete|Archived|To Monetize|Needs Kids"}{/stash:related_ids} {stash:related_two_heading}{custom_related_two_heading}{/stash:related_two_heading} {stash:related_two_total}{exp:playa:total_children field="custom_related_two" entry_id="{entry_id}" status="not Closed|To Delete|Archived|To Monetize|Needs Kids"}{/stash:related_two_total} {stash:related_two_ids}{exp:playa:child_ids field="custom_related_two" entry_id="{entry_id}" status="not Closed|To Delete|Archived|To Monetize|Needs Kids"}{/stash:related_two_ids} {stash:related_three_heading}{custom_related_three_heading}{/stash:related_three_heading} {stash:related_three_total}{exp:playa:total_children field="custom_related_three" entry_id="{entry_id}" status="not Closed|To Delete|Archived|To Monetize|Needs Kids"}{/stash:related_three_total} {stash:related_three_ids}{exp:playa:child_ids field="custom_related_three" entry_id="{entry_id}" status="not Closed|To Delete|Archived|To Monetize|Needs Kids"}{/stash:related_three_ids} {stash:list_columns}{custom_columns}{/stash:list_columns} {stash:list_ratio}{/stash:list_ratio} {stash:entry_icon} {if custom_icon}{exp:jcogs_img:pair hide_relative_path="yes" src="{custom_icon}" width="2500" allow_scale_larger="yes" quality="95"}{made}{/exp:jcogs_img:pair}{/if} {/stash:entry_icon} {stash:entry_icon_focus}{if '{custom_icon_focus}'!=''}{custom_icon_focus}{if:else}center center{/if}{/stash:entry_icon_focus} {stash:entry_icon_text} {exp:jcogs_img:pair src="{custom_icon_text}" crop="yes|center,center|0,0" width="900" allow_scale_larger="yes" max_height="600" quality="95" hide_relative_path="yes"}{made}{/exp:jcogs_img:pair} {/stash:entry_icon_text} {stash:entry_icon-mobile} {exp:jcogs_img:pair src="{custom_icon}" crop="yes|center,center|0,0" width="600" allow_scale_larger="yes" max_height="350" quality="75"}{made}{/exp:jcogs_img:pair} {/stash:entry_icon-mobile} {!--Set the Gallery Images from the Assets Field--} {exp:stash:set_list:nested name="{entry_id}_block_images" parse_tags="yes"} {page_icon var_prefix="galhead"} {stash:gb_url}{galhead:url}{/stash:gb_url} {stash:gb_caption}{if galhead:caption!=""}{galhead:caption}{if:elseif galhead:title!=""}{galhead:title}{if:else}Hawaii Photo Gallery Slide{/if}{/stash:gb_caption} {stash:gb_focus}{if '{galhead:keywords}'=='top' || '{galhead:keywords}'=='bottom'}{galhead:keywords}{if:else}center{/if}{/stash:gb_focus} {/page_icon} {/exp:stash:set_list:nested} {stash:emblem} {custom_emblem limit="3"} {if emblem_code} {if:elseif emblem_icon} GoUS Badge {/if} {/custom_emblem} {/stash:emblem} {stash:emblem_icon} {custom_emblem limit="1"} {if emblem_code}{emblem_code}{/if} {/custom_emblem} {/stash:emblem_icon} {stash:custom_ratio_format}{/stash:custom_ratio_format} {exp:playa:children field="custom_authority_entry" entry_id="{entry_id}" var_prefix="auth"} {!-- Section Data --} {exp:query sql="SELECT field_id_587 as auth_section_url, 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='{auth: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:custom_auth_entry_section_url}{if "{auth_section_url}"}/{auth_section_url}{/if}{/stash:custom_auth_entry_section_url} {/exp:query} {!-- Classification Data --} {exp:query sql="SELECT field_id_544 as auth_class_url, 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='{auth:entry_id}' AND (pr.parent_field_id='543' OR pr.parent_field_id='535') ORDER BY pr.rel_id ASC LIMIT 1"} {stash:custom_auth_entry_classification_url}{if '{auth_class_url}'}/{auth_class_url}{/if}{/stash:custom_auth_entry_classification_url} {/exp:query} {!-- Type Data --} {exp:query sql="SELECT field_id_544 as type_url, 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='{auth:entry_id}' AND (pr.parent_field_id='595' OR pr.parent_field_id='591') ORDER BY pr.rel_id ASC LIMIT 1"} {stash:custom_auth_entry_type_url}{if '{auth:type_url}'}/{auth:type_url}{/if}{/stash:custom_auth_entry_type_url} {/exp:query} {!-- Custom Type Data --} {exp:query sql="SELECT field_id_544 as custom_type_url, 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='976') ORDER BY pr.rel_id ASC LIMIT 1"} {stash:custom_type_entry_type_url}{if '{custom_type_url}'}/{custom_type_url}{/if}{/stash:custom_type_entry_type_url} {/exp:query} {stash:custom_auth_entry_url}{auth:url_title}{/stash:custom_auth_entry_url} {stash:custom_auth_entry_title}{if '{auth:entry_heading}'!='' || '{auth:custom_heading}'!='' || '{auth:page_heading}'!=''}{auth:entry_heading}{auth:custom_heading}{auth:page_heading}{if:else}{auth:title}{/if}{/stash:custom_auth_entry_title} {stash:custom_auth_canon}{auth:entry_canonical_url}{auth:page_canonical}{auth:custom_canonical}{/stash:custom_auth_canon} {/exp:playa:children} {!-- Gallery Block Check --} {stash:gallery-block-check} {exp:query sql="SELECT id FROM exp_blocks_block WHERE entry_id={entry_id} AND (blockdefinition_id=111) LIMIT 1 "}Yes{/exp:query} {/stash:gallery-block-check} {stash:canonical_override} {custom_canonical} {/stash:canonical_override} {/exp:channel:entries}