database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_1NP2JRB3GFRG"

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_0GCP01H3V0RG	CNT_2W4HFSGPX22G	Hollow Regalia CNT_1NP2JRB3GFRG	CNT_1NP2JRB3GFRG	2	2	1	Volume 5	[]	Hollow Regalia, Vol. 5	After their fierce battle in Nagoya and their horrible discoveries about the Japanese populace-turned-Moujuu, Yahiro and Iroha are headed to Kyoto for answers. There, they plan to meet the mysterious Karura Myoujiin who called for them. What they didn’t expect to find is Marquis Eusebius Berith and the Galerie’s European HQ soldiers. Though the marquis heaps praise and accolades on Giuli and Rosé, it’s not that easy to pull the wool over the twins’ eyes! They know he’s up to something, and they’ve got some schemes of their own in motion. With Karura’s help, hopefully they can learn the truth about the dragon mediums and the world—but what they discover may not lead to the salvation they wished for…	01KGBCHPKQH273M91S9ZW6VF5B	5.0	2024-08-29T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Hollow Regalia, Vol. 5	2025-03-04T08:00:00.000Z
PRD_16HYM073AXS0	CNT_2EHW8V1QARK0	Hollow Regalia CNT_1NP2JRB3GFRG	CNT_1NP2JRB3GFRG	2	2	1	Volume 1	[]	Hollow Regalia, Vol. 1	Four years ago, a dragon filled the sky, the nation of Japan fell, and Japanese people around the world were wiped out. Yahiro, a survivor of the tragic event, works as a salvager who obtains Japanese artwork and artifacts for foreign buyers. Not many are willing or able to brave the ruins, which are crawling with monstrous beasts called Moujuu. But Yahiro’s the best man for the task. After all, thanks to his regenerative abilities, he can’t really die. He’s approached about a job to search for the Kushinada, which is capable of controlling the Moujuu, but it will require delving into the most dangerous parts of the city. This is the story of a dragon girl and a dragon slayer.	01KGB2ZK2QQXV1YS5KZVZKXN8Y	1.0	2022-12-07T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Hollow Regalia, Vol. 1	2023-03-21T00:00:00.000Z
PRD_1EG39D9B0TK0	CNT_3TQZA02K5SMG	Hollow Regalia CNT_1NP2JRB3GFRG	CNT_1NP2JRB3GFRG	2	2	1	Volume 6	[]	Hollow Regalia, Vol. 6	Three years after the Ploutonion closed and the world narrowly escaped destruction, humanity is slowly recovering. Although Yahiro and Iroha saved everyone, the pair’s whereabouts are unknown. One day, peace is disrupted when Galerie Berith receives notice that Moujuu have reappeared. Meanwhile, on a nameless island in the south, Yahiro and Iroha have been enjoying a laid-back lifestyle when a mysterious girl washes up on their shore. She is wary of Iroha yet seems quite familiar with Yahiro and the reality of their world. Then, suddenly, monsters attack! Not the Moujuu, but a new threat that appears to be…angels?!	01KG9QAD312FST1RTKVK8R8K2Z	6.0	2025-03-06T08:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1PQM5BDYSMG0	Hollow Regalia, Vol. 6	2025-09-16T07:00:00.000Z
PRD_1FBEH38KN04G	CNT_18RPZ8CWXAVG	Hollow Regalia CNT_1NP2JRB3GFRG	CNT_1NP2JRB3GFRG	2	2	1	Volume 4	[]	Hollow Regalia, Vol. 4	Yahiro and the others journey to Kyoto aboard Galerie Berith's armored train. There, they hope to discover the truth about Japanese people having transformed into moujuu. The train screeches to a halt when soldiers stationed at Nagoya demand a toll-the Regalia: a crimson gem that is...fusing with Ayaho?! There's no way Yahiro or Iroha will hand her over, but how will they keep everyone else safe and escape a barrage of attacks from soldiers and moujuu?	01KGAT362JVYT5Y7FFAVQ3XT08	4.0	2023-10-30T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Hollow Regalia, Vol. 4	2024-04-16T00:00:00.000Z
PRD_1WFY8VHH2HRG	CNT_3KVWATNFE3WG	Hollow Regalia CNT_1NP2JRB3GFRG	CNT_1NP2JRB3GFRG	2	2	1	Volume 2	[]	Hollow Regalia, Vol. 2	Yahiro Narusawa once lived alone in the ruins of Tokyo, but things have changed for him in the blink of an eye. Now his job is to protect a dragon medium—a girl named Iroha who wields the power of fire and the ability to summon a dragon. Yahiro’s sister, Sui, is also a dragon medium and responsible for the cataclysm that destroyed Japan. He’s been searching for her all this time, and he’s finally discovered that she’s allied with the shadowy organization Ganzheit. Determined to kill Sui for what she’s done, Yahiro agrees to work with arms dealer Galerie Berith to eliminate both her and the dragons. That said, Yahiro won’t have any trouble finding them, because the dragon mediums and their Lazaruses are coming for him!	01KGB618V0DM2XBPBVYJWM2BVJ	2.0	2023-03-14T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Hollow Regalia, Vol. 2	2023-08-22T00:00:00.000Z
PRD_2GMQA6XDZPJG	CNT_0QJBT0PTN09G	Hollow Regalia CNT_1NP2JRB3GFRG	CNT_1NP2JRB3GFRG	2	2	1	Volume 3	[]	Hollow Regalia, Vol. 3	When Iroha’s channel surpasses a million views overnight, Yahiro and the others know the reason can’t be anything good. As it turns out, a sleuthstreamer called Yamadou has exposed her as a dragon medium on his channel, and now the whole world is watching Iroha’s every move! Before Yahiro and Galerie Berith can do anything to retaliate, the Guild detains Yahiro…as a suspect for a rash of murders?! While Yahiro is away, the Galerie’s Japanese branch comes under attack by a foe with an old grudge. And with more Lazaruses appearing to shake things up, Iroha and her siblings may be in more danger than ever.	01KH3HK66JJ1SYYZSM8XQ1364D	3.0	2023-08-21T07:00:00.000Z	Yen On LAB_0TB60FJ75DX0	GEO_1KB2KYDQ0JGG	Hollow Regalia, Vol. 3	2023-12-12T00: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);