MySQL - Ayuda con consulta

SELECT

    FLOOR(COALESCE(subconsulta.stock, 0) / COALESCE(subconsulta.valor_stock, 1)) AS stock,

    NULL AS valor_stock

FROM (

    SELECT

        COALESCE(SUM(COALESCE(STK.stock, VSTK.stock)), 0) AS stock,

        COALESCE(PAQUETE_TOTAL_VALOR.valor_total, 0) AS valor_stock

    FROM spv_productos AS P

    INNER JOIN sys_clientes AS SYS ON SYS.id = P.id_sys

    INNER JOIN spv_productos_paquetes AS PAQUETE ON PAQUETE.id_paquete = P.id

    LEFT JOIN (

        SELECT id_producto, SUM(stock) AS stock

        FROM spv_stock

        WHERE id_sucursal = 87

        GROUP BY id_producto

    ) AS STK ON STK.id_producto = PAQUETE.id_producto

    LEFT JOIN (

        SELECT id_variante, SUM(stock) AS stock

        FROM spv_variantes_stock

        WHERE id_sucursal = 87

        GROUP BY id_variante

    ) AS VSTK ON VSTK.id_variante = PAQUETE.id_producto

    LEFT JOIN (

        SELECT id_paquete, SUM(valor_stock) AS valor_total

        FROM spv_productos_paquetes

        GROUP BY id_paquete

    ) AS PAQUETE_TOTAL_VALOR ON PAQUETE_TOTAL_VALOR.id_paquete = P.id

    WHERE P.id = '1884'

        AND P.id_sys = 78

        AND P.deleted = 0

        AND P.estado_sistema = 1

    GROUP BY P.id, P.estado_sistema

) AS subconsulta;