BookWalker

home / database

series_tags

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

24 rows where series_id = "CNT_1A8SFDNH5KT0"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_1A8SFDNH5KT0,TAG_0AMNE3F46BR0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 complete TAG_0AMNE3F46BR0
CNT_1A8SFDNH5KT0,TAG_0NZDKK5S9M20 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 21st Century TAG_0NZDKK5S9M20
CNT_1A8SFDNH5KT0,TAG_100A33G6C0H0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Female Lead TAG_100A33G6C0H0
CNT_1A8SFDNH5KT0,TAG_11R5K4KJWPJ0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Friendship TAG_11R5K4KJWPJ0
CNT_1A8SFDNH5KT0,TAG_14X36HJ7VRC0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Inexperienced in love TAG_14X36HJ7VRC0
CNT_1A8SFDNH5KT0,TAG_15HDDYY3R140 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Kind Male Lead TAG_15HDDYY3R140
CNT_1A8SFDNH5KT0,TAG_17G11DBTTR20 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 High School TAG_17G11DBTTR20
CNT_1A8SFDNH5KT0,TAG_17KHA2S9A570 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Heterosexual TAG_17KHA2S9A570
CNT_1A8SFDNH5KT0,TAG_1KW9BJ72H7Q0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Slow Romance TAG_1KW9BJ72H7Q0
CNT_1A8SFDNH5KT0,TAG_1PY4MBG7CCC0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Time Skip TAG_1PY4MBG7CCC0
CNT_1A8SFDNH5KT0,TAG_1RDTFCRCQS30 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Music TAG_1RDTFCRCQS30
CNT_1A8SFDNH5KT0,TAG_1RRBVSGJ70J0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Modern Era TAG_1RRBVSGJ70J0
CNT_1A8SFDNH5KT0,TAG_1X0XMNRA3Q20 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 School TAG_1X0XMNRA3Q20
CNT_1A8SFDNH5KT0,TAG_1Z31JSRHJCX0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Popular Male Lead TAG_1Z31JSRHJCX0
CNT_1A8SFDNH5KT0,TAG_1ZH6PA6QNZH0 Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Photography TAG_1ZH6PA6QNZH0
CNT_1A8SFDNH5KT0,TAG_2M852Y701XZG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Shoujo TAG_2M852Y701XZG
CNT_1A8SFDNH5KT0,TAG_2MBNBKTGHS0G Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Romance TAG_2MBNBKTGHS0G
CNT_1A8SFDNH5KT0,TAG_3EGFVACRA4FG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Bullying TAG_3EGFVACRA4FG
CNT_1A8SFDNH5KT0,TAG_3GV3C84QP5MG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Student-Student Relationship TAG_3GV3C84QP5MG
CNT_1A8SFDNH5KT0,TAG_3KY6Q5W995AG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Slice of Life TAG_3KY6Q5W995AG
CNT_1A8SFDNH5KT0,TAG_3PWF8SVRMEYG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 Time Skip In Final Chapter/Epilogue TAG_3PWF8SVRMEYG
CNT_1A8SFDNH5KT0,TAG_3X845AY38F6G Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 School Life TAG_3X845AY38F6G
CNT_1A8SFDNH5KT0,TAG_3XBMEEDKRCBG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 School Girl TAG_3XBMEEDKRCBG
CNT_1A8SFDNH5KT0,TAG_3XF5Q23289CG Your Voice is Sour... Yet Sweet CNT_1A8SFDNH5KT0 School Boy TAG_3XF5Q23289CG

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