select 1 from events_events where event_id = :event_id select email from parties where party_id=:user_id select email as contact_email from parties where party_id=:contact_user_id update ec_products set email_on_purchase_list=:email, url='$activity_info(detail_url)',no_shipping_avail_p='t', active_p='t' where product_id=:product_id delete from ec_category_product_map where product_id=:product_id delete from events_venues_conn_used_map where event_id=:event_id and package_id=[ad_conn package_id] insert into events_venues_conn_used_map values (:event_id, :venue_id, [lindex $event_connecting $i], [ad_conn package_id]) select connected_venue_id from events_venues_conn_used_map where event_id=:event_id and venue_id=$event_info(venue_id) and package_id=[ad_conn package_id] and connected_venue_id=:venue_id select venue_id from events_venues where venue_id=:venue_id and $connecting_venue_id in ([events::venue::connecting -venue_id $venue_id -package_id [ad_conn package_id] -sql_p "t"])