BookWalker

home / database

series_tags

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

17 rows where series_id = "CNT_1EEKMR53NPEG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1EEKMR53NPEG,TAG_0M42TYMY92W0 Pretty Boy Detective Club CNT_1EEKMR53NPEG Comedy TAG_0M42TYMY92W0
CNT_1EEKMR53NPEG,TAG_0NDWND9M6450 Pretty Boy Detective Club CNT_1EEKMR53NPEG Adapted to Anime TAG_0NDWND9M6450
CNT_1EEKMR53NPEG,TAG_12SZK0MCYEY0 Pretty Boy Detective Club CNT_1EEKMR53NPEG Detectives TAG_12SZK0MCYEY0
CNT_1EEKMR53NPEG,TAG_16APXT28AFD0 Pretty Boy Detective Club CNT_1EEKMR53NPEG Harem TAG_16APXT28AFD0
CNT_1EEKMR53NPEG,TAG_16PMPYPCD6N0 Pretty Boy Detective Club CNT_1EEKMR53NPEG Glasses-Wearing Female Lead TAG_16PMPYPCD6N0
CNT_1EEKMR53NPEG,TAG_1JPCR714G1K0 Pretty Boy Detective Club CNT_1EEKMR53NPEG Sci-Fi TAG_1JPCR714G1K0
CNT_1EEKMR53NPEG,TAG_1RAA6QAW7XY0 Pretty Boy Detective Club CNT_1EEKMR53NPEG Mystery TAG_1RAA6QAW7XY0
CNT_1EEKMR53NPEG,TAG_1X0XMNRA3Q20 Pretty Boy Detective Club CNT_1EEKMR53NPEG School TAG_1X0XMNRA3Q20
CNT_1EEKMR53NPEG,TAG_1XDCBGAVGBS0 Pretty Boy Detective Club CNT_1EEKMR53NPEG School Clubs TAG_1XDCBGAVGBS0
CNT_1EEKMR53NPEG,TAG_2M852Y701XZG Pretty Boy Detective Club CNT_1EEKMR53NPEG Shoujo TAG_2M852Y701XZG
CNT_1EEKMR53NPEG,TAG_2MBNBKTGHS0G Pretty Boy Detective Club CNT_1EEKMR53NPEG Romance TAG_2MBNBKTGHS0G
CNT_1EEKMR53NPEG,TAG_31BWV424N1DG Pretty Boy Detective Club CNT_1EEKMR53NPEG Gender Bender TAG_31BWV424N1DG
CNT_1EEKMR53NPEG,TAG_39WDMD0WDVQG Pretty Boy Detective Club CNT_1EEKMR53NPEG Bishounen TAG_39WDMD0WDVQG
CNT_1EEKMR53NPEG,TAG_3DJ543SYS94G Pretty Boy Detective Club CNT_1EEKMR53NPEG Crossdressing TAG_3DJ543SYS94G
CNT_1EEKMR53NPEG,TAG_3MX8K9E1NP0G Pretty Boy Detective Club CNT_1EEKMR53NPEG Visual Arts TAG_3MX8K9E1NP0G
CNT_1EEKMR53NPEG,TAG_3X845AY38F6G Pretty Boy Detective Club CNT_1EEKMR53NPEG School Life TAG_3X845AY38F6G
CNT_1EEKMR53NPEG,TAG_3XQA711QV3KG Pretty Boy Detective Club CNT_1EEKMR53NPEG Reverse Harem TAG_3XQA711QV3KG

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