diff options
Diffstat (limited to 'lib/VNDB/DB/Misc.pm')
-rw-r--r-- | lib/VNDB/DB/Misc.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/lib/VNDB/DB/Misc.pm b/lib/VNDB/DB/Misc.pm index e1a1103c..27494380 100644 --- a/lib/VNDB/DB/Misc.pm +++ b/lib/VNDB/DB/Misc.pm @@ -79,11 +79,11 @@ sub dbRevisionGet { ); my($r, $np) = $self->dbPage(\%o, q| - SELECT c.id, c.type, c.itemid, c.requester, c.comments, c.rev, extract('epoch' from c.added) as added, u.username + SELECT c.id, c.type, c.itemid, c.comments, c.rev, extract('epoch' from c.added) as added, !s FROM changes c JOIN users u ON c.requester = u.id !W - ORDER BY c.id DESC|, \%where + ORDER BY c.id DESC|, VNWeb::DB::sql_user(), \%where ); # I couldn't find a way to fetch the titles the main query above without slowing it down considerably, so let's just do it this way. |