1
select `md`.`MobileId` AS `MobileId`,`mdv`.`ClientID` AS `ClientId`,`mdv`.`LocationID` AS `LocationId`,`mdv`.`ContactID` AS `ContactId`,(sum(`md`.`TotalNetDataIn`) + sum(`md`.`TotalNetDataOut`)) AS `DataUsed`,((`mdi`.`DataPlanCap` * 1024) * 1024) AS `DataAvailable`,(((sum(`md`.`TotalNetDataIn`) + sum(`md`.`TotalNetDataOut`)) / ((`mdi`.`DataPlanCap` * 1024) * 1024)) * 100) AS `UsePercentage`,`mbd`.`FirstDate` AS `FirstDate`,`mbd`.`LastDate` AS `LastDate` from (((`labtech`.`h_mobiledata_daily` `md` left join `labtech`.`mobiledevices` `mdv` on((`mdv`.`MobileID` = `md`.`MobileId`))) left join `labtech`.`mobiledeviceinfo` `mdi` on((`mdi`.`MobileID` = `md`.`MobileId`))) left join `labtech`.`v_mobiledata_billingdates` `mbd` on((`mbd`.`MobileID` = `md`.`MobileId`))) where ((`md`.`DayEntered` <= `mbd`.`LastDate`) and (`md`.`DayEntered` >= `mbd`.`FirstDate`) and (`mdi`.`DataPlanCap` <> -(1))) group by `md`.`MobileId`