1
select `tixdata`.`TicketID` AS `TicketID`,`tixdata`.`TicketDataID` AS `TicketDataID`,`tixdata`.`DataType` AS `TicketDataTypeID`,`tdt`.`TicketDataType` AS `TicketDataType`,`tixdata`.`Data` AS `TicketData`,`tixdata`.`Attachment` AS `TicketDataAttachment`,`tixdata`.`Address` AS `TicketDataAddress`,`tixdata`.`UserID` AS `TicketDataUserID`,`usr`.`Name` AS `TicketDataUserName`,`tixdata`.`TicketDataDate` AS `TicketDataDate` from ((`labtech`.`ticketdata` `tixdata` join `labtech`.`ticketdatatypes` `tdt` on((`tixdata`.`DataType` = `tdt`.`TicketDataID`))) left join `labtech`.`users` `usr` on((`tixdata`.`UserID` = `usr`.`UserID`))) where ((to_days(now()) - to_days(`tixdata`.`TicketDataDate`)) <= 30)