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

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_0HNE7DAFHJZ0	CNT_23W276FJJ740	Chasing After Aoi Koshiba CNT_1101Z92K5RFG	CNT_1101Z92K5RFG	2	1	1	Volume 3	[]	Chasing After Aoi Koshiba 3	A young girl's journey through adolescence is packed full of drama, and budding socialite Sahoko is no exception. After a summer of emotions, she's finally acknowledged the feelings she has in her heart for the tomboy, Aoi. With the start of the fall semester just around the corner, the new school year is shaping up to be just as turbulent as the last!	01KGADAB0PV5SY3TYPAY7X586K	3.0	2022-01-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Chasing After Aoi Koshiba 3	Chasing After Aoi Koshiba FLY, Hazuki Takeoka / Ichijinsha Inc.	2022-01-25T08:00:00.000Z
PRD_1SXR59ZTD0Z0	CNT_3C1G3A12J2X0	Chasing After Aoi Koshiba CNT_1101Z92K5RFG	CNT_1101Z92K5RFG	2	1	1	Volume 4	[]	Chasing After Aoi Koshiba 4	Four years have gone by, and Sahoko still yearns for her high school love, Aoi. Flashback to the summer of their second year of high school: A bubbly yet still gawky teen, Sahoko, meets super-hot Aoi at the sports festival. The two develop a close bond but their relationship stalls. Sahoko now anxiously waits for Aoi at their high school reunion, reminiscing about their fateful kiss. Can Sahoko finally reconcile her feelings for Aoi?	01KGB605DM4YV30PKMMR34XHAD	4.0	2023-04-18T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Chasing After Aoi Koshiba 4	FLY, Hazuki Takeoka / Ichijinsha Inc.	2023-05-09T07:00:00.000Z
PRD_3SRDWZVT1CM0	CNT_0XPCSW0Y2G4G	Chasing After Aoi Koshiba CNT_1101Z92K5RFG	CNT_1101Z92K5RFG	2	1	1	Volume 2	[]	Chasing After Aoi Koshiba 2	Sahoko Narita is enjoying the perks of finally being one of the popular girls in high school. One summer day, however, she encounters the athletic and tomboyish Aoi Koshiba and her world is thrown into disarray. Their growing friendship is tested when Aoi Koshiba confides in Sahoko about an upcoming date with a fellow classmate, Shoji Miwa. Sahoko, unable to hide her surprise, must come to grips with her own feelings for Aoi before it's too late...	01KG9FSJEQ0PR3BV08K1YC45HZ	2.0	2021-09-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Chasing After Aoi Koshiba 2	Chasing After Aoi Koshiba FLY, Hazuki Takeoka/Ichijinsha Inc.	2021-09-10T07:00:00.000Z
PRD_3WRDDDXPA44G	CNT_1TFF9Q3CZYS0	Chasing After Aoi Koshiba CNT_1101Z92K5RFG	CNT_1101Z92K5RFG	2	1	1	Volume 1	[]	Chasing After Aoi Koshiba 1	Sahoko had lots of friends in high school, so there's no shortage of people to catch up with at her reunion. But the one face she wants to see is missing: that of Aoi Koshiba, her classmate and first love. A star of the basketball team, Aoi caught Sahoko's eye as an easy way to score social points. But when Aoi quits the team, an unexpected kiss pulls Sahoko closer to her than she intended to be. With a difficult home situation, Aoi is in need of more than just a cynical social climber. She needs a true friend, and something more...	01KG9E5G91J5XK28YVJS29T7R9	1.0	2021-03-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Chasing After Aoi Koshiba 1	FLY, Hazuki Takeoka / Kodansha Ltd.	2021-04-27T07: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);