1
select `labtech`.`timeslips`.`UserID` AS `UserID`,`labtech`.`users`.`Name` AS `UserName`,`labtech`.`timeslips`.`ClientID` AS `ClientID`,`labtech`.`clients`.`Name` AS `ClientName`,`labtech`.`timeslips`.`TicketID` AS `TicketID`,`labtech`.`timeslips`.`Hours` AS `Hours`,`labtech`.`timeslips`.`Mins` AS `Mins`,((`labtech`.`timeslips`.`Hours` * 60) + `labtech`.`timeslips`.`Mins`) AS `TotalMins`,(((`labtech`.`timeslips`.`Hours` * 60) + `labtech`.`timeslips`.`Mins`) / 60) AS `TotalHours`,`labtech`.`timeslips`.`Billed` AS `Billed`,`labtech`.`timeslips`.`Date` AS `Date`,`labtech`.`timeslips`.`Description` AS `Notes`,`labtech`.`timecategory`.`Name` AS `category`,`labtech`.`tickets`.`Subject` AS `Subject` from ((((`labtech`.`timeslips` join `labtech`.`users` on((`labtech`.`users`.`UserID` = `labtech`.`timeslips`.`UserID`))) left join `labtech`.`tickets` on((`labtech`.`tickets`.`TicketID` = `labtech`.`timeslips`.`TicketID`))) left join `labtech`.`clients` on((`labtech`.`clients`.`ClientID` = `labtech`.`timeslips`.`ClientID`))) left join `labtech`.`timecategory` on((`labtech`.`timecategory`.`ID` = `labtech`.`timeslips`.`Category`)))