series_tags

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

31 rows where series_id = "CNT_211FG9FPVRP0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_211FG9FPVRP0,TAG_0NDWND9M6450 A Sign of Affection CNT_211FG9FPVRP0 Adapted to Anime TAG_0NDWND9M6450
CNT_211FG9FPVRP0,TAG_0NZDKK5S9M20 A Sign of Affection CNT_211FG9FPVRP0 21st Century TAG_0NZDKK5S9M20
CNT_211FG9FPVRP0,TAG_100A33G6C0H0 A Sign of Affection CNT_211FG9FPVRP0 Female Lead TAG_100A33G6C0H0
CNT_211FG9FPVRP0,TAG_11P58PSGWS60 A Sign of Affection CNT_211FG9FPVRP0 First Love TAG_11P58PSGWS60
CNT_211FG9FPVRP0,TAG_11R5K4KJWPJ0 A Sign of Affection CNT_211FG9FPVRP0 Friendship TAG_11R5K4KJWPJ0
CNT_211FG9FPVRP0,TAG_126EAB6WE1N0 A Sign of Affection CNT_211FG9FPVRP0 Disability TAG_126EAB6WE1N0
CNT_211FG9FPVRP0,TAG_17KHA2S9A570 A Sign of Affection CNT_211FG9FPVRP0 Heterosexual TAG_17KHA2S9A570
CNT_211FG9FPVRP0,TAG_1A1YWANG7EX0 A Sign of Affection CNT_211FG9FPVRP0 Alcohol TAG_1A1YWANG7EX0
CNT_211FG9FPVRP0,TAG_1APZ3M4N6VZ0 A Sign of Affection CNT_211FG9FPVRP0 Adult Cast TAG_1APZ3M4N6VZ0
CNT_211FG9FPVRP0,TAG_1CPKC1FSG880 A Sign of Affection CNT_211FG9FPVRP0 Cohabitation TAG_1CPKC1FSG880
CNT_211FG9FPVRP0,TAG_1CZKT8ATGE20 A Sign of Affection CNT_211FG9FPVRP0 College TAG_1CZKT8ATGE20
CNT_211FG9FPVRP0,TAG_1H35VN34FSE0 A Sign of Affection CNT_211FG9FPVRP0 Tall Male Lead TAG_1H35VN34FSE0
CNT_211FG9FPVRP0,TAG_1NZJX4X5TH50 A Sign of Affection CNT_211FG9FPVRP0 Young Female Lead TAG_1NZJX4X5TH50
CNT_211FG9FPVRP0,TAG_1Q0HX10YX5F0 A Sign of Affection CNT_211FG9FPVRP0 Unrequited Love TAG_1Q0HX10YX5F0
CNT_211FG9FPVRP0,TAG_1QV19ZVCDCY0 A Sign of Affection CNT_211FG9FPVRP0 Tsundere TAG_1QV19ZVCDCY0
CNT_211FG9FPVRP0,TAG_1TYF1118S1P0 A Sign of Affection CNT_211FG9FPVRP0 Love-Hate Relationship TAG_1TYF1118S1P0
CNT_211FG9FPVRP0,TAG_1YF6BWCNN250 A Sign of Affection CNT_211FG9FPVRP0 Part-Time Job TAG_1YF6BWCNN250
CNT_211FG9FPVRP0,TAG_2M2AXCZQH3EG A Sign of Affection CNT_211FG9FPVRP0 Drama TAG_2M2AXCZQH3EG
CNT_211FG9FPVRP0,TAG_2M852Y701XZG A Sign of Affection CNT_211FG9FPVRP0 Shoujo TAG_2M852Y701XZG
CNT_211FG9FPVRP0,TAG_2MBNBKTGHS0G A Sign of Affection CNT_211FG9FPVRP0 Romance TAG_2MBNBKTGHS0G
CNT_211FG9FPVRP0,TAG_30EJ7HVZM13G A Sign of Affection CNT_211FG9FPVRP0 Female Lead Falls in Love First TAG_30EJ7HVZM13G
CNT_211FG9FPVRP0,TAG_36FY21E0JA5G A Sign of Affection CNT_211FG9FPVRP0 Handsome Male Lead TAG_36FY21E0JA5G
CNT_211FG9FPVRP0,TAG_3AY7M95EEJ3G A Sign of Affection CNT_211FG9FPVRP0 Adventure TAG_3AY7M95EEJ3G
CNT_211FG9FPVRP0,TAG_3DV5JAMZS0YG A Sign of Affection CNT_211FG9FPVRP0 Cute Female Lead TAG_3DV5JAMZS0YG
CNT_211FG9FPVRP0,TAG_3FM92QR4BD7G A Sign of Affection CNT_211FG9FPVRP0 Chibi TAG_3FM92QR4BD7G
CNT_211FG9FPVRP0,TAG_3KY6Q5W995AG A Sign of Affection CNT_211FG9FPVRP0 Slice of Life TAG_3KY6Q5W995AG
CNT_211FG9FPVRP0,TAG_3QESHZBP57SG A Sign of Affection CNT_211FG9FPVRP0 Urban TAG_3QESHZBP57SG
CNT_211FG9FPVRP0,TAG_3QWYN1HM5ADG A Sign of Affection CNT_211FG9FPVRP0 Travel TAG_3QWYN1HM5ADG
CNT_211FG9FPVRP0,TAG_3TG7EMZGHF5G A Sign of Affection CNT_211FG9FPVRP0 Love Triangle TAG_3TG7EMZGHF5G
CNT_211FG9FPVRP0,TAG_3V2HQAEEER4G A Sign of Affection CNT_211FG9FPVRP0 Mature Romance TAG_3V2HQAEEER4G
CNT_211FG9FPVRP0,TAG_3ZA83YSAT31G A Sign of Affection CNT_211FG9FPVRP0 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);