Cacher is the code snippet organizer for pro developers

select p.Id, p.[Name], p.[Description], isnull(ppt.IsActive,0) HavePermission
from Permission p 
left join Permission_PermissionTemplate ppt
on p.Id = ppt.PermissionId and ppt.PermissionTemplateId = 49 
where p.IsActive = 1