הפניות חסרות ספר החוקים הפתוח

SQL

SELECT page.page_title, lt.lt_title
FROM (SELECT cl_from AS page_id FROM categorylinks WHERE cl_to = 'בוט_חוקים') AS cat
JOIN pagelinks AS pl ON pl.pl_from = cat.page_id
LEFT JOIN linktarget AS lt ON lt.lt_id = pl.pl_target_id AND lt.lt_namespace = 0
LEFT JOIN page ON page.page_id = cat.page_id
WHERE NOT EXISTS (
  SELECT 1 FROM page AS dst 
  WHERE dst.page_title = lt.lt_title AND (dst.page_namespace = 0 OR dst.page_namespace = 116)
)

-- LIMIT 1000

/* 
SELECT page_title, lt.lt_title AS target_title
JOIN pagelinks AS pl ON pl.pl_from = page_id
JOIN linktarget AS lt ON lt.lt_id = pl.pl_target_id
WHERE lt.lt_namespace = 0
AND (NOT EXISTS(
 SELECT 1
 FROM page as target
 WHERE target.page_title = lt.lt_title
 AND (target.page_namespace = 0 OR target.page_namespace = 116)
))
AND 

ORDER BY lt.lt_title;
*/
SQL

Checking query status...
