series_tags

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

22 rows where series_id = "CNT_34Z3NM958070"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_34Z3NM958070,TAG_0AMNE3F46BR0 Spell of Desire CNT_34Z3NM958070 complete TAG_0AMNE3F46BR0
CNT_34Z3NM958070,TAG_0MD2Q5KZ9RP0 Spell of Desire CNT_34Z3NM958070 Josei TAG_0MD2Q5KZ9RP0
CNT_34Z3NM958070,TAG_0MV2CQSX9BA0 Spell of Desire CNT_34Z3NM958070 safe TAG_0MV2CQSX9BA0
CNT_34Z3NM958070,TAG_15XX4S8K8430 Spell of Desire CNT_34Z3NM958070 Knight TAG_15XX4S8K8430
CNT_34Z3NM958070,TAG_16K7DS0XXSG0 Spell of Desire CNT_34Z3NM958070 Glasses-Wearing Protagonist TAG_16K7DS0XXSG0
CNT_34Z3NM958070,TAG_17KHA2S9A570 Spell of Desire CNT_34Z3NM958070 Heterosexual TAG_17KHA2S9A570
CNT_34Z3NM958070,TAG_19CMKAXQJ9C0 Spell of Desire CNT_34Z3NM958070 Bodyguard TAG_19CMKAXQJ9C0
CNT_34Z3NM958070,TAG_1E7PCFJJJWJ0 Spell of Desire CNT_34Z3NM958070 Cats TAG_1E7PCFJJJWJ0
CNT_34Z3NM958070,TAG_1FZ1W0CD32F0 Spell of Desire CNT_34Z3NM958070 Childhood Friends TAG_1FZ1W0CD32F0
CNT_34Z3NM958070,TAG_1GBABM09YKD0 Spell of Desire CNT_34Z3NM958070 Supernatural TAG_1GBABM09YKD0
CNT_34Z3NM958070,TAG_2APDBN4CY9FG Spell of Desire CNT_34Z3NM958070 adult TAG_2APDBN4CY9FG
CNT_34Z3NM958070,TAG_2MBNBKTGHS0G Spell of Desire CNT_34Z3NM958070 Romance TAG_2MBNBKTGHS0G
CNT_34Z3NM958070,TAG_32A6JCH66WMG Spell of Desire CNT_34Z3NM958070 Dragons TAG_32A6JCH66WMG
CNT_34Z3NM958070,TAG_32DPV04PPSSG Spell of Desire CNT_34Z3NM958070 Dogs TAG_32DPV04PPSSG
CNT_34Z3NM958070,TAG_32VQGJJMPCDG Spell of Desire CNT_34Z3NM958070 Demons TAG_32VQGJJMPCDG
CNT_34Z3NM958070,TAG_36FY21E0JA5G Spell of Desire CNT_34Z3NM958070 Handsome Male Lead TAG_36FY21E0JA5G
CNT_34Z3NM958070,TAG_36MZ9CS5N77G Spell of Desire CNT_34Z3NM958070 Glasses-Wearing Male Lead TAG_36MZ9CS5N77G
CNT_34Z3NM958070,TAG_39PX0VV3X16G Spell of Desire CNT_34Z3NM958070 Beautiful Female Lead TAG_39PX0VV3X16G
CNT_34Z3NM958070,TAG_3GYGNDT662SG Spell of Desire CNT_34Z3NM958070 Strong Male Lead TAG_3GYGNDT662SG
CNT_34Z3NM958070,TAG_3MFBY703J3CG Spell of Desire CNT_34Z3NM958070 Witch TAG_3MFBY703J3CG
CNT_34Z3NM958070,TAG_3R8JS5DMFY8G Spell of Desire CNT_34Z3NM958070 Mythical Beast TAG_3R8JS5DMFY8G
CNT_34Z3NM958070,TAG_3TS7WVTHH6ZG Spell of Desire CNT_34Z3NM958070 Magic TAG_3TS7WVTHH6ZG

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