music_song
1 row where publish_on = "2013-05-07 22:47:28", "publish_on" is on date 2013-05-07 and release_id = 9
This data as json, CSV (advanced)
Suggested facets: publish_on (date)
id ▼ | slug | publish | publish_on | title | description | credits | lyrics | track | release_id | player_code |
---|---|---|---|---|---|---|---|---|---|---|
63 | portrait-artist-young-trashcan | 1 | 2013-05-07 22:47:28 | Portrait Of The Artist As A Young Trashcan | In the haunted mansion The future holds me hostage It’s neverending In a clapboard palace It’s like I told you Portrait of the artist |
21 | Portrait Of The Artist As A Young Trashcan 9 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "music_song" ("id" integer NOT NULL PRIMARY KEY AUTOINCREMENT, "slug" varchar(50) NOT NULL UNIQUE, "publish" bool NOT NULL, "publish_on" datetime NULL, "title" varchar(200) NOT NULL, "description" text NOT NULL, "credits" text NOT NULL, "lyrics" text NOT NULL, "track" integer unsigned NULL, "release_id" integer NULL REFERENCES "music_release" ("id"), "player_code" text NOT NULL); CREATE INDEX "music_song_release_id_d94af625" ON "music_song" ("release_id");