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

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	on_sale_at
PRD_1FCJCMY1Q9FG	CNT_2TXRK17BMCMG	Puella Magi Kazumi Magica CNT_3KGY1FFZYY30	CNT_3KGY1FFZYY30	2	1	1	Volume 5	[]	Puella Magi Kazumi Magica, Vol. 5	Trapped inside the witch's barrier with the vengeful Kanna, Umika and Kaoru struggle to protect Kazumi as their beloved friend slowly succumbs to her darkening soul gem. If the girls can rally, the witch's grief seed could be used to purify all of their gems, but even that would be only a temporary solution. Facing cruel fate and questions of her own identity, Kazumi will make the ultimate choice whether or not to join her friends in their vendetta against destiny in the final volume of The Innocent Malice!	01KG985BZV6N7YZ3J6CZ0RTET2	5.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Kazumi Magica, Vol. 5	2016-08-18T15:00:00.000Z
PRD_2KX2Y7RBK8EG	CNT_0T7NKCXM3BNG	Puella Magi Kazumi Magica CNT_3KGY1FFZYY30	CNT_3KGY1FFZYY30	2	1	1	Volume 3	[]	Puella Magi Kazumi Magica, Vol. 3	As her teammates look on in horror, Niko succumbs to the taint that has overwhelmed her soul gem and she transforms into a terrifying witch. But there is little time for the Pleiades Saints to grieve-this new witch has gone on the attack! Left with no alternative, Mirai strikes down her friend to save the rest of the girls. Is there any power that can save the Magical Girls from their fate?	01KG9859Q8MRQ8NPSTCQTNH6AP	3.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Kazumi Magica, Vol. 3	2016-08-18T15:00:00.000Z
PRD_2N0DVDQQVPCG	CNT_0WWZJ884X9QG	Puella Magi Kazumi Magica CNT_3KGY1FFZYY30	CNT_3KGY1FFZYY30	2	1	1	Volume 1	[]	Puella Magi Kazumi Magica, Vol. 1	Kidnapped and stuffed into a trunk by an unknown assailant, teenager Kazumi bursts forth from the confines of the case to discover that she has been stripped not only of her clothes, but also of the memories of her life before the kidnapping. When she is recovered by a pair of schoolgirls, she doesn't recognize them as her best friends and roommates, Umika and Kaoru. As Kazumi tries to settle back into her normal life, she quickly realizes that her former "normal" was anything but!	01KG6ZH55C45N9WVN48N4VJ8RW	1.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Kazumi Magica, Vol. 1	2016-08-18T15:00:00.000Z
PRD_2PKX9TTDZQDG	CNT_2XJ2JYKWEAPG	Puella Magi Kazumi Magica CNT_3KGY1FFZYY30	CNT_3KGY1FFZYY30	2	1	1	Volume 2	[]	Puella Magi Kazumi Magica, Vol. 2	Kazumi is determined to continue to battle witches alongside the Pleiades Saints, a group of Magical Girls who were Kazumis companions prior to losing her memory. But it turns out that the witches aren't her only enemy... Yuuri, a Magical Girl, has turned against her own kind and targeted the Pleiades Saints for destroying what was precious to her. What better way for Yuuri to exact her revenge than to destroy what the Saints hold dear?! Abducted by Yuuri, Kazumi knows she has to help the Pleiades Saints...but does she have what it takes to fight one of her sisters-in-arms?!	01KG9858MSGZTE4QY56CSFY1SF	2.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Kazumi Magica, Vol. 2	2016-08-18T15:00:00.000Z
PRD_3DNT5X96N9Z0	CNT_3TJZ3A2FTW40	Puella Magi Kazumi Magica CNT_3KGY1FFZYY30	CNT_3KGY1FFZYY30	2	1	1	Volume 4	[]	Puella Magi Kazumi Magica, Vol. 4	From the very start, it was Kazumi who drew the girls of the Pleiades Saints together. But no magical girl, however beloved by her friends, is exempt from the fate that awaits them all. Fearing that the evil nut may be accelerating Kazumi's transformation, the girls are divided - can the process be delayed, or should they take out Kazumi while they still can?	01KG985BGHT27BMDMS4SENVHK7	4.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Kazumi Magica, Vol. 4	2016-08-18T15: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);