database: products: 12 rows where series_id = "CNT

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

12 rows where series_id = "CNT_3WTNBSB6ZV8G"

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_0J2X9TMV4E1G	CNT_3BAKMC6CQP9G	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 10	[]	Earl and Fairy: Volume 10	Edgar has entrusted Lydia to Kelpie in order to protect her from the Prince. Although she promised to marry Edgar just before they parted, the water horse's magic has robbed her of her memories of him. Meanwhile, a mysterious disease spreads through London's East End. It is said that the only way to survive it is to board the Ark, a mysterious vessel moored near London Bridge. Edgar cannot help but suspect the Prince's involvement...	Edgar travels to Scotland to retrieve Lydia, only to find that Kelpie has stolen her memories. Meanwhile, a mysterious vessel known as the "Ark" appears on the Thames, bringing with it the promise of salvation...	01KGBK9PZGRVERWXE86VWE68H3	10.0	2025-01-21T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 10	Earl and Fairy © 2007 by Mizue Tani Illustration by Asako Takaboshi	2025-03-27T07:00:00.000Z
PRD_22J1GVJRSSX0	CNT_15AY1X0SK8YG	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 3	[]	Earl and Fairy: Volume 3	Fairy doctor Lydia has been hired by Edgar, a smooth-talking earl with a tattered past. Her ability to see and talk to fairies proves invaluable when his London estate is visited by a tiny fairy of the field. The fairy has come to fetch the Blue Knight Earl—Edgar—to marry the Fairy Queen. Unfortunately, the moon-embedded ring to complete the proposal has been stolen! Not only that, but Lydia has to deal with the reappearance of a wild kelpie from her hometown—one who also has his sights set on marriage...	A tiny fairy arrives to take Edgar away to marry the Fairy Queen. But the ring has been stolen by none other than an old acquaintance of Lydia's. A wild kelpie, he vows to take her back to Scotland and away from her post as Edgar's fairy doctor...	01KH3FWTA70PC8RSVBD5E2K1GM	3.0	2023-07-12T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 3	Earl and Fairy © 2005 by Mizue Tani Illustration by Asako Takaboshi	2023-09-21T07:00:00.000Z
PRD_28B3YD2Z46QG	CNT_2DGWQVSXHRCG	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 9	[]	Earl and Fairy: Volume 9	Lord Edgar Ashenbert is more eager than ever to marry his fairy doctor, Lydia Carlton. Having developed a deeper understanding of him, Lydia has found herself unable to spurn him the way she did before. Meanwhile, London has been plagued by a series of gruesome murders that seem to be linked to Edgar's mortal enemy: the Prince. For the sake of Lydia's safety, the earl insists that she come to stay with him at his estate. And thus the two suddenly end up living under the same roof...	A series of gruesome murders with links to the Prince leaves Edgar concerned. For the sake of Lydia's safety, he insists that she stay with him at his estate—all at a time when she is already more confused about her feelings than ever...	01KGBG1Z69F1N3J7F4MXXR8BXX	9.0	2024-10-23T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 9	Earl and Fairy © 2006 by Mizue Tani Illustration by Asako Takaboshi	2025-01-09T08:00:00.000Z
PRD_29K9K940NW40	CNT_00VA79MYRCJ0	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 5	[]	Earl and Fairy: Volume 5	Much to her chagrin, fairy doctor Lydia has failed to convince her employer, Earl Ashenbert, to call off their engagement. As much as she tries to see through his flirtations, he still seems to have her wrapped around his little finger. The appearance of the moonstone's steward, a small fairy called a coblynau, doesn't help—it turns out he's a strong supporter of their union! Meanwhile, Edgar comes into possession of a cursed black diamond that is said to bring its owner great misfortune. Just how does it tie into his revenge against the Prince?	Lydia is still struggling to make Edgar call off their engagement, and matters are only complicated when the moonstone's fairy steward shows up in support of their union. Meanwhile, Edgar obtains a cursed diamond. Just what might he need it for?	01KG9PG1D28P9Z965AMCG7C7F5	5.0	2023-12-21T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 5	Earl and Fairy © 2005 by Mizue Tani Illustration by Asako Takaboshi	2024-03-14T07:00:00.000Z
PRD_2MW4HBPH1ST0	CNT_1SJC7ZN163N0	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 4	[]	Earl and Fairy: Volume 4	The tabloids are full of rumors of scandals surrounding Edgar, but Lydia is insistent that she doesn't care. Their engagement was nothing more than a temporary measure to get out of her agreement to forsake the human world for that of the fairies, after all, and to leave behind the wild and unpredictable kelpie. Edgar, however, seems to be taking it much more seriously—as seriously as a man like him can, anyway. But with the arrival of the latest story, in which he has allegedly found himself a lover in the form of a ghost, things start to unfold in a very unexpected way.	Edgar is taking his temporary engagement to Lydia seriously—much to her chagrin. His words conflict with the tabloids, which claim he has been wooing women left and right. But surely the story that he is pursuing a ghost is too ridiculous to believe?	01KGASNQ69NMWRF7BTKGXC8WG3	4.0	2023-09-22T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 4	Earl and Fairy © 2005 by Mizue Tani Illustration by Asako Takaboshi	2024-01-12T08:00:00.000Z
PRD_2P0PGCPPM7DG	CNT_2WT3HBFQ54RG	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 12	[]	Earl and Fairy: Volume 12	In this series of short stories—set before Lydia officially accepts Edgar's proposal—Lydia first finds herself confronted by her self-proclaimed future child, who announces that she must marry Edgar or he will not be born. But could he really be theirs? Next, a mysterious nightingale fairy educates Lydia in the ways of love. And finally, this volume also includes the romantic and mystical tale of the marriage of Lydia's parents, whose secrets are to be revealed at last!	In this selection of short stories set before Lydia accepts Edgar's proposal, meet their self-proclaimed future son, learn from a nightingale with strange ideas about love, and discover the secrets of Lydia's parents and their marriage.	01KP4DXTW3NJHBJYBXY3AWZYW6	12.0	2026-02-06T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 12	Earl and Fairy © 2007 by Mizue Tani Illustration by Asako Takaboshi	2026-04-28T07:00:00.000Z
PRD_2Z1RBCE87JP0	CNT_21XV3GEEVMKG	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 6	[]	Earl and Fairy: Volume 6	Fairies may kidnap a human child and replace it with their own offspring: a changeling. Now, it seems that such an incident took place in one of the Blue Knight Earl's territories, so Lydia, Edgar's fairy doctor and reluctant fiancée, sets off by herself to investigate. Meanwhile, the earl is visited by some old pirate friends whom he would have preferred to have stayed in his past. They tell him that their companion, Betty, has been kidnapped by someone claiming to be the Blue Knight Earl, but this is the first Edgar's heard of it...	While Lydia heads for a rural village to investigate a changeling, Edgar is visited by some old pirate friends, who accuse him of kidnapping. It soon becomes clear that the cases hold a common link: an impostor calling himself the Blue Knight Earl...	01KH3QN0T7XSDGY7GFKYDR9ZS2	6.0	2024-04-24T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 6	Earl and Fairy © 2005 by Mizue Tani Illustration by Asako Takaboshi	2024-06-27T07:00:00.000Z
PRD_35TF0FW3P1D0	CNT_3RWWNDGKX5F0	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 8	[]	Earl and Fairy: Volume 8	Lydia Carlton is a girl who can see and talk to fairies. After being hired by Lord Edgar Ashenbert as a fairy doctor, she found herself engaged to him. Though it was supposed to be a measure to protect them against some persistent fairies, Edgar is taking it far more seriously than that. This volume comprises a number of short stories from the early days of Lydia's employment. There are also tales set before the pair met, including Lydia's first encounter with Kelpie and her first experience with heartbreak.	Lydia Carlton is a fairy doctor employed by the Earl of Ibrazel, Edgar Ashenbert. In this collection of short stories, find out about Lydia's first client, how she met Kelpie, and enjoy some extra tales of fairy-related mischief!	01KGBCB544EFEKG47Y60NPGPQ3	8.0	2024-08-20T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 8	Earl and Fairy © 2006 by Mizue Tani Illustration by Asako Takaboshi	2024-10-31T07:00:00.000Z
PRD_3H61V3NXHCNG	CNT_2AVAYTRBCBN0	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 2	[]	Earl and Fairy: Volume 2	Fairy doctor Lydia Carlton has been hired by Lord Edgar Ashenbert at his London residence, where she's forever caught between his smooth talk and constant advances. But Lydia has bigger things to worry about when she's attacked in the park one day by a culprit resembling the Fogman, a most ominous fairy. Just as she makes it back to Edgar's, she is visited by a lone woman seeking help to find the baron's daughter. Could the Fogman be related to the case? And what of the mysterious Fairy's Egg that is said to have been lost to time?	Edgar has hired Lydia as his personal fairy doctor. Just as it seems he has no intention of using her skills, he introduces her to a woman seeking help to find the baron's lost daughter. Can Lydia put her abilities to good use and solve the case?	01KGB7TRFW43SVKK3R2FG081HW	2.0	2023-05-16T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 2	Earl and Fairy © 2004 by Mizue Tani Illustration by Asako Takaboshi	2023-07-13T07:00:00.000Z
PRD_3MJNEAA7DQVG	CNT_0Y0G7R7S065G	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 11	[]	Earl and Fairy: Volume 11	Lord Edgar Ashenbert and his fairy doctor, Lydia Carlton, are officially engaged at last. While Edgar is eager for them to be wed as soon as possible, Lydia is overwhelmed by the preparation required for marrying into nobility. Wishing to debut without fear, she swallows her anxieties and agrees to stay with a countess famed for teaching young women how to behave in upper-class society. However, when she gets there, she finds herself inexplicably working as a maid. Meanwhile, Edgar is visited by an unfamiliar young lady who claims that she is his fiancée—and it seems she won't take no for an answer!	Trouble abounds as Lydia and Edgar prepare for their wedding. While Lydia travels to Somerset to learn to be a countess, Edgar is visited by an unfamiliar young lady who claims that she is his fiancée—and it seems she won't take no for an answer!	01KGBR730A1ZD14HS1S3Z2Z4JS	11.0	2025-06-13T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 11	Earl and Fairy © 2007 by Mizue Tani Illustration by Asako Takaboshi	2025-09-09T07:00:00.000Z
PRD_3SAAW9BP81VG	CNT_31E2HP02YMHG	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 7	[]	Earl and Fairy: Volume 7	Fairy doctor Lydia Carlton has returned to her hometown in Scotland for a well-earned rest. Taking an extended Christmas vacation was a fine excuse, but the truth is that she feared falling in love with her employer and would-be fiancé, Edgar Ashenbert, the Earl of Ibrazel. The history of his title is a complex affair, and when she hears a mysterious rumor about the earl's forefather, Lydia heads to the Isle of Mannan to investigate. Meanwhile, a strange girl appears before Paul, Edgar's artist friend in London, and it soon transpires that she isn't exactly human...	During her time away from Edgar, Lydia hears an impossible rumor about the Blue Knight Earl. To investigate, she sets out for the Isle of Mannan to consult with the merrows. Meanwhile, Paul has a mysterious encounter with a fairy in London...	01KGBAYJ8ECPEYPH76BC32ED5V	7.0	2024-06-17T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 7	Earl and Fairy © 2005 by Mizue Tani Illustration by Asako Takaboshi	2024-08-29T07:00:00.000Z
PRD_3Y9X7KPAHXC0	CNT_1V77BFY2BG80	Earl and Fairy CNT_3WTNBSB6ZV8G	CNT_3WTNBSB6ZV8G	2	2	1	Volume 1	[]	Earl and Fairy: Volume 1	Lydia Carlton is a fairy doctor who can see and communicate with fairies. When she embarks on a journey overseas to visit her father in London, she's kidnapped by a young man named Edgar Ashenbert who introduces himself as an earl and requests Lydia's aid in searching for a treasured sword that will prove his status. Although she finds his story dubious, Lydia agrees to work with him—if only because he's her first real client. Meanwhile, rumors of a heinous burglary abound, and the culprit seems to bear an uncanny resemblance to Edgar...	On her way to visit her father in London, fairy doctor Lydia is abducted by a man claiming to be an earl. To prove his identity, he asks for her help finding a legendary sword... Could his resemblance to an infamous thief be mere coincidence?	01KGB6M5KW5HG81E595NR8GJC5	1.0	2023-03-09T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	Earl and Fairy: Volume 1	Earl and Fairy © 2004 by Mizue Tani Illustration by Asako Takaboshi	2023-05-11T07: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);