User:HippieBot/English conjunctions with mismatch between heading and category
Jump to navigation
Jump to search
SELECT DISTINCT e1.page_title
FROM enwiktstruct AS e1
INNER JOIN categorylinks
ON e1.page_id = cl_from
AND e1.lang_id = 0
AND e1.head_id IS NULL
AND cl_to = 'English_conjunctions'
LEFT JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = e2.lang_id
AND e2.head_id = 19
WHERE e2.head_id IS NULL
UNION
SELECT DISTINCT e1.page_title
FROM enwiktstruct e1
INNER JOIN enwiktstruct AS e2
ON e1.page_id = e2.page_id
AND e1.lang_id = 0
AND e1.lang_id = e2.lang_id
AND e1.head_id = 19
AND e1.head_id = e2.head_id
LEFT JOIN categorylinks
ON e2.page_id = cl_from
AND cl_to = 'English_conjunctions'
WHERE cl_to IS NULL
ORDER BY page_title;
'cuz'n'ac=> RfValthobeforebeing thatbothcozergo+adverbfor thatforasmuch asin regardinclusive or=>TRkindof=>adverblet alonerfv-senseneithernornot=>TRonceonlyplusprecisely unlessseeing???sincetherforewhan=>MEwhen, as, and ifwherealongwhereinwheresoe'erwherewithyit