18 rows where authors_id = 1221698

View and edit SQL

Link authors_id books_id
Neil Gaiman 1221698 Neverwhere 14497
Neil Gaiman 1221698 The Ocean at the End of the Lane 15783514
Neil Gaiman 1221698 The Sandman: The Dream Hunters 166580
Neil Gaiman 1221698 Fragile Things: Short Fictions and Wonders 16788
Neil Gaiman 1221698 Stardust 16793
Neil Gaiman 1221698 Coraline 17061
Neil Gaiman 1221698 Fortunately, the Milk 17349203
Neil Gaiman 1221698 The Books of Magic 17727
Neil Gaiman 1221698 Odd and the Frost Giants 2108198
Neil Gaiman 1221698 The Graveyard Book 2213661
Neil Gaiman 1221698 Anansi Boys 2744
Neil Gaiman 1221698 Norse Mythology 30809689
Neil Gaiman 1221698 Books Have Sexes 33791101
Neil Gaiman 1221698 American Gods 4407
Neil Gaiman 1221698 M Is for Magic 47699
Neil Gaiman 1221698 InterWorld 47701
Neil Gaiman 1221698 Snow, Glass, Apples 6366271
Neil Gaiman 1221698 A Study in Emerald 6599565

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [authors_books] (
   [authors_id] TEXT REFERENCES [authors]([id]),
   [books_id] TEXT REFERENCES [books]([id]),
   PRIMARY KEY ([authors_id], [books_id])
);