const orderResult = await pool.request()
      .input("orderNumber", orderNumber)
      .input("orderSecret", orderSecret)
      .query("select orderID, orderIsPaid from MiniShop.Orders" +
        " where orderIsRefunded = 0 and orderIsDeleted = 0" +