User:HippieBot/English phrases with mismatch between heading and category

From Wiktionary, the free dictionary
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_phrases'
       LEFT JOIN enwiktstruct AS e2
         ON e1.page_id = e2.page_id
            AND e1.lang_id = e2.lang_id
            AND e2.head_id = 68
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 = 68
              AND e1.head_id = e2.head_id
         LEFT JOIN categorylinks
           ON e2.page_id = cl_from
              AND cl_to = 'English_phrases'
WHERE    cl_to IS NULL
ORDER BY page_title;

*-H

[edit]

I-Z

[edit]

a

[edit]

b

[edit]

c

[edit]

d

[edit]

ef

[edit]

gh

[edit]

ijk

[edit]

lm

[edit]

n

[edit]

o

[edit]

p

[edit]

qr

[edit]

s

[edit]

t

[edit]

uv

[edit]

w

[edit]

xyz

[edit]
Retrieved from "https://en.wiktionary.org/w/index.php?title=User:HippieBot/English_phrases_with_mismatch_between_heading_and_category&oldid=8258128"