BookWalker

home / database

series_tags

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

42 rows where series_id = "CNT_2ZHHKFM7ZGE0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_2ZHHKFM7ZGE0,TAG_0AMNE3F46BR0 S.A CNT_2ZHHKFM7ZGE0 complete TAG_0AMNE3F46BR0
CNT_2ZHHKFM7ZGE0,TAG_0M42TYMY92W0 S.A CNT_2ZHHKFM7ZGE0 Comedy TAG_0M42TYMY92W0
CNT_2ZHHKFM7ZGE0,TAG_0NDWND9M6450 S.A CNT_2ZHHKFM7ZGE0 Adapted to Anime TAG_0NDWND9M6450
CNT_2ZHHKFM7ZGE0,TAG_100A33G6C0H0 S.A CNT_2ZHHKFM7ZGE0 Female Lead TAG_100A33G6C0H0
CNT_2ZHHKFM7ZGE0,TAG_13C8W64TF7S0 S.A CNT_2ZHHKFM7ZGE0 Ensemble Cast TAG_13C8W64TF7S0
CNT_2ZHHKFM7ZGE0,TAG_14X36HJ7VRC0 S.A CNT_2ZHHKFM7ZGE0 Inexperienced in love TAG_14X36HJ7VRC0
CNT_2ZHHKFM7ZGE0,TAG_17KHA2S9A570 S.A CNT_2ZHHKFM7ZGE0 Heterosexual TAG_17KHA2S9A570
CNT_2ZHHKFM7ZGE0,TAG_18QVE5VY4310 S.A CNT_2ZHHKFM7ZGE0 Arrogant Male Lead TAG_18QVE5VY4310
CNT_2ZHHKFM7ZGE0,TAG_1FZ1W0CD32F0 S.A CNT_2ZHHKFM7ZGE0 Childhood Friends TAG_1FZ1W0CD32F0
CNT_2ZHHKFM7ZGE0,TAG_1GG8JZKEY0F0 S.A CNT_2ZHHKFM7ZGE0 Strong Female Lead TAG_1GG8JZKEY0F0
CNT_2ZHHKFM7ZGE0,TAG_1KRS2YHJ1TJ0 S.A CNT_2ZHHKFM7ZGE0 Smart Male Lead TAG_1KRS2YHJ1TJ0
CNT_2ZHHKFM7ZGE0,TAG_1KW9BJ72H7Q0 S.A CNT_2ZHHKFM7ZGE0 Slow Romance TAG_1KW9BJ72H7Q0
CNT_2ZHHKFM7ZGE0,TAG_1MA29HMBARM0 S.A CNT_2ZHHKFM7ZGE0 Wrestling TAG_1MA29HMBARM0
CNT_2ZHHKFM7ZGE0,TAG_1Q0HX10YX5F0 S.A CNT_2ZHHKFM7ZGE0 Unrequited Love TAG_1Q0HX10YX5F0
CNT_2ZHHKFM7ZGE0,TAG_1Q7H0T5XXFN0 S.A CNT_2ZHHKFM7ZGE0 Twins TAG_1Q7H0T5XXFN0
CNT_2ZHHKFM7ZGE0,TAG_1QV19ZVCDCY0 S.A CNT_2ZHHKFM7ZGE0 Tsundere TAG_1QV19ZVCDCY0
CNT_2ZHHKFM7ZGE0,TAG_1WHGMKZ32V40 S.A CNT_2ZHHKFM7ZGE0 Prince TAG_1WHGMKZ32V40
CNT_2ZHHKFM7ZGE0,TAG_1X0XMNRA3Q20 S.A CNT_2ZHHKFM7ZGE0 School TAG_1X0XMNRA3Q20
CNT_2ZHHKFM7ZGE0,TAG_1XDCBGAVGBS0 S.A CNT_2ZHHKFM7ZGE0 School Clubs TAG_1XDCBGAVGBS0
CNT_2ZHHKFM7ZGE0,TAG_1Z31JSRHJCX0 S.A CNT_2ZHHKFM7ZGE0 Popular Male Lead TAG_1Z31JSRHJCX0
CNT_2ZHHKFM7ZGE0,TAG_2M2AXCZQH3EG S.A CNT_2ZHHKFM7ZGE0 Drama TAG_2M2AXCZQH3EG
CNT_2ZHHKFM7ZGE0,TAG_2M852Y701XZG S.A CNT_2ZHHKFM7ZGE0 Shoujo TAG_2M852Y701XZG
CNT_2ZHHKFM7ZGE0,TAG_2MBNBKTGHS0G S.A CNT_2ZHHKFM7ZGE0 Romance TAG_2MBNBKTGHS0G
CNT_2ZHHKFM7ZGE0,TAG_30WKV21XQNQG S.A CNT_2ZHHKFM7ZGE0 Family Drama TAG_30WKV21XQNQG
CNT_2ZHHKFM7ZGE0,TAG_31BWV424N1DG S.A CNT_2ZHHKFM7ZGE0 Gender Bender TAG_31BWV424N1DG
CNT_2ZHHKFM7ZGE0,TAG_33ZH7ZYGPN5G S.A CNT_2ZHHKFM7ZGE0 Dumb Female Lead TAG_33ZH7ZYGPN5G
CNT_2ZHHKFM7ZGE0,TAG_36CESDRG2D0G S.A CNT_2ZHHKFM7ZGE0 Hard-Working Protagonist TAG_36CESDRG2D0G
CNT_2ZHHKFM7ZGE0,TAG_36FY21E0JA5G S.A CNT_2ZHHKFM7ZGE0 Handsome Male Lead TAG_36FY21E0JA5G
CNT_2ZHHKFM7ZGE0,TAG_39WDMD0WDVQG S.A CNT_2ZHHKFM7ZGE0 Bishounen TAG_39WDMD0WDVQG
CNT_2ZHHKFM7ZGE0,TAG_3DJ543SYS94G S.A CNT_2ZHHKFM7ZGE0 Crossdressing TAG_3DJ543SYS94G
CNT_2ZHHKFM7ZGE0,TAG_3EKZ4E28T1GG S.A CNT_2ZHHKFM7ZGE0 Brother Complex TAG_3EKZ4E28T1GG
CNT_2ZHHKFM7ZGE0,TAG_3GV3C84QP5MG S.A CNT_2ZHHKFM7ZGE0 Student-Student Relationship TAG_3GV3C84QP5MG
CNT_2ZHHKFM7ZGE0,TAG_3GYGNDT662SG S.A CNT_2ZHHKFM7ZGE0 Strong Male Lead TAG_3GYGNDT662SG
CNT_2ZHHKFM7ZGE0,TAG_3KTHE0ETSR1G S.A CNT_2ZHHKFM7ZGE0 Smart Female Lead TAG_3KTHE0ETSR1G
CNT_2ZHHKFM7ZGE0,TAG_3TB679CKHJBG S.A CNT_2ZHHKFM7ZGE0 Male Lead Falls in Love First TAG_3TB679CKHJBG
CNT_2ZHHKFM7ZGE0,TAG_3TG7EMZGHF5G S.A CNT_2ZHHKFM7ZGE0 Love Triangle TAG_3TG7EMZGHF5G
CNT_2ZHHKFM7ZGE0,TAG_3WK8G5MBTTVG S.A CNT_2ZHHKFM7ZGE0 Primarily Teen Cast TAG_3WK8G5MBTTVG
CNT_2ZHHKFM7ZGE0,TAG_3X845AY38F6G S.A CNT_2ZHHKFM7ZGE0 School Life TAG_3X845AY38F6G
CNT_2ZHHKFM7ZGE0,TAG_3XKTYDJ7B6EG S.A CNT_2ZHHKFM7ZGE0 Rich Male Lead TAG_3XKTYDJ7B6EG
CNT_2ZHHKFM7ZGE0,TAG_3Y9Y5N0XD7JG S.A CNT_2ZHHKFM7ZGE0 Personality Change TAG_3Y9Y5N0XD7JG
CNT_2ZHHKFM7ZGE0,TAG_3Z19NP29TDFG S.A CNT_2ZHHKFM7ZGE0 Possessive Lovers TAG_3Z19NP29TDFG
CNT_2ZHHKFM7ZGE0,TAG_3Z4SYBHRAAGG S.A CNT_2ZHHKFM7ZGE0 Popular Female Lead TAG_3Z4SYBHRAAGG

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 9.156ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS