Skip to content

Instantly share code, notes, and snippets.

@cwage

cwage/gist:5519620

Created May 5, 2013 03:50
Show Gist options
  • Save cwage/5519620 to your computer and use it in GitHub Desktop.
Save cwage/5519620 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
[sql] prepare "SELECT DISTINCT T.id, T.name FROM tagged_images JOIN tags T on T.id = tagged_images.tagid WHERE tagged_images.imgid = 52"
[sql] prepare "select folder from film_rolls where id = ?1"
[sql] prepare "select folder || '/' || filename from images, film_rolls where images.film_id = film_rolls.id and images.id = ?1"
[sql] prepare "select value from meta_data where id = ?1 and key = ?2 order by value"
[sql] prepare "select value from meta_data where id = ?1 and key = ?2 order by value"
[sql] prepare "select value from meta_data where id = ?1 and key = ?2 order by value"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment