SELECT s1, s2 FROM ...
       WHERE lang = 'es'
UNION SELECT s1, s2 FROM ...
       WHERE lang = 'de'
      ...