MySQL查询未正确偏移

这意味着要选择games表中的所有记录,并根据另一个表(wishlist)中是否存在具有相同gameId@memberId的记录添加一个值为0或1的列(简单地说,从games中获取所有记录,并将wishlists表中存在的任何游戏标记在我给你的memberId下)

SELECT *,
    CASE WHEN wishlists.memberid IS NULL THEN 0 ELSE 1 END AS InMembersList

FROM games
    INNER JOIN platforms ON games.platformid = platforms.id 
    LEFT OUTER JOIN wishlists ON games.id = wishlists.gameid and wishlists.memberid = @memberId

WHERE platforms.platformUrlId = @platformUrlId

ORDER BY releaseDate DESC

LIMIT 1,8

当我把偏移量从1改为2,或者3,或者其他什么的时候,会出现很多相同的记录,这没有任何意义。我哪里出错了?

platforms(id, platform)
members(id, name)
games(id, platformId, releaseDate)
wishlists(id, memberId, gameId)