series_tags

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

17 rows where series_id = "CNT_1AVTD67ES28G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1AVTD67ES28G,TAG_0AMNE3F46BR0 My Father is a Unicorn CNT_1AVTD67ES28G complete TAG_0AMNE3F46BR0
CNT_1AVTD67ES28G,TAG_0M0JHS1FS5V0 My Father is a Unicorn CNT_1AVTD67ES28G Fantasy TAG_0M0JHS1FS5V0
CNT_1AVTD67ES28G,TAG_0M42TYMY92W0 My Father is a Unicorn CNT_1AVTD67ES28G Comedy TAG_0M42TYMY92W0
CNT_1AVTD67ES28G,TAG_10TVZG8NZP00 My Father is a Unicorn CNT_1AVTD67ES28G Family Life TAG_10TVZG8NZP00
CNT_1AVTD67ES28G,TAG_1BS8CBQCQMY0 My Father is a Unicorn CNT_1AVTD67ES28G Animal Transformation TAG_1BS8CBQCQMY0
CNT_1AVTD67ES28G,TAG_1GBABM09YKD0 My Father is a Unicorn CNT_1AVTD67ES28G Supernatural TAG_1GBABM09YKD0
CNT_1AVTD67ES28G,TAG_1QD1MDDEDRA0 My Father is a Unicorn CNT_1AVTD67ES28G Urban Fantasy TAG_1QD1MDDEDRA0
CNT_1AVTD67ES28G,TAG_1SS5R19FMC10 My Father is a Unicorn CNT_1AVTD67ES28G Non-Human Protagonist TAG_1SS5R19FMC10
CNT_1AVTD67ES28G,TAG_1TCY4V5T9HS0 My Father is a Unicorn CNT_1AVTD67ES28G Male Lead TAG_1TCY4V5T9HS0
CNT_1AVTD67ES28G,TAG_340TEJX9KKFG My Father is a Unicorn CNT_1AVTD67ES28G Iyashikei TAG_340TEJX9KKFG
CNT_1AVTD67ES28G,TAG_3B7G0SY4ZN8G My Father is a Unicorn CNT_1AVTD67ES28G Animals TAG_3B7G0SY4ZN8G
CNT_1AVTD67ES28G,TAG_3C6TBD8KR66G My Father is a Unicorn CNT_1AVTD67ES28G Contemporary Fantasy TAG_3C6TBD8KR66G
CNT_1AVTD67ES28G,TAG_3E2E7R6TAHVG My Father is a Unicorn CNT_1AVTD67ES28G Centaur TAG_3E2E7R6TAHVG
CNT_1AVTD67ES28G,TAG_3KHPHSKSS2FG My Father is a Unicorn CNT_1AVTD67ES28G Slapstick TAG_3KHPHSKSS2FG
CNT_1AVTD67ES28G,TAG_3KY6Q5W995AG My Father is a Unicorn CNT_1AVTD67ES28G Slice of Life TAG_3KY6Q5W995AG
CNT_1AVTD67ES28G,TAG_3Q29TMS6N32G My Father is a Unicorn CNT_1AVTD67ES28G Unicorn TAG_3Q29TMS6N32G
CNT_1AVTD67ES28G,TAG_3R6KYQTAF2WG My Father is a Unicorn CNT_1AVTD67ES28G Monster Boys TAG_3R6KYQTAF2WG

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