SELECT * FROM T_Agglomerations 
    WHERE
      aggState=1 AND
      aggCode NOT IN (SELECT aucAggCode FROM T_UWWTPAgglos) AND
      aggCode NOT IN (SELECT aggCode FROM T_UWWTPS WHERE uwwState=1)
    ORDER BY
      aggGenerated DESC