Language reference

Language reference

Full syntax for GDQL. For conventions (case, strings, comments), see Conventions.


Query types

QueryDescription
SHOWSList shows; filter by date, WHERE conditions, ORDER BY, LIMIT, AS format.
SONGSList songs; filter by WITH LYRICS, WRITTEN date.
PERFORMANCESList performances of a song; filter by date, WITH LENGTH, ORDER BY.
SETLISTSetlist for a single date (e.g. SETLIST FOR 5/8/77).

Conditions and operators

  • WHERE conditions — Segues (>, >>), set position (SET1 OPENED, ENCORE =), PLAYED, GUEST, LENGTH; AND/OR/NOT.
  • Operators — Segue tokens, logical operators, comparisons, dates/eras, output formats.

Use Getting started for install and running queries.