Abstain vote is incorrect in SPOs

[kneerose]

https://dev.drep.id/governance_actions/047ed888d082830584e6c9979bc986da3d99093c4154d3dc38119ae0c363d148#0

Here, dRep abstained displays the Total abstain vote, but sPos abstained displays the sPos abstains instead of the total sPos Abstain

For reference

https://govtool.cardanoapi.io/outcomes/governance_actions/047ed888d082830584e6c9979bc986da3d99093c4154d3dc38119ae0c363d148#0

[mesudip]

WIP

[reeshavacharya]

WITH ga AS (
    SELECT 
        g.id, 
        b.epoch_no AS submittedEpoch, 
        g.expiration AS expirationEpoch
    FROM gov_action_proposal g
    JOIN tx ON tx.id = g.tx_id
    JOIN block b ON b.id = tx.block_id
    WHERE tx.hash = DECODE(
        '047ed888d082830584e6c9979bc986da3d99093c4154d3dc38119ae0c363d148', 'hex'
    )
    AND g.index = 0
)
SELECT * 
FROM voting_procedure vp 
JOIN ga ON ga.id = vp.gov_action_proposal_id;

This returns nothing.
Which means that there is no vote for this gov action.

WIP : Check presence of always abstain SPOs if any