Use Prev/Next pagination for exploring projects

Merged yorickpeterse-staging requested to merge pagination-projects-explore into master

What does this MR do?

This changes the pagination system of the "Explore" page so we don't need to perform expensive COUNT queries.

@tauriedavis @sarrahvesselov This is based on my findings discussed in and the comments following it. Since this affects UI/UX I would greatly appreciate any comments. The style of this pagination is the same as the normal one, except we don't display any page numbers (see screenshot below). On the first/last page the prev/next buttons simply aren't displayed.

Screenshots (if relevant)


Does this MR meet the acceptance criteria?

What are the relevant issue numbers?

Edited by yorickpeterse-staging