series_tags

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

23 rows where series_id = "CNT_1G74AMJ68JWG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1G74AMJ68JWG,TAG_0AMNE3F46BR0 Clamp School Detectives CNT_1G74AMJ68JWG complete TAG_0AMNE3F46BR0
CNT_1G74AMJ68JWG,TAG_0M42TYMY92W0 Clamp School Detectives CNT_1G74AMJ68JWG Comedy TAG_0M42TYMY92W0
CNT_1G74AMJ68JWG,TAG_0NDWND9M6450 Clamp School Detectives CNT_1G74AMJ68JWG Adapted to Anime TAG_0NDWND9M6450
CNT_1G74AMJ68JWG,TAG_12SZK0MCYEY0 Clamp School Detectives CNT_1G74AMJ68JWG Detectives TAG_12SZK0MCYEY0
CNT_1G74AMJ68JWG,TAG_19CMKAXQJ9C0 Clamp School Detectives CNT_1G74AMJ68JWG Bodyguard TAG_19CMKAXQJ9C0
CNT_1G74AMJ68JWG,TAG_1C1J57W4GVE0 Clamp School Detectives CNT_1G74AMJ68JWG Cool Male Lead TAG_1C1J57W4GVE0
CNT_1G74AMJ68JWG,TAG_1DWXZWD7HEC0 Clamp School Detectives CNT_1G74AMJ68JWG Cute Boys Doing Cute Things TAG_1DWXZWD7HEC0
CNT_1G74AMJ68JWG,TAG_1FVHKCYYK5A0 Clamp School Detectives CNT_1G74AMJ68JWG Childhood Love TAG_1FVHKCYYK5A0
CNT_1G74AMJ68JWG,TAG_1GWV9VXYE3A0 Clamp School Detectives CNT_1G74AMJ68JWG Student Council TAG_1GWV9VXYE3A0
CNT_1G74AMJ68JWG,TAG_1RAA6QAW7XY0 Clamp School Detectives CNT_1G74AMJ68JWG Mystery TAG_1RAA6QAW7XY0
CNT_1G74AMJ68JWG,TAG_1RJRPPB1PQX0 Clamp School Detectives CNT_1G74AMJ68JWG Meta TAG_1RJRPPB1PQX0
CNT_1G74AMJ68JWG,TAG_1TCY4V5T9HS0 Clamp School Detectives CNT_1G74AMJ68JWG Male Lead TAG_1TCY4V5T9HS0
CNT_1G74AMJ68JWG,TAG_1WN0XQJKJR90 Clamp School Detectives CNT_1G74AMJ68JWG Primarily Male Cast TAG_1WN0XQJKJR90
CNT_1G74AMJ68JWG,TAG_1X0XMNRA3Q20 Clamp School Detectives CNT_1G74AMJ68JWG School TAG_1X0XMNRA3Q20
CNT_1G74AMJ68JWG,TAG_1XDCBGAVGBS0 Clamp School Detectives CNT_1G74AMJ68JWG School Clubs TAG_1XDCBGAVGBS0
CNT_1G74AMJ68JWG,TAG_1Z31JSRHJCX0 Clamp School Detectives CNT_1G74AMJ68JWG Popular Male Lead TAG_1Z31JSRHJCX0
CNT_1G74AMJ68JWG,TAG_1Z8G6B0225J0 Clamp School Detectives CNT_1G74AMJ68JWG Primarily Child Cast TAG_1Z8G6B0225J0
CNT_1G74AMJ68JWG,TAG_2M852Y701XZG Clamp School Detectives CNT_1G74AMJ68JWG Shoujo TAG_2M852Y701XZG
CNT_1G74AMJ68JWG,TAG_2MBNBKTGHS0G Clamp School Detectives CNT_1G74AMJ68JWG Romance TAG_2MBNBKTGHS0G
CNT_1G74AMJ68JWG,TAG_2NH5Z5211KHG Clamp School Detectives CNT_1G74AMJ68JWG 20th Century TAG_2NH5Z5211KHG
CNT_1G74AMJ68JWG,TAG_3C3A29N38TXG Clamp School Detectives CNT_1G74AMJ68JWG Cooking TAG_3C3A29N38TXG
CNT_1G74AMJ68JWG,TAG_3KHPHSKSS2FG Clamp School Detectives CNT_1G74AMJ68JWG Slapstick TAG_3KHPHSKSS2FG
CNT_1G74AMJ68JWG,TAG_3X845AY38F6G Clamp School Detectives CNT_1G74AMJ68JWG School Life TAG_3X845AY38F6G

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