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

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_0TMTNKHQAM40	CNT_3K5V7HDQGS8G	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 1	[]	The Reprise of the Spear Hero Volume 1	Don’t like the outcome? Then start over and do it again! An exhilarating, new otherworldly redemption fantasy begins in this spin-off of the massively popular otherworldly fantasy, the Rising of the Shield Hero! Motoyasu Kitamura is summoned to another world to serve as the Spear Hero, but something eventually manages to kill him. When he dies Motoyasu suddenly finds himself back on the day he was first summoned to the new world?without losing any of his power! It’s the start of a new game in god mode! This time he’s determined to get things right?for the sake of his beloved Filo-tan, the magnificent filolials, and his “father,” the Shield Hero.	01KG9BTQT5A927FMMVEBPGWRB7	1.0	2020-05-15T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 1	(c)Aneko Yusagi 2017	2020-05-19T07:00:00.000Z
PRD_184AKK0BE1KG	CNT_2XRQ18RV84H0	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 10	[]	The Reprise of the Spear Hero Volume 10	"It sure has changed since the last time I was here." A deadly illness has spread from the dragon corpse left unburied as a tourist spectacle. The shadow of death falls over the village to the east. Following Wyndia's wishes, Naofumi and Motoyasu head there to try to put a stop to the plague. But the attitude of the villagers, who want a scapegoat for their misfortune, push the heroes to their limit . . . The heroes, seeking a proper burial for Gaelion and Wyndia's father, head to the site of the corpse—only to find it transformed into a dragon zombie!	01KGBEZG9J14JZVSFES49WCJ83	10.0	2024-09-30T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 10		2024-11-24T08:00:00.000Z
PRD_1EYY1KHFZZ4G	CNT_1GAQ7FBW2MFG	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 6	[]	The Reprise of the Spear Hero Volume 6	Motoyasu has been thrown back in time once more. Relying on his vague memories of previous go-arounds" he brings Naofumi to the slave market and tries to convince him to buy a slave. But there is a familiar face among the demi-humans for sale who could it be?	01KGADC946XJT597EVGPHGMB5S	6.0	2021-06-25T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 6		2022-02-03T08:00:00.000Z
PRD_1JHKEY5BP8MG	CNT_35PVC14FSVV0	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 4	[]	The Reprise of the Spear Hero Volume 4	If you don't like where things are going, just hit the reset! Welcome to a thrilling, otherwordly time-loop fantasy! This spin-off of the anime-adapted hit The Rising of the Shield Hero stars none other than the Love Hunter, the Spear Hero!	01KG9GG13NW02E9Q17C6M9NVPR	4.0	2021-06-18T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 4		2021-07-29T07:00:00.000Z
PRD_1K5GMHB6WY2G	CNT_3DMCJWXC24B0	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 7	[]	The Reprise of the Spear Hero Volume 7	The loop resets" and the journey begins anew! Will Motoyasu and company finally see a different outcome?! After Naofumi and his friends buy Keel from a slave trader and start peddling Keel is determined to transform into a therianthrope so that Motoyasu can understand her but isn't having much luck. But when they journey to Siltvelt " a panda therianthrope agrees to teach her! What will become of this encounter?!	01KGAEV78S3TWJENYD2C2NSBZA	7.0	2022-02-25T08:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 7		2022-02-26T08:00:00.000Z
PRD_1NMJB40QYPTG	CNT_34B5FYF0KT50	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 5	[]	The Reprise of the Spear Hero Volume 5	Motoyasu and friends are in Siltvelt when the Melromarc army invades. But what exactly has Itsuki been up to this whole time? Motoyasu and Naofumi ride a dragon and face off against the Church of the Three Heroes in an epic battle!	01KG9GFXZE0H06KGBSFH2JFG4N	5.0	2021-06-18T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 5		2021-07-29T07:00:00.000Z
PRD_1R5H0VSVF7C0	CNT_11EM6QQ75W40	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 3	[]	The Reprise of the Spear Hero Volume 3	Don't like the outcome? Then start over and do it again! The exhilarating, otherworldly redemption fantasy continues! After finally getting rid of their Church of the Three Heroes pursuers, Motoyasu and Naofumi arrive in Siltvelt. But once there, things still don't go as smoothly as planned.	01KG9DMHTRY7C28ZPP4VP8ZJGF	3.0	2020-12-18T08:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 3		2020-12-22T08:00:00.000Z
PRD_1WRGZ3F0A58G	CNT_3FQYJ6QKSG7G	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 8	[]	The Reprise of the Spear Hero Volume 8	Naofumi and his friends managed to minimize the damage from the Melromarc wave. But their enjoyment of the celebratory banquet is interrupted when Itsuki picks a fight with Naofumi. With the release of his slaves on the line, a duel between shield and bow begins!	01KGASRWYS1TPW6A2KKHRQN0QD	8.0	2023-09-29T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 8		2023-09-30T07:00:00.000Z
PRD_2RWDEW0M8MVG	CNT_0JTHQT8VS8R0	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 2	[]	The Reprise of the Spear Hero Volume 2	Don’t like the outcome? Then start over and do it again! The exhilarating, otherworldly redemption fantasy continues! The Spear Hero, Motoyasu, finally realizes that he’s stuck in a time loop after being sent back in time repeatedly as a result of his Time Reversal skill. Motoyasu decides that he must save the Shield Hero, Naofumi, for the sake of Filo, but how?!	01KGA95ESSZVS5A8VGX6K4XBNQ	2.0	2020-05-15T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 2	(c)Aneko Yusagi 2017	2020-05-19T07:00:00.000Z
PRD_3X1RGDY585R0	CNT_0FCN2FJQYZQ0	The Reprise of the Spear Hero CNT_2T1TVAVWNVB0	CNT_2T1TVAVWNVB0	2	1	1	Volume 9	[]	The Reprise of the Spear Hero Volume 9	"I also want to get stronger. So I don't lose anyone ever again." Motoyasu and friends come to a small village to investigate the corpse of a dragon slayed by the Ren, only to find the site turned into a tourist attraction. Soon after, Naofumi takes a dragon girl, targeted by adventurers seeking the dragon's treasure, into his protection. This young girl is soon faced with a harsh truth...and a glimmer of hope.	01KGASRW5BYSK893HCG5E37R4E	9.0	2023-09-29T07:00:00.000Z	One Peace Books LAB_0KDKBQKJQBCG	GEO_1PQM5BDYSMG0	The Reprise of the Spear Hero Volume 9		2023-10-03T07: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);