books_tags

7 rows where tags_id = "world-fantasy-award"

✎ View and edit SQL

This data as json, CSV (advanced)

Link tags_id books_id
china-mieville/the-city-the-city,world-fantasy-award world-fantasy-award The City & the City china-mieville/the-city-the-city
emily-tesh/silver-in-the-wood,world-fantasy-award world-fantasy-award Silver in the Wood emily-tesh/silver-in-the-wood
gene-wolfe/the-shadow-of-the-torturer,world-fantasy-award world-fantasy-award The Shadow of the Torturer gene-wolfe/the-shadow-of-the-torturer
john-m-ford/the-dragon-waiting,world-fantasy-award world-fantasy-award The Dragon Waiting john-m-ford/the-dragon-waiting
ken-liu/the-paper-menagerie-and-other-stories,world-fantasy-award world-fantasy-award The Paper Menagerie and Other Stories ken-liu/the-paper-menagerie-and-other-stories
patrick-suskind/perfume,world-fantasy-award world-fantasy-award Perfume: The Story of a Murderer patrick-suskind/perfume
ursula-k-le-guin/the-other-wind,world-fantasy-award world-fantasy-award The Other Wind ursula-k-le-guin/the-other-wind

Advanced export

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

CSV options: 

CREATE TABLE [books_tags] (
   [tags_id] TEXT REFERENCES [tags]([id]),
   [books_id] TEXT REFERENCES [books]([id]),
   PRIMARY KEY ([books_id], [tags_id])
);