database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_222Z5ZCER5P0"

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_0B0TAYA4THHG	CNT_064J7AM3H15G	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 1	[]	Gazing at the Star Next Door 1	Chiaki is a pretty normal teenage girl. Since they were kids, she's had a thing for her best friend Subaru-who's fast becoming the hottest young actor in Japan! With Subaru threatening to slip away, Chiaki has a decision to make: Will she finally take her shot, or give Subaru up to his adoring public?	01KG9PWE63HESBF83G0NTPV4B5	1.0	2024-01-16T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 1	Ammitsu/Kodansha Ltd.	2024-02-06T08:00:00.000Z
PRD_0EVH0SWTZ1A0	CNT_1M6MQTRRR3S0	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 4	[]	Gazing at the Star Next Door 4	Subaru kisses Chiaki, but only to give her a reason to "back off." Wounded, Chiaki agrees to a spontaneous day trip with her workmate, Takahashi-kun. Will Subaru's true feelings ever come out?	01KGBG092B850CWAZSEDKENPGB	4.0	2025-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 4	Ammitsu/Kodansha Ltd.	2025-01-28T08:00:00.000Z
PRD_0PAR985S91J0	CNT_29J76J2MQ540	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 8	[]	Gazing at the Star Next Door 8	While Chiaki and Subaru endure the challenges of a long-distance romance, Takahashi-kun confesses his feelings for Chiaki and pursues her relentlessly. During a free moment between shoots, Subaru rushes home to put Takahashi-kun back in his place. Now it's all-out war, with Chiaki caught in the middle! Meanwhile, as the film shoot continues, Maju's feelings for Subaru seem to be growing stronger!	01KPTZPHP0EPCFHAX7S2D05DG7	8.0	2026-04-21T00:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 8	Ammitsu/KODANSHA LTD.	2026-05-12T00:00:00.000Z
PRD_0TBZTE67STWG	CNT_3NBBMVTSH9T0	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 5	[]	Gazing at the Star Next Door 5	Chiaki and Subaru press the reset button on their relationship and return to being "just friends," which sure beats losing each other altogether! But after Chiaki discovers the video that's been circling the internet, even their friendship might be in jeopardy...	01KG9R1V93XE71RERVV92ZG56W	5.0	2025-03-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 5	Ammitsu/Kodansha Ltd.	2025-03-25T07:00:00.000Z
PRD_1Y95A0JRMQGG	CNT_31BWY94DT5RG	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 6	[]	Gazing at the Star Next Door 6	With Chiaki and Subaru's secret relationship in full swing, it seems like every day is sunshine and rainbows. But after accidentally spilling the beans to Takahashi, how long will their secret stay safe...?!	01KGBRDYHSHDBAMPBGHTRJ9993	6.0	2025-06-27T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 6	Ammitsu/KODANSHA LTD.	2025-07-15T07:00:00.000Z
PRD_24WHNYS7K5B0	CNT_3AGQF16VR8EG	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 3	[]	Gazing at the Star Next Door 3	Chiaki falls into a funk after seeing Subaru on the job and realizing what a different world he's entered, but she knows she can't keep running from her feelings. She decides to keep her chin up and give him her best shot, but with how Subaru acts when it's just the two of them, Chiaki's emotions just might overflow...	01KGBAQ5QF8Q8P3T33KYRVVZD7	3.0	2024-07-23T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 3	Ammitsu/Kodansha Ltd.	2024-08-13T07:00:00.000Z
PRD_26W0ZF4GC3E0	CNT_1Z0Q93FD0KEG	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 2	[]	Gazing at the Star Next Door 2	Despite her best efforts, Chiaki continues to find herself teetering on the edge of telling Subaru how she really feels. A particularly close call at their seaside photoshoot has Chiaki in knots. Meanwhile, Subaru continues his climb up the stardom ladder, and his latest role could very well tip the scale of Chiaki's delicately balanced patience...	01KGAZVPJHZ5GNGAJDKQKRCAA7	2.0	2024-04-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 2	Ammitsu/Kodansha Ltd.	2024-05-07T07:00:00.000Z
PRD_3YBSDB23BHB0	CNT_2TXA51ATC9G0	Gazing at the Star Next Door CNT_222Z5ZCER5P0	CNT_222Z5ZCER5P0	2	1	1	Volume 7	[]	Gazing at the Star Next Door 7	After some loud but persuasive words of encouragement from Chiaki, Subaru agrees to take his costar, Maju, on a "mock date"! Unfortunately, this leaves Chiaki torn between her desire to support him and her own insecurities... When Takahashi-kun catches on to Chiaki's feelings, he makes a jaw-dropping remark. Is this the start of a four-way entanglement?!	01KGC17RRGWPFKNAP36YRKZE97	7.0	2025-10-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Gazing at the Star Next Door 7	Ammitsu/KODANSHA LTD.	2025-11-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);