Skip to content

Instantly share code, notes, and snippets.

Brian L. Troutwine blt

Block or report user

Report or block blt

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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.