database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_0GB50C3GREQ0"

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_07B018HXMCE0	CNT_1ARHBCJNRNG0	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 7	[]	Rainbows After Storms, Vol. 7	After resolving the big fight during the Nagasaki field trip, Nanoha and Chidori return home, their relationship stronger than ever. Then, Mai, the underclassman with secrets of her own, accidentally reveals her crush on Nanoha—to none other than Chidori!	01KGC0KS054CBSTRYEZVQ50MZ7	7.0	2025-11-07T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 7	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2025-12-09T08:00:00.000Z
PRD_0GY04YSP8KSG	CNT_3W0H5ZBJTB1G	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 1	[]	Rainbows After Storms, Vol. 1	For Nanoha and Chidori, best friends turned lovers, normal situations for close friends turn into electrifying moments through the lens of love. Between sharing furtive looks and promise bracelets, the pair spend their hectic school days flirting in secret and hiding their relationship from their friends.	01KG9RRKDZJSJX4JF80VEQ1Z5Q	1.0	2024-12-05T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 1	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2024-12-10T08:00:00.000Z
PRD_0TVHWT23RF4G	CNT_1MPB70X3VKA0	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 4	[]	Rainbows After Storms, Vol. 4	In the midst of their first beach trip as a couple, Nanoha and Chidori enjoy some fun in the sun. But trouble awaits them at home—the older girl who broke Chidori's heart is back in town! Perilous storms may threaten to ruin their perfect summer vacation, but after every storm, a rainbow kisses the horizon.	01KGBNJSRP54N2NDSG0BQVMWAS	4.0	2025-05-15T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 4	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2025-06-10T07:00:00.000Z
PRD_0ZAABFXCQ790	CNT_2M51ZPF6QSN0	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 9	[]	Rainbows After Storms, Vol. 9	As the snow falls, Chidori and Nanoha look forward to the next major events in their relationship: Christmas, winter break, the upcoming semester, and most importantly, Valentine's Day. Whether or not the future holds happiness for them, they want to cherish the time they have together in a winter wonderland.	01KN7SM2FG3NQPRTFTP85ZZNPN	9.0	2026-02-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 9	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2026-04-21T07:00:00.000Z
PRD_1J0Z51444Y40	CNT_3EQQSAM0XWWG	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 6	[]	Rainbows After Storms, Vol. 6	Mai, an underclassman with a crush on Nanoha, finds out about Nanoha and Chidori's secret. Her very presence sows discord between the usually inseparable couple. Can Nanoha and Chidori overcome these communication issues without letting frustration get the best of them?	01KGBV54ZASJNN5HJRZC229M3K	6.0	2025-09-11T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 6	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2025-10-14T07:00:00.000Z
PRD_211EH7072ARG	CNT_0F418DFPN8X0	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 8	[]	Rainbows After Storms, Vol. 8	Chidori has her mind set on going to college in Tokyo, while Nanoha's mind is running on empty. Hoping for some inspiration, Nanoha suggests visiting Tokyo for a campus tour. Their cherished high school days together are numbered, but can they make sure their futures align?	01KH2WETPCCAWV4XF4QYMD5241	8.0	2026-01-16T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 8	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2026-02-10T08:00:00.000Z
PRD_2FSZBYKTSV8G	CNT_1HAG40VAKDSG	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 5	[]	Rainbows After Storms, Vol. 5	After weathering their first storm, Nanoha and Chidori find their bond even stronger than before. Though they each struggle to keep their awkward sides in check, the pair moves forward together to face their next challenge: the school festival! With even fewer places to hide, will their secret finally be revealed?	01KGBQNHZMG28FQHMVMP2KC6YQ	5.0	2025-07-11T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 5	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2025-08-12T07:00:00.000Z
PRD_2WX5PAB3XADG	CNT_1RTEFK8AKT90	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 3	[]	Rainbows After Storms, Vol. 3	Sunshine and storm clouds await Nanoha and Chidori as they head into their first summer as a couple. They'll need to be ready for all sorts of thrilling activities, like an aquarium date, Chidori's birthday, and their first sleepover—with all of their friends, of course. Even while hiding their relationship, the pair spend their precious time together treasuring each other.	01KG9QBRJP9B4FC3DAFC40N43A	3.0	2025-03-10T07:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 3	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2025-04-15T07:00:00.000Z
PRD_3HRBZ3VE1WJG	CNT_0J5STJ20MK8G	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 10	[]	Rainbows After Storms, Vol. 10	Amidst Chidori and Nanoha’s anxieties about what comes after graduating, their one-year anniversary arrives. With a perfect plan for their date, nothing can get in their way! Except everything that can go wrong does. Can Chidori and Nanoha figure out how to salvage what’s left of their precious da	01KT04P4QHHWS5008ZNQ9M1F7P	10.0	2026-05-05T00:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 10	HANA NI ARASHI © 2018 Ruka KOBACHI/SHOGAKUKAN	2026-06-16T07:00:00.000Z
PRD_3THAFQ61PD6G	CNT_264BB0QZYNMG	Rainbows After Storms CNT_0GB50C3GREQ0	CNT_0GB50C3GREQ0	2	1	1	Volume 2	[]	Rainbows After Storms, Vol. 2	The couple cherishes each other while hiding their relationship from their friends. Chidori can't help but cheer on her super-cool girlfriend during gym class, and Nanoha wants to flirt while the rain pitter-patters on the umbrella they're sharing, no matter who might be listening. The seasons pass from spring to winter, but their relationship only grows warmer as time marches on.	01KG9SDZYSYYS78YP4MJK4A89K	2.0	2025-01-17T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PZ1FZ4QK0N0	Rainbows After Storms, Vol. 2	© 2024 Luka KOBACHI/SHOGAKUKAN	2025-02-18T08: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);