Query list stok minimun by Daniel

SELECT
  (SELECT category_name
   FROM category
   WHERE category_id = item.category_id
   LIMIT 1) AS kategori,

  (SELECT branch_name
   FROM master_branch
   WHERE master_branch.branch_id =
       (SELECT item_stock_detail.branch_id
        FROM item_stock_detail
        WHERE item.item_id = item_stock_detail.item_id
          AND item_stock_detail.branch_id = 1
          AND item_stock_detail.department_id = 0
        ORDER BY stock_detail_id DESC
        LIMIT 1)
   LIMIT 1) AS cabang,
       item.item_name AS nama_item,
       item.item_sku AS sku_1,

  (SELECT item_stock_detail.unit
   FROM item_stock_detail
   WHERE item.item_id = item_stock_detail.item_id
     AND item_stock_detail.branch_id = 1
     AND item_stock_detail.department_id = 0
   ORDER BY stock_detail_id DESC
   LIMIT 1) AS satuan_1,

  (SELECT item_stock_detail.balance
   FROM item_stock_detail
   WHERE item.item_id = item_stock_detail.item_id
     AND item_stock_detail.branch_id = 1
     AND item_stock_detail.department_id = 0
   ORDER BY stock_detail_id DESC
   LIMIT 1) AS stok_1,
       item.conversion_sku AS sku_2,

  (SELECT item_stock_detail.conversion_unit
   FROM item_stock_detail
   WHERE item.item_id = item_stock_detail.item_id
     AND item_stock_detail.branch_id = 1
     AND item_stock_detail.department_id = 0
   ORDER BY stock_detail_id DESC
   LIMIT 1) AS satuan_2,

  (SELECT item_stock_detail.conversion_balance
   FROM item_stock_detail
   WHERE item.item_id = item_stock_detail.item_id
     AND item_stock_detail.branch_id = 1
     AND item_stock_detail.department_id = 0
   ORDER BY stock_detail_id DESC
   LIMIT 1) AS stok_2,
       item.category_id,

  (SELECT item_stock_detail.branch_id
   FROM item_stock_detail
   WHERE item.item_id = item_stock_detail.item_id
     AND item_stock_detail.branch_id = 1
     AND item_stock_detail.department_id = 0
   ORDER BY stock_detail_id DESC
   LIMIT 1) AS branch_id,
       item.stock_minimum,
       item.conversion_stock_minimum
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)