1
select `loc`.`ClientID` AS `ClientID`,`loc`.`LocationID` AS `LocationID`,`hls`.`StatDate` AS `StatDate`,`hls`.`Servers` AS `Servers`,`hls`.`WorkStations` AS `Workstations`,`hls`.`TotalDevices` AS `NetworkDevices` from (`labtech`.`h_locationstats` `hls` join `labtech`.`locations` `loc` on((`hls`.`LocationID` = `loc`.`LocationID`))) where ((to_days(`hls`.`StatDate`) % 7) = 1)