database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_3GYXF34EGHK0"

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_01T9GFZ7TGAG	CNT_0D8AJ4Q27WDG	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 10	[]	Bloody Mary, Volume 10	No one suspected that the death and resurrection of “Mary” was actually an attempt to revive the weak and ailing Mary. When Mary learns this truth, he hears the voice of “Mary.” And now Maria must finally fulfill Mary's death wish... But a tragedy awaits...	01KGA1E6HCHB8F1Y8Y8NMQ0460	10.0	2018-02-06T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 10	BLOODY MARY Volume 10 (C) Akaza SAMAMIYA 2017	2018-03-06T08:00:00.000Z
PRD_0C4CW6V4B8R0	CNT_0EE1FCXDDTV0	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 4	[]	Bloody Mary, Volume 4	Another “Mary” who resides within Mary turns out to be the one who killed Maria’s father, Yusei. In search of why his father had to die, Maria tries to get in contact with “Mary” but is unsuccessful. In the meantime, a mysterious man pays a visit to Maria and reveals how Maria’s mother first met Yusei and provides crucial information about Maria’s family lineage.	01KG987XFN5GEVCZ00K9VEPE0P	4.0	2016-09-13T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 4	BLOODY MARY Volume 1 (C) Akaza SAMAMIYA 2015	2016-09-13T15:00:00.000Z
PRD_0J97H8N6J08G	CNT_390GQWCGFKBG	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 6	[]	Bloody Mary, Volume 6	"“Mary” finally appears before Maria, who can’t bring himself to ask about what happened on the night his father died. While Maria is unable to face the truth, “Mary” offers him a deal: if Maria can get Mary to recall the forgotten memories of Mary’s past, “Mary” will reveal how his father died. Meanwhile, Hydra, who has also come to England, has a reunion with the skeleton of “Mary” in an old castle…	01KG9YWW61N6JHKRJK6Y1WN8FD	6.0	2017-03-06T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 6	BLOODY MARY Volume 6 (C) Akaza SAMAMIYA 2015	2017-03-06T15:00:00.000Z
PRD_0MSJQRQP3NE0	CNT_1DC4FQK77RN0	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 5	[]	Bloody Mary, Volume 5	Maria and Mary go to England to meet the mentor who taught Shinobu how to fight vampires, hoping that he might hold the answers Maria seeks. But he’s already gone by the time they arrive, and they are met, instead, by a blond beauty in a lab coat. Meanwhile, the familiar scenery stirs up long-repressed memories Mary had once forgotten.	01KG989D651NZZDR1EZM8WNEKC	5.0	2017-01-16T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 5	BLOODY MARY Volume 5 (C) Akaza SAMAMIYA 2015	2017-01-16T15:00:00.000Z
PRD_13375CP6BM10	CNT_1GGPY2MXFXW0	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 7	[]	Bloody Mary, Volume 7	At the Sakuraba Estate, Maria and Shin discover the estate has been attacked by vampires. Meanwhile, hoping to rouse the immortal Yzak from his coma, Mary imbibes his blood, but the exorcist does not awaken. Weak and unstable, Mary stumbles back to find Maria but suffers from a bout of amnesia that leaves Maria shaken.	01KG9Z2JP4DHSZ37880Z5K578K	7.0	2017-06-05T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 7	BLOODY MARY Volume 7 (C) Akaza SAMAMIYA 2016	2017-06-05T15:00:00.000Z
PRD_24VDS2XQZCSG	CNT_1YBJ8AQFAPS0	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 1	[]	Bloody Mary, Volume 1	“Bloody” Mary is not your typical vampire. He can withstand sunlight, holds a reflection in mirrors, refuses to drink blood?and wants 17-year-old student and priest Maria to kill him. But to Mary’s dismay, Maria doesn’t know how to kill vampires. Desperate to die, Mary agrees to become Maria’s bodyguard until Maria can find a way to kill him at last.	01K5G9TT74ZXM3JF5M3PVDV9R3	1.0	2015-12-21T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 1	(C) Akaza SAMAMIYA 2014	2015-12-21T15:00:00.000Z
PRD_2GT4HANVHF10	CNT_3NSZ6F6W7A2G	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 3	[]	Bloody Mary, Volume 3	Maria’s father, Yusei, was killed by vampires?and it was Maria’s own fault. Haunted by guilt, he sealed away the memory. That is, until he remembers the face of the murderous vampire…and it looks just like Mary’s! On a mission for answers, Maria comes to the kidnapped Mary’s rescue, but he finds someone else within Mary…	01K5GB18A5PB3F3G3CKKS2JWDV	3.0	2016-06-15T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 3	BLOODY MARY Volume 3 (C) Akaza SAMAMIYA 2014	2016-06-15T15:00:00.000Z
PRD_2YWM17NAY3HG	CNT_0NBSS5JZ3XH0	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 2	[]	Bloody Mary, Volume 2	Maria never knew he possessed the Power of Exorcism, which enables him to kill vampires. Now with Mary’s help, Maria digs into his past and unearths “Red Memories” that he had suppressed. Meanwhile, Mary begins to recover missing memories of his own. What truths await the exorcist and the vampire, and could their lives have intersected in the past?	01K5GAXWM7CA4KG2TGBAAPQVQN	2.0	2016-03-09T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 2	(C) Akaza SAMAMIYA 2014	2016-03-09T15:00:00.000Z
PRD_35D2YTK3N9TG	CNT_0HK2AH12FJBG	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 9	[]	Bloody Mary, Volume 9	Mary's twin brother, “Mary,” is unable to fend off his overpowering thirst for blood, and as a result, Mary comes ever closer to becoming “the blood-stained vampire.” Meanwhile, Hydra learns that Bloody Eye's plan is to ultimately battle her. Then, Maria launches a risky strategy in an attempt to get Mary back. But is the risk worth his own life?	01KG9VX4C133FEB8YA4CTJJQEN	9.0	2017-11-07T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 9	BLOODY MARY Volume 9 (C) Akaza SAMAMIYA 2016	2017-12-05T08:00:00.000Z
PRD_3H1M9B1T1K8G	CNT_1EAHZE4P4D5G	Bloody Mary CNT_3GYXF34EGHK0	CNT_3GYXF34EGHK0	2	1	1	Volume 8	[]	Bloody Mary, Volume 8	Unable to bear the shocking truth that Maria reveals to him, Mary loses consciousness and disappears inside of himself, which allows “Mary” to surface to take his place. “Mary” heads out alone, while Maria, along with Shinobu and Hydra, confront a trio of vampires. Bathed in blood, “Mary” gradually succumbs to madness...	01KG9Z9WWMB5S1KME6D73TVR9T	8.0	2017-09-03T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Bloody Mary, Volume 8	BLOODY MARY Volume 8 (C) Akaza SAMAMIYA 2016	2017-09-04T15: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);