Brian L. Troutwine blt
-
Software Developer
- Berkeley, CA
- Sign in to view email
- blog.troutwine.us
View sfml.rb
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' |
View sql query
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 |