Pages with most items
SQL query for Notion
Find the pages with the most number of items.
SELECT page_id, COUNT(*) AS items_count FROM database_items GROUP BY page_id ORDER BY items_count DESC LIMIT 1;
Notion data model
Databases
Database Items
Pages
Ready to get instant access to all your company data ?
Connect 300+ sources, serve any BI tool, and give every AI agent one governed endpoint to read, and write back where the app supports it.
- 14-day free trial
- No credit card needed