v_xr_timeslips

select (select `labtech`.`properties`.`Value` from `labtech`.`properties` where (`labtech`.`properties`.`Name` = 'ReportCompanyName') limit 1) AS `ReportCompanyName`,`clt`.`ClientID` AS `ClientID`,ifnull(`clt`.`Company`,`clt`.`Name`) AS `ClientName`,`ts`.`TicketID` AS `TicketID`,`ts`.`TimeSlipID` AS `TimeslipID`,`ts`.`Date` AS `TimeslipDate`,`ts`.`Hours` AS `TimeslipHours`,`ts`.`Mins` AS `TimeslipMins`,`usr`.`Name` AS `TimeslipUser`,`ts`.`Description` AS `TimeslipDescription`,`ts`.`Billed` AS `TimeslipBilled`,`tc`.`Name` AS `TimeslipCategory` from (((`labtech`.`timeslips` `ts` left join `labtech`.`clients` `clt` on((`ts`.`ClientID` = `clt`.`ClientID`))) left join `labtech`.`timecategory` `tc` on((`ts`.`Category` = `tc`.`ID`))) left join `labtech`.`users` `usr` on((`ts`.`UserID` = `usr`.`UserID`)))