Laravel advanced query

Affiliate has many affiliatesHistory, affiliatesHistory belongs to affiliate, how to make the following query?

Take affiliates, where has affiliatesHistory, if affiliatesHistory records count is equal to 1, then do not take affiliatesHistory, which has status of uninstalled.

$affiliates = $user->affiliates()
        ->whereDoesntHave('affiliatesHistory', function ($q) {
        $q->where('affiliates_histories.status', 'Installed earlier')
 ->orWhere('affiliates_histories.status', 'Uninstalled / Installed earlier');

The following query works, but I need to not take those affiliates, where affiliatesHistory count is equal to 1 and the status is uninstalled.

Any help will be appriaciated.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3i8cxPq
via IFTTT