{"id":15170,"date":"2022-10-10T15:51:04","date_gmt":"2022-10-10T10:21:04","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/"},"modified":"2022-10-10T15:51:04","modified_gmt":"2022-10-10T10:21:04","slug":"solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/","title":{"rendered":"[Solved] joins in MySQL for leave management in PHP and MySQL [closed]"},"content":{"rendered":"

[ad_1]
\n<\/p>\n

\n
\n
<\/div>\n
\n
\n

Let’s take it step-by-step…<\/p>\n

First, the entities you’re selecting are in the leave_request<\/code> table. So let’s start there:<\/p>\n

SELECT leave_request.* FROM leave_request\n<\/code><\/pre>\n
Now, you need to know the data for the applied_by<\/code> column in the desired results.  So you join the staff<\/code> table:<\/p>\n
SELECT\n  applied_staff.name AS applied_by\nFROM\n  leave_request\n  INNER JOIN staff AS applied_staff ON leave_request.staff_id = applied_staff.staff_id\n<\/code><\/pre>\n
(Note that I’m using aliases for the table names.  This will come in handy later.)<\/p>\n
Now you need to know applied_from<\/code> and applied_to<\/code>, which you already have available:<\/p>\n
SELECT\n  applied_staff.name AS applied_by,\n  leave_request.applied_from,\n  leave_request.applied_to\nFROM\n  leave_request\n  INNER JOIN staff AS applied_staff ON leave_request.staff_id = applied_staff.staff_id\n<\/code><\/pre>\n
Now you need to know approved_from<\/code> and approved_to<\/code>, which are in the leave_approval<\/code> table:<\/p>\n
SELECT\n  applied_staff.name AS applied_by,\n  leave_request.applied_from,\n  leave_request.applied_to,\n  admin_approval.approved_from,\n  admin_approval.approved_to\nFROM\n  leave_request\n  INNER JOIN staff AS applied_staff ON leave_request.staff_id = applied_staff.staff_id\n  INNER JOIN leave_approval AS admin_approval ON leave_request.request_id = admin_approval.request_id\n<\/code><\/pre>\n
Uh oh, now we have a problem.  There’s a one-to-many relationship, so now we have duplicated leave requests in the results.  We need to filter that down somehow.  You don’t specify how, so I’m going to make a couple assumptions: You want to know the approved_from<\/code> and approved_to<\/code> of the “admin” approval AND there will only be ONE “admin” approval.<\/em><\/p>\n
Let’s reflect those assumptions in the table joins:<\/p>\n
SELECT\n  applied_staff.name AS applied_by,\n  leave_request.applied_from,\n  leave_request.applied_to,\n  admin_approval.approved_from,\n  admin_approval.approved_to\nFROM\n  leave_request\n  INNER JOIN staff AS applied_staff ON leave_request.staff_id = applied_staff.staff_id\n  INNER JOIN leave_approval AS admin_approval ON leave_request.request_id = admin_approval.request_id\n  INNER JOIN staff AS approved_staff ON admin_approval.approved_by = approved_staff.staff_id\n  INNER JOIN group AS approved_staff_group on approved_staff.group_id = approved_staff_group.group_id\nWHERE\n  approved_staff_group.group_name=\"admin\"\n<\/code><\/pre>\n
That should be better.  Note that the table aliasing came in handy here because we now have two instances of the staff<\/code> table for two different purposes in the same query.  So we needed to distinguish them.  (Keep in mind that I’m flying blind here and can’t actually test any of this.  So correct me if there are any problems encountered along the way.  I’m also free-handing this code because I don’t have MySQL handy, so let me know if there are syntax errors as well.)<\/p>\n
Now let’s add the approved_admin<\/code> field to the results, which is already available:<\/p>\n
SELECT\n  applied_staff.name AS applied_by,\n  leave_request.applied_from,\n  leave_request.applied_to,\n  admin_approval.approved_from,\n  admin_approval.approved_to,\n  approved_staff.name AS approved_admin\nFROM\n  leave_request\n  INNER JOIN staff AS applied_staff ON leave_request.staff_id = applied_staff.staff_id\n  INNER JOIN leave_approval AS admin_approval ON leave_request.request_id = admin_approval.request_id\n  INNER JOIN staff AS approved_staff ON admin_approval.approved_by = approved_staff.staff_id\n  INNER JOIN group AS approved_staff_group on approved_staff.group_id = approved_staff_group.group_id\nWHERE\n  approved_staff_group.group_name=\"admin\"\n<\/code><\/pre>\n
Finally, we need to know the approved_hr<\/code>.  And null<\/code> is allowed?  We’re going to use a different join for this one, then.  I’m also making similar assumptions to those above.  Let’s try this:<\/p>\n
SELECT\n  applied_staff.name AS applied_by,\n  leave_request.applied_from,\n  leave_request.applied_to,\n  admin_approval.approved_from,\n  admin_approval.approved_to,\n  approved_staff.name AS approved_admin,\n  hr_staff.name AS approved_hr\nFROM\n  leave_request\n  INNER JOIN staff AS applied_staff ON leave_request.staff_id = applied_staff.staff_id\n  INNER JOIN leave_approval AS admin_approval ON leave_request.request_id = admin_approval.request_id\n  INNER JOIN staff AS approved_staff ON admin_approval.approved_by = approved_staff.staff_id\n  INNER JOIN group AS approved_staff_group on approved_staff.group_id = approved_staff_group.group_id\n  LEFT OUTER JOIN leave_approval AS hr_approval ON leave_request.request_id = hr_approval.request_id\n  LEFT OUTER JOIN staff AS hr_staff ON hr_approval.approved_by = hr_staff.staff_id\n  LEFT OUTER JOIN group AS hr_staff_group ON hr_staff.group_id = hr_staff_group.group_id\nWHERE\n  approved_staff_group.group_name=\"admin\"\n  AND hr_staff_group.group_name=\"HR\"\n<\/code><\/pre>\n
I’m not entirely<\/em> sure about those latter LEFT OUTER JOIN<\/code>s.  The first one is definitely going to need to be a join that allows for null<\/code> values, but I’m not sure how the query engine handles joins beyond that.  I’d prefer that they be INNER JOIN<\/code>s within the scope of the initial LEFT OUTER JOIN<\/code>.  But I guess all of that really also depends on the integrity of the data, which I can’t guarantee.<\/p>\n
It’s also worth noting that you claim to want \"Jack\"<\/code> as output when the value is \"jack\"<\/code>.  I didn’t do any string manipulation in this code to make that happen.  If the value should be capitalized in the data, then capitalize it in the data.<\/p>\n
Again, I can’t guarantee<\/em> this code.  But as a walk-through it should get you moving in the right direction.  As I mentioned in a comment on the question, I really recommend picking up a book on MySQL if you’re going to be writing MySQL code.<\/p>\n
Edit:<\/strong> One recommendation I can give is to the structure of the data itself.  Specifically that leave_approval<\/code> table feels a bit messy, and it’s that table alone which is causing the confusion.  I have a couple recommendations:<\/p>\n
    \n
  1. Add an approval_type<\/code> to the leave_approval<\/code> table.  At the very least this would indicate if it’s an admin approval, an HR approval, or any other kind of approval.  (Are there even other kinds?  Will there ever be?)  Then you could also use request_id<\/code> and approval_type<\/code> as a combined primary key, or at least a combined unique constraint, to enforce better data integrity and prevent duplicate approvals.<\/li>\n
  2. If there are only two kinds of approvals and that’s probably not going to change, reflect them both in the leave_approval<\/code> table.  Have one set of columns for admin_approval_*<\/code> and one set for hr_approval_*<\/code>.  (Each set would include the staff_id<\/code> and relevant dates for the approval.)  Then request_id<\/code> itself could be a primary key on leave_approval<\/code> making it one-to-one with leave_request<\/code>.  This would dramatically simplify the relational data, essentially turning a leave_approval<\/code> record into an optional set of additional information for a leave_request<\/code> record.  The joins would become much simpler and the data would express itself much more clearly.<\/li>\n<\/ol>\n<\/div>\n
    <\/div>\n<\/div>\n
                <\/span> <\/p><\/div>\n<\/div>\n
    [ad_2]<\/p>\n
    solved joins in MySQL for leave management in PHP and MySQL [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"
    [ad_1] Let’s take it step-by-step… First, the entities you’re selecting are in the leave_request table. So let’s start there: SELECT leave_request.* FROM leave_request Now, you need to know the data for the applied_by column in the desired results. So you join the staff table: SELECT applied_staff.name AS applied_by FROM leave_request INNER JOIN staff AS applied_staff … Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[534,340,339],"class_list":["post-15170","post","type-post","status-publish","format-standard","hentry","category-solved","tag-join","tag-mysql","tag-php"],"yoast_head":"\n[Solved] joins in MySQL for leave management in PHP and MySQL [closed] - JassWeb<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] joins in MySQL for leave management in PHP and MySQL [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] Let’s take it step-by-step… First, the entities you’re selecting are in the leave_request table. So let’s start there: SELECT leave_request.* FROM leave_request Now, you need to know the data for the applied_by column in the desired results. So you join the staff table: SELECT applied_staff.name AS applied_by FROM leave_request INNER JOIN staff AS applied_staff ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-10T10:21:04+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] joins in MySQL for leave management in PHP and MySQL [closed]\",\"datePublished\":\"2022-10-10T10:21:04+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/\"},\"wordCount\":663,\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"keywords\":[\"join\",\"mysql\",\"php\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/\",\"name\":\"[Solved] joins in MySQL for leave management in PHP and MySQL [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\"},\"datePublished\":\"2022-10-10T10:21:04+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] joins in MySQL for leave management in PHP and MySQL [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#website\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/wp-content\\\/uploads\\\/2021\\\/02\\\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/#\\\/schema\\\/person\\\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"contentUrl\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/wp-content\\\/litespeed\\\/avatar\\\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\\\/\\\/jassweb.com\"],\"url\":\"https:\\\/\\\/jassweb.com\\\/solved\\\/author\\\/jaspritsinghghumangmail-com\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] joins in MySQL for leave management in PHP and MySQL [closed] - JassWeb","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] joins in MySQL for leave management in PHP and MySQL [closed] - JassWeb","og_description":"[ad_1] Let’s take it step-by-step… First, the entities you’re selecting are in the leave_request table. So let’s start there: SELECT leave_request.* FROM leave_request Now, you need to know the data for the applied_by column in the desired results. So you join the staff table: SELECT applied_staff.name AS applied_by FROM leave_request INNER JOIN staff AS applied_staff ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/","og_site_name":"JassWeb","article_published_time":"2022-10-10T10:21:04+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] joins in MySQL for leave management in PHP and MySQL [closed]","datePublished":"2022-10-10T10:21:04+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/"},"wordCount":663,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["join","mysql","php"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/","name":"[Solved] joins in MySQL for leave management in PHP and MySQL [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-10-10T10:21:04+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-joins-in-mysql-for-leave-management-in-php-and-mysql-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] joins in MySQL for leave management in PHP and MySQL [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1777008400","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15170","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=15170"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/15170\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=15170"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=15170"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=15170"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}