To better understand the impact of T434259: Introduce case sensitivity to Add-a-Link, we will need to revalidate Add Link suggestions on enwiki.
This has also been requested by the community.
Acceptance Criteria:
Similar to T434319: Revalidate Add Link suggestions on enwiki, we should revalidate Add Link suggestions on enwiki via revalidateLinkRecommendations.php and monitor for errors.
Progress checking query
SET @run_start := UNIX_TIMESTAMP('2026-09-01 00:00:00'); -- when the script was started
SELECT
COUNT(*) AS recommendations,
SUM(is_fresh) AS regenerated,
COUNT(*) - SUM(is_fresh) AS pending,
ROUND(100 * SUM(is_fresh) / COUNT(*), 2) AS pct_regenerated
FROM (
SELECT CAST(COALESCE(JSON_VALUE(gelr_data, '$.meta.task_timestamp'), 0) AS UNSIGNED) >= @run_start AS is_fresh
FROM growthexperiments_link_recommendations
WHERE gelr_data IS NOT NULL
) AS r;