@@ -566,7 +566,7 @@ class opdsDatabase:
"from "+TBL_BOOKS+" a "
"left join "+TBL_BAUTHORS+" b on a.book_id=b.book_id "
"left join "+TBL_BSERIES +" c on a.book_id=c.book_id "
- "where author_id=%s and ser_id=%s and a.avail!=0 "+dstr+" order by a.title "+limitstr)
+ "where author_id=%s and ser_id=%s and a.avail!=0 "+dstr+" order by c.ser_no, a.title "+limitstr)
data=(author_id,ser_id)
else:
sql=("select SQL_CALC_FOUND_ROWS a.book_id,a.filename,a.path,a.registerdate,a.title,a.annotation,a.docdate,a.format,a.filesize,a.cover