Wikipedia:WikiProject Red Link Recovery/SQL scraps

From Wikipedia, the free encyclopedia

[edit] Unlikely links

---

// Mismatched brackets (cheeky method of counting how many x's in string 'xuxtlkx')

SELECT page_title, orig
FROM page, crushed_links
WHERE length(replace(orig, '(', '')) <> length(replace(orig, ')', ''))
AND id = page_id
AND  page_namespace = 0;

// Mismatched quotes, excluding " used to represent inches
SELECT page_title, orig
FROM page, crushed_links
WHERE (length(orig) - length(replace(orig, '\"', '')) ) mod 2 = 1
AND orig NOT REGEXP '[0-9]"'
AND id = page_id
AND  page_namespace = 0;

---