How to do a grandparent query?

In soql you can reference grandparent as follows:

AND Subscription__r.Lead__c != null

You might just want to create a checkbox formula and query on that instead.

AND(
    ISNULL(Lead__c),
    NOT(ISNULL(Subscription__r.Lead__c))
)