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

Hello, you have come here looking for the meaning of the word User:HippieBot/English prepositions with mismatch between heading and category. In DICTIOUS you will not only get to know all the dictionary meanings for the word User:HippieBot/English prepositions with mismatch between heading and category, but we will also tell you about its etymology, its characteristics and you will know how to say User:HippieBot/English prepositions with mismatch between heading and category in singular and plural. Everything you need to know about the word User:HippieBot/English prepositions with mismatch between heading and category you have here. The definition of the word User:HippieBot/English prepositions with mismatch between heading and category will help you to be more precise and correct when speaking or writing your texts. Knowing the definition ofUser:HippieBot/English prepositions with mismatch between heading and category, as well as those of other words, enriches your vocabulary and provides you with more and better linguistic resources.
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_prepositions'
       LEFT JOIN enwiktstruct AS e2
         ON e1.page_id = e2.page_id
            AND e1.lang_id = e2.lang_id
            AND e2.head_id = 33
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 = 33
              AND e1.head_id = e2.head_id
         LEFT JOIN categorylinks
           ON e2.page_id = cl_from
              AND cl_to = 'English_prepositions'
WHERE    cl_to IS NULL
ORDER BY page_title;
Wikious
Boobota
Sagapedia