def get_twpics
    # logger.debug "\t DEBUG regions (#{@regions.id})"
    @neighbors = Neighborhood.find(:all,      :joins => "JOIN region_for_neighborhoods ON neighborhoods.id = region_for_neighborhoods.neighborhood_id",
      :conditions => "region_id = #{@regions.id}",      :select => "distinct neighborhoods.id"    )
    a_list = []
    @neighbors.each { |x| a_list.push(x.id.to_s) }
    s_list = a_list.join(", ")
      return Event.find(
        :all,
        :conditions => "venues.neighborhood_id IN (#{s_list}) AND events.venue_id IS NOT NULL",
        :select => "events.*, venues.*, medias.*",
        :joins => "JOIN venues ON (events.venue_id = venues.id) JOIN medias ON (venues.media_id = medias.id) JOIN region_for_neighborhoods ON venues.neighborhood_id = region_for_neighborhoods.neighborhood_id",
        :order => 'events.updated_at DESC',
        :limit => 8
        )
  end