X-Git-Url: https://ruin.nu/git/?p=ndwebbie.git;a=blobdiff_plain;f=lib%2FNDWeb%2FController%2FMembers.pm;h=33fdc5cb61243710e476d5822e7fb81faf75135d;hp=b88574505f2f2e677794889564e97c268fbc7c3b;hb=48df392b0817ea813443309eecc5949550095155;hpb=aa93c4baf476e9fa421e1a5ce0d97e9527d33417 diff --git a/lib/NDWeb/Controller/Members.pm b/lib/NDWeb/Controller/Members.pm index b885745..33fdc5c 100644 --- a/lib/NDWeb/Controller/Members.pm +++ b/lib/NDWeb/Controller/Members.pm @@ -78,7 +78,7 @@ ORDER BY landing_tick DESC LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1) ftv ON ftv.ftid = ft.ftid WHERE ft.fbid = 1 GROUP BY ft.ftid, ft.subject,ft.sticky,u.username - HAVING count(NULLIF(COALESCE(ft.sticky OR fp.time > ftv.time,TRUE),FALSE)) >= 1 + HAVING count(NULLIF(COALESCE(fp.time > ftv.time,TRUE),FALSE)) >= 1 ORDER BY sticky DESC,last_post DESC }); $announcements->execute($c->user->id);