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

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_0A9J3113FDX0	CNT_20Z95VWSAHB0	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 3	[]	The Witch and the Beast 3	Guideau and Ashaf's next assignment puts them in pursuit of the youthful witch Helga, but they'll have to contend with the illustrious Paladin Corps to secure their target. Helga herself has every intention of keeping her freedom—an aim better served if only her demon sword Ashgan would cooperate. With dark secrets plaguing all sides, just who will triumph in this free-for-all?	01KG9DFR0ZZR7KTKS237SS6A5K	3.0	2020-11-18T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 3	Kousuke Satake / Kodansha Ltd	2020-12-08T08:00:00.000Z
PRD_0MD174Q97QGG	CNT_2GAN4V3VB3YG	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 10	[]	The Witch and the Beast 10	THE SILENT MYSTERY Ten days have passed since the siege on the Paladin stronghold where stores of forbidden instruments were kept under lock and key. Ashaf leaves one such instrument, which takes the form of a child, in Guideau's care until a method to contain its ability to absorb magic is secured. Meanwhile, Paladin Cugat finds himself at the Executioners' doorstep, lured by Oakleave's invitation to the shadowy organization...	01KGB4ASGF71DRZBADP7K6YECG	10.0	2023-01-24T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 10	Kousuke Satake/Kodansha Ltd.	2023-02-14T08:00:00.000Z
PRD_0RD5QM5KA8F0	CNT_1RKXF58P137G	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 6	[]	The Witch and the Beast 6	In pursuit of Angela, Guideau and Ashaf venture into the Fall—an immeasurably deep chasm that acts as a portal to other worlds, including the land of vampires, Orlencia Sett. As outsiders, the pair must rely on two envoys from the Order to navigate this unfamiliar territory. However, Guideau and Ashaf soon find themselves ensnared in a self-serving plot orchestrated by one of their companions, a plot that could upset the status quo of the vampire underworld...	01KG9FQ4YH40Q800PQEZ74YK9X	6.0	2021-07-08T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 6	Kousuke Satake / Kodansha Ltd.	2021-07-20T07:00:00.000Z
PRD_0VT4QX1BD190	CNT_2ESPC010CC5G	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 5	[]	The Witch and the Beast 5	An unexpected encounter with Angela, the witch responsible for Guideau's curse, leaves Guideau in a primal, beast-like state. The regression calls to Ashaf's mind the time the pair had first met—it was in a village out in the countryside, a place supposedly untouched by magic, but where rumors of a witch began to poison the community...	01KG9FK1GWG34C8JP3EAJP8MNR	5.0	2021-06-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 5	Kousuke Satake / Kodansha Ltd.	2021-06-22T07:00:00.000Z
PRD_0X4BT3RR0QX0	CNT_3BCF6T0YNC60	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 8	[]	The Witch and the Beast 8	A NEW DAWN Dunward, Oscar, and Ashaf finally come face to face with the Queen of the Night. The encounter reopens old wounds for Dunward, and he must make a critical decision if he hopes to have his revenge. Meanwhile, unbeknownst to those in the fray, Guideau and a new weapon are not far behind...	01KGAE4852S1M3D2NTD6SJV2TW	8.0	2021-12-23T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 8	The Witch and the Beast Kousuke Satake/Kodansha Ltd.	2022-02-08T08:00:00.000Z
PRD_1FSH0YQHFQF0	CNT_1Y11YE38TWNG	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 1	[]	The Witch and the Beast 1	Ashaf: a soft-spoken man with delicate features, a coffin strapped to his back, and an entourage of black crows. Guideau: a feral, violent girl with long fangs and the eyes of a beast. This ominous pair appear one day in a town in thrall to a witch — a ruler with magic coursing through her tattooed body, who has convinced the townsfolk she's their hero. But Ashaf and Guideau know better. They live by one creed: "Wherever a witch goes, only curses and disasters follow." They have scores to settle, and they won't hesitate to remove anyone in their way, be it angry mob or army garrison. A dark fairytale set in a steampunk world of magic and monsters, The Witch and the Beast will entice and entrap manga readers looking for their next fantasy action fix!	01KG9CCMWZZWVF2MME369REYW5	1.0	2020-09-17T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 1	The Witch and the Beast Kousuke Satake / Kodansha Ltd	2020-10-27T07:00:00.000Z
PRD_25Y4EBPAT0VG	CNT_3PDW7B24N4DG	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 4	[]	The Witch and the Beast 4	Paladin Corps officer Matt Cugat joins forces with Guideau and Ashaf in one last stand to protect the demon sword Ashgan from falling into the wrong hands–but their efforts are no match for the Executioner's clever ruse. As all bear witness to the ancient weapon's awakening, what sort of terrible calamity awaits? And is there anything that can be done to stop it?	01KG9DYHBHF6GPTP2CZE2VV122	4.0	2021-01-27T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 4	Kousuke Satake / Kodansha Ltd	2021-02-09T08:00:00.000Z
PRD_2Q4D32CC4XH0	CNT_0MXH42K1HA5G	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 9	[]	The Witch and the Beast 9	THE PULLED THREAD Their business in the Fall finally concluded, Guideau and Ashaf next find themselves in a city teeming with artisans specializing in magical tools. Amid the trivial and frivolous, Guideau is drawn to a mysterious doll said to have a deep connection with a witch. Could it finally be a new clue for tracking down Angela? If only the obstinate shopkeeper would be willing to part with it...	01KGAJC20F3SBZFVWWDB7YDX3R	9.0	2022-08-02T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 9	The Witch and the Beast Kousuke Satake/Kodansha Ltd.	2022-08-23T07:00:00.000Z
PRD_2S75T4J733Z0	CNT_2Z6ZVR9E685G	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 2	[]	The Witch and the Beast 2	After a routine job, Ashaf and Guideau have a run-in with a berserk "undead"—a deceased human being restored to life through the art of necromancy. Though the city strictly regulates the practice, these aberrant cases have only been growing in number. In his stead, Ashaf recommends his colleague Phanora and her assistant Johan, though the pair is as much a mystery as the one they intend to solve...	01KG9DBJQTXNG7X7YMWNBJJKBN	2.0	2020-10-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 2	The Witch and the Beast Kousuke Satake / Kodansha Ltd	2020-11-17T08:00:00.000Z
PRD_3RRDSTEKP9YG	CNT_2XFYKQSWFX10	The Witch and the Beast CNT_06WBPNH32YD0	CNT_06WBPNH32YD0	2	1	1	Volume 7	[]	The Witch and the Beast 7	THE LONG NIGHT Guideau and Ashaf continue their mission in Orlencia Sett alongside Dunward and Oscar, with tensions running high as each party is anxious to achieve their goals. To reach the Queen of the Night, they must first make contact with the Bridge—a mediator among the deeply divided vampire factions, known for his peculiar taste for flesh...	01KG9HB94F8ZSN8CARWR820VMW	7.0	2021-10-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Witch and the Beast 7	The Witch and the Beast Kousuke Satake/Kodansha Ltd.	2021-11-09T08: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);