database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_0WG40H6EAD40"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0A76YG1ETW40	CNT_2DQQSMVGSQFG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 2	[]	GA-REI 2	The battle heats up quickly as Yomi plans to revive an immortal creature sleeping below the city and the Agency races to stop her. Kensuke joins the fight to assist Kagura, but is he leaving his greatest weakness wide open?	Non-stop after-school spirit-fighting action!	01KKTXXA73FFKFYA18GE2DZW0K	2.0	2014-12-09T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 2	(c)Hajime SEGAWA 2006	2014-12-09T15:00:00.000Z
PRD_0BXVDFHG1G10	CNT_32PP9YQSQV2G	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 6	[]	GA-REI 6	The Agency headquarters have been annihilated by Jugondo and Setsuna's attack. Kagura and Kensuke have survived to hide out in an Agency safehouse in the city, waiting for a chance to strike back. If only they knew the location of the last sesshoseki...!	Will Kagura or Setsuna get her hands on the last sesshoseki?	01KKTXZ9GCT41KH08NDGG58JAF	6.0	2015-02-11T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 6	(c)Hajime SEGAWA 2008	2015-02-11T15:00:00.000Z
PRD_0EJBR2KTDZ00	CNT_121398C22T3G	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 7	[]	GA-REI 7	A final battle on a solitary island! Kagura and Setsuna fight to the finish at last in the alternate dimension of Tamamo's Garden! But with all the sesshoseki assembled, the Kyubi, god of creation and destruction, will be revived after a thousand years. Can Kensuke and his allies save the world...?	With all the sesshoseki assembled, the fuse is lit for an explosive final battle!	01KKTXZ9VANK2A7GQ2MQ34NQQW	7.0	2015-02-11T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 7	(c)Hajime SEGAWA 2008	2015-02-11T15:00:00.000Z
PRD_0N20REDYR9V0	CNT_271KZW6RJ3RG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 11	[]	GA-REI 11	On the verge of fleeing with Yomi, Kagura regains all her memories and rejoins Kensuke to lay low at Michael's place. There, the true nature of the expanding Naraku is made clear. The "Decimation Plan" is an occult system meant to lead to the destruction of humanity! To oppose it, the Agency sends four agents to wipe out the Black Priestess, Yomi. As the crisis approaches, what will Kensuke and his allies do?! An eleventh volume of non-stop after-school spirit-fighting action!	The non-stop after-school spirit-fighting action reaches a climax! The final battle - the last night.	01K5GA85ADZJTT1XQQKSXZRSQW	11.0	2015-03-24T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 11	(c)Hajime SEGAWA 2009	2015-03-24T15:00:00.000Z
PRD_0PDGEVKMWAM0	CNT_07Q6ZJGG74ZG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 12	[]	GA-REI 12	The Decimation Plan begins at last! What end awaits Kensuke and his allies as they race toward Naraku...?! The fate of humanity rests on the outcome of the battle between the White Priestess and the Black Priestess. It's a conclusion of epic scale, in the final volume of Ga-Rei!	The final page of the ultimate battle, and the conclusion of Ga-Rei!	01K5GA85X1ZK3AJH0WH9CQNYX2	12.0	2015-03-24T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 12	(c)Hajime SEGAWA 2010	2015-03-24T15:00:00.000Z
PRD_0PY5EYJA2J20	CNT_29SSW6SYBX1G	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 3	[]	GA-REI 3	Yomi has embedded a sesshoseki, a deadly spirit crystal, in Kensuke's very flesh. Frantic for Kensuke's well-being, Kagura confronts Yomi at the risk of her own life. And when the life-or-death struggle shudders to a halt, a mysterious child appears... This is after-school spirit-fighting action at its best!	The mortal struggle with Yomi ends at last! A new twist in the tale!	01KKTXXP2S0FSED8PDD6KBZVZJ	3.0	2014-12-26T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 3	(c)Hajime SEGAWA 2006	2014-12-26T15:00:00.000Z
PRD_151XNWD274K0	CNT_03NX5HZWFEGG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 1	[]	GA-REI 1	Kensuke Nimura has always been able to see spirits, but he never expected to find himself helping a girl named Kagura who battles evil spirits with her spirit beast, Byakuei. As it turns out, she's a member of the Ministry of the Environment's top-secret Occult Disaster Response Agency, and she's out to recruit him, too...	After-school underground spirit-fighting action!	01K5FVQGHDDPPB32FDDT70HPGY	1.0	2014-10-28T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 1	(C)Hajime SEGAWA 2006	2014-10-28T15:00:00.000Z
PRD_2MSNF5A51790	CNT_2JXE7PDFWJAG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 9	[]	GA-REI 9	Two girls appear before an amnesiac Kagura: Yomi, whose fate is deeply entwined with Kagura's, and Izumi, who could be Yomi's twin. In the meantime, the Naraku region that appeared in the middle of Tokyo begins to spill over with evil spirits...!	The Agency returns?! And who's this new girl, Izumi, who looks like Yomi...?	01K5GA6NA3KBSJ4VK5PKAH5F1P	9.0	2015-02-24T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 9	(c)Hajime SEGAWA 2009	2015-02-24T15:00:00.000Z
PRD_3K82WZW1QYPG	CNT_050PRWXEP8W0	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 8	[]	GA-REI 8	Kagura and her allies have ended their battle with Jugondo and sealed the Kyubi away once more. But in return, the Agency has been disbanded, and Kagura has lost her memories of the past. Can Kensuke really go back to begin a peaceful new life as a student?	A new chapter kicks off! When Kagura loses her memories, what will happen to Kensuke?!	01KKTXZ83FT3M9BZCSJM6B56VT	8.0	2015-02-11T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 8	(c)Hajime SEGAWA 2008	2015-02-11T15:00:00.000Z
PRD_3KCZ4Z4CTCM0	CNT_1GH7GZZA96ZG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 5	[]	GA-REI 5	Shizuru's older sister Setsuna has slain the head of Jugondo and established herself as the new head. In order to obtain more sesshoseki, she plans an attack on the Agency. How will Kagura and Kensuke fight back against her overwhelming power?! Tensions rise in Volume Five!	Total war breaks out between the Agency and Jugondo!	01KKTXXWBCCPT3EENZCY8XK5XJ	5.0	2015-01-27T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 5	(c)Hajime SEGAWA 2007	2015-01-27T15:00:00.000Z
PRD_3T46938Q2GHG	CNT_1WMZB248EAH0	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 10	[]	GA-REI 10	As evil spirits overflow from Naraku in the middle of Tokyo, the Agency is re-formed. Kensuke hesitates over whether to rejoin them, while Kagura regains some of her memories thanks to the appearance of a man with a black spirit beast. At the same time, Yomi reawakens within Izumi. Kensuke turns his blade on her, but the one who dives in the way to protect Yomi is...Kagura?!	A clash between Kagura and Kensuke! As Naraku grows, what will the Agency do?!	01K5GA6Y08VQBBBZGV1S4N65NP	10.0	2015-03-10T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 10	(c)Hajime SEGAWA 2009	2015-03-10T15:00:00.000Z
PRD_3TKY153S2AT0	CNT_1K61KVBV34SG	GA-REI CNT_0WG40H6EAD40	CNT_0WG40H6EAD40	2	1	1	Volume 4	[]	GA-REI 4	A new transfer student, Shizuru Imawano, appears before Kagura and Kensuke. She is the presumptive head of the sinister Jugondo organization. As Shizuru gathers sesshoseki to obtain the spiritual power of the Kyubi, she declares war on Kagura. A girl-vs-girl battle breaks out, with Kensuke and the sesshoseki in his flesh as the prize!	Kagura vs. Shizuru in a girl-vs-girl sesshoseki battle!	01KKTXXTY3D4V2SSPYWTT93THD	4.0	2015-01-27T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	GA-REI 4	(c)Hajime SEGAWA 2007	2015-01-27T15: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);