database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_3A3QAAKE7ZRG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0HGCJYKTK2Z0	CNT_23H28CJMC4TG	He's Expecting CNT_3A3QAAKE7ZRG	CNT_3A3QAAKE7ZRG	2	1	1	Volume 3	[]	He's Expecting 3	With his son, Kotaro, soon facing his fourth birthday, Kentaro finds it hard to juggle new work projects with being a single father. As if that wasn't stressful enough, a coworker confides in him about an office affair...one with a potential baby on the way. Meanwhile, the two pop idols, Sakura and Seiya, are working hard to outrun the rumors and scandals. Once outspoken about his pregnancy, Kentaro was the go-to guy for parenting advice-but who can he turn to when he's spread himself too thin?	01KGBA377MEJEH2E5TJVTRKPT9	3.0	2024-05-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	He's Expecting 3	Eri Sakai/Kodansha Ltd.	2024-06-18T07:00:00.000Z
PRD_0YK1RGRAAT50	CNT_0E9VWRQF8AH0	He's Expecting CNT_3A3QAAKE7ZRG	CNT_3A3QAAKE7ZRG	2	1	1	Volume 2	[]	He's Expecting 2	Three years have passed since Kentaro gave birth to his son Kotaro, and he finds himself struggling to balance his career with raising a child on his own. Papa & Kids, the cafe that he started for pregnant men and fathers, is in peril of being shuttered as business declined in the wake of waning interest in the struggles of pregnant men. Meanwhile, a male pop idol who's gotten pregnant-and who must keep the identity of the mother secret from the prying fans and press-seeks out his help, and Kentaro's complicated relationship with Kotaro's mother Aki hits a few new bumps.	01KG9PHM32MNRDBZ08KA9J4YAZ	2.0	2024-01-16T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	He's Expecting 2	Eri Sakai/Kodansha Ltd.	2024-02-06T08:00:00.000Z
PRD_3696PN1PHJT0	CNT_25E9MV9F7NJ0	He's Expecting CNT_3A3QAAKE7ZRG	CNT_3A3QAAKE7ZRG	2	1	1	Volume 4	[]	He's Expecting 4	Several years have passed and Kotaro is about to attend his first day of elementary school! As the public has slowly come to understand male pregnancy, the progressive political party has also become more vocal in their support for childcare initiatives. When Kentaro attends the party's induction ceremony on behalf of his company, he ends up meeting none other than Hajime Shimazu, the party's next leader. Hajime and his wife have spent nearly a decade trying to conceive, but when the couple learns they have a baby on the way, Hajime must grapple with how to bring a life into a better, more accepting future... FINAL VOLUME!	01KGBCH2VPNDHT0F6A4JC97DCJ	4.0	2024-09-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	He's Expecting 4	Eri Sakai/Kodansha Ltd.	2024-10-08T07:00:00.000Z
PRD_38PSG5C89MZG	CNT_0NVVMVHNMYGG	He's Expecting CNT_3A3QAAKE7ZRG	CNT_3A3QAAKE7ZRG	2	1	1	Volume 1	[]	He's Expecting 1	When career-minded Kentaro Hiyama finds out that he's pregnant, it will change the course of more than just his own life. In the Japan of Eri Sakai's thought experiment, ten years have passed since the male sex has spontaneously gained the ability to get pregnant, and society has struggled to adjust. Kentaro isn't sure at first who the mother might be, and quickly finds himself butting up against regressive attitudes and discriminatory policies-most of which long precede male pregnancy. In his previous life, he'd never given any of it a second thought-he may have even held the same views. But through his encounters with other pregnant people, and galvanized by his new perspective, Kentaro turns his skills in business and marketing to effecting social change.	01KGASSRRJHSV10RY88G54Y4QY	1.0	2023-10-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	He's Expecting 1	Eri Sakai/Kodansha Ltd.	2023-11-07T08:00:00.000Z

Advanced export

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

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);