BookWalker

home / database

series_tags

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

23 rows where series_id = "CNT_1J79VPJZTSCG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1J79VPJZTSCG,TAG_0AMNE3F46BR0 MARS RED CNT_1J79VPJZTSCG complete TAG_0AMNE3F46BR0
CNT_1J79VPJZTSCG,TAG_0MV2CQSX9BA0 MARS RED CNT_1J79VPJZTSCG safe TAG_0MV2CQSX9BA0
CNT_1J79VPJZTSCG,TAG_0NDWND9M6450 MARS RED CNT_1J79VPJZTSCG Adapted to Anime TAG_0NDWND9M6450
CNT_1J79VPJZTSCG,TAG_0NPD5CER9Y80 MARS RED CNT_1J79VPJZTSCG Shounen TAG_0NPD5CER9Y80
CNT_1J79VPJZTSCG,TAG_17EG37FMB850 MARS RED CNT_1J79VPJZTSCG Human-Nonhuman Relationship TAG_17EG37FMB850
CNT_1J79VPJZTSCG,TAG_17S1ZM6VTZM0 MARS RED CNT_1J79VPJZTSCG Historical TAG_17S1ZM6VTZM0
CNT_1J79VPJZTSCG,TAG_1FZ1W0CD32F0 MARS RED CNT_1J79VPJZTSCG Childhood Friends TAG_1FZ1W0CD32F0
CNT_1J79VPJZTSCG,TAG_1GBABM09YKD0 MARS RED CNT_1J79VPJZTSCG Supernatural TAG_1GBABM09YKD0
CNT_1J79VPJZTSCG,TAG_1JPCR714G1K0 MARS RED CNT_1J79VPJZTSCG Sci-Fi TAG_1JPCR714G1K0
CNT_1J79VPJZTSCG,TAG_1K1SZ5CK1G40 MARS RED CNT_1J79VPJZTSCG Soldier TAG_1K1SZ5CK1G40
CNT_1J79VPJZTSCG,TAG_1P3QSYSHW6X0 MARS RED CNT_1J79VPJZTSCG Tragedy TAG_1P3QSYSHW6X0
CNT_1J79VPJZTSCG,TAG_1QD1MDDEDRA0 MARS RED CNT_1J79VPJZTSCG Urban Fantasy TAG_1QD1MDDEDRA0
CNT_1J79VPJZTSCG,TAG_1YX7FENBMPS0 MARS RED CNT_1J79VPJZTSCG Orphans TAG_1YX7FENBMPS0
CNT_1J79VPJZTSCG,TAG_2M2AXCZQH3EG MARS RED CNT_1J79VPJZTSCG Drama TAG_2M2AXCZQH3EG
CNT_1J79VPJZTSCG,TAG_2MBNBKTGHS0G MARS RED CNT_1J79VPJZTSCG Romance TAG_2MBNBKTGHS0G
CNT_1J79VPJZTSCG,TAG_2MSAF40PHDMG MARS RED CNT_1J79VPJZTSCG Action TAG_2MSAF40PHDMG
CNT_1J79VPJZTSCG,TAG_2NH5Z5211KHG MARS RED CNT_1J79VPJZTSCG 20th Century TAG_2NH5Z5211KHG
CNT_1J79VPJZTSCG,TAG_35K590QBG0VG MARS RED CNT_1J79VPJZTSCG Kind Female Lead TAG_35K590QBG0VG
CNT_1J79VPJZTSCG,TAG_3G43TZ3GPVEG MARS RED CNT_1J79VPJZTSCG Suicide TAG_3G43TZ3GPVEG
CNT_1J79VPJZTSCG,TAG_3GYGNDT662SG MARS RED CNT_1J79VPJZTSCG Strong Male Lead TAG_3GYGNDT662SG
CNT_1J79VPJZTSCG,TAG_3M8ACFZCJS6G MARS RED CNT_1J79VPJZTSCG Writers TAG_3M8ACFZCJS6G
CNT_1J79VPJZTSCG,TAG_3QB88VM7NTMG MARS RED CNT_1J79VPJZTSCG Vampires TAG_3QB88VM7NTMG
CNT_1J79VPJZTSCG,TAG_3RH394JSZ8FG MARS RED CNT_1J79VPJZTSCG Military TAG_3RH394JSZ8FG

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