Pollutants

SELECT Label as label,
    SUM(total) as total,
    pollutantId,
    parentId,
    euregReportingYear
FROM [IED].[DB_VERSION].[Tableau_Glossary2_3_4_MostCommonPollutants] as MCP
LEFT JOIN [IED].[DB_VERSION].[Glo_Pollutants] as GP ON MCP.Label = GP.name
WHERE MCP.euregReportingYear IN (
        SELECT TOP 1 reportingYear
        FROM [IED].[DB_VERSION].[ReportData]
        WHERE Datasource = 'EUReg'
        ORDER BY reportingYear DESC
    ) AND GP.eperPollutantId IS NOT NULL
GROUP BY Label, pollutantId, parentId, euregReportingYear
ORDER BY total DESC