{exp:query sql="SELECT cd.field_id_587 as section_url, ct.url_title as the_url_title FROM exp_channel_data cd JOIN exp_channel_titles ct on cd.entry_id = ct.entry_id JOIN exp_playa_relationships pr WHERE cd.entry_id = pr.child_entry_id AND pr.parent_entry_id={stash:canon_id} AND pr.parent_field_id=580 ORDER BY pr.rel_id ASC LIMIT 1"}{if section_url}/{section_url}{if:else}/{the_url_title}{/if}{/exp:query}{exp:query sql="SELECT cd.field_id_544 as class_url, ct.url_title as the_url_title FROM exp_channel_data cd JOIN exp_channel_titles ct on cd.entry_id = ct.entry_id JOIN exp_playa_relationships pr WHERE cd.entry_id = pr.child_entry_id AND pr.parent_entry_id={stash:canon_id} AND pr.parent_field_id=595 ORDER BY pr.rel_id ASC LIMIT 1"}{if class_url}/{class_url}{if:else}/{the_url_title}{/if}{/exp:query}{exp:query sql="SELECT cd.field_id_867 as entry_url, ct.url_title as the_url_title FROM exp_channel_data cd JOIN exp_channel_titles ct on cd.entry_id = ct.entry_id WHERE cd.entry_id = {stash:canon_id} LIMIT 1"}{if entry_url}/{entry_url}{if:else}/{the_url_title}{/if}{/exp:query}