select a.*, count(b.id) as c from orders a left join products b on a.id=b.order_id group by a.id having (a.description is not null) and (c=0);