[![enter image description here](https://i.stack.imgur.com/JZoDW.png)](https://i.stack.imgur.com/JZoDW.png)

I have some custom objects displayed on schema. I need return vacancies which have last active interview at least week ago. I have some query: 

```
List<Vacancy__c> ids = new List<Vacancy__c>();

    for(Application_Proces__c ap : [
            SELECT Vacancy__r.Id, Vacancy__r.Name, Vacancy__r.Status__c, Vacancy__r.Requirements__c, Vacancy__r.Priority__c, Vacancy__r.Rate__c
            FROM Application_Proces__c
            WHERE Id NOT IN (
                    SELECT Application_Process__c
                    FROM Interview__c
                    WHERE Meeting_Date__c = LAST_N_DAYS:7
                    OR Meeting_Date__c > TODAY
            ) AND Status__c = 'Open'
    ]) {
        ids.add(ap.Vacancy__r);
    }

```

I need to rewrite this query to make it without subqueries.