select count(*) as total from collection where collection.new = 1 and collection.hide = 0 and exists (select 1