database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_0D1RBP1YZ880"

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_023PGQ9J3SE0	CNT_09JF1812CWFG	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 1	[]	The Fiancee Chosen by the Ring, Vol. 1	<P>Aurora el la Porta is a noblewoman with one love—the art of embroidery. While she attends the lavish evening parties her peers so adore, she’s not looking for a dance but inspiration for a new design! On one such night, distracted by the many beautiful dresses on display, she’s struck in the face by a mysterious wedding ring. When she picks it up, one of the finest knights in the kingdom approaches, declaring her his new fiancée! Aurora has no idea what’s going on, but one thing’s for sure—she’s got a big decision to make…</P>	01KGAGZYTKA1AH2C5K0BE85F41	1.0	2022-05-25T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Fiancee Chosen by the Ring, Vol. 1	2022-06-14T00:00:00.000Z
PRD_0MPBWS9ZG370	CNT_1W00Y6BXD0F0	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 4	[]	The Fiancee Chosen by the Ring, Vol. 4	It’s been a week since Aurora was offered a place at The Tower where she can dedicate each day to her embroidery without interruption. That has always been Aurora’s dream, so why is she hesitating when given that exact opportunity? Felix, on the other hand, isn’t quite as divided on the issue, and he’s pulling out all the stops to convince her to stay with him instead. One night, after an unexpected encounter, Aurora finally sorts out her conflicting feelings, but can she tell Felix before her resolve fades?	01KGB4FCNDYSEY2WSSH3SN1WGV	4.0	2023-02-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Fiancee Chosen by the Ring, Vol. 4	2023-05-23T00:00:00.000Z
PRD_1QP7FEXR1ZHG	CNT_2QQZBWFQ76G0	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 7	[]	The Fiancee Chosen by the Ring, Vol. 7	With the kidnapping incident behind her, Aurora and the others head back to the royal capital. Later, she’s summoned by Felix's mother and sister back to the Clavis estate, where she’s offered the opportunity to serve the crown princess as her lady-in-waiting...!?	01KKWPZK3WHB72DDBAEVKG5YG2	7.0	2025-09-17T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Fiancee Chosen by the Ring, Vol. 7	2026-03-24T00:00:00.000Z
PRD_25TNAP0VTMHG	CNT_20FRQRMP1YAG	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 5	[]	The Fiancee Chosen by the Ring, Vol. 5	As Aurora continues to prepare outfits for the Harvest Festival, she gets an unexpected visit from none other than Felix, who’s come to investigate the suspicious group that’s believed to be targeting primordial witches like Aurora. Determined to protect his fiancée at any cost, Felix is all too happy to serve as her bodyguard, which means that until the situation is resolved, they’ll be living together! Will Aurora be able to handle her new life under the same roof as her future husband?	01KH3G6KPMVXBYCPCTWBRVPYQZ	5.0	2023-08-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Fiancee Chosen by the Ring, Vol. 5	2023-12-12T00:00:00.000Z
PRD_299GF1YFPTFG	CNT_3EB1T74BJQY0	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 2	[]	The Fiancee Chosen by the Ring, Vol. 2	In an unexpected twist, Aurora and Felix have been invited to a party hosted by the Lumis family—Felix’s bitter rivals! While he’s more than a little suspicious of Yule’s intentions, one thing is clear—his fiancée will need a new dress, and she’s got the perfect design in mind! At an event like this, standing out is a must, and Aurora’s determined to steal the show—even if she has to raise a few eyebrows along the way…	01KGAJRT59XRB3GS5WQ1530J4S	2.0	2022-09-28T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Fiancee Chosen by the Ring, Vol. 2	2022-10-04T00:00:00.000Z
PRD_2D4GK6TXWZ50	CNT_0ZVVH0AAZZ2G	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 6	[]	The Fiancee Chosen by the Ring, Vol. 6	The Harvest Festival is in just three days. Aurora is scrambling to finish her embroidering in time, but she’s running low on the threads she needs! Meanwhile, the suspicious people searching for a primordial witch are still in town... Aurora convinces Luminox to let her step out to buy more thread, so long as she’s accompanied by Yule and Arabella. But when disaster strikes, will Felix be able to save her?	01KG9QCREREGXD9JHDX40C61EN	6.0	2025-03-19T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	The Fiancee Chosen by the Ring, Vol. 6	2025-03-25T07:00:00.000Z
PRD_2GVVEDYVTSX0	CNT_23V0BDRRYMZ0	The Fiancee Chosen by the Ring CNT_0D1RBP1YZ880	CNT_0D1RBP1YZ880	2	1	1	Volume 3	[]	The Fiancee Chosen by the Ring, Vol. 3	Aurora’s dignity hangs in the balance as Felix and his rival, Yule, brawl over her engagement with the heir of the Clavis family. But when their fight comes to a head, they are interrupted by none other than the Princess Royal herself! As more parties grow entangled in her affairs, Aurora begins to rethink her future and her feelings toward Felix—maybe there’s some truth to her so-called fake engagement after all?	01KGB2QVX0M5FQVFVFW1F2FSDS	3.0	2022-12-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	The Fiancee Chosen by the Ring, Vol. 3	2022-12-13T00: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);