Yes you are right, it was late at night :-) That makes it even simpler, removing one join... SELECT * FROM tickets JOIN comments on comments.ticket_ID = ticke

Yes you are right, it was late at night :-) That makes it even simpler, removing one join... SELECT * FROM tickets JOIN comments on comments.ticket_ID = ticket.ID JOIN autor on comments.autor_ID = autor.ID where autor_ID = me and tickets.date < 1 week