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;
Retrieved from "https://en.wiktionary.org/w/index.php?title=User:HippieBot/English_abbreviations,_acronyms,_and_initialisms_with_translations&oldid=7639221"