scripts for getting the next list items

getOrderedWordsList.sql

SELECT
  Asses.id,
  Groups.orderNum,
  Defs.phrase, Defs.definition AS translation,
  Items.phrase, Items.translation
FROM WordGroups AS Groups
INNER JOIN WordListAssignments AS Asses
  ON Groups.id = Asses.wordGroupId
  AND Groups.wordListId = 1
INNER JOIN WordListItems AS Items
  ON Asses.wordListItemId = Items.id
LEFT JOIN Definitions AS Defs
  ON Defs.id = Items.definitionId
  
ORDER BY Groups.orderNum ASC, Asses.id ASC;
LIMIT 2, 5;