SELECT USR.username AS SubscriptionOwner,
SUB.modifieddate,
SUB.[description],
SUB.eventtype,
SUB.deliveryextension,
SUB.laststatus,
SUB.lastruntime,
SCH.nextruntime,
SCH.NAME AS ScheduleName,
CAT.[path] AS ReportPath,
CAT.[description] AS ReportDescription
FROM dbo.subscriptions AS SUB
INNER JOIN dbo.users AS USR
ON SUB.ownerid = USR.userid
INNER JOIN dbo.[catalog] AS CAT
ON SUB.report_oid = CAT.itemid
INNER JOIN dbo.reportschedule AS RS
ON SUB.report_oid = RS.reportid
AND SUB.subscriptionid = RS.subscriptionid
INNER JOIN dbo.schedule AS SCH
ON RS.scheduleid = SCH.scheduleid
ORDER BY USR.username,
CAT.[path];
