,date_trunc('seconds',max(ft.mtime)::timestamp ) AS last_post
FROM forum_categories fc
JOIN forum_boards fb USING (fcid)
- JOIN forum_threads ft USING (fbid)
+ LEFT OUTER JOIN forum_threads ft USING (fbid)
LEFT OUTER JOIN (SELECT * FROM forum_thread_visits WHERE uid = $1)
ftv USING (ftid)
WHERE fbid IN (SELECT fbid FROM forum_access
my $query = $dbh->prepare(q{SELECT uid,username FROM users
WHERE uid > 0 AND uid IN (SELECT uid FROM groupmembers)
- ORDER BY LOWER(username)});
+ ORDER BY username});
$query->execute;
$c->stash(users => $query->fetchall_arrayref({}) );
FROM forum_boards fb
NATURAL JOIN forum_threads ft
NATURAL JOIN forum_categories fc
- LEFT OUTER JOIN (SELECT * FROM forum_access
- WHERE gid IN (SELECT groups($2))
+ LEFT OUTER JOIN (SELECT fa.* FROM forum_access fa
+ JOIN (SELECT groups($2) AS gid) g USING (gid)
) fa USING (fbid)
WHERE ft.ftid = $1 AND (fa.post IS NOT NULL
OR ft.ftid IN (SELECT ftid FROM forum_priv_access WHERE uid = $2))