         VOs.name AS LCGUserVO,
         CAST(SUM(NumberOfJobs) AS UNSIGNED) AS Njobs,
         ROUND((SUM(CpuDuration) / 3600), 0) AS SumCPU,
-        ROUND(SUM(NormalisedCpuDuration * ServiceLevel / (1000 * 3600)), 0) AS NormSumCPU,
+        ROUND(SUM(NormalisedCpuDuration / 3600), 0) AS NormSumCPU,
         ROUND((SUM(WallDuration) / 3600), 0) AS SumWCT,
-        ROUND(SUM(NormalisedWallDuration * ServiceLevel / (1000 * 3600)), 0) AS NormSumWCT,
+        ROUND(SUM(NormalisedWallDuration / 3600), 0) AS NormSumWCT,
         Month,
         Year,
         CAST(MIN(EarliestEndTime) AS DATE) AS RecordStart,

        VORoles.name AS PrimaryRole,
        CAST(SUM(NumberOfJobs) AS UNSIGNED) AS Njobs,
        ROUND((SUM(CpuDuration) / 3600),0) AS SumCPU,
        ROUND(SUM((NormalisedCpuDuration * ServiceLevel) / (1000 * 3600)),0) AS NormSumCPU,
        ROUND((SUM(WallDuration) / 3600),0) AS SumWCT,
        ROUND(SUM((NormalisedWallDuration * ServiceLevel) / (1000 * 3600)),0) AS NormSumWCT,
        Month,
        Year,
        CAST(MIN(EarliestEndTime) AS DATE) AS RecordStart,

CREATE VIEW VSpecIntHistory AS
    SELECT
        site.name AS ExecutingSite,
        CAST(ROUND(NormalisedWallDuration / WallDuration * 250, 0) AS UNSIGNED) AS SpecInt2000,
        CAST(SUM(NumberOfJobs) AS UNSIGNED) AS Njobs,
        Month,
        Year,
        CAST(MIN(EarliestEndTime) AS DATE) AS RecordStart,
        CAST(MAX(LatestEndTime) AS DATE) AS RecordEnd
    FROM
        NormalisedSuperSummaries JOIN Sites AS site ON SiteID = site.id
    GROUP BY
        SiteID,
        SpecInt2000,
