restful: addition of pagination

This might fail in the near future if we introduce `unique` index on `email` column.