From 71138ef6045205af0973516a4066d3f08187d5ed Mon Sep 17 00:00:00 2001
From: Yorhel <git@yorhel.nl>
Date: Sun, 2 Oct 2022 20:09:20 +0200
Subject: API: Use deterministic ORDER BY to fix pagination

Fixes https://vndb.org/t19163.7
---
 lib/Multi/API.pm | 18 +++++++++---------
 1 file changed, 9 insertions(+), 9 deletions(-)

(limited to 'lib/Multi/API.pm')

diff --git a/lib/Multi/API.pm b/lib/Multi/API.pm
index 22e40036..368833d8 100644
--- a/lib/Multi/API.pm
+++ b/lib/Multi/API.pm
@@ -453,11 +453,11 @@ my %GET_VN = (
   sortdef => 'id',
   sorts   => {
     id => 'v.id %s',
-    title => 'v.title %s',
-    released => 'v.c_released %s',
-    popularity => 'v.c_popularity %s NULLS LAST',
-    rating => 'v.c_rating %s NULLS LAST',
-    votecount => 'v.c_votecount %s',
+    title => 'v.title %s, v.id',
+    released => 'v.c_released %s, v.id',
+    popularity => '-v.c_pop_rank %s NULLS LAST, v.id',
+    rating => '-v.c_rat_rank %s NULLS LAST, v.id',
+    votecount => 'v.c_votecount %s, v.id',
   },
   flags  => {
     basic => {
@@ -650,8 +650,8 @@ my %GET_RELEASE = (
   sortdef => 'id',
   sorts   => {
     id => 'r.id %s',
-    title => 'r.sorttitle %s',
-    released => 'r.released %s',
+    title => 'r.sorttitle %s, r.id',
+    released => 'r.released %s, r.id',
   },
   proc    => sub {
     $_[0]{id} = idnum $_[0]{id};
@@ -838,7 +838,7 @@ my %GET_PRODUCER = (
   sortdef => 'id',
   sorts   => {
     id => 'p.id %s',
-    name => 'p.name %s',
+    name => 'p.name %s, p.id',
   },
   flags  => {
     basic => {
@@ -912,7 +912,7 @@ my %GET_CHARACTER = (
   sortdef => 'id',
   sorts   => {
     id => 'c.id %s',
-    name => 'c.name %s',
+    name => 'c.name %s, c.id',
   },
   flags  => {
     basic => {
-- 
cgit v1.2.3