BookWalker

home / database

series_tags

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

16 rows where series_id = "CNT_16640AJY9D0G"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_16640AJY9D0G,TAG_0M42TYMY92W0 Hot Steamy Glasses CNT_16640AJY9D0G Comedy TAG_0M42TYMY92W0
CNT_16640AJY9D0G,TAG_1E0PTP9KJJ40 Hot Steamy Glasses CNT_16640AJY9D0G CEOs TAG_1E0PTP9KJJ40
CNT_16640AJY9D0G,TAG_1EJ7RW5023X0 Hot Steamy Glasses CNT_16640AJY9D0G Brothers TAG_1EJ7RW5023X0
CNT_16640AJY9D0G,TAG_1PY4MBG7CCC0 Hot Steamy Glasses CNT_16640AJY9D0G Time Skip TAG_1PY4MBG7CCC0
CNT_16640AJY9D0G,TAG_1YGQ828T4J20 Hot Steamy Glasses CNT_16640AJY9D0G Opposites Attract TAG_1YGQ828T4J20
CNT_16640AJY9D0G,TAG_2APDBN4CY9FG Hot Steamy Glasses CNT_16640AJY9D0G adult TAG_2APDBN4CY9FG
CNT_16640AJY9D0G,TAG_2M5T60D610KG Hot Steamy Glasses CNT_16640AJY9D0G Boys Love TAG_2M5T60D610KG
CNT_16640AJY9D0G,TAG_2MBNBKTGHS0G Hot Steamy Glasses CNT_16640AJY9D0G Romance TAG_2MBNBKTGHS0G
CNT_16640AJY9D0G,TAG_31SXGP8TMM1G Hot Steamy Glasses CNT_16640AJY9D0G Friends to Lovers TAG_31SXGP8TMM1G
CNT_16640AJY9D0G,TAG_36MZ9CS5N77G Hot Steamy Glasses CNT_16640AJY9D0G Glasses-Wearing Male Lead TAG_36MZ9CS5N77G
CNT_16640AJY9D0G,TAG_3KY6Q5W995AG Hot Steamy Glasses CNT_16640AJY9D0G Slice of Life TAG_3KY6Q5W995AG
CNT_16640AJY9D0G,TAG_3RXK00Z9FBAG Hot Steamy Glasses CNT_16640AJY9D0G Misunderstandings TAG_3RXK00Z9FBAG
CNT_16640AJY9D0G,TAG_3V2HQAEEER4G Hot Steamy Glasses CNT_16640AJY9D0G Mature Romance TAG_3V2HQAEEER4G
CNT_16640AJY9D0G,TAG_3WAT06Q6B0MG Hot Steamy Glasses CNT_16640AJY9D0G Reunion/s TAG_3WAT06Q6B0MG
CNT_16640AJY9D0G,TAG_3YJCNM12WHHG Hot Steamy Glasses CNT_16640AJY9D0G Older Uke Younger Seme TAG_3YJCNM12WHHG
CNT_16640AJY9D0G,TAG_3YVF3WW3WQBG Hot Steamy Glasses CNT_16640AJY9D0G Otaku TAG_3YVF3WW3WQBG

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