products

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

5 rows where series_id = "CNT_1W3BWNEHXKEG"

✎ 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_015E5EY7BMV0 CNT_197S6N1GXEG0 After the Rain CNT_1W3BWNEHXKEG CNT_1W3BWNEHXKEG 2 1 1 Volume 5 []   After the Rain Vol. 5   As winter deepens, Yui works up the courage to give Yoshizawa her hand-knit scarf. The staff of Garden ring in the new year together, and January begins with new-fallen snow. Alone in his apartment, Kondo's pen glides along manuscript paper. Akira heads out, hand-made scarf and umbrella in hand. ""I'm sure it'll clear up soon."" So many seasons have passed since the day Akira and Kondo met. In this final volume, what will the two of them write in the clearing sky…?   01KH3H7RATKT4E9CSAS92H2M2N 5.0 2020-02-18T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG After the Rain Vol. 5 Jun MAYUZUKI   2020-02-18T08:00:00.000Z   0 0
PRD_05VYG1R9QKT0 CNT_38HP60QS8DH0 After the Rain CNT_1W3BWNEHXKEG CNT_1W3BWNEHXKEG 2 1 1 Volume 4 []   After the Rain Vol. 4   Basis of the popular anime series, After the Rain is a story about friendship and rediscovering your passion. Selected as one of ""The Best Manga of 2018"" by Comics Beat. Kondo starts to feel a slight something towards Akira, but his expression turns stern and pained. Akira is perplexed by this change in him. Meanwhile, Yui works up the courage to tell Yoshizawa how she feels…   01KH3H7NVRYPWD44C3FCMZBNHK 4.0 2020-02-18T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG After the Rain Vol. 4 Jun MAYUZUKI   2020-02-18T08:00:00.000Z   0 0
PRD_08893MNKKJS0 CNT_1BW31JC1QCJ0 After the Rain CNT_1W3BWNEHXKEG CNT_1W3BWNEHXKEG 2 1 1 Volume 2 []   After the Rain Vol. 2   Akira's feelings toward her boss grow more intense, and Kondo, in the face of such unwavering attention, finds that emotions he thought he'd lost long ago are welling up once again, and he meets up with an old college classmate. Meanwhile, Akira clashes with her best friend Kiyan, as she feels the distance between them has grown too much. And so the summer of Akira's 17th year passes by…   01KH3H7KE1KHF118KK5KG2GFMX 2.0 2020-02-18T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG After the Rain Vol. 2 Jun MAYUZUKI   2020-02-18T08:00:00.000Z   0 0
PRD_27JPZQ949KAG CNT_28WZPZWN3Y1G After the Rain CNT_1W3BWNEHXKEG CNT_1W3BWNEHXKEG 2 1 1 Volume 3 []   After the Rain Vol. 3   17-year-old high school student Akira Tachibana is a girl who barely expresses herself. She harbors a secret crush on Masami Kondō, a 45-year-old manager of the restaurant she works at part-time. ""Tachibana… What are you doing here?"" The blunt question, even though it was asked innocently, shakes Akira's heart. As Christmas draws closer, Akira resolves to do a certain something for Kondo, and Yui, Yoshizawa and Kase grapple with secret feelings of their own…   01KH3H7PYH75BZS4BT3YF5CC9F 3.0 2020-02-18T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG After the Rain Vol. 3 Jun MAYUZUKI   2020-02-18T08:00:00.000Z   0 0
PRD_2A319ABENJ9G CNT_087CP9JXEX2G After the Rain CNT_1W3BWNEHXKEG CNT_1W3BWNEHXKEG 2 1 1 Volume 1 []   After the Rain Vol. 1   Akira Tachibana. 17 years old, high school junior. Akira, awkward when it comes to expressing her feelings, finds herself secretly falling for the manager of the family restaurant where she works, one Masami Kondo, age 45. The curtain rises on the small love story that begins to unfold between Akira, stuck standing on the crossroads of adolescence, and Kondo, at the turning point of his own life…   01KH3GB18139513CZ569M6VYJH 1.0 2020-02-18T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG After the Rain Vol. 1 Jun MAYUZUKI   2020-02-18T08: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);