Query Counter Stok Minimum

SELECT
    COUNT(*) AS total
FROM
    `item`
WHERE
    item.status_id = 1
    AND (
        SELECT item_stock_detail.item_id FROM item_stock_detail
        WHERE item.item_id = item_stock_detail.item_id AND item_stock_detail.department_id = 0
        ORDER BY stock_detail_id DESC LIMIT 1 ) IN (
            (
                SELECT item_id FROM item WHERE status_id = 1
            )
        )
    AND (
        (
            SELECT item_stock_detail.balance FROM item_stock_detail
            WHERE item.item_id = item_stock_detail.item_id AND item_stock_detail.department_id = 0
            ORDER BY stock_detail_id DESC LIMIT 1
        ) <= stock_minimum
        OR
        (
            SELECT item_stock_detail.conversion_balance FROM item_stock_detail
            WHERE item.item_id = item_stock_detail.item_id AND item_stock_detail.department_id = 0
            ORDER BY stock_detail_id DESC LIMIT 1
        ) <= conversion_stock_minimum
    )