update events_venues
set venue_name = :venue_name,
address1 = :address1,
address2 = :address2,
city = :city,
usps_abbrev = :usps_abbrev,
postal_code = :postal_code,
iso = :iso,
time_zone = :time_zone,
phone_number = :phone_number,
fax_number = :fax_number,
email = :email,
needs_reserve_p = :needs_reserve_p,
max_people = :max_people,
description = :description
where venue_id = :venue_id
select venue_name, address1, address2, city, usps_abbrev, postal_code, iso,
time_zone, phone_number, fax_number, email,
needs_reserve_p, max_people, description
from events_venues
where venue_id = :venue_id
select 1 from events_venues where venue_id = :venue_id
select venue_name, venue_id
from events_venues
select venue_id from events_venues where venue_id=:parent_id and package_id=:package_id
select venue_id from events_venues where venue_id=:child_id and package_id=:package_id
insert into events_venues_venues_map (parent_venue_id, child_venue_id, package_id) values (:parent_id, :child_id, :package_id)
select right_venue_id from events_venues_connecting_map where right_venue_id=:right_id and left_venue_id=:left_id and package_id=:package_id
select venue_id from events_venues where venue_id=:left_id and package_id=:package_id
select venue_id from events_venues where venue_id=:right_id and package_id=:package_id
insert into events_venues_connecting_map (left_venue_id, right_venue_id, package_id) values (:left_id, :right_id, :package_id)
select venue_id from events_venues where venue_id=:left_id and package_id=:package_id
select venue_id from events_venues where venue_id=:right_id and package_id=:package_id
delete from events_venues_connecting_map where package_id=:package_id and ((left_venue_id=:left_id and right_venue_id=:right_id) or (right_venue_id=:left_id and left_venue_id=:right_id))
select venue_id as this_venue_id, venue_name from events_venues where package_id=:package_id and venue_id<>:venue_id order by venue_name, venue_id
select parent_venue_id as venue_1, child_venue_id as venue_2 from events_venues_venues_map where child_venue_id=$venue_id and package_id=$package_id
select child_venue_id as venue_1, parent_venue_id as venue_2 from events_venues_venues_map where parent_venue_id=$venue_id and package_id=$package_id
select venue_id, venue_name from events_venues where package_id=:package_id
select venue_id, venue_name from events_venues where venue_id<>:this_venue_id and package_id=:package_id
delete from events_venues_venues_map where child_venue_id=:child_id and (parent_venue_id=:parent_id or parent_venue_id in ([events::venue::all_parents_or_children -venue_id $parent_id -parent_p "f" -sql_p "t"])) and package_id=:package_id
select connected_venue_id, events_venues.venue_name as connected_venue_name from events_venues_conn_used_map, events_venues where events_venues_conn_used_map.event_id=:event_id and events_venues_conn_used_map.venue_id=:venue_id and events_venues_conn_used_map.package_id=:package_id and events_venues_conn_used_map.connected_venue_id=events_venues.venue_id
select min(max_people) as min from events_venues where venue_id in ([events::venue::all_parents_or_children -venue_id $venue_id -parent_p "t" -sql_p "t"])