books_tags

8 rows where tags_id = "british-fantasy-award"

✎ View and edit SQL

This data as json, CSV (advanced)

Link tags_id books_id
aliette-de-bodard/the-tea-master-and-the-detective,british-fantasy-award british-fantasy-award The Tea Master and the Detective aliette-de-bodard/the-tea-master-and-the-detective
china-mieville/perdido-street-station,british-fantasy-award british-fantasy-award Perdido Street Station china-mieville/perdido-street-station
china-mieville/the-scar,british-fantasy-award british-fantasy-award The Scar china-mieville/the-scar
jo-walton/among-others,british-fantasy-award british-fantasy-award Among Others jo-walton/among-others
naomi-novik/uprooted,british-fantasy-award british-fantasy-award Uprooted naomi-novik/uprooted
neil-gaiman/anansi-boys,british-fantasy-award british-fantasy-award Anansi Boys neil-gaiman/anansi-boys
r-j-barker/the-bone-ships,british-fantasy-award british-fantasy-award The Bone Ships r-j-barker/the-bone-ships
stephen-king/the-dark-tower,british-fantasy-award british-fantasy-award The Dark Tower stephen-king/the-dark-tower

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])
);