-
Notifications
You must be signed in to change notification settings - Fork 33
Open
Description
FireSQL is very good. But I met a following issue.
const players = await fireSQL.query('\
SELECT id, player, pos, team, url_photo, \
`ranking.2019.points.Yahoo_HalfPPR` AS points2019, \
`ranking.2018.points.Yahoo_HalfPPR` AS points2018, \
`ranking.2017.points.Yahoo_HalfPPR` AS points2017, \
`ranking.2019.stats` AS stats\
FROM players\
WHERE points2019 > 0 AND id > ' + this.state.lastPlayerId + '\
ORDER BY points2019 DESC, id\
LIMIT ' + this.state.limit + '\
');
I'm going to do pagination query by the last id after sorting the players, make sense?
Would you let me know how to solve this issue?
Thank you.
Metadata
Metadata
Assignees
Labels
No labels