Review Remaining Associators

OVERVIEW:

If there are any other active associators, they should be reviewed for whether their associations need updating.

Primary Language Only. Non-primary languages likely will not have any additional associators, as the only associations come from KWG, User Associations, and Bulk Rank Check.

PROCESS:

select kua.kw_url_associator_id as id, kua.[name], kua.description as [desc], url_cnt, kw_cnt
 ,suk.min_t, suk.max_t
 from kw_url_associator kua
 left outer join (
 select kw_url_associator_id, count(distinct site_url_id) as url_cnt, count(*) as kw_cnt,
 min(association_timestamp) as min_t,
 max(association_timestamp) as max_t
 from site_url_kw with(nolock)
 group by kw_url_associator_id
 ) suk on suk.kw_url_associator_id = kua.kw_url_associator_id
 where is_Active = 1
 order by kua.priority