BookWalker

home / database

series_tags

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

17 rows where series_id = "CNT_2CKX3ANMXN60"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_2CKX3ANMXN60,TAG_0AMNE3F46BR0 Honey Darling CNT_2CKX3ANMXN60 complete TAG_0AMNE3F46BR0
CNT_2CKX3ANMXN60,TAG_0M42TYMY92W0 Honey Darling CNT_2CKX3ANMXN60 Comedy TAG_0M42TYMY92W0
CNT_2CKX3ANMXN60,TAG_0MV2CQSX9BA0 Honey Darling CNT_2CKX3ANMXN60 safe TAG_0MV2CQSX9BA0
CNT_2CKX3ANMXN60,TAG_12FERKXXE7F0 Honey Darling CNT_2CKX3ANMXN60 Doctors TAG_12FERKXXE7F0
CNT_2CKX3ANMXN60,TAG_14BJRBPH88Q0 Honey Darling CNT_2CKX3ANMXN60 Jealousy TAG_14BJRBPH88Q0
CNT_2CKX3ANMXN60,TAG_1E7PCFJJJWJ0 Honey Darling CNT_2CKX3ANMXN60 Cats TAG_1E7PCFJJJWJ0
CNT_2CKX3ANMXN60,TAG_1KW9BJ72H7Q0 Honey Darling CNT_2CKX3ANMXN60 Slow Romance TAG_1KW9BJ72H7Q0
CNT_2CKX3ANMXN60,TAG_1Q4166PDD2G0 Honey Darling CNT_2CKX3ANMXN60 Unexpressed Feelings TAG_1Q4166PDD2G0
CNT_2CKX3ANMXN60,TAG_1YQMVVDS4W80 Honey Darling CNT_2CKX3ANMXN60 Older Male Younger Male TAG_1YQMVVDS4W80
CNT_2CKX3ANMXN60,TAG_1ZMPZFM65WT0 Honey Darling CNT_2CKX3ANMXN60 Pets TAG_1ZMPZFM65WT0
CNT_2CKX3ANMXN60,TAG_2APDBN4CY9FG Honey Darling CNT_2CKX3ANMXN60 adult TAG_2APDBN4CY9FG
CNT_2CKX3ANMXN60,TAG_2M5T60D610KG Honey Darling CNT_2CKX3ANMXN60 Boys Love TAG_2M5T60D610KG
CNT_2CKX3ANMXN60,TAG_2MBNBKTGHS0G Honey Darling CNT_2CKX3ANMXN60 Romance TAG_2MBNBKTGHS0G
CNT_2CKX3ANMXN60,TAG_3B40648MC87G Honey Darling CNT_2CKX3ANMXN60 Anthropomorphic TAG_3B40648MC87G
CNT_2CKX3ANMXN60,TAG_3EBEM0XVAQDG Honey Darling CNT_2CKX3ANMXN60 Character Growth TAG_3EBEM0XVAQDG
CNT_2CKX3ANMXN60,TAG_3KY6Q5W995AG Honey Darling CNT_2CKX3ANMXN60 Slice of Life TAG_3KY6Q5W995AG
CNT_2CKX3ANMXN60,TAG_3YNWY9MHCYTG Honey Darling CNT_2CKX3ANMXN60 Older Seme Younger Uke TAG_3YNWY9MHCYTG

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