BookWalker

home / database

series_tags

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

17 rows where series_id = "CNT_1TT0JF209280"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1TT0JF209280,TAG_0MD2Q5KZ9RP0 Heartbreaker CNT_1TT0JF209280 Josei TAG_0MD2Q5KZ9RP0
CNT_1TT0JF209280,TAG_10TVZG8NZP00 Heartbreaker CNT_1TT0JF209280 Family Life TAG_10TVZG8NZP00
CNT_1TT0JF209280,TAG_14BJRBPH88Q0 Heartbreaker CNT_1TT0JF209280 Jealousy TAG_14BJRBPH88Q0
CNT_1TT0JF209280,TAG_1BQ91XX2Q7J0 Heartbreaker CNT_1TT0JF209280 Amnesia TAG_1BQ91XX2Q7J0
CNT_1TT0JF209280,TAG_1P3QSYSHW6X0 Heartbreaker CNT_1TT0JF209280 Tragedy TAG_1P3QSYSHW6X0
CNT_1TT0JF209280,TAG_1Q0HX10YX5F0 Heartbreaker CNT_1TT0JF209280 Unrequited Love TAG_1Q0HX10YX5F0
CNT_1TT0JF209280,TAG_1YX7FENBMPS0 Heartbreaker CNT_1TT0JF209280 Orphans TAG_1YX7FENBMPS0
CNT_1TT0JF209280,TAG_2M2AXCZQH3EG Heartbreaker CNT_1TT0JF209280 Drama TAG_2M2AXCZQH3EG
CNT_1TT0JF209280,TAG_2MBNBKTGHS0G Heartbreaker CNT_1TT0JF209280 Romance TAG_2MBNBKTGHS0G
CNT_1TT0JF209280,TAG_30WKV21XQNQG Heartbreaker CNT_1TT0JF209280 Family Drama TAG_30WKV21XQNQG
CNT_1TT0JF209280,TAG_368YG851J1ZG Heartbreaker CNT_1TT0JF209280 Harlequin TAG_368YG851J1ZG
CNT_1TT0JF209280,TAG_3CMV0ZPHRATG Heartbreaker CNT_1TT0JF209280 Cold Male Lead TAG_3CMV0ZPHRATG
CNT_1TT0JF209280,TAG_3KY6Q5W995AG Heartbreaker CNT_1TT0JF209280 Slice of Life TAG_3KY6Q5W995AG
CNT_1TT0JF209280,TAG_3P1ZWB3947FG Heartbreaker CNT_1TT0JF209280 Tragic Past TAG_3P1ZWB3947FG
CNT_1TT0JF209280,TAG_3Y9Y5N0XD7JG Heartbreaker CNT_1TT0JF209280 Personality Change TAG_3Y9Y5N0XD7JG
CNT_1TT0JF209280,TAG_3YDEEAPDX4QG Heartbreaker CNT_1TT0JF209280 Past Plays a Big Role TAG_3YDEEAPDX4QG
CNT_1TT0JF209280,TAG_3ZVS04TZDMYG Heartbreaker CNT_1TT0JF209280 Playboys TAG_3ZVS04TZDMYG

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 6.155ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS