mysql>SELECT
        events.*,
        titles.msgtext as title,
        subjects.msgtext as event
FROM events
left JOIN msgcodes AS titles
        ON titles.fkey=events.id
        AND titles.FIELD="title"
        AND titles.msgtext <>""
left JOIN msgcodes AS subjects
        ON subjects.fkey=events.id
        AND subjects.FIELD="event"
        AND subjects.msgtext <>"" where events.id=1882 and (titles.lang="en" or titles.lang="de");