(a) Consider the presence of a LIMIT/OFFSET in a sub-select as making it parallel-unsafe.
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных