database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_0M5RVBRC2RPG"

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_00H0PQRB7TE0	CNT_1N7AAC33AYT0	Beyond the Clouds CNT_0M5RVBRC2RPG	CNT_0M5RVBRC2RPG	2	1	1	Volume 3	[]	Beyond the Clouds 3	Thanks to the Sage's medicine, Mia has recovered, but now she also knows she's in danger of burning out her magic if she doesn't learn how to control it. But where to find a wizard in this mundane world? Mia and Theo follow a legend to Karatope, the city of merchants, where every corner features something new, marvelous, or delicious—for a price! But what could a wizard be doing here? They hear of a fortune-teller and realize there's no better vocation for someone with magical powers. Yet even after they spend hours in line, this seer refuses to see them! What does he know that he's not sharing...?	01KG9DKE2NA46TFR5YJHEZ188S	3.0	2020-12-15T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Beyond the Clouds 3	Beyond the Clouds Nicke / Ki-oon	2021-01-12T08:00:00.000Z
PRD_0N1FNPG4GXJ0	CNT_0TNR76X3KYAG	Beyond the Clouds CNT_0M5RVBRC2RPG	CNT_0M5RVBRC2RPG	2	1	1	Volume 1	[]	Beyond the Clouds 1	A boy with a talent for machines and a the mysterious girl whose wings he's fixed will take you past the ordinary. In the tradition of the high-flying, resonant adventure stories of Studio Ghibli comes a gorgeous tale about the longing of young hearts for adventure and friendship! Young Theo works as a mechanic, putting his knack for machines to use in the industrialized city where he lives. But when he finds an injured, amnesiac girl with wings, his life changes forever. Her name is Mia, and although Theo's talents make quick work of repairing her injured wing, their quest to find her home will take them beyond the clouds and further than they would ever have imagined.	01KG9BTDG0AEJ0F6G0N0NNASBS	1.0	2020-05-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Beyond the Clouds 1	Beyond the Clouds (C) Nicke / Ki-oon	2020-05-12T07:00:00.000Z
PRD_135CSTVSBJ7G	CNT_3YBG4092XQCG	Beyond the Clouds CNT_0M5RVBRC2RPG	CNT_0M5RVBRC2RPG	2	1	1	Volume 4	[]	Beyond the Clouds 4	Another Catastrophe Mia and Theo's erstwhile new friend Nora was kidnapped by a band of thieves, but with the help of the little lumiferret Tama, the pair managed to find the kidnappers' lair! Unfortunately, the operation ended in disaster when, in a panic, Mia again caused a monstrous cat of darkness to appear. After raging out of control, the beast only disappeared once she lost consciousness. Now, though the worst has been avoided, Mia feels guiltier than ever towards Theo for what she's putting him through...	01KGADCCQ4QFZJ6CMR6CGG6449	4.0	2022-02-02T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Beyond the Clouds 4	Beyond the Clouds Nicke/Ki-oon	2022-03-01T08:00:00.000Z
PRD_19Y06AJ6WHHG	CNT_3NA3YP5R7VEG	Beyond the Clouds CNT_0M5RVBRC2RPG	CNT_0M5RVBRC2RPG	2	1	1	Volume 5	[]	Beyond the Clouds 5	A QUEST NEARS ITS END Theo and Mia grow consumed by their search for a magician able to teaching the winged girl how to control her dangerous powers. At last, a merchant from Karatope gives them a clue that leads to their next destination: Holpe! On the way, the friends make a stop in the small village of Chikari, where a baker insists they stay the night. In this stranger's warm home, Theo finally opens up about his sorrowful past...	01KGAT8H52RQ610S6GFF7JEZ87	5.0	2023-11-13T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Beyond the Clouds 5	Nicke/Ki-oon	2023-11-28T08:00:00.000Z
PRD_2MR73C17JX2G	CNT_3V01QW3ZDES0	Beyond the Clouds CNT_0M5RVBRC2RPG	CNT_0M5RVBRC2RPG	2	1	1	Volume 2	[]	Beyond the Clouds 2	Deep in the forest, Theo has finally found the mysterious Doctor, whose medicine might save Mia's life. In exchange, Theo must find what the Doctor desires most and bring it back to him. Theo agrees without thinking, but how will he even figure out this riddle, not to mention find what the Doctor's looking for in this vast, forbidding wood full of fairies and monsters? The clock is ticking as Mia lies in her sickbed, and the unknown enemies who attacked her plot their next move...	01KGA92QC27VQM7W752JA0T7HE	2.0	2020-05-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Beyond the Clouds 2	Beyond the Clouds (C) Nicke / Ki-oon	2020-05-12T07: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);