TIL that in mysql , you have to "limit then offset", because "offset then limit" is an sql error, wtf.