SHOWS FROM 1977 LIMIT 10;
SHOWS FROM 77;
SHOWS FROM 1977-1980 ORDER BY DATE;
SHOWS FROM 77-80 LIMIT 25;
SHOWS FROM PRIMAL;
SHOWS FROM EUROPE72;
SHOWS FROM BRENT_ERA;
SHOWS FROM 1972 ORDER BY DATE DESC LIMIT 5;

SHOWS FROM 1977 WHERE "Scarlet Begonias" > "Fire on the Mountain";
SHOWS FROM 77-80 WHERE "Help on the Way" > "Slipknot!" > "Franklin's Tower";
SHOWS WHERE "China Cat Sunflower" INTO "I Know You Rider";
SHOWS FROM 1974 WHERE "Weather Report Suite" > "Let It Grow";

SHOWS WHERE "Scarlet Begonias" >> "Fire on the Mountain";
SHOWS WHERE "Estimated Prophet" THEN "Eyes of the World";

SHOWS WHERE "Dark Star" ~> "Saint Stephen";
SHOWS WHERE "Uncle John's Band" TEASE "St. Stephen";

SHOWS WHERE SET1 OPENED "Jack Straw";
SHOWS WHERE SET1 OPENED "Bertha";
SHOWS FROM 1977 WHERE SET1 OPENED "New Minglewood Blues";

SHOWS WHERE SET2 CLOSED "Sugar Magnolia";
SHOWS WHERE SET2 CLOSED "Around and Around";

SHOWS WHERE ENCORE = "U.S. Blues";
SHOWS WHERE ENCORE = "Brokedown Palace";
SHOWS WHERE ENCORE = "One More Saturday Night";
SHOWS WHERE SET3 OPENED "U.S. Blues";
SHOWS WHERE SET3 CLOSED "Brokedown Palace";

SHOWS FROM 1990 WHERE PLAYED "Eyes of the World";
SHOWS FROM 1977 WHERE PLAYED "Scarlet Begonias";
SHOWS WHERE PLAYED "Dark Star" AND PLAYED "Saint Stephen";
SHOWS FROM 72 WHERE PLAYED "Morning Dew";

SHOWS WHERE GUEST "Branford Marsalis";
SHOWS WHERE GUEST "Clarence Clemons";
SHOWS FROM 1990 WHERE GUEST "Branford Marsalis";

SETLIST FOR 5/8/77;
SETLIST FOR 8/27/72;
SETLIST FOR 12/31/78;
SETLIST FOR 3/29/90;
SETLIST FOR "Cornell 1977";
SETLIST FOR 1977;

SONGS LIMIT 50;
SONGS ORDER BY TITLE LIMIT 30;

SONGS WITH LYRICS("train");
SONGS WITH LYRICS("train", "road");
SONGS WITH LYRICS("rose") WRITTEN 1970 LIMIT 20;
SONGS WITH LYRICS("sun", "shine");
SONGS WITH LYRICS("water");
SONGS WITH LYRICS("highway") WRITTEN 1969-1971 LIMIT 10;

SONGS WRITTEN 1968-1970;
SONGS WRITTEN 1970;
SONGS WRITTEN 1969 LIMIT 20;

PERFORMANCES OF "Dark Star";
PERFORMANCES OF "Scarlet Begonias";
PERFORMANCES OF "Eyes of the World";

PERFORMANCES OF "Dark Star" FROM 1972-1974;
PERFORMANCES OF "Dark Star" WITH LENGTH > 20min;
PERFORMANCES OF "Dark Star" WITH LENGTH > 30min;
PERFORMANCES OF "Eyes of the World" ORDER BY LENGTH DESC LIMIT 5;
PERFORMANCES OF "Playing in the Band" WITH LENGTH < 10min;

PERFORMANCES OF "Dark Star" FROM 1973-1974 WITH LENGTH > 20min ORDER BY LENGTH DESC LIMIT 5;
PERFORMANCES OF "Scarlet Begonias" FROM 77-79 ORDER BY DATE DESC LIMIT 20;

SHOWS FROM 1977 LIMIT 3;
SHOWS FROM 1977 LIMIT 3 AS TABLE;
SHOWS FROM 1977 LIMIT 3 AS JSON;
SHOWS FROM 1977 LIMIT 3 AS CSV;
SHOWS FROM 1977 LIMIT 3 AS SETLIST;
SHOWS FROM 1977 LIMIT 3 AS CALENDAR;

SHOWS FROM 1977 WHERE "Scarlet Begonias" > "Fire on the Mountain" AND PLAYED "Estimated Prophet";
SHOWS WHERE SET1 OPENED "Jack Straw" OR SET1 OPENED "Bertha";
SHOWS WHERE SET2 CLOSED "Sugar Magnolia" OR SET2 CLOSED "Around and Around";
SHOWS WHERE PLAYED "Dark Star" AND NOT PLAYED "Saint Stephen";
SHOWS FROM 1990 WHERE GUEST "Branford Marsalis" AND PLAYED "Eyes of the World";
SHOWS WHERE "Help on the Way" > "Slipknot!" > "Franklin's Tower" AND PLAYED "Estimated Prophet";