series_tags

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

16 rows where series_id = "CNT_3AQ7RHT9WTYG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3AQ7RHT9WTYG,TAG_0M9XE1W8SVD0 X-Gender CNT_3AQ7RHT9WTYG Seinen TAG_0M9XE1W8SVD0
CNT_3AQ7RHT9WTYG,TAG_126EAB6WE1N0 X-Gender CNT_3AQ7RHT9WTYG Disability TAG_126EAB6WE1N0
CNT_3AQ7RHT9WTYG,TAG_128EPTRYEX10 X-Gender CNT_3AQ7RHT9WTYG Drawing TAG_128EPTRYEX10
CNT_3AQ7RHT9WTYG,TAG_15FWFQ2X8HF0 X-Gender CNT_3AQ7RHT9WTYG LGBTQ+ TAG_15FWFQ2X8HF0
CNT_3AQ7RHT9WTYG,TAG_1BG9Y4R3QX40 X-Gender CNT_3AQ7RHT9WTYG Androgynous Character TAG_1BG9Y4R3QX40
CNT_3AQ7RHT9WTYG,TAG_1V9RRFC0PGB0 X-Gender CNT_3AQ7RHT9WTYG Memoir TAG_1V9RRFC0PGB0
CNT_3AQ7RHT9WTYG,TAG_2MBNBKTGHS0G X-Gender CNT_3AQ7RHT9WTYG Romance TAG_2MBNBKTGHS0G
CNT_3AQ7RHT9WTYG,TAG_3350B1617FTG X-Gender CNT_3AQ7RHT9WTYG Educational TAG_3350B1617FTG
CNT_3AQ7RHT9WTYG,TAG_35E4255PGKSG X-Gender CNT_3AQ7RHT9WTYG Lifestyle Change TAG_35E4255PGKSG
CNT_3AQ7RHT9WTYG,TAG_38R2D1MGCJZG X-Gender CNT_3AQ7RHT9WTYG Autobiographical TAG_38R2D1MGCJZG
CNT_3AQ7RHT9WTYG,TAG_3CTBM2Y283BG X-Gender CNT_3AQ7RHT9WTYG Coming of Age TAG_3CTBM2Y283BG
CNT_3AQ7RHT9WTYG,TAG_3G43TZ3GPVEG X-Gender CNT_3AQ7RHT9WTYG Suicide TAG_3G43TZ3GPVEG
CNT_3AQ7RHT9WTYG,TAG_3KY6Q5W995AG X-Gender CNT_3AQ7RHT9WTYG Slice of Life TAG_3KY6Q5W995AG
CNT_3AQ7RHT9WTYG,TAG_3PAYAKYA4X1G X-Gender CNT_3AQ7RHT9WTYG Transgender TAG_3PAYAKYA4X1G
CNT_3AQ7RHT9WTYG,TAG_3WWBECGMTGDG X-Gender CNT_3AQ7RHT9WTYG Psychological TAG_3WWBECGMTGDG
CNT_3AQ7RHT9WTYG,TAG_3ZA83YSAT31G X-Gender CNT_3AQ7RHT9WTYG 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);