series_tags

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

15 rows where series_id = "CNT_3AYQ4CDDT1M0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3AYQ4CDDT1M0,TAG_0AMNE3F46BR0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 complete TAG_0AMNE3F46BR0
CNT_3AYQ4CDDT1M0,TAG_100A33G6C0H0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Female Lead TAG_100A33G6C0H0
CNT_3AYQ4CDDT1M0,TAG_1720DWX4TNE0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Horror TAG_1720DWX4TNE0
CNT_3AYQ4CDDT1M0,TAG_19N5382V53K0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Best Friends TAG_19N5382V53K0
CNT_3AYQ4CDDT1M0,TAG_1GBABM09YKD0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Supernatural TAG_1GBABM09YKD0
CNT_3AYQ4CDDT1M0,TAG_1GG8JZKEY0F0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Strong Female Lead TAG_1GG8JZKEY0F0
CNT_3AYQ4CDDT1M0,TAG_1PN464N6FPT0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Thriller TAG_1PN464N6FPT0
CNT_3AYQ4CDDT1M0,TAG_1RAA6QAW7XY0 Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Mystery TAG_1RAA6QAW7XY0
CNT_3AYQ4CDDT1M0,TAG_2M2AXCZQH3EG Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Drama TAG_2M2AXCZQH3EG
CNT_3AYQ4CDDT1M0,TAG_2MSAF40PHDMG Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Action TAG_2MSAF40PHDMG
CNT_3AYQ4CDDT1M0,TAG_36FY21E0JA5G Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Handsome Male Lead TAG_36FY21E0JA5G
CNT_3AYQ4CDDT1M0,TAG_39PX0VV3X16G Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Beautiful Female Lead TAG_39PX0VV3X16G
CNT_3AYQ4CDDT1M0,TAG_3G0KHVC06Y5G Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Super Powers TAG_3G0KHVC06Y5G
CNT_3AYQ4CDDT1M0,TAG_3GYGNDT662SG Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Strong Male Lead TAG_3GYGNDT662SG
CNT_3AYQ4CDDT1M0,TAG_3YDEEAPDX4QG Tokyo Phantom Pain CNT_3AYQ4CDDT1M0 Past Plays a Big Role TAG_3YDEEAPDX4QG

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