select
    company_name,
    count(distinct job_ads.id) as jumlah_job_ads,
    COUNT(DISTINCT applications.id) as applikasi,
    type,
    total_ads_id
from
    employer
        left join
    job_ads ON job_ads.employer_id = employer.id
        and job_ads.is_active = 1
        and job_ads.review_status = 'a'
        left join
    company ON employer.company_id = company.id
        left join
    company_external_ads ON company_external_ads.company_id = company.id
        left join
    applications ON applications.job_ads_id = job_ads.id
where
    type like 'jobstreet'
        and total_ads_id > 0
group by employer.id
having count(Distinct job_ads.id) > 0
    and COUNT(DISTINCT applications.id) < 5