WITH

fip AS(
    SELECT
    fip.fulfilments_income_packages_id
    , IF(fip.fulfilments_income_packages_parent_id = 0, fip.fulfilments_income_packages_id, fip.fulfilments_income_packages_parent_id) AS fulfilments_income_packages_parent_id
    , fip.fulfilments_income_packages_external_id
    , fip.fulfilments_income_packages_status
    , fip.orders_products_id
    , fip.products_attributes_id
    , fip.first_products_attributes_id
    FROM fulfilments_income_packages AS fip
    WHERE fip.fulfilments_income_packages_external_id IN(
    423928,490046,513007,545908,545994,555991,577895,590551,607556,607719


    )
)

SELECT
t.fulfilments_income_packages_id
, t.fulfilments_income_packages_external_id
, COUNT(DISTINCT t.fulfilments_income_packages_ids) as cnt
, GROUP_CONCAT(DISTINCT t.fulfilments_income_packages_ids ORDER BY t.fulfilments_income_packages_ids) AS external_ids
, t.statuses_name AS current_statuses_name
, t.orders_products_id
, t.first_products_attributes_id
FROM (
        SELECT fip.fulfilments_income_packages_id
        , fip.fulfilments_income_packages_external_id
        , fip_first.fulfilments_income_packages_id AS fulfilments_income_packages_ids
        , s.statuses_name
        , fip.orders_products_id
        , fip.first_products_attributes_id
        FROM fip
            left JOIN statuses AS s ON s.statuses_id = fip.fulfilments_income_packages_status
            left JOIN fulfilments_income_packages AS fip_first ON fip.fulfilments_income_packages_parent_id = fip_first.fulfilments_income_packages_parent_id

        UNION

        SELECT fip.fulfilments_income_packages_id
        , fip.fulfilments_income_packages_external_id
        , fip_first.fulfilments_income_packages_id AS fulfilments_income_packages_ids
        , s.statuses_name
        , fip.orders_products_id
        , fip.first_products_attributes_id
        FROM fip
            left JOIN statuses AS s ON s.statuses_id = fip.fulfilments_income_packages_status
            LEFT JOIN fulfilments_income_packages AS fip_first ON fip.fulfilments_income_packages_parent_id = fip_first.fulfilments_income_packages_id

) AS t

GROUP BY t.fulfilments_income_packages_id

HAVING cnt > 1