SELECT central_products.products.incremental,
    central_products.products.mfg_part_number,
    central_products.products.item_condition,
    central_products.products.description,
    COUNT(
        CASE
            WHEN Viixim.inventory.status = 'IN_STOCK' THEN 1
        END
    ) AS Viixim_stock,
    COUNT(
        CASE
            WHEN Evrymm.inventory.status = 'IN_STOCK' THEN 1
        END
    ) AS Evrymm_stock,
    IFNULL(AVG(Viixim.inventory.cost), 0) AS Viixim_cost,
    IFNULL(AVG(Evrymm.inventory.cost), 0) AS Evrymm_cost
FROM central_products.products
    LEFT JOIN Viixim.inventory ON Viixim.inventory.product_code = central_products.products.incremental
    LEFT JOIN Evrymm.inventory ON Evrymm.inventory.product_code = central_products.products.incremental
GROUP BY central_products.products.incremental