series_tags

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

20 rows where series_id = "CNT_2AGE2DMH0790"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_2AGE2DMH0790,TAG_0AMNE3F46BR0 A Death Wish and an Alien CNT_2AGE2DMH0790 complete TAG_0AMNE3F46BR0
CNT_2AGE2DMH0790,TAG_0MV2CQSX9BA0 A Death Wish and an Alien CNT_2AGE2DMH0790 safe TAG_0MV2CQSX9BA0
CNT_2AGE2DMH0790,TAG_12FERKXXE7F0 A Death Wish and an Alien CNT_2AGE2DMH0790 Doctors TAG_12FERKXXE7F0
CNT_2AGE2DMH0790,TAG_15FWFQ2X8HF0 A Death Wish and an Alien CNT_2AGE2DMH0790 LGBTQ+ TAG_15FWFQ2X8HF0
CNT_2AGE2DMH0790,TAG_17EG37FMB850 A Death Wish and an Alien CNT_2AGE2DMH0790 Human-Nonhuman Relationship TAG_17EG37FMB850
CNT_2AGE2DMH0790,TAG_1FZ1W0CD32F0 A Death Wish and an Alien CNT_2AGE2DMH0790 Childhood Friends TAG_1FZ1W0CD32F0
CNT_2AGE2DMH0790,TAG_1GBABM09YKD0 A Death Wish and an Alien CNT_2AGE2DMH0790 Supernatural TAG_1GBABM09YKD0
CNT_2AGE2DMH0790,TAG_1JRF4PV6GYZ0 A Death Wish and an Alien CNT_2AGE2DMH0790 Senpai-Kouhai Relationship TAG_1JRF4PV6GYZ0
CNT_2AGE2DMH0790,TAG_1YGQ828T4J20 A Death Wish and an Alien CNT_2AGE2DMH0790 Opposites Attract TAG_1YGQ828T4J20
CNT_2AGE2DMH0790,TAG_2APDBN4CY9FG A Death Wish and an Alien CNT_2AGE2DMH0790 adult TAG_2APDBN4CY9FG
CNT_2AGE2DMH0790,TAG_2M2AXCZQH3EG A Death Wish and an Alien CNT_2AGE2DMH0790 Drama TAG_2M2AXCZQH3EG
CNT_2AGE2DMH0790,TAG_2M5T60D610KG A Death Wish and an Alien CNT_2AGE2DMH0790 Boys Love TAG_2M5T60D610KG
CNT_2AGE2DMH0790,TAG_2MBNBKTGHS0G A Death Wish and an Alien CNT_2AGE2DMH0790 Romance TAG_2MBNBKTGHS0G
CNT_2AGE2DMH0790,TAG_31SXGP8TMM1G A Death Wish and an Alien CNT_2AGE2DMH0790 Friends to Lovers TAG_31SXGP8TMM1G
CNT_2AGE2DMH0790,TAG_373R9ETCJMXG A Death Wish and an Alien CNT_2AGE2DMH0790 Homophobia TAG_373R9ETCJMXG
CNT_2AGE2DMH0790,TAG_3A06GRZ8FFFG A Death Wish and an Alien CNT_2AGE2DMH0790 Aliens TAG_3A06GRZ8FFFG
CNT_2AGE2DMH0790,TAG_3EEYX4KBTMPG A Death Wish and an Alien CNT_2AGE2DMH0790 Changed by Love TAG_3EEYX4KBTMPG
CNT_2AGE2DMH0790,TAG_3G9JE2B16NZG A Death Wish and an Alien CNT_2AGE2DMH0790 Supernatural Elements TAG_3G9JE2B16NZG
CNT_2AGE2DMH0790,TAG_3V2HQAEEER4G A Death Wish and an Alien CNT_2AGE2DMH0790 Mature Romance TAG_3V2HQAEEER4G
CNT_2AGE2DMH0790,TAG_3WAT06Q6B0MG A Death Wish and an Alien CNT_2AGE2DMH0790 Reunion/s TAG_3WAT06Q6B0MG

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