SELECT A.GROUPNUM `GROUP`, A.FTNTNUM FNOTENUM, A.REVVER, A.LISTNUM, A.HAS_WISLINK, B.DESCIDX, B.ABBR, B.LANG, B.TEXT, B.SEQNUM, A.KB, B.CONTINUED
FROM 
  alltext_bm_footnotes_v2 A
  JOIN alltext_bm_footnotes_dictionary_v B 
    ON A.DESCIDX = B.DESCIDX 
    AND B.LANG = 'E' 
WHERE 
  A.CATNUM = 'C02   ' 
  AND A.GROUPNUM = '92' 
UNION
SELECT A.GROUPNUM `GROUP`, A.FTNTNUM FNOTENUM, A.REVVER, A.LISTNUM, A.HAS_WISLINK, B.DESCIDX, B.ABBR, B.LANG, B.TEXT, B.SEQNUM, A.KB, B.CONTINUED
FROM 
  alltext_bm_footnotes_v2 A
  JOIN alltext_bm_footnotes_dictionary_v B 
    ON A.DESCIDX = B.DESCIDX 
    AND B.LANG = 'N'
WHERE 
  A.CATNUM = 'C02   ' 
  AND A.GROUPNUM = '92' 
UNION
SELECT A.GROUPNUM `GROUP`, A.FTNTNUM FNOTENUM, A.REVVER, A.LISTNUM, A.HAS_WISLINK, B.DESCIDX, B.ABBR, B.LANG, B.TEXT, B.SEQNUM, A.KB, B.CONTINUED
FROM 
  alltext_bm_footnotes_v2 A
  JOIN alltext_bm_footnotes_dictionary_v B 
    ON A.DESCIDX = B.DESCIDX 
    AND B.LANG ='E'
WHERE 
  A.CATNUM = 'C02   ' 
  AND A.GROUPNUM = '92' 
ORDER BY FNOTENUM, SEQNUM, CONTINUED