{!-- 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 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={stash: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}