We provide all the information about MCP servers via our MCP API.
curl -X GET 'https://glama.ai/api/mcp/v1/servers/houtini-ai/seo-crawler-mcp'
If you have feedback or need assistance with the MCP directory API, please join our Discord server
orphan-pages.sql•396 B
-- Orphan Pages (MEDIUM)
-- Pages not linked from any other internal page
-- Priority: MEDIUM
-- Category: technical
SELECT
p.url,
p.title,
p.depth,
p.word_count,
p.status_code
FROM pages p
WHERE p.url NOT IN (
SELECT DISTINCT target_url
FROM links
WHERE is_internal = 1
)
AND p.depth > 0
AND p.status_code = 200
ORDER BY p.word_count DESC, p.depth ASC
LIMIT 100;