BookWalker

home / database

series_tags

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

18 rows where series_id = "CNT_0JSBK00B2ARG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_0JSBK00B2ARG,TAG_0M42TYMY92W0 Kageki Shojo!! CNT_0JSBK00B2ARG Comedy TAG_0M42TYMY92W0
CNT_0JSBK00B2ARG,TAG_0NDWND9M6450 Kageki Shojo!! CNT_0JSBK00B2ARG Adapted to Anime TAG_0NDWND9M6450
CNT_0JSBK00B2ARG,TAG_100A33G6C0H0 Kageki Shojo!! CNT_0JSBK00B2ARG Female Lead TAG_100A33G6C0H0
CNT_0JSBK00B2ARG,TAG_126EAB6WE1N0 Kageki Shojo!! CNT_0JSBK00B2ARG Disability TAG_126EAB6WE1N0
CNT_0JSBK00B2ARG,TAG_17B0T3R5VB00 Kageki Shojo!! CNT_0JSBK00B2ARG Idols TAG_17B0T3R5VB00
CNT_0JSBK00B2ARG,TAG_193M526PNKT0 Kageki Shojo!! CNT_0JSBK00B2ARG Boarding School TAG_193M526PNKT0
CNT_0JSBK00B2ARG,TAG_1P3QSYSHW6X0 Kageki Shojo!! CNT_0JSBK00B2ARG Tragedy TAG_1P3QSYSHW6X0
CNT_0JSBK00B2ARG,TAG_1Q7H0T5XXFN0 Kageki Shojo!! CNT_0JSBK00B2ARG Twins TAG_1Q7H0T5XXFN0
CNT_0JSBK00B2ARG,TAG_1X0XMNRA3Q20 Kageki Shojo!! CNT_0JSBK00B2ARG School TAG_1X0XMNRA3Q20
CNT_0JSBK00B2ARG,TAG_1YBP2RS55500 Kageki Shojo!! CNT_0JSBK00B2ARG Performing Arts TAG_1YBP2RS55500
CNT_0JSBK00B2ARG,TAG_2M2AXCZQH3EG Kageki Shojo!! CNT_0JSBK00B2ARG Drama TAG_2M2AXCZQH3EG
CNT_0JSBK00B2ARG,TAG_2M852Y701XZG Kageki Shojo!! CNT_0JSBK00B2ARG Shoujo TAG_2M852Y701XZG
CNT_0JSBK00B2ARG,TAG_2N34VMM3E0XG Kageki Shojo!! CNT_0JSBK00B2ARG Acting TAG_2N34VMM3E0XG
CNT_0JSBK00B2ARG,TAG_35RNYKW40S8G Kageki Shojo!! CNT_0JSBK00B2ARG Kuudere TAG_35RNYKW40S8G
CNT_0JSBK00B2ARG,TAG_3ACPP39SZ2AG Kageki Shojo!! CNT_0JSBK00B2ARG All-Girls School TAG_3ACPP39SZ2AG
CNT_0JSBK00B2ARG,TAG_3WK8G5MBTTVG Kageki Shojo!! CNT_0JSBK00B2ARG Primarily Teen Cast TAG_3WK8G5MBTTVG
CNT_0JSBK00B2ARG,TAG_3WPRTSBTA7WG Kageki Shojo!! CNT_0JSBK00B2ARG Primarily Female Cast TAG_3WPRTSBTA7WG
CNT_0JSBK00B2ARG,TAG_3X845AY38F6G Kageki Shojo!! CNT_0JSBK00B2ARG School Life TAG_3X845AY38F6G

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