v_xr_tickets

select distinct `tix`.`TicketID` AS `TicketID`,`tix`.`Status` AS `TicketStatusID`,`status`.`TicketStatus` AS `TicketStatus`,`tix`.`Priority` AS `TicketPriorityID`,`priority`.`Name` AS `TicketPriority`,`infocat`.`CategoryName` AS `TicketCategory`,`tix`.`Level` AS `TicketLevel`,`tix`.`StartedDate` AS `TicketCreated`,`tix`.`ContactDate` AS `TicketLastContact`,`tix`.`DueDate` AS `TicketDueDate`,`tix`.`RequestorEmail` AS `TicketContactEmail`,`tix`.`Subject` AS `TicketSubject`,`tix`.`ClientID` AS `ClientID`,`tix`.`ComputerID` AS `ComputerID`,`tix`.`DeviceID` AS `NetworkDeviceID` from (((`labtech`.`tickets` `tix` left join `labtech`.`ticketstatus` `status` on((`tix`.`Status` = `status`.`TicketStatusID`))) left join `labtech`.`ticketpriority` `priority` on((`tix`.`Priority` = `priority`.`Priority`))) left join `labtech`.`infocategory` `infocat` on((`tix`.`Category` = `infocat`.`ID`))) where ((to_days(now()) - to_days(`tix`.`StartedDate`)) <= 30)