update rss_gen_subscrs
set lastbuild = CURRENT_TIMESTAMP,
last_ttb = :last_ttb $extra_sql
where subscr_id = :subscr_id
select impl_id
from acs_sc_impls i
where impl_contract_name = 'RssGenerationSubscriber'
and not exists (select 1
from acs_sc_bindings b
where b.impl_id = i.impl_id
and b.contract_id = :contract_id)
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