authors_books
1 row where books_id = "adam-r-shannon/on-the-day-you-spend-forever-with-your-dog"
This data as json, CSV (advanced)
Link | authors_id | books_id |
---|---|---|
adam-r-shannon,adam-r-shannon/on-the-day-you-spend-forever-with-your-dog | Jason Sizemore adam-r-shannon | Apex Magazine -- December 2018 adam-r-shannon/on-the-day-you-spend-forever-with-your-dog |
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]) );