books_tags
5 rows where books_id = "ada-palmer/too-like-the-lightning"
This data as json, CSV (advanced)
Link | tags_id | books_id |
---|---|---|
ada-palmer/too-like-the-lightning,five-stars | five-stars | Too Like the Lightning ada-palmer/too-like-the-lightning |
ada-palmer/too-like-the-lightning,hugo-award-nominees | hugo-award-nominees | Too Like the Lightning ada-palmer/too-like-the-lightning |
ada-palmer/too-like-the-lightning,otherwise-award-nominees | otherwise-award-nominees | Too Like the Lightning ada-palmer/too-like-the-lightning |
ada-palmer/too-like-the-lightning,scifi | scifi | Too Like the Lightning ada-palmer/too-like-the-lightning |
ada-palmer/too-like-the-lightning,space-monks | space-monks | Too Like the Lightning ada-palmer/too-like-the-lightning |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [books_tags] ( [tags_id] TEXT REFERENCES [tags]([id]), [books_id] TEXT REFERENCES [books]([id]), PRIMARY KEY ([books_id], [tags_id]) );