BookWalker

home / database

series_tags

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

11 rows where series_id = "CNT_1HGW9QZ1NMN0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1HGW9QZ1NMN0,TAG_0MD2Q5KZ9RP0 My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Josei TAG_0MD2Q5KZ9RP0
CNT_1HGW9QZ1NMN0,TAG_17KHA2S9A570 My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Heterosexual TAG_17KHA2S9A570
CNT_1HGW9QZ1NMN0,TAG_1CPKC1FSG880 My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Cohabitation TAG_1CPKC1FSG880
CNT_1HGW9QZ1NMN0,TAG_1E9H8X4WK9Y0 My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Character Who Bullies the One They Love TAG_1E9H8X4WK9Y0
CNT_1HGW9QZ1NMN0,TAG_1FZ1W0CD32F0 My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Childhood Friends TAG_1FZ1W0CD32F0
CNT_1HGW9QZ1NMN0,TAG_1TYF1118S1P0 My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Love-Hate Relationship TAG_1TYF1118S1P0
CNT_1HGW9QZ1NMN0,TAG_2APDBN4CY9FG My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 adult TAG_2APDBN4CY9FG
CNT_1HGW9QZ1NMN0,TAG_2MBNBKTGHS0G My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Romance TAG_2MBNBKTGHS0G
CNT_1HGW9QZ1NMN0,TAG_36FY21E0JA5G My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Handsome Male Lead TAG_36FY21E0JA5G
CNT_1HGW9QZ1NMN0,TAG_3TB679CKHJBG My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 Male Lead Falls in Love First TAG_3TB679CKHJBG
CNT_1HGW9QZ1NMN0,TAG_3ZA83YSAT31G My Sneaky Childhood Friend Won't Let Me Get Away CNT_1HGW9QZ1NMN0 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);
Powered by Datasette · Queries took 8.492ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS