database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_3413YS5HS7FG"

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	on_sale_at
PRD_05941R2TCEA0	CNT_3GM1RAQ7CVM0	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 3	[]	Chitose Is in the Ramune Bottle, Vol. 3	A battle fit for a king! Under Saku Chitose’s strict tutelage, otaku loser Kenta Yamazaki is gradually learning to live the normie life. But when it turns out that a rival group of popular kids is coming after Kenta, it’s once again up to “King Saku” to swoop in and save the day. Of course, resolving arguments and participating in some friendly competition are all in a day’s work for His Majesty—but Kenta doesn’t find it quite so easy!	01KG9KSYRKX6G6B5XGFQ3CN23T	3.0	2023-02-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 3	2023-05-23T00:00:00.000Z
PRD_0B0S5WA4A720	CNT_3GHRJSP809T0	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 4	[]	Chitose Is in the Ramune Bottle, Vol. 4	“I’m…going to reach for the moon.” When Kenta Yamazaki sets out to face the otaku group at the source of his trauma, he doesn’t expect to be hit with a torrent of verbal abuse! No need to worry, however—the king, Saku Chitose, has got his back, and with the help of his quick wit and charm, Kenta feels he can finally shut the book on his old life. Things are far from over for Saku though, as Yuzuki approaches him with a shocking request…	01KGB6DAWHRS00ZEQA089T3SSV	4.0	2023-04-24T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 4	2023-09-19T00:00:00.000Z
PRD_0XCYEYHM4YV0	CNT_0CPMBQ8E7B3G	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 2	[]	Chitose Is in the Ramune Bottle, Vol. 2	Get ready for a crash course on the Saku Chitose style! When Kenta Yamazaki, former shut-in and all-around loser, asks Saku Chitose to teach him how to become popular at school…Saku can’t quite refuse. After all, he’s the man who works magic and takes care of things—everybody’s hero. Under his instruction, Kenta faces a head-to-toe transformation from the way he talks to his fashion choices. Will he finally start living the dream? Or is the life of a popular kid harder than he thought?	01KGAJS1Q0J29A9WJMB0C3G4NX	2.0	2022-09-28T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 2	2022-10-18T00:00:00.000Z
PRD_1B0R4MXCCNH0	CNT_33P99GNVY7MG	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 1	[]	Chitose Is in the Ramune Bottle, Vol. 1	<P> “After all, death is better than an unbeautiful life.”<BR /> Saku Chitose is living the good life. He’s got his friends, his harem of hotties, and his haters. What more could he ask for? However...his reputation as a problem-solver may be more trouble than it’s worth. So when a teacher saddles him with the task of bringing a shut-in back to school, it’s not like he can just brush it off. But no sweat! After all, there’s nothing he can’t handle...right? </P>	01KGAH3W23EC05K4Z2JYTH5NEK	1.0	2022-06-28T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 1	2022-07-12T00:00:00.000Z
PRD_24E963J1RY0G	CNT_0RN5H93DXPBG	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 8	[]	Chitose Is in the Ramune Bottle, Vol. 8	“You called…Princess?”When Yuzuki Nanase was at the end of her rope, Saku Chitose was there to pull her back up. And now she’s made the decision to confront the phantoms haunting her once and for all! Of course, she won’t be alone—Team Chitose is there to support her in any way they can, whether it’s by beating up some baddies or getting to the bottom of the stalker mystery. What awaits Yuzuki on her path forward? Find out in this satisfying final volume!	01KP0B1Z7996AVCHK1CMZPNA94	8.0	2025-10-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 8	2026-04-28T00:00:00.000Z
PRD_2R0KP5YEKZJG	CNT_07K3WSRM1Z4G	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 6	[]	Chitose Is in the Ramune Bottle, Vol. 6	In order to deal with a potential stalker, Saku and Yuzuki decide to fake date each other. Soon, rumors are blowing up about the latest good-looking couple in town, and things go way beyond expectations! Yan High’s delinquents come after them, a lovelorn Tomoya Naruse seeks Saku out for advice, and just as Saku is having a friendly conversation with Asuka Nishino, Yuzuki butts in and asks—“What is the deal between you two, anyway?!”	01KGAXWF6JSBS3HYNHZBKK5RBH	6.0	2024-01-09T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 6	2024-06-18T00:00:00.000Z
PRD_32Q98A0QYXYG	CNT_0S31VG6NPCR0	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 7	[]	Chitose Is in the Ramune Bottle, Vol. 7	“Who scares you more? Me or him?”What was meant to be a relaxing summer festival goes all wrong when the fake couple—Saku Chitose and Yuzuki Nanase—is interrupted by a boy claiming to be Yuzuki’s ex. And to make matters worse, Yuuko isn’t too happy when she finds out what Saku and Yuzuki have been doing behind her back! Haunted by her past trauma and pursued by her mysterious stalker, Yuzuki is driven into a corner. Will Saku manage to save her when she’s at her lowest?	01KG9R0M5SGDSW1M4RW5ARG5P7	7.0	2025-03-06T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Chitose Is in the Ramune Bottle, Vol. 7	2025-08-26T07:00:00.000Z
PRD_3B5KCNEH2TZG	CNT_2SQTK7DA3MWG	Chitose Is in the Ramune Bottle CNT_3413YS5HS7FG	CNT_3413YS5HS7FG	2	1	1	Volume 5	[]	Chitose Is in the Ramune Bottle, Vol. 5	“We’ve started going out.” Saku Chitose is everybody’s hero, which is why he’s signed on to pose as Yuzuki Nanase’s fake boyfriend—to protect her from a potential stalker. But soon he realizes he might have bitten off more than he can chew as their “relationship” attracts jealousy from all sides, and a pack of bad boys starts coming after them! Using force really isn’t Saku’s style, but maybe some people just need to be taught a lesson…right?	01KH3GX1V83CX9E64BS4JVV6NM	5.0	2023-08-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Chitose Is in the Ramune Bottle, Vol. 5	2024-01-23T00: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);