Skip to content

Instantly share code, notes, and snippets.

@mkubala

mkubala/events_by_tag_query.sql

Created July 10, 2020 11:50
Show Gist options
  • Save mkubala/d7116274332b1225ae28713815719d31 to your computer and use it in GitHub Desktop.
Save mkubala/d7116274332b1225ae28713815719d31 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
events_by_tag_query.sql
SELECT * FROM public.journal WHERE deleted = false AND tags @> ARRAY[3] AND ordering > 1000 AND ordering <= 3000 ORDER BY ordering ASC LIMIT 1000;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment