blt

require 'formula'

# Documentation: https://github.com/mxcl/homebrew/wiki/Formula-Cookbook
# PLEASE REMOVE ALL GENERATED COMMENTS BEFORE SUBMITTING YOUR PULL REQUEST!

class Sfml < Formula
  homepage 'http://www.sfml-dev.org'

  version '2.0'
  url 'http://www.sfml-dev.org/download/sfml/2.0/SFML-2.0-sources.zip'

blt

SELECT p.name as procedure_name, addr.zip as zip,
				s.procedure_id	as proc,  s.id
				FROM slots AS s, procedures AS p, organizations AS o, addresses_organizations as au, addresses as addr
				WHERE s.provider_id = o.id
				AND s.procedure_id = p.id
				AND au.organization_id = o.id
				AND addr.id = au.address_id
				AND addr.zip LIKE '".$zipcode."%'
				ORDER BY random()
				LIMIT 5