books_tags
5 rows where books_id = "anne-mccaffrey/dragonflight"
This data as json, CSV (advanced)
Link | tags_id | books_id |
---|---|---|
anne-mccaffrey/dragonflight,fantasy | fantasy | Dragonflight anne-mccaffrey/dragonflight |
anne-mccaffrey/dragonflight,romance | romance | Dragonflight anne-mccaffrey/dragonflight |
anne-mccaffrey/dragonflight,scifi | scifi | Dragonflight anne-mccaffrey/dragonflight |
anne-mccaffrey/dragonflight,time-travel | time-travel | Dragonflight anne-mccaffrey/dragonflight |
anne-mccaffrey/dragonflight,ya | ya | Dragonflight anne-mccaffrey/dragonflight |
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]) );