Skip to content

Instantly share code, notes, and snippets.

Brian L. Troutwine blt

View GitHub Profile
@blt
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'
@blt
blt / sql query
Created Aug 27, 2011 — forked from mikeyhill/sql query
slow query
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
You can’t perform that action at this time.