products

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

3 rows where series_id = "CNT_1PT49Q06D8RG"

✎ 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_07XKK29DH9K0 CNT_0WB2VBV2RQX0 I Hear the Sunspot: Four Seasons CNT_1PT49Q06D8RG CNT_1PT49Q06D8RG 2 1 1 Volume 3 []   I Hear the Sunspot: Four Seasons Volume 3   Though handsome and well-liked, Kohei Sugihara has led a gloomy and withdrawn existence ever since he developed severe hearing loss in junior high. But in college, a chance encounter with his ever optimistic classmate Taichi Sagawa ignites an undeniable shared spark that eventually blossoms into love. Graduation nears for Kohei, and with a job offer in hand from his top choice, he embarks on a summer internship to ease the transition. However, the experience quickly turns into a trial by fire, leaving Kohei struggling to find his way among the sometimes divisive opinions of his new coworkers. "I'm always gonna be there to lift you to your feet. Even when we get into a fight, I'm still on your side!"   01KGBQ44ND7QJJ2RWBM1QPTG8K 3.0 2025-05-22T07:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1MP5F77DVBZG I Hear the Sunspot: Four Seasons Volume 3 (c) Yuki Fumino   2025-06-03T07:00:00.000Z   0 0
PRD_1N86MG0AJQX0 CNT_00H8P49FZT4G I Hear the Sunspot: Four Seasons CNT_1PT49Q06D8RG CNT_1PT49Q06D8RG 2 1 1 Volume 2 []   I Hear the Sunspot: Four Seasons Volume 2   Kohei Sugihara, a college student with hearing loss, and Taichi Sagawa, his ever-optimistic former classmate, met in a chance encounter that ignited an undeniable spark that would eventually blossom into love. Summer has at last arrived, but Kohei's job search is sapping all his free time. Taichi, now a working professional, is struggling with his role as a mentor to the office's new hire. And life only grows more complicated when Taichi receives a sudden phone call from his estranged father.   01KGBAHC4PX773Y1N1W78D86W9 2.0 2024-05-23T07:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1MP5F77DVBZG I Hear the Sunspot: Four Seasons Volume 2     2024-07-02T07:00:00.000Z   0 0
PRD_30141JE6FEC0 CNT_374145XYX180 I Hear the Sunspot: Four Seasons CNT_1PT49Q06D8RG CNT_1PT49Q06D8RG 2 1 1 Volume 1 []   I Hear the Sunspot: Four Seasons Volume 1   Kohei Sugihara, college student with hearing loss, and Taichi Sagawa, his ever-optimistic former classmate, met in a chance encounter that ignited an undeniable spark that would eventually blossom into love. Now it's spring and as Kohei nears graduation, his search for a job begins. Meanwhile, Taichi finds himself in charge of someone new at work. Life is busier than ever, but all in all, things seem to be looking up for the pair. That is, until the sudden appearance of Ena, one of Kohei's old flames.   01KGB6QWMGVCS2YWFJY2743KJB 1.0 2023-04-13T07:00:00.000Z One Peace Books LAB_0KDKBQKJQBCG GEO_1MP5F77DVBZG I Hear the Sunspot: Four Seasons Volume 1     2023-04-18T07: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);