From a5e3f8447022a50080a62285e359d38e0875de21 Mon Sep 17 00:00:00 2001
From: dev
Date: Thu, 25 Jun 2026 20:45:58 +0200
Subject: fix: skip already-classified entries in wikidata query

Add has_no_wiki_article = 0 filter so entries previously marked as
having no Wikipedia article are not re-queried on subsequent runs.
---
 src/wikidata.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/src/wikidata.go b/src/wikidata.go
index dfaf1bd..20411d2 100644
--- a/src/wikidata.go
+++ b/src/wikidata.go
@@ -42,7 +42,7 @@ type jsonNode struct {
 
 // getMissingWikiArticles returns imdb_ids where wiki_article IS NULL.
 func (a *App) getMissingWikiArticles() ([]string, error) {
-	rows, err := a.DB.Query(`SELECT imdb_id FROM imdb WHERE wiki_article IS NULL AND imdb_id LIKE 'tt%'`)
+	rows, err := a.DB.Query(`SELECT imdb_id FROM imdb WHERE wiki_article IS NULL AND has_no_wiki_article = 0 AND imdb_id LIKE 'tt%'`)
 	if err != nil {
 		return nil, fmt.Errorf("query missing wiki articles: %w", err)
 	}
-- 
cgit v1.2.3