How can I retrieve ContactKey/SubscriberKey for all MobilePush Opt-In contacts using SQL? _PushAddress only returns ContactID and all joins tested (_Subscribers, _MobileAddress, _SMSSubscriptionLog) return 0 rows.

I'm trying to extract all MobilePush Opt-In contacts from SFMC.

This query works:

SQL

SELECT

 _ContactID AS ContactID,

 _DeviceID AS DeviceID,

 _Platform AS Platform,

 _OptInStatusID AS OptInStatusID

FROM _PushAddress

WHERE _OptInStatusID = 2 

However, _PushAddress only exposes ContactID.

In Contact Builder > All Contacts > Mobile Opt-In I can see both:

ContactKey

DeviceID

Using the same DeviceID in _PushAddress, I can retrieve:

ContactID

DeviceID

So SFMC clearly knows: ContactKey <-> DeviceID <-> ContactID

I've already tried:

SQL

_PushAddress._ContactID = _Subscribers.SubscriberID

``

SQL

_PushAddress -> _MobileAddress -> _SMSSubscriptionLog

and all joins return 0 rows.

Is there any SQL-accessible Data View that maps MobilePush ContactID to ContactKey / SubscriberKey? Or has anyone successfully extracted all MobilePush Opt-In ContactKeys via SQL?