Show products that are running out in dashboard

Show product variants for which the stock value is below the given threshold value in dashboard index.
Can't we do this using one query somehow? Be it joins or union, having these as separate queries is not just costly but also introduces problems with sorting and pagination.