I’m trying to fix the date filter to filter out users made less than 2 days before a certain topic was created. I’ve been told either datediff or INTERVAL but havent got either to work.
And I needed help with adding topic t as another inner join but I sorted that with:
FROM post_actions pa INNER JOIN users u ON u.id = pa.user_id INNER JOIN topics t on t.id = t.id
t.id shows as a number rather than a preview is there anyway to go about that aswell?