{exp:playa:children field="custom_authority_entry" entry_id="26952" 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}{auth:title}{/stash:custom_auth_entry_title} {/exp:playa:children}