products

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

4 rows where series_id = "CNT_1404PAV4JMZ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_0NX1MMVC7Y9G CNT_18WWA9XPHAM0 Our Dreams at Dusk: Shimanami Tasogare CNT_1404PAV4JMZ0 CNT_1404PAV4JMZ0 2 1 1 Volume 2 []   Our Dreams at Dusk: Shimanami Tasogare Vol. 2   Tasuku is starting to feel at home at the drop-in center--just in time for him to help a younger student who also hangs out there. Misora Shuji likes to wear girls' clothing but is unsure about their gender identity. Will Tasuku's guidance offer Shuji some clarity or just make things harder? HELP OR HINDRANCE? 01KGA77SX3H1ZPQW7ASWP4T5EB 2.0 2019-05-31T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1MP5F77DVBZG Our Dreams at Dusk: Shimanami Tasogare Vol. 2 2015 Yuhki KAMATANI   2019-07-23T07:00:00.000Z   0 0
PRD_1VXD6PB9RV30 CNT_0FQ2E61M6Q3G Our Dreams at Dusk: Shimanami Tasogare CNT_1404PAV4JMZ0 CNT_1404PAV4JMZ0 2 1 1 Volume 1 []   Our Dreams at Dusk: Shimanami Tasogare Vol. 1   Not only is high schooler Tasuku Kaname the new kid in town, he is also terrified that he has been outed as gay. Just as he's contemplating doing the unthinkable, Tasuku meets a mysterious woman who leads him to a group of people dealing with problems not so different from his own. In this realistic, heartfelt depiction of LGBT+ characters from different backgrounds finding their place in the world, a search for inner peace proves to be the most universal experience of all. The beloved coming-out and coming-of-age manga about a broad LGBT+ community. 01KGA6032RRQSDC0192WPY1T0S 1.0 2019-05-13T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1MP5F77DVBZG Our Dreams at Dusk: Shimanami Tasogare Vol. 1 2015 Yuhki KAMATANI   2019-05-24T07:00:00.000Z   0 0
PRD_2VJCNRGSZVAG CNT_03YDX59SY7B0 Our Dreams at Dusk: Shimanami Tasogare CNT_1404PAV4JMZ0 CNT_1404PAV4JMZ0 2 1 1 Volume 3 []   Our Dreams at Dusk: Shimanami Tasogare Vol. 3   When Tasuku attends a workshop organized by Cat Clutter, the last person he is expecting to see there shows up: his crush, Tsubaki! Is this the beginning of a dream come true? AN UNEXPECTED VISITOR 01KGA7DTHXYQ0J9FRNMMG294D7 3.0 2019-07-25T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1MP5F77DVBZG Our Dreams at Dusk: Shimanami Tasogare Vol. 3 2015 Yuhki KAMATANI   2019-09-24T07:00:00.000Z   0 0
PRD_35K0P8842JYG CNT_0W0FAPEKZE70 Our Dreams at Dusk: Shimanami Tasogare CNT_1404PAV4JMZ0 CNT_1404PAV4JMZ0 2 1 1 Volume 4 []   Our Dreams at Dusk: Shimanami Tasogare Vol. 4   Tchaiko has always been an enigma, but when he goes to visit his partner in the hospital, his story is finally revealed. Meanwhile, Saki's biggest secret is thrust out in the open--despite her desperate attempts to keep it under wraps. The emotional final volume of Yuhki Kamatani's tale of gender, sexuality, and self discovery! A SECRET EXPOSED 01KGA7G8ENZEQ8YAGXA22402YW 4.0 2019-08-30T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1MP5F77DVBZG Our Dreams at Dusk: Shimanami Tasogare Vol. 4 2015 Yuhki KAMATANI   2019-12-10T08:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE products (
      id TEXT PRIMARY KEY,
      content_id TEXT NOT NULL,
      series_id TEXT NOT NULL,
      parent_content_id TEXT,
      level INTEGER NOT NULL,
      content_type INTEGER NOT NULL,
      product_type INTEGER NOT NULL,
      title TEXT NOT NULL,
      alt_titles TEXT NOT NULL,
      subtitle TEXT NOT NULL,
      display_title TEXT NOT NULL,
      display_title_short TEXT NOT NULL,
      description TEXT NOT NULL,
      description_short TEXT NOT NULL,
      image_id TEXT NOT NULL,
      display_order REAL NOT NULL,
      listed_at TEXT NOT NULL,
      label_id TEXT NOT NULL,
      geoblock_id TEXT,
      display_name TEXT NOT NULL,
      copyright TEXT,
      on_presale_at TEXT,
      on_sale_at TEXT NOT NULL,
      off_sale_at TEXT,
      add_on INTEGER NOT NULL,
      add_on_campaign_only INTEGER NOT NULL,
      FOREIGN KEY (series_id) REFERENCES series(id),
      FOREIGN KEY (label_id) REFERENCES labels(id),
      FOREIGN KEY (geoblock_id) REFERENCES geoblocks(id)
    );
CREATE INDEX idx_products_content ON products(content_id);
CREATE INDEX idx_products_series ON products(series_id);
CREATE INDEX idx_products_label ON products(label_id);
CREATE INDEX idx_products_geoblock ON products(geoblock_id);
CREATE INDEX idx_products_image ON products(image_id);