products

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

3 rows where series_id = "CNT_3R6YM8C67XW0"

✎ 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_09T8STAEX4SG CNT_2DGTYNP8DPZ0 A Brief Moment of Ichika CNT_3R6YM8C67XW0 CNT_3R6YM8C67XW0 2 1 1 Volume 2 []   A Brief Moment of Ichika 2   I want to be happy, and I want it to be with him- Happy-go-lucky college student Ichika Sendawara is living on borrowed time, but when the professor she's in love with learns of her illness, her cheery facade begins to crack. Can Ichika and Professor Yurugi, terminally ill himself, maintain-or deepen-their relationship, even with the knowledge that they have no future...? -They'll risk it all for even a brief moment of love.   01KGBAQ4A43VXH8F7XHEGJWEDN 2.0 2024-06-11T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG A Brief Moment of Ichika 2 Natsu Tadano/Kodansha Ltd.   2024-07-02T07:00:00.000Z   0 0
PRD_2CZAZBN8KVVG CNT_3QHGG3QRXAG0 A Brief Moment of Ichika CNT_3R6YM8C67XW0 CNT_3R6YM8C67XW0 2 1 1 Volume 1 []   A Brief Moment of Ichika 1   He was my reason for living- It's been three years since college student Ichika Sendawara was given two years to live, and she naturally feels like time is running out. But then, on the train, she happens to see her beloved teacher Professor Yurugi, who had vanished suddenly at the end of last semester. That one glimpse stokes the fire of a passion she had more or less given up on...but they may have more in common than she ever suspected. The economy in storytelling in this first of three volumes only serves to underline the poignancy of their connection-is a brief flash of happiness worth the pain of separation? - Life is fleeting, and love all the more so.   01KGB01G6FFNFJV7J82P5RF8NA 1.0 2024-03-12T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG A Brief Moment of Ichika 1 Natsu Tadano/Kodansha Ltd.   2024-04-02T07:00:00.000Z   0 0
PRD_3AZH083RXHS0 CNT_04R6M6ZQJMK0 A Brief Moment of Ichika CNT_3R6YM8C67XW0 CNT_3R6YM8C67XW0 2 1 1 Volume 3 []   A Brief Moment of Ichika 3   At the age of 16, Ichika Sendawara learned that she only had two years left to live. Now a 2nd year college student, she lives a busy, upbeat life, despite never knowing when the end will come. Everything changes when Ichika meets Professor Yurugi-for the first time she feels she has something to live for. But then Yurugi quietly leaves the university, and Ichika is left wondering why, and what could have been... A gentle love story that grapples with the deepest existential questions we face in life. As the Shuji Terayama poem quoted in the text says, "If life is nothing but goodbyes, who needs life?"   01KGBCH1G49HKAC2ZYM4A3T2EZ 3.0 2024-09-17T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG A Brief Moment of Ichika 3 Natsu Tadano/Kodansha Ltd.   2024-10-08T07: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);