select w.channel_id from weblogger_channels w where w.package_id = :package_id and w.user_id is null select subscr_id from rss_gen_subscrs s, acs_sc_impls i, weblogger_channels w where s.summary_context_id = w.channel_id and w.package_id = :package_id and w.user_id is null and s.impl_id = i.impl_id and i.impl_name = 'pinds_blog_entries' and i.impl_owner_name = 'lars-blogger' select w.channel_id from weblogger_channels w where w.package_id = :package_id and w.user_id = :creation_user select subscr_id from rss_gen_subscrs s, acs_sc_impls i, weblogger_channels w where s.summary_context_id = w.channel_id and w.user_id = :creation_user and w.package_id = :package_id and s.impl_id = i.impl_id and i.impl_name = 'pinds_blog_entries' and i.impl_owner_name = 'lars-blogger' update rss_gen_subscrs set channel_title = :channel_title, channel_link = :channel_link where subscr_id = :subscr_id select screen_name from users where user_id = :creation_user select count(*) from pinds_blog_entries where package_id = :package_id and draft_p = 'f'