database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_12D1PE8P3GMG"

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_0HABNTRG2Y70	CNT_0QM49MBD68R0	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 6	[]	In the Clear Moonlit Dusk 6	Though the trial period is over, Yoi and Ichimura-sempai realize that navigating their new relationship will be no easy task. Their friend trip to Kobe reveals they still have a lot of work to do when it comes to being able to voice their own desires while being understanding of their partner's. Meanwhile, Yoi's fellow part-timer Ohji has something on his mind that he may not be able to hold in much longer...	01KGAT8EAM6837C5YPTBNKH38F	6.0	2023-11-28T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 6	Mika Yamamori/Kodansha Ltd.	2023-12-19T08:00:00.000Z
PRD_0PCF74EQYSX0	CNT_1XP96BN87Y60	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 3	[]	In the Clear Moonlit Dusk 3	Yoi Takiguchi is a girl who's called a "prince" because of her beautiful appearance and the stylish way she carries herself. She meets Ichimura-sempai, who is also called a prince at her school and somehow they start a trial relationship. At first, Yoi was prepared to find out what her sempai was really like, but as she gradually noticed a change in her own feelings, she has become more confused day by day. On the other hand, Ichimura-sempai is realizing that Yoi is starting to hold a much larger place in his heart than before. And with all this going on, Yoi meets a new prince at her job...?!	01KGADC6EPAX6T16ZCYG8Y5SX4	3.0	2022-02-01T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 3	In the Clear Moonlit Dusk Mika Yamamori/Kodansha Ltd.	2022-02-08T08:00:00.000Z
PRD_0WXB01NDXCHG	CNT_0B52M21QD5NG	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 9	[]	In the Clear Moonlit Dusk 9	After Kohaku's very public stunt brings the couple closer together than ever, Yoi finds herself becoming a part of Kohaku's world. Chance meetings with his uncle and his parents offer a glimpse into the true “Kohaku Ichimura,” and Yoi is increasingly convinced she can no longer shy away from him-or her feelings for him. With Nobara in similarly dire straits, the romantic holiday season fast approaches…	01KNH2VY2EX6CKFWV6980KKN27	9.0	2026-03-24T00:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 9	Mika Yamamori/KODANSHA LTD.	2026-04-14T00:00:00.000Z
PRD_114MJE6BQ99G	CNT_1W0D826K5XP0	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 2	[]	In the Clear Moonlit Dusk 2	Yoi Takiguchi is a girl who's called a "prince" because of her beautiful appearance and the stylish way she carries herself. She had mixed feelings about longing to be like a shojo manga hero. That's when she meets Ichimura-sempai, who is also called a "prince." She didn't have a good impression of him at first, but her feelings began to change after he helped her out with something and got more involved with him, and then decided to go out with him as a trial?	01KG9GXEE5HMF7BA1PHFQV30K2	2.0	2021-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 2	In the Clear Moonlit Dusk Mika Yamamori/Kodansha Ltd.	2021-09-21T07:00:00.000Z
PRD_1BJE5KE77HE0	CNT_3J9QH5E79GJ0	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 8	[]	In the Clear Moonlit Dusk 8	The school festival is in full swing, which leaves Yoi and Kohaku with barely any time to get on the same page about their earnest feelings and desires. Little do they realize that an epic revelation on stage, in front of the entire school, might just be the catalyst they need to get back in sync. Meanwhile, Nobara wrestles with her budding interest in a certain upperclassman...	01KGBR6PMREZXTCKJ3NT452N45	8.0	2025-06-13T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 8	Mika Yamamori/KODANSHA LTD.	2025-07-01T07:00:00.000Z
PRD_1F2MPNWDEM0G	CNT_0912X9M6PEX0	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 1	[]	In the Clear Moonlit Dusk 1	Yoi Takiguchi has long legs, a deep voice, and a handsome face...in other words, Yoi is such a good-looking guy that most people don't notice or care that she is, in fact, a girl. Indeed, she's had the nickname "Prince" as long as she can remember. That is, until she met Ichimura-senpai...the only person who's really seemed to see her for herself. To her surprise, she's not sure how to handle this new relationship, especially when her newfound friend is a prince himself (and a guy prince, at that). The story of the two high school princes starts here!	01KG9FV9M4Y0B0E2TKBH5NQFA1	1.0	2021-06-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 1	In the Clear Moonlit Dusk Mika Yamamori/Kodansha Ltd.	2021-07-13T07:00:00.000Z
PRD_2B02K7XT76AG	CNT_26SGZZE40P00	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 5	[]	In the Clear Moonlit Dusk 5	After a tumultuous trial period, Yoi and Ichimura-sempai finally pour their hearts out at the summer festival, and the two officially start going out. It's uncharted waters now for both teenagers, and while Yoi insists on keeping things at a measured pace, Ichimura-sempai is about ready to dive in headfirst. With school out for the summer, it'll be Yoi's first time being in a relationship during a long break, and her boyfriend suggests...a trip to Kobe?!	01KGB7XHD60VJ0TAH68NHYD1JW	5.0	2023-07-04T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 5	Mika Yamamori/Kodansha Ltd.	2023-07-25T07:00:00.000Z
PRD_3BWXA5T4F5T0	CNT_01JB95HV77ZG	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 7	[]	In the Clear Moonlit Dusk 7	Swept up by the throes of summer vacation, Ohji finally finds the courage to tell Yoi how he feels. Yoi's affection for Kohaku remains firm in spite of this, but just as things seem to heat up between the young couple, an ill-timed miscommunication has them reeling. As they stumble through many firsts in their romance, can they overcome this latest obstacle...?	01KGBA3AYEAMMMJQWPZXJT07ST	7.0	2024-06-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 7	Mika Yamamori/Kodansha Ltd.	2024-07-09T07:00:00.000Z
PRD_3PNWV0V8B3FG	CNT_0RRQY6GX9K30	In the Clear Moonlit Dusk CNT_12D1PE8P3GMG	CNT_12D1PE8P3GMG	2	1	1	Volume 4	[]	In the Clear Moonlit Dusk 4	Yoi and Ichimura-sempai's experimental dating relationship continues in full swing. Although hesitant at first, Yoi is flustered as she notices her feelings for him develop over time. Meanwhile, it seems Yoi holds a special place in Ichimura-sempai's heart as well, as he gets jealous over a new "prince" working at her part-time job. The end of their trial period approaches, but the relationship hits an unexpected rough patch! With the summer festival nearly here and no word from Ichimura-sempai, Yoi must decide on her next move.	01KGB6KC77SGB0ESQXFSKVE36M	4.0	2023-05-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	In the Clear Moonlit Dusk 4	Mika Yamamori/Kodansha Ltd.	2023-06-06T07: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);