select a.lower_email as email from 

unique_subscribers a
inner join 

(
select id from
unique_subscribers 
where status = '' and `count` = 0 and cert_count = 0 and complained = 0
    order by cert_count asc, id asc
    limit 30
) b

on a.id = b.id
group by a.lower_email