Skip to content

Instantly share code, notes, and snippets.

@bhearsum

bhearsum/gist:8244173

Created January 3, 2014 19:00
Show Gist options
  • Save bhearsum/8244173 to your computer and use it in GitHub Desktop.
Save bhearsum/8244173 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
select * from buildrequests LEFT OUTER JOIN builds on builds.brid =
buildrequests.id WHERE builds.brid IS NULL and buildrequests.complete = 0 and
buildrequests.claimed_at != 0 and (buildrequests.claimed_at < (unix_timestamp() - 300)) order by submitted_at desc;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment