SELECT count(*) AS missing_target_count FROM dot_tools WHERE status IN ('active','published') AND tier = 'B' AND NOT (extra_metadata ? 'target_collections')