1
select `rep`.`LTReportID` AS `LTReportID`,`rep`.`ReportTitle` AS `ReportName`,`rc`.`ReportCategory` AS `ReportCategory`,`rep`.`DateAdded` AS `ReportPublishDate`,`usr1`.`Name` AS `ReportPublishUser`,`rep`.`DateLastUpdate` AS `ReportUpdateDate`,`usr2`.`Name` AS `ReportUpdateUser`,`rep`.`Description` AS `ReportDescription`,`rep`.`IsSubReport` AS `ReportIsSubreport`,`rep`.`GUID` AS `ReportInstanceGUID`,`rep`.`TemplateGUID` AS `ReportTemplateGUID`,`rt`.`ReportTemplateTitle` AS `ReportTemplateName`,trim(trailing ',' from concat(if((`rep`.`Flags` & (1 << 1)),'Client,',''),if((`rep`.`Flags` & (1 << 2)),'Location,',''),if((`rep`.`Flags` & (1 << 3)),'Computer,',''),if((`rep`.`Flags` & (1 << 4)),'Software,',''),if((`rep`.`Flags` & (1 << 5)),'Ticket,',''),if((`rep`.`Flags` & (1 << 6)),'System,',''),if((`rep`.`Flags` & (1 << 7)),'Contact,',''),if((`rep`.`Flags` & (1 << 8)),'Network Device,',''),if((`rep`.`Flags` & (1 << 9)),'Group,',''),if((`rep`.`Flags` & (1 << 10)),'Script',''))) AS `ReportFlagTypesEnabled`,ifnull(if((locate('.',`rep`.`TemplateVersion`) = 0),NULL,`rep`.`TemplateVersion`),'- -') AS `ReportTemplatePublishedVersion`,ifnull(concat(`rt`.`Version`,if((`rep`.`ReportData` <> `rt`.`ReportTemplateObject`),' (Modified)','')),'- -') AS `ReportTemplateLatestVersion`,if(((length(`rep`.`TemplateGUID`) < 2) or isnull(`rep`.`TemplateGUID`)),'Custom Report',if((`rep`.`TemplateVersion` = `rt`.`Version`),if((`rep`.`ReportData` = `rt`.`ReportTemplateObject`),'Current','Modified Template'),'Older Template')) AS `ReportStatus` from ((((`labtech`.`ltreports` `rep` left join `labtech`.`ltreportcategories` `rc` on((`rep`.`ReportCategoryID` = `rc`.`ReportCategoryID`))) left join `labtech`.`reporttemplates` `rt` on((`rep`.`TemplateGUID` = `rt`.`ReportTemplateGUID`))) left join `labtech`.`users` `usr1` on((`rep`.`UserIDAdded` = `usr1`.`UserID`))) left join `labtech`.`users` `usr2` on((`rep`.`UserIDLastUpdate` = `usr2`.`UserID`)))