User:HippieBot/English abbreviations, acronyms, and initialisms with translations

From Wiktionary, the free dictionary
Jump to navigation Jump to search
SELECT   DISTINCT page_title,
                  head_name
FROM     head
         INNER JOIN ews AS e1
           ON head_id = head.id
              AND head_level = 3
         INNER JOIN ews AS e2
           USING(page_id,lang_id)
         INNER JOIN title
           USING(page_id)
WHERE    e1.lang_id = 1
         AND e2.head_id = 5
         AND head_name REGEXP "([aA]bbreviation|[aA]cronym|[iI]nititalism)"
         AND head_name != 'Abbreviations'
ORDER BY page_title;