使用LIMIT / OFFSET在SQL中进行分页有时会导致不同页面上出现重复

I'm developing an online gallery with voting and have a separate table for pictures and votes (for every vote I'm storing the ID of the picture and the ID of the voter). The tables related like this: I'm developing an online gallery with voting an