authors_books
1 row where authors_id = "andrzej-sapkowski" sorted by authors_id
This data as json, CSV (advanced)
Link | authors_id ▼ | books_id |
---|---|---|
andrzej-sapkowski,andrzej-sapkowski/the-last-wish | Andrzej Sapkowski andrzej-sapkowski | The Last Wish andrzej-sapkowski/the-last-wish |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [authors_books] ( [authors_id] TEXT REFERENCES [authors]([id]), [books_id] TEXT REFERENCES [books]([id]), PRIMARY KEY ([authors_id], [books_id]) );