BookWalker

home / database

series_tags

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

10 rows where series_id = "CNT_047J9NJZ29EG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_047J9NJZ29EG,TAG_0AMNE3F46BR0 Pieces of The Past CNT_047J9NJZ29EG complete TAG_0AMNE3F46BR0
CNT_047J9NJZ29EG,TAG_1CAJKEV5GH00 Pieces of The Past CNT_047J9NJZ29EG Cousins TAG_1CAJKEV5GH00
CNT_047J9NJZ29EG,TAG_1Q7H0T5XXFN0 Pieces of The Past CNT_047J9NJZ29EG Twins TAG_1Q7H0T5XXFN0
CNT_047J9NJZ29EG,TAG_2APDBN4CY9FG Pieces of The Past CNT_047J9NJZ29EG adult TAG_2APDBN4CY9FG
CNT_047J9NJZ29EG,TAG_2M2AXCZQH3EG Pieces of The Past CNT_047J9NJZ29EG Drama TAG_2M2AXCZQH3EG
CNT_047J9NJZ29EG,TAG_2M5T60D610KG Pieces of The Past CNT_047J9NJZ29EG Boys Love TAG_2M5T60D610KG
CNT_047J9NJZ29EG,TAG_2N8QF7XXYSJG Pieces of The Past CNT_047J9NJZ29EG Adoption TAG_2N8QF7XXYSJG
CNT_047J9NJZ29EG,TAG_3FSSQS1PV7MG Pieces of The Past CNT_047J9NJZ29EG Childhood Trauma TAG_3FSSQS1PV7MG
CNT_047J9NJZ29EG,TAG_3P1ZWB3947FG Pieces of The Past CNT_047J9NJZ29EG Tragic Past TAG_3P1ZWB3947FG
CNT_047J9NJZ29EG,TAG_3RFJCYHBFRPG Pieces of The Past CNT_047J9NJZ29EG Murder TAG_3RFJCYHBFRPG

Advanced export

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

CSV options:

CREATE TABLE series_tags (
      series_id TEXT NOT NULL,
      tag_id TEXT NOT NULL,
      PRIMARY KEY (series_id, tag_id),
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (tag_id) REFERENCES tags(id)
    );
CREATE INDEX idx_series_tags_tag ON series_tags(tag_id);
Powered by Datasette · Queries took 7.201ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS