Exactly what @Darren_Murphy said. You could do something like this:
In the user publications table, relate back to the user profile table and do a lookup of the user’s subscription status. If they’re an active member, then adjust the sorting of the publications so their content is first.