database: products: 13 rows where series_id = "CNT

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

13 rows where series_id = "CNT_19Z1KZ785KQG"

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_00EKXS3EJT0G	CNT_1JM3K265S520	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 10	[]	Until Death Do Us Part, Vol. 10	As their conflict with the Trumps reaches its conclusion, Mamoru again proves himself to be a master tactician. Haruka feels like she's not worthy to stand beside such a capable defender, especially after what he said the last time they spoke...	01KG95JBX0Y9BZVADQ2BB53TDQ	10.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 10	2016-06-30T15:00:00.000Z
PRD_02EKQG5S14DG	CNT_1KVAP3J4XQPG	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 13	[]	Until Death Do Us Part, Vol. 13	The battle against Zashid Turus, the most deadly foe in the world, has begun, and though Mamoru has a plan up his sleeve, he may be heading toward possible death... A superhuman demon of war versus a blind demon of the blade...When two monsters collide, who will cross the line of death?!	01KG989WTPR8GZ4XZFH22BGVPG	13.0	2016-11-21T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 13	2016-11-21T15:00:00.000Z
PRD_0SJZGNPS7R5G	CNT_0V0V0WZC13D0	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 11	[]	Until Death Do Us Part, Vol. 11	Trained by the same master, Mamoru Hijikata and Teppei Genda are both men driven ruthlessly to pursue justice from opposite ends of the spectrum. Where Genda serves the laws of society, Mamoru dishes out his own brand of retribution. The past has left a gulf between these warriors seemingly impossible to bridge, but there always comes a reckoning...	01KG95GNMPSQ4TKFKM8EM30K2M	11.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 11	2016-06-30T15:00:00.000Z
PRD_10TBC1512BW0	CNT_1AZ579Z7S67G	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 3	[]	Until Death Do Us Part, Vol. 3	Haruka and Mamoru take to the streets, fleeing the deadly invisible enemy that pursues them. With Mamoru wounded and his sword blunted, Haruka fears that prolonging this fight will only end with her protector's destruction. But Mamoru has not been relying on his strength alone. Igawa has been working behind the scenes to counter the assassin's drones...but is the pair's technical expert up to the task of disabling government-grade weaponry? Or has Igawa met his match in the world-class hit man, Fang?!	01KG97V3R16X56135DY7N8A9QP	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 3	2016-06-30T15:00:00.000Z
PRD_1EB8CTV43T3G	CNT_1HEB9NY5F570	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 1	[]	Until Death Do Us Part, Vol. 1	Haruka Touyama is a twelve-year-old girl with incredible precognitive abilites. But her accuracy in predicting the future has made her a target for any number of greedy corporations that would use her power for their own profits. After she is taken from her family, Haruka uses her gift to seek out someone who can help her escape her captors and fixes upon a blind man making his way through the busy streets of Tokyo. Though it may seem an odd choice, Haruka's powers have not led her wrong. Despite hisinability to see, her chosen protector's fighting skills become apparent when he draws a sword from his walking stick and takes out a corporation's thugs. Haruka knows she will always be pursued and begs the mystery swordsman to keep her safe..."until death do us part."	01KG9323K3Z01FQR0XA3DTQR2W	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 1	2016-06-30T15:00:00.000Z
PRD_1J68Q3VHWYYG	CNT_05VMX0NS9940	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 7	[]	Until Death Do Us Part, Vol. 7	(Volume 1) Haruka Touyama is a twelve-year-old girl with incredible precognitive abilites. But her accuracy in predicting the future has made her a target for any number of greedy corporations that would use her power for their own profits. After she is taken from her family, Haruka uses her gift to seek out someone who can help her escape her captors and fixes upon a blind man making his way through the busy streets of Tokyo. Though it may seem an odd choice, Haruka's powers have not led her wrong. Despite hisinability to see, her chosen protector's fighting skills become apparent when he draws a sword from his walking stick and takes out a corporation's thugs. Haruka knows she will always be pursued and begs the mystery swordsman to keep her safe..."until death do us part."	01KG97TASERYEF35TE9XVMVCPJ	7.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 7	2016-06-30T15:00:00.000Z
PRD_1W5R1EBZ6CX0	CNT_3BN87YAZA76G	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 5	[]	Until Death Do Us Part, Vol. 5	Caught in Wiseman's trap, besieged on all sides by snipers and drug-crazed attackers, Mamoru is saved only by the arrival of Haruka and a stroke of good fortune. Frustrated by his own helplessness, Mamoru abandons the Element Network to further hone his skills. He can't rely on luck alone if he wants to survive his next encounter with Wiseman...	01KG97V5FMRSMGYPGQHHV2QZXA	5.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 5	2016-06-30T15:00:00.000Z
PRD_287FKC8DF0W0	CNT_07072MN8WB7G	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 12	[]	Until Death Do Us Part, Vol. 12	Mamoru, teaming up with his old nemesis, Wiseman, leads the Black Unit into Duhana in a plot to assassinate "Mr. Darkside"--Zashid Turus, secret ruler of Galboa and Duhana. At the same time, Haruka steers her new team of elite fighters from the Element Network, to Duhana in order to stop Mamoru! But just what is Zashid Turus's ultimate goal...and how does it involve Haruka?! The greatest battle begins to unfold!	01K5G9X8FH0QXFT8BT0EVSTKMS	12.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 12	2016-06-30T15:00:00.000Z
PRD_2HRW93H5Y0FG	CNT_325895J4DVB0	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 9	[]	Until Death Do Us Part, Vol. 9	Mamoru has surrendered himself to the elite seven-man unit the Trumps. Tied up and unarmed, his odds of survival are looking grim. In spite of this, Mamoru stubbornly holds up under the enemy's interrogation...until Haruka herself is captured in the middle of his torment! Under the most desperate circumstances imaginable, the battle erupts: Mamoru vs. the Trumps!!	01KG95K8YACNYQE92VVFZSQMB2	9.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 9	2016-06-30T15:00:00.000Z
PRD_2Z9X9V78ZZF0	CNT_08KYKHH23TMG	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 8	[]	Until Death Do Us Part, Vol. 8	Haruka has begun school again, nestled among Jesus's forces at Aitou Academy. The teaching staff should deter most groups from making a move against Haruka, but stronger organizations could still pose a threat no matter where she hides. Seven warriors of Galboa's most elite unit have already announced their intentions to seize Haruka by force. Jesus may be able to cut off the attackers before they enter the school, but not if one has already made it inside--the operative called "Invisible" seems to be just what his codename boasts...! It's unseen vs. unseeing as Mamoru takes on Galboa's intruders!	01KG95KXH2AE92Q8SV9Q6T4QG0	8.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 8	2016-06-30T15:00:00.000Z
PRD_313K5BM60BKG	CNT_2AMVPJTBZNQ0	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 2	[]	Until Death Do Us Part, Vol. 2	Haruka Touyama is a twelve-year-old girl with incredible precognitive abilites. But her accuracy in predicting the future has made her a target for any number of greedy corporations that would use her power for their own profits. After she is taken from her family, Haruka uses her gift to seek out someone who can help her escape her captors and fixes upon a blind man making his way through the busy streets of Tokyo. Though it may seem an odd choice, Haruka's powers have not led her wrong. Despite hisinability to see, her chosen protector's fighting skills become apparent when he draws a sword from his walking stick and takes out a corporation's thugs. Haruka knows she will always be pursued and begs the mystery swordsman to keep her safe..."until death do us part."	01KG97V19553GKRPY2SWBYDT1M	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 2	2016-06-30T15:00:00.000Z
PRD_32D0VRTW4BCG	CNT_0BAEQ743GPP0	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 4	[]	Until Death Do Us Part, Vol. 4	Officer Genda's suspicions that Mamoru is involved in the Haruka Tooyama case are confirmed when he confronts the blind man in the park on the night of the operation. Genda manages to hold his own against the master swordsman, but Mamoru isn't of a mind to show his cards to the police and makes a quick getaway. Despite the officer's interference, the mission is a success-whispered, fearful rumors of the Tokyo swordsman are beginning to spread. Who will be drawn out to test Mamoru next?!	01KG97V4MF2D81A8BVJ0QNJ806	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 4	2016-06-30T15:00:00.000Z
PRD_35G3GYP8CAJG	CNT_0DZ8PWGMAMG0	Until Death Do Us Part CNT_19Z1KZ785KQG	CNT_19Z1KZ785KQG	2	1	1	Volume 6	[]	Until Death Do Us Part, Vol. 6	(Volume 1) Haruka Touyama is a twelve-year-old girl with incredible precognitive abilites. But her accuracy in predicting the future has made her a target for any number of greedy corporations that would use her power for their own profits. After she is taken from her family, Haruka uses her gift to seek out someone who can help her escape her captors and fixes upon a blind man making his way through the busy streets of Tokyo. Though it may seem an odd choice, Haruka's powers have not led her wrong. Despite hisinability to see, her chosen protector's fighting skills become apparent when he draws a sword from his walking stick and takes out a corporation's thugs. Haruka knows she will always be pursued and begs the mystery swordsman to keep her safe..."until death do us part."	01KG97TZHATW9996GDGDCMGEMV	6.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Until Death Do Us Part, Vol. 6	2016-06-30T15: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);