series_tags

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

12 rows where series_id = "CNT_00KY9H5528XG"

✎ View and edit SQL

This data as json, CSV (advanced)

Link series_id tag_id
CNT_00KY9H5528XG,TAG_0AMNE3F46BR0 Mellow Boy Friend CNT_00KY9H5528XG complete TAG_0AMNE3F46BR0
CNT_00KY9H5528XG,TAG_0MD2Q5KZ9RP0 Mellow Boy Friend CNT_00KY9H5528XG Josei TAG_0MD2Q5KZ9RP0
CNT_00KY9H5528XG,TAG_0N1CY2Z4P1E0 Mellow Boy Friend CNT_00KY9H5528XG Actor TAG_0N1CY2Z4P1E0
CNT_00KY9H5528XG,TAG_0NZDKK5S9M20 Mellow Boy Friend CNT_00KY9H5528XG 21st Century TAG_0NZDKK5S9M20
CNT_00KY9H5528XG,TAG_2APDBN4CY9FG Mellow Boy Friend CNT_00KY9H5528XG adult TAG_2APDBN4CY9FG
CNT_00KY9H5528XG,TAG_2MBNBKTGHS0G Mellow Boy Friend CNT_00KY9H5528XG Romance TAG_2MBNBKTGHS0G
CNT_00KY9H5528XG,TAG_2N34VMM3E0XG Mellow Boy Friend CNT_00KY9H5528XG Acting TAG_2N34VMM3E0XG
CNT_00KY9H5528XG,TAG_2NT4DDS2E9BG Mellow Boy Friend CNT_00KY9H5528XG Abused Male Lead TAG_2NT4DDS2E9BG
CNT_00KY9H5528XG,TAG_36FY21E0JA5G Mellow Boy Friend CNT_00KY9H5528XG Handsome Male Lead TAG_36FY21E0JA5G
CNT_00KY9H5528XG,TAG_3TB679CKHJBG Mellow Boy Friend CNT_00KY9H5528XG Male Lead Falls in Love First TAG_3TB679CKHJBG
CNT_00KY9H5528XG,TAG_3WAT06Q6B0MG Mellow Boy Friend CNT_00KY9H5528XG Reunion/s TAG_3WAT06Q6B0MG
CNT_00KY9H5528XG,TAG_3ZVS04TZDMYG Mellow Boy Friend CNT_00KY9H5528XG Playboys TAG_3ZVS04TZDMYG

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);