products

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

4 rows where series_id = "CNT_06QWMJ9K3EKG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: copyright, 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_1AB6J6908PJG CNT_3Q7Q9DCD6T6G Doughnuts Under a Crescent Moon CNT_06QWMJ9K3EKG CNT_06QWMJ9K3EKG 2 1 1 Volume 1 []   Doughnuts Under a Crescent Moon Vol. 1   Uno Hinako throws herself into makeup, fashion, and falling in love, hoping that will make her seem "normal" to the other people at her job. But no matter how hard she tries, she's a self-doubting mess inside, and her attempts at "normal" romance with men just keep failing. When she starts to think she might be alone forever, a new normal presents itself in the form of her relationship with Asahi Sato, a level-headed woman who works at her company. It starts as respect, and then it becomes far more intimate. A yuri romance for the modern career woman! 01KG9CGRVW16R8G845FRWSFB3Z 1.0 2020-12-21T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Doughnuts Under a Crescent Moon Vol. 1 2020 SHIO USUI   2021-02-16T08:00:00.000Z   0 0
PRD_1AGFRRH03M90 CNT_0KD7DQ1JAQ30 Doughnuts Under a Crescent Moon CNT_06QWMJ9K3EKG CNT_06QWMJ9K3EKG 2 1 1 Volume 4 []   Doughnuts Under a Crescent Moon Vol. 4   Asahi has never been big on romantic love--her top priority has always been family. But now that Hinako is in her life, her feelings about romance seem to be changing. Asahi still doesn't know exactly what that means, but one thing is for sure: her feelings for Hinako are growing more intense by the day. Are Asahi and Hinako destined for more than friendship? Find out in the final volume of Doughnuts Under a Crescent Moon! A CHANGE OF HEART 01KGB4KC61S5P9RYRYQJB9P0AK 4.0 2023-03-03T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Doughnuts Under a Crescent Moon Vol. 4 2022 SHIO USUI   2023-03-21T07:00:00.000Z   0 0
PRD_1Q1MQ8DRF7D0 CNT_12FVJ00XRT8G Doughnuts Under a Crescent Moon CNT_06QWMJ9K3EKG CNT_06QWMJ9K3EKG 2 1 1 Volume 3 []   Doughnuts Under a Crescent Moon Vol. 3   Hinako wants to get closer to Asahi, but there is still a lot she needs to work out. What will happen when she turns to Fuuka in her time of need? And how will Fuuka handle her own feelings for Asahi? BETWEEN FRIENDSHIP AND ROMANCE 01KGAGQNBDMHNDGAANXFA6CAYW 3.0 2022-05-30T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Doughnuts Under a Crescent Moon Vol. 3 2021 SHIO USUI   2022-06-21T07:00:00.000Z   0 0
PRD_3ZH7T61H6540 CNT_0K7ZGCRM6FTG Doughnuts Under a Crescent Moon CNT_06QWMJ9K3EKG CNT_06QWMJ9K3EKG 2 1 1 Volume 2 []   Doughnuts Under a Crescent Moon Vol. 2   The distance between Hinako and Asahi is closing! What started as a typical coworker relationship has blossomed into friendship. But now, Hinako has started to wonder if her feelings for Asahi go even deeper. Could this be love?! MORE THAN FRIENDS 01KG9E1GT2G9V9VN00M389213Z 2.0 2021-05-25T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Doughnuts Under a Crescent Moon Vol. 2 2020 SHIO USUI   2021-08-10T07: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);