Skip to content

Instantly share code, notes, and snippets.

@bojanrajkovic

bojanrajkovic/foo.sql

Created November 28, 2015 15:00
Show Gist options
  • Save bojanrajkovic/b10fa0c0ef38fd3555fa to your computer and use it in GitHub Desktop.
Save bojanrajkovic/b10fa0c0ef38fd3555fa to your computer and use it in GitHub Desktop.
Download ZIP
Raw
foo.sql
SELECT "g.Gif"."Id", "g.Gif"."AddedAt", "g.Gif"."FirstFrame", "g.Gif"."LastUsed", "g.Gif"."Url", "g.Gif"."UsedCount"
FROM "tags" AS "g"
INNER JOIN "gifs" AS "g.Gif" ON "g"."GifId" = "g.Gif"."Id"
WHERE lower("g"."Tag") = lower(@__tag_0)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment