database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_217VAD8C0BK0"

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_1N7T55YG32E0	CNT_169BGNG8HXD0	The Troubles of Miss Nicola the Exorcist CNT_217VAD8C0BK0	CNT_217VAD8C0BK0	2	2	1	Volume 2	[]	The Troubles of Miss Nicola the Exorcist: Volume 2	Overcome with survivor's guilt, Nicola von Weber plans to visit the grave of a vanquished foe. In this journey, the usual suspects who constantly consult her on matters of the occult—Sieghart, Alois, and Ernst—accompany her, along with two new faces. The young adventurers' weekend trip away from the royal capital to the March of Ludendorff and Luneburg turns into one filled with pleasant and horrific surprises. How will Nicola resolve a ghoulish conspiracy involving the disappearances of a number of children from a lakeside town? And what will become of her budding romance with Sieghart as her father's imminent elevation to the rank of marquess has made her a candidate for marriage to the prince? Although Nicola knows she will never marry Alois, she is unsure about doing so with Sieghart...	Having barely averted the consequences of a fatal curse she placed on a foe, Nicola departs on a journey of redemption. How will she cope with an even more terrible threat? Will she find room in her heart for Sieghart, her adoring childhood friend?	01KH3G9DHR4NFYDQTTHMT3BNBG	2.0	2023-09-01T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Troubles of Miss Nicola the Exorcist: Volume 2	Copyright © Ito Iino, Kinokohime 2023	2023-11-02T07:00:00.000Z
PRD_29BTYR10QYT0	CNT_237F295GFGZG	The Troubles of Miss Nicola the Exorcist CNT_217VAD8C0BK0	CNT_217VAD8C0BK0	2	2	1	Volume 3	[]	The Troubles of Miss Nicola the Exorcist: Volume 3	Winter has arrived at the Royal Academy, bringing the annual student ball. Whoever one takes as their partner in the first dance is expected to become the person's future spouse. As such, Nicola and Sieghart prepare to reveal their engagement to the world. Jealous actors, however, seek to destroy their love by inflicting whatever carnage they deem necessary. Romance and horror play second and third fiddle to a bona fide mystery in this final installment. After all they've been through together, will Nicola and Sieghart let anyone tear them apart? And what do these goings-on, if anything, have to do with the latest series of ghost stories students have been spreading around the school?	Nicola and Sieghart announce their engagement by sharing the first dance at the winter ball—spurring jealous actors to take action. With just six months until Sieghart graduates, will they escape peril, surrounded by fell spirits and spiteful nobles?	01KH3QN1S6RBAT0AZ6H1E447G4	3.0	2024-04-24T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Troubles of Miss Nicola the Exorcist: Volume 3	Copyright © Ito Iino, Kinokohime 2024	2024-07-22T07:00:00.000Z
PRD_2YAG9PRNQPNG	CNT_28D8CMBX65N0	The Troubles of Miss Nicola the Exorcist CNT_217VAD8C0BK0	CNT_217VAD8C0BK0	2	2	1	Volume 1	[]	The Troubles of Miss Nicola the Exorcist: Volume 1	After an untimely death, a Shinto exorcist finds herself reincarnated into another world as Miss Nicola von Weber. And that's just the start of her troubles. On Nicola's first day at a new school, she's reunited with her childhood friend Sieghart. He's now a handsome marquess who acts like a spoiled child around her, and wherever he goes, strange incidents follow. You see, Sieghart's beauty attracts both people and...otherworldly admirers. Nicola thus has to put her homework aside and use her skills as an exorcist to save him—all while trying to avoid his inevitable proposal, for Sieghart once swore he'd never marry anyone but her. And so Nicola's hectic, haunted life continues with a splash of romance, which she almost finds more annoying than the ghosts. All Nicola wants is normalcy, and this is the story of how she'll (try to) get it.	What's worse? Spirits that need exorcising, or the one-sided romantic overtures of your childhood friend who far outranks your entire family in the aristocratic pecking order? Well, after reincarnating in a new world, Nicola must deal with both.	01KH3ECRXDYCETR7W0F1HGHXKE	1.0	2023-06-02T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Troubles of Miss Nicola the Exorcist: Volume 1	Copyright © Ito Iino, Kinokohime 2023	2023-08-04T07: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);