Popular Page is empty.

[drew2a]

Describe the bug
The Popular Page is empty.

To Reproduce
Steps to reproduce the behavior:

1. Open Tribler
2. Go to "Popular"
3. See an empty page

Expected behavior
I expect to see a list of popular torrents.

Screenshots

Desktop (please complete the following information):

• OS: macOS 12.7.4
• Tribler's version: main (5695d0e)

[drew2a]

After some time, the results appear on the page. The strange thing here is that the database was not empty. It contains torrent entities that, for some reason, do not appear on the Popular page.

The query:

tribler/src/tribler/core/components/database/db/store.py

Lines 492 to 502 in 5695d0e

	t = time() - POPULAR_TORRENTS_FRESHNESS_PERIOD
	health_list = list(
	select(
	health for health in self.TorrentState
	if health.has_data == 1 # The condition had to be written this way for the partial index to work
	and health.last_check >= t and (health.seeders > 0 or health.leechers > 0)
	).order_by(
	lambda health: (desc(health.seeders), desc(health.leechers), desc(health.last_check))
	)[:POPULAR_TORRENTS_COUNT]
	)
	pony_query = pony_query.where(lambda g: g.health in health_list)