Howto: Query for Field of Research (2018) FOR labels

If you're working with FoR labels in the Reporting Database, the following will make sure that only labels from the FoR vocabulary are returned, and gives the numeric code in a separate column

SELECT  pl.[Publication ID]
        ,pl.[Label]
        ,lv.[Label Code]
FROM    [Publication] p
        JOIN [Publication Label] pl
            ON pl.[Publication ID] = p.ID
        JOIN [Label Vocabulary] lv
            ON  lv.[Scheme ID] = pl.[Scheme ID]
                AND lv.[Label] = pl.[Label]
        JOIN [Label Scheme] ls
            ON ls.ID = lv.[Scheme ID]
WHERE   ls.[Name] = 'for'
;