select i.impl_name,
r.summary_context_id
from acs_sc_impls i,
rss_gen_subscrs r
where r.subscr_id = :subscr_id
and i.impl_id = r.impl_id
select s.summary_context_id,
i.impl_name
from rss_gen_subscrs s,
acs_sc_impls i
where i.impl_id = s.impl_id
and s.subscr_id = :subscr_id
select s.summary_context_id,
i.impl_name
from rss_gen_subscrs s,
acs_sc_impls i
where i.impl_id = s.impl_id
and s.subscr_id = :subscr_id