database: products: 13 rows where series_id = "CNT

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

13 rows where series_id = "CNT_24BHKX502JS0"

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_0DM450E89QMG	CNT_3FET6F85JG20	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 12	[]	The Fragrant Flower Blooms With Dignity 12	Following an eventful class trip, Rintaro just about returns to his daily routine when a surprise visit from his older brother throws a wrench in the works. Fortunately, the advice he receives as a parting gift helps him get just a little closer to Kaoruko. But as the couple's relationship deepens, a figure from Rintaro's past makes a fateful appearance-and she may not be able to keep a lid on her feelings…	01KNH73AYFG02JVHJ1RJHQHGPD	12.0	2026-03-17T00:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 12	Saka Mikami/KODANSHA LTD.	2026-04-07T00:00:00.000Z
PRD_0MYH8NBV1A9G	CNT_2HWRM1KMVTD0	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 6	[]	The Fragrant Flower Blooms With Dignity 6	Rintaro has begun to acknowledge his growing feelings for Kaoruko, but keeps them close to his chest. Until, one summer day when the two of them are alone, he's overwhelmed by affection and the words, "I like you," spill from his lips without warning. With things still left unspoken between them, Rintaro knows he owes Kaoruko an explanation and vows to tell her his real feelings... But how will Kaoruko react?	01KG9QD3T3GCB4NPNSPZ1CD014	6.0	2025-03-24T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 6	Saka Mikami/Kodansha Ltd.	2025-04-02T07:00:00.000Z
PRD_0NN3H3XJZ710	CNT_0KJBAWG1RAV0	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 2	[]	The Fragrant Flower Blooms With Dignity 2	Chidori High second-year Rintaro is a gentle soul, with a fierce face and an even fiercer reputation. Used to being judged by everyone around him, he finds himself thrown off balance when he meets the open-hearted Kaoruko, a girl who attends a rival school and should be his polar opposite in every way. But her genuine attitude slowly makes his walls crumble. Despite their growing relationship, the rivalry between the two schools becomes a deep chasm that may be hard to cross, especially after Kaoruko's best friend, Subaru Hoshina, finds out about their relationship...	01KGB9RNN03HD4405X8RM75DG6	2.0	2024-07-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 2	Saka Mikami/Kodansha Ltd.	2024-08-06T07:00:00.000Z
PRD_1AEMPMCFZ6R0	CNT_1HTPB1PT2E20	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 5	[]	The Fragrant Flower Blooms With Dignity 5	After spending so much time together, Rintaro has grown comfortable around Kaoruko, and has even begun to suspect he may like her as more than a friend. But just as the school term was drawing to a close and Rintaro began looking forward to spending his first summer vacation with all his friends, Kaoruko's friend springs a surprise on him: her birthday is only a few weeks away! So now, after agonizing over what to get her, he finally decides to bake her a cake with his own two hands. Will the effort and devotion he's putting towards his cake be able to touch Kaoruko's heart...?	01KG9RK9B7ACXBQGW44E335BQZ	5.0	2025-01-14T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 5	Saka Mikami/Kodansha Ltd.	2025-02-04T08:00:00.000Z
PRD_1JJC4WCY58NG	CNT_1M8BENPHSTCG	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 8	[]	The Fragrant Flower Blooms With Dignity 8	An eventful birthday celebration for Saku brings the whole group closer together, as presents and fond memories are shared. With the end of summer vacation looming, Rintaro sets his sights on his next cake: one celebrating all Kaoruko has accomplished in a particularly busy season. The couple meets for one last date before school is back in session, but a surprise visitor quickly throws a wrench in their plans...	01KGBSY5NYM9BRDR5KBKCMMJJD	8.0	2025-07-22T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 8	Saka Mikami/KODANSHA LTD.	2025-08-05T07:00:00.000Z
PRD_1PSBWAZ8PRJG	CNT_2CJ1D5GWGTP0	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 1	[]	The Fragrant Flower Blooms With Dignity 1	Chidori High is a boys' school that takes in the dregs of society with the lowest grades. Next door stands Kikyo Girls' High, where the wealthy, high-class families send their precious daughters. Chidori second-year Rintaro, who has a fierce face but a gentle heart, is helping at his family's patisserie when he meets a girl named Kaoruko. The two hit it off right away...but this blissful peace is quickly disturbed when Rintaro discovers that Kaoruko is actually a student at Kikyo. Worse, she doesn't seem to realize what a huge problem this really is! Will these two be able to forge a path for themselves, and sidestep the traps (metaphorical and literal) laid by their classmates?	01KH3R1X4DDC2ZDZXC6RVX8JYB	1.0	2024-05-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 1	Saka Mikami/Kodansha Ltd.	2024-06-04T07:00:00.000Z
PRD_1WMB3A7Q2D90	CNT_1ZZSQR12HPN0	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 10	[]	The Fragrant Flower Blooms With Dignity 10	Subaru convinces the girls who spotted Kaoruko and Rintaro on their date to meet the Chidori boys for themselves. While the hangout goes well enough at first, an outburst from Ayu threatens the progress made. Thankfully, the group manages to talk it all out, and now that their friends have been introduced to each other, it's time for the next hurdle in Kaoruko and Rintaro's relationship: visiting Rintaro's home together!	01KGC1V918DZZ2W058H2EJR34Z	10.0	2025-11-18T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 10	Saka Mikami/KODANSHA LTD.	2025-12-09T08:00:00.000Z
PRD_1WWVT3VJWTB0	CNT_145FJYM8GE10	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 3	[]	The Fragrant Flower Blooms With Dignity 3	Despite the hostile rivalry between their schools, after spending time together, Rintaro and Kaoruko have begun to feel comfortable around each other. However, even with their growing bond, the barriers between the two schools are so high that Rintaro finds himself at a loss with his friends. The secret of his relationship is putting up walls between them. And so, Rintaro calls Kaoruko and her friend Subaru to a meeting, hoping to find a solution...	01KGBC731XBP93J2WD634XCGQH	3.0	2024-09-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 3	Saka Mikami/Kodansha Ltd.	2024-10-01T07:00:00.000Z
PRD_205YH2ZB1CH0	CNT_21C4SWZTV3HG	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 9	[]	The Fragrant Flower Blooms With Dignity 9	Rintaro and Kaoruko reach an important relationship milestone when Rintaro formally introduces himself to her mother and brother. However, before they can make another leap forward, Kaoruko's friends from Kikyo discover them mid-date. At school, Subaru tries to ease the other girls' minds about their Chidori friends, even suggesting they meet the boys for themselves. Rintaro wants to offer his support, too, and comes up with a very visible way to show it...	01KGBWDVP2CWB1SZTW6D12DKNV	9.0	2025-09-26T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 9	Saka Mikami/KODANSHA LTD.	2025-10-07T07:00:00.000Z
PRD_21T283PG3F0G	CNT_1PJYJBGMD1AG	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 4	[]	The Fragrant Flower Blooms With Dignity 4	Despite his new closeness with Kaoruko, the divide between Chidori and Kikyo became a constant source of worry for Rintaro. In the end, the introductions between his friends and Kaoruko's friend, Subaru, went well. Not only are they starting to build a good relationship, but Rintaro finally decided to open up more to the people around him. With Rintaro revealing his past struggles, the bonds of friendship deepen. Summer is right around the corner and now that he has many new friends to spend it with, it's time to make plans!	01KGBE0JT7Z7QXKY4R1FP9988W	4.0	2024-11-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 4	Saka Mikami/Kodansha Ltd.	2024-12-03T08:00:00.000Z
PRD_22QBFNE8CSZ0	CNT_3VA50YV9S7ZG	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 11	[]	The Fragrant Flower Blooms With Dignity 11	While Kaoruko formally introduces herself as Rintaro's girlfriend to his parents, the Chidori boys, Subaru, and Madoka enjoy a day out together at the arcade-a vision of friendship beyond schools. The seasons change, and with cooler temperatures comes a highly-anticipated school event: the overnight field trip! Chidori and Kikyo may be visiting different places, but is that enough to stop Kaoruko and Rintaro from sharing new experiences with each other?	01KH2WDNS7P5R0FT4Z2VVMKG38	11.0	2026-01-16T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 11	Saka Mikami/KODANSHA LTD.	2026-02-03T08:00:00.000Z
PRD_29MSJ3YGFWSG	CNT_3XEHRH3PG050	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 7	[]	The Fragrant Flower Blooms With Dignity 7	The summer festival marks a momentous occasion for Rintaro and Kaoruko as their relationship reaches new heights, amid an outpouring of feelings and a poignant recollection of their first meeting. Now a couple, the two cautiously navigate what that means both for their own interactions, and how they interact with those around them-friends and schools included. Luckily, there's still time to find their footing, as summer vacation continues...	01KGBPGBSBGSWD1FYF2P53N994	7.0	2025-05-15T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 7	Saka Mikami/Kodansha Ltd.	2025-06-03T07:00:00.000Z
PRD_3YC5WQ7NV6T0	CNT_3F71YMZP7F6G	The Fragrant Flower Blooms With Dignity CNT_24BHKX502JS0	CNT_24BHKX502JS0	2	1	1	Volume 13	[]	The Fragrant Flower Blooms With Dignity 13	The year draws to a close, and the question of life after high school begins to creep up on Chidori and Kikyo students alike. In an unexpected turn, Ayato seems to be the one struggling the most with his future plans. Rintaro aches to support his friend, but genuine concern and his indecision about his own path weighs him down. Meanwhile, his Christmas date with Kaoruko fast approaches…	01KTPEGJDK7R7J4CJ10E4SGSZD	13.0	2026-05-19T00:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Fragrant Flower Blooms With Dignity 13	Saka Mikami/KODANSHA LTD.	2026-06-09T07: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);