books_tags
6 rows where books_id = "ann-leckie/ancillary-sword"
This data as json, CSV (advanced)
| Link | tags_id | books_id |
|---|---|---|
| ann-leckie/ancillary-sword,bsfa-award | bsfa-award | Ancillary Sword ann-leckie/ancillary-sword |
| ann-leckie/ancillary-sword,bsfa-award-nominees | bsfa-award-nominees | Ancillary Sword ann-leckie/ancillary-sword |
| ann-leckie/ancillary-sword,five-stars | five-stars | Ancillary Sword ann-leckie/ancillary-sword |
| ann-leckie/ancillary-sword,hugo-award-nominees | hugo-award-nominees | Ancillary Sword ann-leckie/ancillary-sword |
| ann-leckie/ancillary-sword,nebula-award-nominees | nebula-award-nominees | Ancillary Sword ann-leckie/ancillary-sword |
| ann-leckie/ancillary-sword,scifi | scifi | Ancillary Sword ann-leckie/ancillary-sword |
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]) );