SELECT count(id) as kazu FROM article WHERE active = 1 AND listed = 1