BookWalker

home / database

series_tags

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

21 rows where series_id = "CNT_3J8GYAGE8T8G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_3J8GYAGE8T8G,TAG_0AMNE3F46BR0 I.O.N CNT_3J8GYAGE8T8G complete TAG_0AMNE3F46BR0
CNT_3J8GYAGE8T8G,TAG_0M0JHS1FS5V0 I.O.N CNT_3J8GYAGE8T8G Fantasy TAG_0M0JHS1FS5V0
CNT_3J8GYAGE8T8G,TAG_0M42TYMY92W0 I.O.N CNT_3J8GYAGE8T8G Comedy TAG_0M42TYMY92W0
CNT_3J8GYAGE8T8G,TAG_100A33G6C0H0 I.O.N CNT_3J8GYAGE8T8G Female Lead TAG_100A33G6C0H0
CNT_3J8GYAGE8T8G,TAG_12QZ8H22HHJ0 I.O.N CNT_3J8GYAGE8T8G Dead Family Member/s TAG_12QZ8H22HHJ0
CNT_3J8GYAGE8T8G,TAG_17KHA2S9A570 I.O.N CNT_3J8GYAGE8T8G Heterosexual TAG_17KHA2S9A570
CNT_3J8GYAGE8T8G,TAG_1GBABM09YKD0 I.O.N CNT_3J8GYAGE8T8G Supernatural TAG_1GBABM09YKD0
CNT_3J8GYAGE8T8G,TAG_1QD1MDDEDRA0 I.O.N CNT_3J8GYAGE8T8G Urban Fantasy TAG_1QD1MDDEDRA0
CNT_3J8GYAGE8T8G,TAG_1T3ZPMES9T70 I.O.N CNT_3J8GYAGE8T8G Mahou Shoujo TAG_1T3ZPMES9T70
CNT_3J8GYAGE8T8G,TAG_1X0XMNRA3Q20 I.O.N CNT_3J8GYAGE8T8G School TAG_1X0XMNRA3Q20
CNT_3J8GYAGE8T8G,TAG_1XDCBGAVGBS0 I.O.N CNT_3J8GYAGE8T8G School Clubs TAG_1XDCBGAVGBS0
CNT_3J8GYAGE8T8G,TAG_2M852Y701XZG I.O.N CNT_3J8GYAGE8T8G Shoujo TAG_2M852Y701XZG
CNT_3J8GYAGE8T8G,TAG_2MBNBKTGHS0G I.O.N CNT_3J8GYAGE8T8G Romance TAG_2MBNBKTGHS0G
CNT_3J8GYAGE8T8G,TAG_2NH5Z5211KHG I.O.N CNT_3J8GYAGE8T8G 20th Century TAG_2NH5Z5211KHG
CNT_3J8GYAGE8T8G,TAG_30EJ7HVZM13G I.O.N CNT_3J8GYAGE8T8G Female Lead Falls in Love First TAG_30EJ7HVZM13G
CNT_3J8GYAGE8T8G,TAG_3DJ543SYS94G I.O.N CNT_3J8GYAGE8T8G Crossdressing TAG_3DJ543SYS94G
CNT_3J8GYAGE8T8G,TAG_3G0KHVC06Y5G I.O.N CNT_3J8GYAGE8T8G Super Powers TAG_3G0KHVC06Y5G
CNT_3J8GYAGE8T8G,TAG_3TG7EMZGHF5G I.O.N CNT_3J8GYAGE8T8G Love Triangle TAG_3TG7EMZGHF5G
CNT_3J8GYAGE8T8G,TAG_3TKMQ8D71CEG I.O.N CNT_3J8GYAGE8T8G Love Rival TAG_3TKMQ8D71CEG
CNT_3J8GYAGE8T8G,TAG_3TS7WVTHH6ZG I.O.N CNT_3J8GYAGE8T8G Magic TAG_3TS7WVTHH6ZG
CNT_3J8GYAGE8T8G,TAG_3WK8G5MBTTVG I.O.N CNT_3J8GYAGE8T8G Primarily Teen Cast TAG_3WK8G5MBTTVG

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