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_0469APHANDFG"

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_1ZFJ2SEAN8Z0	CNT_2HPP17HP0Q10	The Otaku Love Connection CNT_0469APHANDFG	CNT_0469APHANDFG	2	1	1	Volume 03	[]	The Otaku Love Connection 03	Nerdy high-schooler Wataru Otonari was living his best otaku life shipping his OTP alongside partner-in-crime Mashiro Tomaki until he found out the unthinkable! They don't actually have the same OTP at all! Wataru prefers a strong woman on top, which means he wants his beautiful classmate and friend Yuzuru to take the lead and dominate her boyfriend, the hunky Chihiro. But Mashiro loves to see a gorgeous princess protected by a faithful knight, meaning she ships Chihiro/Yuzuru. In that order, no switching! In a world where tops can't be bottoms and bottoms can't be tops, can Wataru and Mashiro bridge their shipping differences and overcome this trial? Or is it farewell to fandom fun forever?!	01KGBRPGD8HS1CS4GZHTN4KKFN	3.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Otaku Love Connection 03	2025-10-21T07:00:00.000Z
PRD_2F7Q65QBG8EG	CNT_07SD723787JG	The Otaku Love Connection CNT_0469APHANDFG	CNT_0469APHANDFG	2	1	1	Volume 01	[]	The Otaku Love Connection 01	Life has its simple joys, and for geeky fanboy Wataru Otonari, that's admiring his gorgeous classmate Yuzuru Kakoi and her equally gorgeous boyfriend, Chihiro Kawai. Luckily for Wataru, his classroom seat next to Yuzuru gives him a perfect view of his OTP. But this self-professed NPC doesn't seem to know he's just as beautiful himself! As Wataru encounters other students who stan his faves just as much as he does—although some have very, very different takes on their dynamic—every day turns into a rollercoaster of emotions for this obliviously beautiful boyfailure!	01KGBQV1Q96CEY6RZGW87T9QAY	1.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Otaku Love Connection 01	2025-07-03T07:00:00.000Z
PRD_3XDZB19H6BBG	CNT_0PBB0J737ANG	The Otaku Love Connection CNT_0469APHANDFG	CNT_0469APHANDFG	2	1	1	Volume 04	[]	The Otaku Love Connection 04	Summer is upon the otaku, and the heat is on! Comiket, cosplaying, hijinks at the beach, and sleepovers give otaku partners in crime Wataru and Mashiro endless opportunities to observe and adore their fave it couple, Yuzuru and Chihiro! Of course, they're also primed to keep an eye on how things are developing between BL-loving Supika and yuri fiend Yuri, a.k.a. a pampered heiress and her faithful butler! But could things finally be heating up on the romance front between Wataru and Mashiro too?!	01KPDBKS9QM050XZ11AV7SFNR1	4.0	2025-08-19T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Otaku Love Connection 04	2026-05-19T07:00:00.000Z
PRD_3XVQ330V65C0	CNT_1CWX9BENR4W0	The Otaku Love Connection CNT_0469APHANDFG	CNT_0469APHANDFG	2	1	1	Volume 02	[]	The Otaku Love Connection 02	Self-professed otaku Wataru Otonari means to admire his favorite classmate couple—the beautiful Yuzuru Kakoi and cool Chihiro Kawai—only from afar, and nothing more! And yet somehow he's managed to become their...friend? He's living the dream! Will their newly budding relationship reveal some lore only the power of friendship can unlock? Suddenly two other otaku arrive on the scene, with some very unique takes on Wataru's faves—that definitely clash with his! Can he not be allowed to stan in peace?	01KGBRNHDZFQGPRPS5DN5119VR	2.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Otaku Love Connection 02	2025-07-03T07: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);