1
select `labtech`.`tickets`.`TicketID` AS `TicketID`,`labtech`.`tickets`.`ClientID` AS `ClientID`,`labtech`.`tickets`.`ComputerID` AS `ComputerID`,`labtech`.`tickets`.`DeviceID` AS `DeviceID`,`labtech`.`tickets`.`Subject` AS `Subject`,`labtech`.`tickets`.`Priority` AS `Priority`,`labtech`.`tickets`.`StartedDate` AS `StartedDate`,`labtech`.`tickets`.`ContactDate` AS `ContactDate`,`labtech`.`tickets`.`UpdateDate` AS `UpdateDate`,`labtech`.`tickets`.`DueDate` AS `DueDate`,`labtech`.`tickets`.`RequestorEmail` AS `RequestorEmail`,`labtech`.`tickets`.`CCEmail` AS `CCEmail`,`labtech`.`tickets`.`Level` AS `Level`,`labtech`.`ticketstatus`.`TicketStatus` AS `Status`,`labtech`.`users`.`Name` AS `UserName`,`labtech`.`clients`.`Name` AS `ClientName` from (((`labtech`.`tickets` left join `labtech`.`users` on((`labtech`.`users`.`UserID` = `labtech`.`tickets`.`TicketID`))) left join `labtech`.`clients` on((`labtech`.`clients`.`ClientID` = `labtech`.`tickets`.`ClientID`))) join `labtech`.`ticketstatus` on((`labtech`.`ticketstatus`.`TicketStatusID` = `labtech`.`tickets`.`Status`)))