database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_3B9MT08PW220"

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_0H2V27NQM65G	CNT_25KRNH63PP50	Rascal Does Not Dream CNT_3B9MT08PW220	CNT_3B9MT08PW220	2	1	1	Rascal Does Not Dream of Logical Witch	[]	Rascal Does Not Dream of Logical Witch	“For the past three days, there have been two Rio Futabas.” After successfully breaking the time loop that he and Koga were trapped in, Sakuta’s threshold for what qualifies as “odd” was higher than most. So seeing his friend Futaba in a net café late at night should have been downright unremarkable—if he wasn’t already on the phone with another Futaba…The ever-logical second-year has a doppelgänger, and neither one can (or will) explain what’s caused this sudden case of Adolescence Syndrome. With one of the Futabas staying at his place, Sakuta will have to work fast in order to solve this. After all, who knows what could happen if the two doppelgängers meet?"	01KH3EXS873N72YBYS3B966BZX	3.0	2023-05-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Rascal Does Not Dream of Logical Witch	2023-11-21T00:00:00.000Z
PRD_18589CKFNJ3G	CNT_3D3F4NS1QT8G	Rascal Does Not Dream CNT_3B9MT08PW220	CNT_3B9MT08PW220	2	1	1	Rascal Does Not Dream of a Dreaming Girl	[]	Rascal Does Not Dream of a Dreaming Girl	“What shape that future takes is up to you now.”Shouko Makinohara’s weak heart didn’t afford her the luxury of a future, but meeting Sakuta made her yearn for one all the same. Sakuta might be a rascal, but deep down, he’s a softie when it comes to those most important to him. And sure enough, before Sakuta can decipher what’s so familiar about this girl he’s seemingly never met, she’d already fallen in love with him. But the choices we are forced to make in the name of love are never as simple as the act of falling for someone in the first place. When their future is shattered by unthinkable tragedy, Shouko’s own case of Adolescence Syndrome may be the only thing that can put the pieces back together—even if it could cost her everything…	01KGC0YTQQBS0KCWSWHPT8TCBY	5.0	2025-10-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Rascal Does Not Dream of a Dreaming Girl	2026-01-20T08:00:00.000Z
PRD_261G1D8EH6S0	CNT_2KY12D01J570	Rascal Does Not Dream CNT_3B9MT08PW220	CNT_3B9MT08PW220	2	1	1	Rascal Does Not Dream of a Sister Home Alone	[]	Rascal Does Not Dream of a Sister Home Alone	The slightly mysterious youth drama starring Kaede begins!Kaede Azusagawa wants to go outside. That might sound easy, but her brush with Adolescence Syndrome has kept her shut away inside the apartment for a long, long time. Sure, she’s got Sakuta and Mai (not to mention the revolving door of girls they keep bringing home) to keep her company, but she can’t spend the rest of her life cooped up. Hearing everyone talk about the future—about their dreams—has awoken something in Kaede, and she won’t be left behind. Going out after two long years won’t be easy, but with a lot of help and a little bravery, Kaede might finally take the first steps on an adventure of her own.	01KGBR4S3WK1K7K7JBZ11W5CH8	4.0	2025-06-11T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Rascal Does Not Dream of a Sister Home Alone	2025-12-09T08:00:00.000Z
PRD_2CN07VKN335G	CNT_3HWSMT4QT7KG	Rascal Does Not Dream CNT_3B9MT08PW220	CNT_3B9MT08PW220	2	1	1	Rascal Does Not Dream of Petite Devil Kohai	[]	Rascal Does Not Dream of Petite Devil Kohai	“Today...is yesterday?” Sakuta may have cured Mai’s Adolescence Syndrome in the nick of time, but now he faces a no-less-harrowing task: convincing her to officially date him. After managing to win that round of verbal fencing, he gets some well-deserved rest...only to wake up “yesterday,” with all his progress reset. This inexplicable phenomenon seems to be caused by Tomoe Koga-the self-righteous yet self-conscious schoolgirl who offered up her own butt to be kicked after mistakenly assaulting Sakuta’s-and the only cure is to...pretend to be her boyfriend?!	01KG9DJF0BGA5RJ4Z111YMPF5F	2.0	2020-11-26T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Rascal Does Not Dream of Petite Devil Kohai	2020-12-15T08:00:00.000Z
PRD_2G5KXDENPEF0	CNT_26W4Y68433NG	Rascal Does Not Dream CNT_3B9MT08PW220	CNT_3B9MT08PW220	2	1	1	Rascal Does Not Dream of Bunny Girl Senpai	[]	Rascal Does Not Dream of Bunny Girl Senpai	“Forget what you saw today.”There’s something odd about Sakuta Azusagawa, an acerbic, standoffish high schooler who doesn’t even own a cell phone in this day and age. And perhaps strange things happen to strange people, which is why on the last day of the Golden Week holiday, in a tranquil library, he meets a wild bunny girl. With that unforgettable encounter, their bizarre and mysterious love story begins.	01KG9CAWJ9916MH8RAHVMX6WGG	1.0	2020-07-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Rascal Does Not Dream of Bunny Girl Senpai	2020-08-18T07: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);