SELECT
    `GroupBy1`.`A1` AS `C1`
FROM
    (SELECT
        SUM(CASE
                WHEN (`Project1`.`C2` IS NOT NULL) THEN (`Project1`.`C1`)
                ELSE (0)
            END) AS `A1`
    FROM
        (SELECT 1 AS `X`) AS `SingleRowTable1`
    LEFT OUTER JOIN (SELECT
        `Join1`.`amount` AS `C1`,
            1 AS `C2`
    FROM
        `portfolios` AS `Extent1`
    INNER JOIN (SELECT
        `Extent2`.`id`,
            `Extent2`.`portfolio_id`,
            `Extent2`.`category_id`,
            `Extent2`.`field1`,
            `Extent2`.`field2`,
            `Extent2`.`field3`,
            `Extent2`.`...`,
            `Extent2`.`status`,
            ...
            `Extent3`.`id` AS `ID1`,
            `Extent3`.`reference`,
            `Extent3`.`field1`,
            `Extent3`.`field2`,
            `Extent3`.`field3`,
            `Extent3`.`...`,
            `Extent3`.`status` AS `STATUS1`
    FROM
        `items` AS `Extent2`
    INNER JOIN `categories` AS `Extent3` ON `Extent2`.`category_id` = `Extent3`.`id`) AS `Join1` ON (`Extent1`.`id` = `Join1`.`portfolio_id`)
        AND ((@gp1 = `Join1`.`status`)
        AND (`Join1`.`STATUS1` IN (@gp2 , @gp3, @gp4, @gp5, @gp6)))
    WHERE
        `Extent1`.`id` = @portfolioId) AS `Project1` ON 1 = 1) AS `GroupBy1`