SELECT
            MIN(CONCAT('F', pu.company_number)) AS id,
            MIN(
                CASE
                    WHEN
                    'EN'
                    = 'EN' THEN pu.company_name
                    ELSE COALESCE(nn.native_name, pu.company_name)
                END
            ) AS NAME,
            MIN(pu.company_name) AS SORT_NAME,
            MIN(pu.company_name) AS sort_parent_name,
            MIN(pu.inst_id) AS inst_id,
            MIN(pu.company_name) AS parent_name,
            0 AS LEVEL,
            'Institution' AS instinsid,
            MIN(pu.ultparentid) AS ultparentid,
            MIN(pu.ultparentname) AS ultparentname,
            MIN(pu.htype) AS htype,
            MIN(pu.investor) AS investor,
            MIN(pu.Institution_Name) AS MFADVISOR,
            MIN(pu.style) AS style,
            MIN(pu.mstyle) AS mstyle,
            MIN(pu.capgrp) AS capgrp,
            MIN(pu.turn) AS turn,
            MIN(pu.metro) AS metro,
            MIN(pu.region) AS region,
            MIN(pu.subregion) AS subregion,
            MIN(pu.cntry) AS cntry,
            MIN(pu.state) AS state,
            MIN(pu.city) AS city,
            MIN(
                CASE
                    WHEN 
                   'US'
                    = NULL
                    OR pu.iso_country IS NULL THEN NULL
                    ELSE (
                        CASE
                            WHEN pu.iso_country = 
                           'US'
                            THEN 'Domestic'
                            ELSE 'Foreign'
                        END
                    )
                END
            ) AS domfor,
            MIN(opsa.pct_sector) AS UKSECT,
            MIN(opca.pct_market) AS UKMKT,
            NULL AS title,
            MAX(
                CASE
                    WHEN pu.cfax = '' THEN NULL
                    ELSE pu.cfax
                END
            ) AS cfax,
            MIN(pu.beta) AS beta,
            MIN(pu.relstr) AS relstr,
            MIN(
                pu.aum * 
                1
            ) AS AUM,
            MIN(
                pu.eqasset * 
                1
            ) AS EQASSET,
            MIN(pu.filername) AS filername,
            MIN(pu.mfcontact) AS mfcontact,
            MIN(pu.cphone) AS cphone,
            MIN(pu.cadd) AS cadd,
            MIN(pu.cemail) AS cemail,
            MIN(pu.ctitle) AS ctitle,
            MIN(pu.actdesc) AS actdesc,
            MIN(pu.actscore) AS actscore,
            MIN(pu.sw) AS sw,
            MIN(pu.pb) AS pb,
            MIN(pu.divyld) AS divyld,
            MIN(pu.pe) AS pe,
            SUM(
                CASE
                    WHEN hh.report_date = '20210630' THEN hh.position
                    ELSE 0
                END
            ) AS parent_pos,
            SUM(
                case
                    when hh.report_date = '20210331' then hh.position
                    else 0
                end
            ) as POS0,
            SUM(
                case
                    when hh.report_date = '20210630' then hh.position
                    else 0
                end
            ) as POS1,
            CASE
                WHEN 
               NULL
                = 'NULL' THEN NULL
                ELSE 
               NULL
            END AS WATCHLIST,
            CASE
                WHEN MIN(hh.company_number) = ANY(
                    STRING_TO_ARRAY('284159,9342070,10992703,12044185,12445676,13371444',
                        ','
                    ) :: int []
                ) THEN 1
                ELSE 0
            END AS ACTFLAG,
            SUM(
                CASE
                    WHEN hh.report_date = ANY(
                        STRING_TO_ARRAY('20200930,20201231', ',' ) :: date []
                    ) THEN 0
                    ELSE 1
                END
            ) AS include
        FROM
            own.own_snapshot hh
            JOIN own.own_portmas_ultimate pu ON hh.company_number = pu.company_number
            AND pu.portfolio_type = 'F'
            INNER JOIN own.own_secmas s ON hh.cusip = s.cusip
            LEFT JOIN own.own_portmas_native nn ON pu.company_number = nn.company_number
            AND nn.language_code = 
            'EN'
            LEFT JOIN own.own_holdings_hist_prices hhp ON hh.cusip = hhp.CUSIP
            AND hh.report_date = hhp.Price_Date
            LEFT JOIN own.own_portmas_optmv_snapshot optmv ON hh.company_number = optmv.company_number
            AND hh.report_date = optmv.date
            AND optmv.type = 'F'
            LEFT JOIN own.own_portmas_sector_analytics_fds opsa ON opsa.company_number = hh.company_number
            AND opsa.code = '3300'
            AND opsa.iso_country = 'GB'
            AND opsa.type = 'F'
            LEFT JOIN own.own_portmas_country_analytics_uk_fds opca ON opca.company_number = hh.company_number
            AND opca.type = 'F'
            LEFT JOIN own.own_stakes_snapshot sts ON hh.cusip = sts.cusip
            AND hh.company_number = sts.company_number
            AND hh.report_date = sts.report_date
        WHERE
            hh.cusip = '594918104'
            AND hh.report_date IN ('20210331', '20210630')
        GROUP BY
            hh.company_number