books_tags
4 rows where books_id = "astrid-lindgren/kalle-blomquist"
This data as json, CSV (advanced)
Link | tags_id | books_id |
---|---|---|
astrid-lindgren/kalle-blomquist,five-stars | five-stars | Kalle Blomquist astrid-lindgren/kalle-blomquist |
astrid-lindgren/kalle-blomquist,german | german | Kalle Blomquist astrid-lindgren/kalle-blomquist |
astrid-lindgren/kalle-blomquist,kids | kids | Kalle Blomquist astrid-lindgren/kalle-blomquist |
astrid-lindgren/kalle-blomquist,mystery | mystery | Kalle Blomquist astrid-lindgren/kalle-blomquist |
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]) );