blt
/ sfml.rb
Last active Dec 17, 2015
— forked from juniorz/sfml.rb
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 |