adding sql that scopes hf_asset rows to active revisions only