from news as N
join News_reactions as R
on R.newsid = N.newsid
= ( select max(`datetime`)
where newsid = N.newsid )
by R.`datetime` desc limit 3
Rudy, thanx for answering. But to no avail.
I tried the query but it gives me an error (1064)
The error occurs at the subquery, 'select max(date) from ..'
I have no idea why that happens, because when i try to select the max date from that table it does work.. but in a subquery it seems to trow an error?
Does anybody else know how to solve this or has any hints/tips?
(edit,.. i replied, but the board still shows one reaction,.. so testing if this works.)