1
select min(cast(`ar`.`ActivityChecked` as date)) AS `ActivityCheckDate`,`ar`.`ClientID` AS `ClientID`,`ar`.`ActivityID` AS `ActivityID`,`act`.`ActivityName` AS `ActivityName`,concat(sum(`ar`.`ActivityValue`),' ',`act`.`ActivityDescription`,if((`ar`.`TargetType` <> 3),concat(' ',count(distinct `ar`.`TargetID`),if((count(distinct `ar`.`TargetID`) > 1),elt(`ar`.`TargetType`,' computers',' locations',' clients',' probes',' network devices'),elt(`ar`.`TargetType`,' computer',' location',' client',' probe',' network device'))),'')) AS `ActivityMessage` from (`labtech`.`plugin_sap_activityresults` `ar` join `labtech`.`plugin_sap_activities` `act` on((`ar`.`ActivityID` = `act`.`ActivityID`))) where ((to_days(now()) - to_days(`ar`.`ActivityChecked`)) < 7) group by `ar`.`ClientID`,`ar`.`ActivityID`