database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_09QDCAKA5KQ0"

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_06TASN8F2DQG	CNT_2RHHTMMT8HW0	Shaman King: Flowers CNT_09QDCAKA5KQ0	CNT_09QDCAKA5KQ0	2	1	1	Volume 2	[]	Shaman King: Flowers 2	Hana Asakura is drifting through his gloomy life at Funbarigaoka, until one day he gets some surprise visitors: Yohane and Luca Asakura, two members of a secret branch of his family, and Alumi, the Third Itako Anna who claims to be Hana's fiancée! In the midst of the chaos, Alumi tells him about a new battle to come: the mysterious "Flower of Maize." Things are heating up for the new generation of shamans in Volume 2!	01KG9D9WWV56X31A85RAY28R4S	2.0	2020-10-14T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Shaman King: Flowers 2	Hiroyuki Takei / Kodansha Ltd.	2020-10-27T07:00:00.000Z
PRD_0G6AWQYZWGJ0	CNT_1KE1GK9BRMJG	Shaman King: Flowers CNT_09QDCAKA5KQ0	CNT_09QDCAKA5KQ0	2	1	1	Volume 1	[]	Shaman King: Flowers 1	The action returns in this brand-new sequel to Shaman King! Hana Asakura finds that being the son of Yoh & Anna Asakura isn't all it's cracked up to be, and his boredom has him itching for any kind of excitement. But when a fight comes straight to his doorstep, it's from a place he least expects—his own family? The battle for Asakura supremacy begins!	01KG9CDWVMKWYCX9JW2VVV3HZB	1.0	2020-10-07T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Shaman King: Flowers 1	Hiroyuki Takei / Kodansha Ltd.	2020-10-20T07:00:00.000Z
PRD_0P8NVAS7104G	CNT_04CNKRA674WG	Shaman King: Flowers CNT_09QDCAKA5KQ0	CNT_09QDCAKA5KQ0	2	1	1	Volume 6	[]	Shaman King: Flowers 6	After bringing out his demons and dying by the riverbank, Hana Asakura heads inside the Great Spirit where his uncle Hao, the current god, forces him to fight...his father at the same age as himself?! Meanwhile on Earth, there's trouble brewing at Funbari Hot Spring. Ludsev and Salerm appear with a girl who calls herself Black Maiden... How will Tao Men, Gakko Ibuki, and the others react to this critical situation?!	01KG9DM9VCZSTAH774RPC8FNNQ	6.0	2020-12-09T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Shaman King: Flowers 6	Hiroyuki Takei / Kodansha Ltd.	2020-12-22T08:00:00.000Z
PRD_19HJNZW1TQ00	CNT_3Z69H4HPDBG0	Shaman King: Flowers CNT_09QDCAKA5KQ0	CNT_09QDCAKA5KQ0	2	1	1	Volume 5	[]	Shaman King: Flowers 5	After bringing out his demons and dying by the riverbank, Hana Asakura heads inside the Great Spirit where his uncle Hao, the current god, forces him to fight...his father at the same age as himself?! Meanwhile on Earth, there's trouble brewing at Funbari Hot Spring. Ludsev and Salerm appear with a girl who calls herself Black Maiden... How will Tao Men, Gakko Ibuki, and the others react to this critical situation?!	01KG9DGM0219ZQCTJRFJR2JQC4	5.0	2020-11-25T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Shaman King: Flowers 5	Hiroyuki Takei / Kodansha Ltd.	2020-12-08T08:00:00.000Z
PRD_1CYERQK3C9NG	CNT_1ECV14GH3DY0	Shaman King: Flowers CNT_09QDCAKA5KQ0	CNT_09QDCAKA5KQ0	2	1	1	Volume 4	[]	Shaman King: Flowers 4	Hana Asakura has had his guardian spirit, Amidamaru, stolen from him. On top of that, someone who calls himself "Gakko Ibuki of Team Hao" picks a fight with Hana right in his own hideout! The time has come for Hana to learn the truth about his true enemies and the mysterious "Flower of Maize"... Things are developing rapidly for the next generation of shamans in Flowers Volume 4!	01KG9DC7G9GWRTF3D9WWQVB788	4.0	2020-10-28T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Shaman King: Flowers 4	Hiroyuki Takei / Kodansha Ltd.	2020-11-10T08:00:00.000Z
PRD_20A4QA9KB1X0	CNT_2HVSTNNZ067G	Shaman King: Flowers CNT_09QDCAKA5KQ0	CNT_09QDCAKA5KQ0	2	1	1	Volume 3	[]	Shaman King: Flowers 3	Shaman Hana Asakura heads to the mall with his new classmate Yohane to teach him about society. But when they run into Yohane's sister Luca, they discover she's used a mysterious power to turn Amidamaru to stone! How will Hana survive this new attack without his guardian spirit?! The story of the new generation of shamans takes a shocking turn in Volume 3!	01KG9DBFQYARCMZM1J2CMJMR92	3.0	2020-10-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Shaman King: Flowers 3	Hiroyuki Takei / Kodansha Ltd.	2020-11-03T08: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);