I've updated my previous post. Here is the full working code: net_votes:<20 AND created:[2017-06-05 TO 2017-06-11] AND pending_payout_value:<1 There is currently no way to search by total payout (coming in future) however, I've added in my example a way to search by pending payout which will work as long as the date range is less than 7 days.