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

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_034G8BDDSCBG	CNT_36KYPTJVEQF0	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 4	[]	Fate/stay night, Vol. 4	Shiro and Saber are in big trouble when they face off against Caster and her horde of undead soldiers. Will they be able to defeat Caster on their own or will Rin have to save Shiro again? And what will happen when the next Servant appears, and Saber chooses to defy Emiya's orders as her Master?	01KKTXW7FP936GHYJDDACRQF6V	4.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 4	(C) Dat NISHIWAKI 2007 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_07N0VYEG5BAG	CNT_1SYBP473XP80	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 1	[]	Fate/stay night, Vol. 1	When he was little, high school student and amateur mechanic Shirou Emiya was adopted by a magus man. Now he wants nothing more than to follow in his stepfather's footsteps and become a hero of justice. Little does he know that a war is waging among some chosen magi, and that he is about to become its focal point... The manga addition to the super-popular multimedia franchise has finally arrived!	01K5FVHY5V2TZS8SHEBQZXA8PJ	1.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 1	(C) Dat NISHIWAKI 2006 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_0NK61JQZNF6G	CNT_14M7QKG29TC0	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 3	[]	Fate/stay night, Vol. 3	The excitement continues as Emiya discovers the origin of the spell field only to be greeted by the Servant who controls it: Rider! As she attacks, though, Rider carelessly discloses a secret about the field to Emiya. Will Saber arrive in time to save Emiya from catastrophe? Meanwhile, our heroes discover something truly shocking as they scramble to find the cause of what ails the city of Shinto...	01KKTXWMRXXTF50C0K8B4TWV9A	3.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 3	(C) Dat NISHIWAKI 2007 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_125R8Q1C82G0	CNT_381MAJQ2QCKG	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 5	[]	Fate/stay night, Vol. 5	Shinji and Rider are up to no good again, and this time everyone is going to suffer. As Shiro wrestles with the dramatic changes in Shinji, he tries to change his old friend, believing that there's still good in him. Meanwhile, Shiro struggles to reconcile the growing complications in his relationship with Saber. What does it really mean to be Master and Servant, anyway?	01K5FYD2ET611GZ0BXCP3KEQ00	5.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 5	(C) Dat NISHIWAKI 2007 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_1C4WJ29EF2H0	CNT_02A75DAD9CJG	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 10	[]	Fate/stay night, Vol. 10	Shinji and Rider are up to no good again, and this time everyone is going to suffer. As Shiro wrestles with the dramatic changes in Shinji, he tries to change his old friend, believing that there's still good in him. Meanwhile, Shiro struggles to reconcile the growing complications in his relationship with Saber. What does it really mean to be Master and Servant, anyway?	01KKTXX3TKSWF3FTP8VNXT9KVN	10.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 10	(C) Dat NISHIWAKI 2009 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_1V2CBHXMXNCG	CNT_1XWSKTAPBGP0	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 9	[]	Fate/stay night, Vol. 9	Emiya and Rin have paired up in order to defeat Caster and regain their companions, but does Emiya have the strength to face a servant in battle? Can he even face his decision to let Saber be captured? With the help of Rin and an unexpected ally, the team may actually have a chance at winning if luck is on their side. What will it take to turn the tides of war in their favor? And just what is their new friend hiding from them...?	01K5FYT0XJTXKZ7N7BQPTZNN67	9.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 9	(C) Dat NISHIWAKI 2009 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_1ZQ9X47AC3H0	CNT_18Q7B72T8DJG	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 2	[]	Fate/stay night, Vol. 2	The Legend of the Grail continues! After suffering the deathly blow of Beserker, Emiya wakes up with a mysteriously healed body. Determined to survive and defeat the Masters, Emiya sets out to unravel the mysteries of the Grail and how his past is tied to his new powers. With enemies waiting in the wings, Emiya has no choice but to hurry and learn more about what he's gotten himself into if he's to have any chance of continuing on his quest...	01K5FYDWYVDX5MB4RMAQJD9G26	2.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 2	(C) Dat NISHIWAKI 2006 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_28GVZVVZFAS0	CNT_0RXZ1RRGH4TG	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 6	[]	Fate/stay night, Vol. 6	Shiro activates his command mantra, summoning Saber to his side, while Rin and Archer attack Shinji and Rider, pushing them to the edge of defeat. But Saber blocks Archer's final blow - under Shiro's orders - promising to defend Shinji even at the cost of breaking their agreement with Rin. But can they convince Shinji to cease his immoral acts? And Rider questions Saber's loyalty to a Master who doesn't even want to fight - just what are Saber's true reasons for obeying Shiro?	01KKTXW363YFF7SQX4F1NR8J4W	6.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 6	(C) Dat NISHIWAKI 2008 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_28QM7V3ANRYG	CNT_1MEFSVTC0340	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 8	[]	Fate/stay night, Vol. 8	With the cruel Caster now in control of the powerful Saber, the situation has turned bleak for the remaining Masters. But right when all the cards seem to have fallen into Caster's hands, Berserker decimates her base, leaving her open to attack from Tosaka and Archer! Will a chilling revelation about Archer's true identity put a stop to their assault...or will the honors go to Saber?	01K5FYJPTPJ02GXJR7BBH7QVNP	8.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 8	(C) Dat NISHIWAKI 2008 (C) TYPE-MOON	2014-10-28T15:00:00.000Z
PRD_2QE8Q9C5XYMG	CNT_1GFHW5RSJ8Y0	Fate/stay night CNT_3GSVJYEWKQJG	CNT_3GSVJYEWKQJG	2	1	1	Volume 7	[]	Fate/stay night, Vol. 7	Shinji is nearly defeated, but everyone is in for a surprise when Rider's true master is revealed! In the aftermath of Shinji's rage, Shiro learns about Saber's past and why her noble phantasm is what it is. But are things finally calming down? No one is prepared when Caster starts a new onslaught! Tosaka is determined to put an end to Caster's machinations, but it may prove harder than she ever imagined...	01K5FYNS8Y65X7H89E5J9EWH76	7.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Fate/stay night, Vol. 7	(C) Dat NISHIWAKI 2008 (C) TYPE-MOON	2014-10-28T15: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);