BookWalker

home / database

series_tags

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

36 rows where series_id = "CNT_332ZYHQMPJ0G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_332ZYHQMPJ0G,TAG_0AMNE3F46BR0 Sweet Blue Flowers CNT_332ZYHQMPJ0G complete TAG_0AMNE3F46BR0
CNT_332ZYHQMPJ0G,TAG_0M7J3JAESE10 Sweet Blue Flowers CNT_332ZYHQMPJ0G Mature TAG_0M7J3JAESE10
CNT_332ZYHQMPJ0G,TAG_0NDWND9M6450 Sweet Blue Flowers CNT_332ZYHQMPJ0G Adapted to Anime TAG_0NDWND9M6450
CNT_332ZYHQMPJ0G,TAG_100A33G6C0H0 Sweet Blue Flowers CNT_332ZYHQMPJ0G Female Lead TAG_100A33G6C0H0
CNT_332ZYHQMPJ0G,TAG_11P58PSGWS60 Sweet Blue Flowers CNT_332ZYHQMPJ0G First Love TAG_11P58PSGWS60
CNT_332ZYHQMPJ0G,TAG_14SKXXWQBVB0 Sweet Blue Flowers CNT_332ZYHQMPJ0G Infidelity TAG_14SKXXWQBVB0
CNT_332ZYHQMPJ0G,TAG_15FWFQ2X8HF0 Sweet Blue Flowers CNT_332ZYHQMPJ0G LGBTQ+ TAG_15FWFQ2X8HF0
CNT_332ZYHQMPJ0G,TAG_19N5382V53K0 Sweet Blue Flowers CNT_332ZYHQMPJ0G Best Friends TAG_19N5382V53K0
CNT_332ZYHQMPJ0G,TAG_19Y5HGS45S50 Sweet Blue Flowers CNT_332ZYHQMPJ0G Bisexual TAG_19Y5HGS45S50
CNT_332ZYHQMPJ0G,TAG_1CAJKEV5GH00 Sweet Blue Flowers CNT_332ZYHQMPJ0G Cousins TAG_1CAJKEV5GH00
CNT_332ZYHQMPJ0G,TAG_1FZ1W0CD32F0 Sweet Blue Flowers CNT_332ZYHQMPJ0G Childhood Friends TAG_1FZ1W0CD32F0
CNT_332ZYHQMPJ0G,TAG_1GSBF6EFY610 Sweet Blue Flowers CNT_332ZYHQMPJ0G Student-Teacher Relationship TAG_1GSBF6EFY610
CNT_332ZYHQMPJ0G,TAG_1PY4MBG7CCC0 Sweet Blue Flowers CNT_332ZYHQMPJ0G Time Skip TAG_1PY4MBG7CCC0
CNT_332ZYHQMPJ0G,TAG_1Q0HX10YX5F0 Sweet Blue Flowers CNT_332ZYHQMPJ0G Unrequited Love TAG_1Q0HX10YX5F0
CNT_332ZYHQMPJ0G,TAG_1X0XMNRA3Q20 Sweet Blue Flowers CNT_332ZYHQMPJ0G School TAG_1X0XMNRA3Q20
CNT_332ZYHQMPJ0G,TAG_1XDCBGAVGBS0 Sweet Blue Flowers CNT_332ZYHQMPJ0G School Clubs TAG_1XDCBGAVGBS0
CNT_332ZYHQMPJ0G,TAG_2M2AXCZQH3EG Sweet Blue Flowers CNT_332ZYHQMPJ0G Drama TAG_2M2AXCZQH3EG
CNT_332ZYHQMPJ0G,TAG_2MBNBKTGHS0G Sweet Blue Flowers CNT_332ZYHQMPJ0G Romance TAG_2MBNBKTGHS0G
CNT_332ZYHQMPJ0G,TAG_2N34VMM3E0XG Sweet Blue Flowers CNT_332ZYHQMPJ0G Acting TAG_2N34VMM3E0XG
CNT_332ZYHQMPJ0G,TAG_2NMNSTHHHGTG Sweet Blue Flowers CNT_332ZYHQMPJ0G Yuri TAG_2NMNSTHHHGTG
CNT_332ZYHQMPJ0G,TAG_30WKV21XQNQG Sweet Blue Flowers CNT_332ZYHQMPJ0G Family Drama TAG_30WKV21XQNQG
CNT_332ZYHQMPJ0G,TAG_318CJ0CM548G Sweet Blue Flowers CNT_332ZYHQMPJ0G Girls Love TAG_318CJ0CM548G
CNT_332ZYHQMPJ0G,TAG_31SXGP8TMM1G Sweet Blue Flowers CNT_332ZYHQMPJ0G Friends to Lovers TAG_31SXGP8TMM1G
CNT_332ZYHQMPJ0G,TAG_3ACPP39SZ2AG Sweet Blue Flowers CNT_332ZYHQMPJ0G All-Girls School TAG_3ACPP39SZ2AG
CNT_332ZYHQMPJ0G,TAG_3CTBM2Y283BG Sweet Blue Flowers CNT_332ZYHQMPJ0G Coming of Age TAG_3CTBM2Y283BG
CNT_332ZYHQMPJ0G,TAG_3EBEM0XVAQDG Sweet Blue Flowers CNT_332ZYHQMPJ0G Character Growth TAG_3EBEM0XVAQDG
CNT_332ZYHQMPJ0G,TAG_3GV3C84QP5MG Sweet Blue Flowers CNT_332ZYHQMPJ0G Student-Student Relationship TAG_3GV3C84QP5MG
CNT_332ZYHQMPJ0G,TAG_3JFQNBSZRN3G Sweet Blue Flowers CNT_332ZYHQMPJ0G Shoujo Ai TAG_3JFQNBSZRN3G
CNT_332ZYHQMPJ0G,TAG_3KY6Q5W995AG Sweet Blue Flowers CNT_332ZYHQMPJ0G Slice of Life TAG_3KY6Q5W995AG
CNT_332ZYHQMPJ0G,TAG_3PWF8SVRMEYG Sweet Blue Flowers CNT_332ZYHQMPJ0G Time Skip In Final Chapter/Epilogue TAG_3PWF8SVRMEYG
CNT_332ZYHQMPJ0G,TAG_3TG7EMZGHF5G Sweet Blue Flowers CNT_332ZYHQMPJ0G Love Triangle TAG_3TG7EMZGHF5G
CNT_332ZYHQMPJ0G,TAG_3WAT06Q6B0MG Sweet Blue Flowers CNT_332ZYHQMPJ0G Reunion/s TAG_3WAT06Q6B0MG
CNT_332ZYHQMPJ0G,TAG_3WK8G5MBTTVG Sweet Blue Flowers CNT_332ZYHQMPJ0G Primarily Teen Cast TAG_3WK8G5MBTTVG
CNT_332ZYHQMPJ0G,TAG_3WPRTSBTA7WG Sweet Blue Flowers CNT_332ZYHQMPJ0G Primarily Female Cast TAG_3WPRTSBTA7WG
CNT_332ZYHQMPJ0G,TAG_3X845AY38F6G Sweet Blue Flowers CNT_332ZYHQMPJ0G School Life TAG_3X845AY38F6G
CNT_332ZYHQMPJ0G,TAG_3XBMEEDKRCBG Sweet Blue Flowers CNT_332ZYHQMPJ0G School Girl TAG_3XBMEEDKRCBG

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