Refactor popularity SQL #4967

Job	Run time
Get changes	19s
Get image tag	1s
Lint files	2m 26s
Determine images to build and publish	9s
Add stack label	2s
Run checks for packages/*	0s
Run Nuxt checks	0s
Check Nuxt build	0s
Build Docker images (upstream_db)	3m 23s
Build Docker images (api_nginx)	38s
Build Docker images (catalog)	3m 30s
Build Docker images (ingestion_server)	1m 15s
Build Docker images (api)	1m 21s
Build full-stack docs	0s
Run Playwright tests	0s
Run checks for packages/* (build)	4s
Run checks for packages/* (unit_test)	2s
Run Nuxt checks (unit_test)	8s
Run Nuxt checks (storybook_smoke_test)	2s
Run Playwright tests (playwright_vr)	2s
Run Playwright tests (playwright_e2e)	2s
Run Playwright tests (storybook)	8s
Post Playwright test debugging instructions	2s
Run tests for ingestion-server	3m 56s
Run tests for the API	10m 30s
Run catalog checks	5m 13s
Run Django checks (check_django)	4m 13s
Run Django checks (validate_openapi)	5m 0s
Run Django checks (check_migrations)	4m 26s
Run Django checks (test_doc)	4m 4s
Run tests for the catalog	5m 17s
Run Django checks	0s
Publish Docker images	0s
Emit full-stack docs	0s
Deploy staging frontend	0s
Deploy staging API	0s
Send Slack report	0s
	56m 13s

Provide feedback