series_tags

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

16 rows where series_id = "CNT_3DC1RD6TPRRG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3DC1RD6TPRRG,TAG_0MD2Q5KZ9RP0 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Josei TAG_0MD2Q5KZ9RP0
CNT_3DC1RD6TPRRG,TAG_100A33G6C0H0 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Female Lead TAG_100A33G6C0H0
CNT_3DC1RD6TPRRG,TAG_17KHA2S9A570 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Heterosexual TAG_17KHA2S9A570
CNT_3DC1RD6TPRRG,TAG_1FDGZTGRKJP0 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Classical Music TAG_1FDGZTGRKJP0
CNT_3DC1RD6TPRRG,TAG_1FZ1W0CD32F0 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Childhood Friends TAG_1FZ1W0CD32F0
CNT_3DC1RD6TPRRG,TAG_1RDTFCRCQS30 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Music TAG_1RDTFCRCQS30
CNT_3DC1RD6TPRRG,TAG_1VNYH20V9QK0 Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Manipulative Antagonists TAG_1VNYH20V9QK0
CNT_3DC1RD6TPRRG,TAG_2M2AXCZQH3EG Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Drama TAG_2M2AXCZQH3EG
CNT_3DC1RD6TPRRG,TAG_2MBNBKTGHS0G Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Romance TAG_2MBNBKTGHS0G
CNT_3DC1RD6TPRRG,TAG_36FY21E0JA5G Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Handsome Male Lead TAG_36FY21E0JA5G
CNT_3DC1RD6TPRRG,TAG_3DJ543SYS94G Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Crossdressing TAG_3DJ543SYS94G
CNT_3DC1RD6TPRRG,TAG_3KY6Q5W995AG Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Slice of Life TAG_3KY6Q5W995AG
CNT_3DC1RD6TPRRG,TAG_3V2HQAEEER4G Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Mature Romance TAG_3V2HQAEEER4G
CNT_3DC1RD6TPRRG,TAG_3WAT06Q6B0MG Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Reunion/s TAG_3WAT06Q6B0MG
CNT_3DC1RD6TPRRG,TAG_3YDEEAPDX4QG Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Past Plays a Big Role TAG_3YDEEAPDX4QG
CNT_3DC1RD6TPRRG,TAG_3ZA83YSAT31G Such a Treacherous Piano Sonata CNT_3DC1RD6TPRRG Primarily Adult Cast TAG_3ZA83YSAT31G

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