SELECT ticket.id, mask, subject, is_closed, team_id, ticket.created_date, updated_date, first_wrote_address_id, last_wrote_address_id, message.id as messageID, message.created_date as messageCreated, content, message.address_id AS fromAddr, requester.ticket_id, team.id as teamID, name as team_name, signature FROM `ticket`,`message`,`message_content`,`requester`,`team` WHERE ticket.mask = 'XRF-25336-387' AND message.ticket_id = ticket.id AND message_content.message_id = message.id AND requester.ticket_id = ticket.id AND team.id = ticket.team_id