Fix sorting of box versions: 15.5.10.117 is newer and current version than 15.5.10.94 of opensuse leap 15.5
Improve search
2.1 Match search words in box title string: pseudosql: ... where box.title ilike '%word1placeholder% and box.title ilike '%word2placeholder%' and ...
2.2 Eventually prefer exact account name matches like opensuse, debian, generic, bento
Add a real pagination navigation for the result list containing: count of results, position of the pagination.
Resultlist should show all leap 15.5 boxes, but only one result is shown. The account 'opensuse' should be even more prominent in the result list.
Pressing the 'Next' button ends with a no result message which is wrong. The logic should be a tiny bit more clever to figure it out if there are n-results<'pagination size' at least to hide the next button or fallback to first page or something similiar. Showing the 'select count(*)' and the current page number of the pagination can also help there.
Resultlist should now show up with opensuse official leap 15.5 versions. But it lists the old 15.5.0.94 there instead of current uploaded 15.5.10.117
But as it can be seen, there exist boxes of official opensuse account that have 'opensuse', 'leap', and '15.5' in their title:
Please
... where box.title ilike '%word1placeholder% and box.title ilike '%word2placeholder%' and ...
2.2 Eventually prefer exact account name matches like opensuse, debian, generic, bentoRelated: https://github.com/openSUSE/vagrant/issues/48
Reproduction information
Current behavior of https://app.vagrantup.com/boxes/search
Steps to reproduce
Search for 'opensuse leap 15.5' on https://app.vagrantup.com/boxes/search
Resultlist should show all leap 15.5 boxes, but only one result is shown. The account 'opensuse' should be even more prominent in the result list.
Pressing the 'Next' button ends with a no result message which is wrong. The logic should be a tiny bit more clever to figure it out if there are n-results<'pagination size' at least to hide the next button or fallback to first page or something similiar. Showing the 'select count(*)' and the current page number of the pagination can also help there.
![vagrantup_noresultbut1result](https://github.com/hashicorp/vagrant/assets/1839154/5aa823ff-18b1-4a0e-b12d-d80e15a7b30d)
Search for 'opensuse leap' on https://app.vagrantup.com/boxes/search, Sorting 'Recently Updated'
Resultlist should now show up with opensuse official leap 15.5 versions. But it lists the old 15.5.0.94 there instead of current uploaded 15.5.10.117 But as it can be seen, there exist boxes of official opensuse account that have 'opensuse', 'leap', and '15.5' in their title:![vagrantup_leaponly](https://github.com/hashicorp/vagrant/assets/1839154/96c83214-8145-4b09-a178-4d2c3912f3a1)
Open https://app.vagrantup.com/opensuse/boxes/Leap-15.5.x86_64
The real current version is listed at the bottom, while 15.5.0.94 is at top and marked as current version.![vagrantup_oldcurrentversion](https://github.com/hashicorp/vagrant/assets/1839154/d536a530-1e55-4b2a-b440-ef0e5e226ea7)