series_tags

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

25 rows where series_id = "CNT_353JQZJNAFJG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_353JQZJNAFJG,TAG_0AMNE3F46BR0 not simple CNT_353JQZJNAFJG complete TAG_0AMNE3F46BR0
CNT_353JQZJNAFJG,TAG_0M9XE1W8SVD0 not simple CNT_353JQZJNAFJG Seinen TAG_0M9XE1W8SVD0
CNT_353JQZJNAFJG,TAG_0MV2CQSX9BA0 not simple CNT_353JQZJNAFJG safe TAG_0MV2CQSX9BA0
CNT_353JQZJNAFJG,TAG_0N4W76DB6EK0 not simple CNT_353JQZJNAFJG Achronological Order TAG_0N4W76DB6EK0
CNT_353JQZJNAFJG,TAG_15CC6KFERMA0 not simple CNT_353JQZJNAFJG Loneliness TAG_15CC6KFERMA0
CNT_353JQZJNAFJG,TAG_15FWFQ2X8HF0 not simple CNT_353JQZJNAFJG LGBTQ+ TAG_15FWFQ2X8HF0
CNT_353JQZJNAFJG,TAG_175HPGKBAJK0 not simple CNT_353JQZJNAFJG Homeless TAG_175HPGKBAJK0
CNT_353JQZJNAFJG,TAG_1KPY60ZG1D60 not simple CNT_353JQZJNAFJG Siblings TAG_1KPY60ZG1D60
CNT_353JQZJNAFJG,TAG_1NPJ0W64TVK0 not simple CNT_353JQZJNAFJG Writing TAG_1NPJ0W64TVK0
CNT_353JQZJNAFJG,TAG_1P3QSYSHW6X0 not simple CNT_353JQZJNAFJG Tragedy TAG_1P3QSYSHW6X0
CNT_353JQZJNAFJG,TAG_1Q0HX10YX5F0 not simple CNT_353JQZJNAFJG Unrequited Love TAG_1Q0HX10YX5F0
CNT_353JQZJNAFJG,TAG_1RAA6QAW7XY0 not simple CNT_353JQZJNAFJG Mystery TAG_1RAA6QAW7XY0
CNT_353JQZJNAFJG,TAG_1TCY4V5T9HS0 not simple CNT_353JQZJNAFJG Male Lead TAG_1TCY4V5T9HS0
CNT_353JQZJNAFJG,TAG_1WY3BY9WJY30 not simple CNT_353JQZJNAFJG Prostitution TAG_1WY3BY9WJY30
CNT_353JQZJNAFJG,TAG_2M2AXCZQH3EG not simple CNT_353JQZJNAFJG Drama TAG_2M2AXCZQH3EG
CNT_353JQZJNAFJG,TAG_30WKV21XQNQG not simple CNT_353JQZJNAFJG Family Drama TAG_30WKV21XQNQG
CNT_353JQZJNAFJG,TAG_32JQ2BPA9PVG not simple CNT_353JQZJNAFJG Death of Loved One TAG_32JQ2BPA9PVG
CNT_353JQZJNAFJG,TAG_3555NYENGW7G not simple CNT_353JQZJNAFJG LGBT Character TAG_3555NYENGW7G
CNT_353JQZJNAFJG,TAG_373R9ETCJMXG not simple CNT_353JQZJNAFJG Homophobia TAG_373R9ETCJMXG
CNT_353JQZJNAFJG,TAG_3CTBM2Y283BG not simple CNT_353JQZJNAFJG Coming of Age TAG_3CTBM2Y283BG
CNT_353JQZJNAFJG,TAG_3J6Q732YRZ9G not simple CNT_353JQZJNAFJG Sexual Abuse TAG_3J6Q732YRZ9G
CNT_353JQZJNAFJG,TAG_3KY6Q5W995AG not simple CNT_353JQZJNAFJG Slice of Life TAG_3KY6Q5W995AG
CNT_353JQZJNAFJG,TAG_3M8ACFZCJS6G not simple CNT_353JQZJNAFJG Writers TAG_3M8ACFZCJS6G
CNT_353JQZJNAFJG,TAG_3QWYN1HM5ADG not simple CNT_353JQZJNAFJG Travel TAG_3QWYN1HM5ADG
CNT_353JQZJNAFJG,TAG_3XGAN9WGVS5G not simple CNT_353JQZJNAFJG Romantic Subplot TAG_3XGAN9WGVS5G

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