published_songs (view)
1 row where publish_on = "2014-05-03 08:22:29" and "publish_on" is on date 2014-05-03
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 |
---|---|---|---|---|---|---|---|---|---|---|
66 | destroy-this-poem | 1 | 2014-05-03 08:22:29 | Destroy This Poem | Hey alright, we're cherry picking days till we die hey alright, can you believe we escaped alive? i'm doing ok I guess Hey alright, I figured out how to sleep through the night Cuz there's a lotta people saying |
3 | 10 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW published_songs as select * from music_song where publish;