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.
FireSQL is very good. But I met a following issue.
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.