assessed='no' (Not assessed) was truthy, forcing hasEnrichFilter=true and routing to SQLite even when prescreen_status='none'. But domains that have never been prescreened don't exist in SQLite at all → 0 results every time. Rule: if prescreen_status='none', always use DuckDB. Enrichment-only filters (niche, site_type, country, assessed) are irrelevant for domains that haven't entered the pipeline and must not override the DuckDB path. Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
39 KiB
39 KiB