The syntax offset 10 fetch first 10 rows only should be translated to limit 10 offset 10 on MySQL. (And on other databases which don’t support the more verbose form.)