1
select `labtech`.`locations`.`ClientID` AS `ClientID`,sum(`labtech`.`h_locationstats`.`TotalComputers`) AS `TotalComputers`,sum(`labtech`.`h_locationstats`.`ActiveComputers`) AS `ActiveComputers`,sum(`labtech`.`h_locationstats`.`TotalDevices`) AS `TotalDevices`,sum(`labtech`.`h_locationstats`.`ActiveDevices`) AS `ActiveDevices`,sum(`labtech`.`h_locationstats`.`RetiredAssets`) AS `RetiredAssets`,sum(`labtech`.`h_locationstats`.`MasterComputers`) AS `MasterComputers`,sum(`labtech`.`h_locationstats`.`Servers`) AS `Servers`,sum(`labtech`.`h_locationstats`.`WorkStations`) AS `WorkStations`,sum(`labtech`.`h_locationstats`.`Mobile`) AS `Mobile`,sum(`labtech`.`h_locationstats`.`Smartphone`) AS `Smartphones`,sum(`labtech`.`h_locationstats`.`Tablet`) AS `Tablets`,`labtech`.`h_locationstats`.`StatDate` AS `Statdate` from (`labtech`.`h_locationstats` join `labtech`.`locations` on((`labtech`.`h_locationstats`.`LocationID` = `labtech`.`locations`.`LocationID`))) group by `labtech`.`locations`.`ClientID`,`labtech`.`h_locationstats`.`StatDate`