SELECT servicedefinition.NAME "Service Category", requesttemplate_list.TEMPLATENAME "Service template", accountdefinition.ORG_NAME "Account", aaauser.FIRST_NAME "Approver" FROM requesttemplate_list

    LEFT JOIN servicedefinition ON (requesttemplate_list.PARENT_SERVICE = servicedefinition.SERVICEID)

    LEFT JOIN servicetempaccmapping ON (servicetempaccmapping.TEMPLATEID = requesttemplate_list.TEMPLATEID)

    LEFT JOIN escalateton ON (servicetempaccmapping.ESCALATETOID = escalateton.ESCALATETOID)

    LEFT JOIN aaauser ON (escalateton.USERID = aaauser.USER_ID)    

    LEFT JOIN accountdefinition ON (servicetempaccmapping.ACCOUNTID = accountdefinition.ORG_ID)

WHERE (requesttemplate_list.IS_CATALOG_TEMPLATE ='1');