series_tags

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

29 rows where series_id = "CNT_01XR8GNVWG3G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_01XR8GNVWG3G,TAG_0AMNE3F46BR0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G complete TAG_0AMNE3F46BR0
CNT_01XR8GNVWG3G,TAG_0M42TYMY92W0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Comedy TAG_0M42TYMY92W0
CNT_01XR8GNVWG3G,TAG_0M9XE1W8SVD0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Seinen TAG_0M9XE1W8SVD0
CNT_01XR8GNVWG3G,TAG_0NZDKK5S9M20 Oh, My Sweet Alien! CNT_01XR8GNVWG3G 21st Century TAG_0NZDKK5S9M20
CNT_01XR8GNVWG3G,TAG_100A33G6C0H0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Female Lead TAG_100A33G6C0H0
CNT_01XR8GNVWG3G,TAG_10TVZG8NZP00 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Family Life TAG_10TVZG8NZP00
CNT_01XR8GNVWG3G,TAG_13T9H8JRFAD0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Ecchi TAG_13T9H8JRFAD0
CNT_01XR8GNVWG3G,TAG_17EG37FMB850 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Human-Nonhuman Relationship TAG_17EG37FMB850
CNT_01XR8GNVWG3G,TAG_17KHA2S9A570 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Heterosexual TAG_17KHA2S9A570
CNT_01XR8GNVWG3G,TAG_1JPCR714G1K0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Sci-Fi TAG_1JPCR714G1K0
CNT_01XR8GNVWG3G,TAG_1QD1MDDEDRA0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Urban Fantasy TAG_1QD1MDDEDRA0
CNT_01XR8GNVWG3G,TAG_1SEMDMPR46P0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Office Worker TAG_1SEMDMPR46P0
CNT_01XR8GNVWG3G,TAG_1SS5R19FMC10 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Non-Human Protagonist TAG_1SS5R19FMC10
CNT_01XR8GNVWG3G,TAG_1TCY4V5T9HS0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Male Lead TAG_1TCY4V5T9HS0
CNT_01XR8GNVWG3G,TAG_1VYSFAZ5PD50 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Married Couple TAG_1VYSFAZ5PD50
CNT_01XR8GNVWG3G,TAG_1X7X6EX93H80 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Salarymen TAG_1X7X6EX93H80
CNT_01XR8GNVWG3G,TAG_1Y2QMG245FE0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Parenthood TAG_1Y2QMG245FE0
CNT_01XR8GNVWG3G,TAG_1ZC0F0QJJ2Q0 Oh, My Sweet Alien! CNT_01XR8GNVWG3G Pregnancy TAG_1ZC0F0QJJ2Q0
CNT_01XR8GNVWG3G,TAG_2MBNBKTGHS0G Oh, My Sweet Alien! CNT_01XR8GNVWG3G Romance TAG_2MBNBKTGHS0G
CNT_01XR8GNVWG3G,TAG_344BQPGR3GGG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Interspecies Relationship TAG_344BQPGR3GGG
CNT_01XR8GNVWG3G,TAG_3A06GRZ8FFFG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Aliens TAG_3A06GRZ8FFFG
CNT_01XR8GNVWG3G,TAG_3FGSSJANV02G Oh, My Sweet Alien! CNT_01XR8GNVWG3G Childcare TAG_3FGSSJANV02G
CNT_01XR8GNVWG3G,TAG_3KHPHSKSS2FG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Slapstick TAG_3KHPHSKSS2FG
CNT_01XR8GNVWG3G,TAG_3KY6Q5W995AG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Slice of Life TAG_3KY6Q5W995AG
CNT_01XR8GNVWG3G,TAG_3STX5K7PCBMG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Non-human TAG_3STX5K7PCBMG
CNT_01XR8GNVWG3G,TAG_3V2HQAEEER4G Oh, My Sweet Alien! CNT_01XR8GNVWG3G Mature Romance TAG_3V2HQAEEER4G
CNT_01XR8GNVWG3G,TAG_3VM6NGBWY9XG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Marriage TAG_3VM6NGBWY9XG
CNT_01XR8GNVWG3G,TAG_3VX1276XYFQG Oh, My Sweet Alien! CNT_01XR8GNVWG3G Married Life TAG_3VX1276XYFQG
CNT_01XR8GNVWG3G,TAG_3ZA83YSAT31G Oh, My Sweet Alien! CNT_01XR8GNVWG3G 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);