database: products: 16 rows where series_id = "CNT

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

16 rows where series_id = "CNT_2BGF8M42M370"

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_03MDARJ9MJR0	CNT_3T4MH12X46V0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 5	[]	The Apothecary Diaries: Volume 5	The political situation at court has changed: the birth of Gyokuyou's son has seen her elevated to the status of Empress, and meanwhile Jinshi is no longer able to continue his pretense at the rear palace. Although all seems peaceful after the destruction of the Shi clan, threats continue to loom—not least a potential plague of insects—and Maomao, as ever, somehow finds herself caught up in them. When Jinshi orders an expedition to Gyokuyou's homeland, Maomao heads west. But is there something lurking in the shadows of the glittering city? And will Maomao be able to discover what it is before it's too late?	When Jinshi orders an expedition to Gyokuyou's homeland, Maomao heads west. But is there something lurking in the shadows of the glittering city? And will Maomao be able to discover what it is before it's too late?	01KGADB09W3K0K6Q5R74Z8WA8V	5.0	2022-01-14T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 5	Copyright (C) Natsu Hyuuga 2016	2022-05-09T07:00:00.000Z
PRD_04EA9DTH3PV0	CNT_3J5XFD1G40BG	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 3	[]	The Apothecary Diaries: Volume 3	Maomao must help keep Consort Gyokuyou safe during her pregnancy. An imperial consort being with child is supposed to be a matter of the utmost secrecy, but this is the rear palace, where maneuvering and backstabbing are as commonplace as banter and tea parties. Threats seem to lurk around every corner—but it's not just the rear palace keeping busy. Jinshi finds himself struggling to entertain a most unusual request from a pair of visiting ambassadors. Later, he's invited to an important gathering in a faraway place—but who knows what dangers might be waiting for him?	With Consort Gyokuyou pregnant, threats seem to lurk in every corner of the rear palace. When Jinshi goes to a faraway land to be part of an important gathering, however, Gyokuyou may not be the only one in danger...	01KG9FGKR636BNCRP3F10A1VCR	3.0	2021-05-20T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 3	Copyright (C) Natsu Hyuuga 2015	2021-09-14T07:00:00.000Z
PRD_0HKTFDZGHP0G	CNT_0AKV4VTG56PG	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 11	[]	The Apothecary Diaries: Volume 11	I-sei Province is still reeling in the aftermath of the insect plague. Jinshi resolves to do everything in his power to help the people of this land—but how far does his power really go in the western capital? And will he regret his efforts when all the credit seems to go to Gyoku-ou? The local lord seems to have an agenda of his own, but Jinshi still doesn't know what it might be. Meanwhile Maomao must deal with problems of her own, from finding relief for a sick child to unraveling the mystery around the freak strategist's favorite Shogi opponent. Somehow, each answer only seems to lead her to a bigger question...	As I-sei Province reels from the insect plague, each mystery Maomao solves only seems to lead toward a greater question...	01KGAY112M58AA1VSHE1FWS11S	11.0	2024-01-30T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 11	Copyright © Natsu Hyuuga 2021	2024-05-20T07:00:00.000Z
PRD_0WKZXXBT4WNG	CNT_16KB8MR26EQ0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 6	[]	The Apothecary Diaries: Volume 6	The events in the western capital threaten to shake not only the political order, but Maomao's personal relationships as well, and she departs the city uncertain what her future holds. A detour on the way home, however, gives her an unexpected insight into her own family. Meanwhile, Consort Lishu finds herself at the center of an ugly scandal. Might the truth of the matter help explain everything that's happened recently?	Maomao leaves the western capital with her future uncertain, while Consort Lishu encounters fresh difficulties when she finds herself at the center of an ugly scandal.	01KGAGT6MX3ZG7DRXM9P5Q63W0	6.0	2022-06-17T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 6	Copyright © Natsu Hyuuga 2016	2022-10-10T07:00:00.000Z
PRD_111GXC3ZD210	CNT_3T45MBR5EZD0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 8	[]	The Apothecary Diaries: Volume 8	The whole capital seems to have gone Go-crazy when Lakan publishes a book about his games. He's got even bigger plans, holding a Go tournament that's open to all—and rumor has it that if anyone can topple the strategist himself, he'll grant them any single request they might ask. Jinshi sees an opportunity. But it's not all fun and games, as Jinshi learns when reports arrive of crops devastated by a plague of locusts in a remote village. All his attempts to forestall the insects' devastation will soon be put to the test, and the outcome may mean survival or starvation.	A Go tournament featuring Lakan holds a tantalizing prize for Jinshi, but a plague of locusts threatens destruction in Li.	01KGB5P1CD8XFAERR9NQ2T079T	8.0	2023-02-17T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 8	Copyright © Natsu Hyuuga 2019	2023-05-29T07:00:00.000Z
PRD_1GPC6ZPW86MG	CNT_35439MX25RW0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 12	[]	The Apothecary Diaries: Volume 12	The tumultuous political events of recent days have left I-sei Province looking for leadership, but there are obstacles everywhere they turn. Gyokuen's sons refuse to rule, while Gyoku-ou's oldest child is unpredictable and violent. Jinshi decides to tutor Gyoku-ou's other sons in the ways of politics, but they're going to discover that it's an even more dangerous business than they ever anticipated. Maomao, as ever, just wants to live her life, but she might not be able to ignore the escalating perils around her. In fact, they might not ignore her...	Jinshi decides to tutor Gyoku-ou's sons in the ways of politics, but they're going to discover that it's an even more dangerous business than they ever anticipated...	01KGBARHPSRS3179DY4ZTBYFDN	12.0	2024-06-06T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 12	Copyright © Natsu Hyuuga 2022	2024-10-14T07:00:00.000Z
PRD_227DS1DJFYH0	CNT_29F01JECB8E0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 10	[]	The Apothecary Diaries: Volume 10	Maomao finds herself once more in the western capital. She tries to focus on her work—which isn't made any easier when she's paired with not just the quack doctor but the smart-mouthed young physician Tianyu. Meanwhile, Jinshi might be the Imperial younger brother, but the western capital has its own hierarchies, both obvious and hidden. He and the other visitors from the court will have to navigate these halls of power even more carefully than usual, lest they run afoul of enemies they don't even know they have. Over it all looms the threat of the insect plague, which seems insurmountable—until one man claims to know how to counter the menace. His method is intimately connected to secrets buried deep in the region's past.	An insect plague is only the most obvious threat Maomao and Jinshi face on their second journey to the western capital.	01KGASS9S10YKQ01PH17V5VEME	10.0	2023-10-03T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 10	Copyright © Natsu Hyuuga 2021	2024-01-18T08:00:00.000Z
PRD_2DBSD9MATGGG	CNT_1MRX99NEPZA0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 9	[]	The Apothecary Diaries: Volume 9	Maomao has effectively become Jinshi's personal physician, but she's just a simple apothecary. If she's going to give him proper medical treatment, she'll need more than her meager surgical skills. When she turns to her father for help, he says he'll only teach her if she can pass a test he sets for her. Even if she succeeds at his mysterious request, however, the truth behind the practice of surgery at court may be more than she cares to know. And only once she has the knowledge she needs will she be able to accompany Jinshi on what could be his most dangerous journey yet.	Maomao knows Jinshi's secret, but to continue to keep it, she'll have to do the one thing her father forbids in order to pass her most difficult trials yet.	01KH3FVZFVNXD4X7ZXS0FPP298	9.0	2023-06-16T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 9	Copyright © Natsu Hyuuga 2020	2023-10-09T07:00:00.000Z
PRD_2DR95E4AXQN0	CNT_0N45BCR0B400	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 16	[]	The Apothecary Diaries: Volume 16	Weeks have passed since the successful surgery on the Emperor, and winter is coming on. Now that the upper physicians have taken over postsurgical care, Maomao's daily life is both getting back to normal and getting busier. One day, a letter arrives for Dr. Lao that makes Yo go pale. It reports a rise in patients with pustules... Maomao has a bad feeling about this, and as ever, it proves correct—there's been a smallpox outbreak. Contagious and often deadly, survivors of smallpox are often left scarred for life. There is no known cure, and even Maomao can't invent one out of thin air. An entire village has already been quarantined to contain the outbreak. Yet in these desperate circumstances, there's one ray of hope...	After the successful surgery on the Emperor, a letter arrives reporting a rise in patients with pustules. There's a smallpox outbreak, and an entire village has been quarantined to contain it! Yet in these desperate times, there's one ray of hope...	01KRXVSKG8KSGVDFAFRV747MRB	16.0	2026-01-30T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 16	Copyright © Hyuganatsu 2025	2026-05-29T07:00:00.000Z
PRD_2E9D02FMXBJG	CNT_0AGBYB64K7WG	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 7	[]	The Apothecary Diaries: Volume 7	Maomao attempts the court service exam once more, winning herself a position as an assistant in one of the medical offices. That's only the beginning of her troubles, though, as a new consort enters the rear palace and brings new riddles with her. What does a former emissary to the court want with three young medical assistants? How is that connected to a mysterious shrine maiden from Shaoh? And will one particular monocled freak ever just mind his own business?	Maomao becomes an assistant in one of the palace medical offices, but the arrival of a new consort in the rear palace brings fresh mysteries.	01KGB48X090X90C5Z64JCE76RB	7.0	2023-01-16T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 7	Copyright © Natsu Hyuuga 2018	2023-03-01T08:00:00.000Z
PRD_31RGPEX2M2XG	CNT_2P1FNVFB3TDG	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 14	[]	The Apothecary Diaries: Volume 14	No sooner is Maomao settled back in the royal capital than she's dragged off to a meeting of the named clans, and despite the posh surroundings, intrigue is the order of the day. Old grudges come to the surface, new ones threaten to break out into fights, and...is that a hint of love in the air? Maomao will have to navigate the twisting politics and conflicting priorities of the different clans—including hers—if she wants to survive one of the liveliest meetings around!	No sooner is Maomao settled back in the capital than she's dragged off to a meeting of the named clans, and intrigue is the order of the day. She'll have to navigate the twisting politics of the different clans—including hers—if she wants to survive!	01KGBK9VAETS74EP20K81EABRD	14.0	2025-01-21T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 14	Copyright © Hyuganatsu 2023	2025-05-30T07:00:00.000Z
PRD_34VRK7MVAWX0	CNT_3ZM5809WBEP0	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 13	[]	The Apothecary Diaries: Volume 13	Maomao, Jinshi, and the others finally return to the royal capital to discover that life went on while they were away: Lahan is still working his abacus, Maamei is still pondering the future of both the Ma clan and her little brother Basen, and Yao and En'en are still pursuing their dreams (to become a doctor and to geek out over Yao, respectively). Maomao might have hoped that things would quiet down now that she no longer has to deal with locust swarms and succession crises, but it turns out things are livelier than ever as she reconnects with people and places she hasn't seen in almost a year. Meanwhile, the seeds of a new mystery are being planted...	Maomao, Jinshi, and the rest finally return to the royal capital and reconnect with people and places they haven't seen in almost a year. It's good to know that some things never change; meanwhile, the seeds of a new mystery are being planted...	01KGBG0R35MYEDJHYRJK2H3C59	13.0	2024-10-22T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 13	Copyright © Hyuganatsu 2023	2025-01-14T08:00:00.000Z
PRD_3FS5E8F6RQQG	CNT_0YV01DCTKV1G	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 1	[]	The Apothecary Diaries: Volume 1	In the East is a land ruled by an emperor, whose consorts and serving women live in a sprawling complex known as the hougong, the rear palace. Maomao, an unassuming girl raised in an unassuming town by her apothecary father, never imagined the rear palace would have anything to do with her—until she was kidnapped and sold into service there. Though she looks ordinary, Maomao has a quick wit, a sharp mind, and an extensive knowledge of medicine. That's her secret, until she encounters a resident of the palace at least as perceptive as she is: the head eunuch, Jinshi. He sees through Maomao's façade and makes her a lady-in-waiting to none other than the Emperor's favorite consort... so she can taste the lady's food for poison! At her lady's side, Maomao starts to learn about everything that goes on in the rear palace—not all of it seemly. Can she ever lead a quiet life, or will her powers of deduction and insatiable curiosity bring her ever more adventures, and ever more dangers?		01KG9CFFRMKX275XXB2P63WD58	1.0	2020-11-25T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 1	Copyright (C) Natsu Hyuuga 2014	2021-02-14T08:00:00.000Z
PRD_3SWY4Z35QTSG	CNT_296XHZ2SME60	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 4	[]	The Apothecary Diaries: Volume 4	Though her main duty is still looking after Consort Gyokuyou, Maomao finds time to help her friends and acquaintances in the rear palace, including Xiaolan, who will need a job after her term of service ends, and Consort Lishu, who's convinced she's seen a ghost! When complications arise with Gyokuyou's pregnancy, however, Maomao knows she's not skilled enough to handle a situation that could threaten the life of both mother and child. She knows someone who is, but they haven't been welcome in the rear palace for a very long time... Meanwhile, Maomao begins to discern what seem to be links between otherwise unrelated incidents in the rear palace. But what if her dawning knowledge makes her the next victim?	When complications arise with Consort Gyokuyou's pregnancy, Maomao knows only one person skilled enough to help, but will they even be allowed in the rear palace?	01KG9FSDWZVH3SYCY8W1QT0ZD1	4.0	2021-09-03T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 4	Copyright (C) Natsu Hyuuga 2015	2022-01-07T08:00:00.000Z
PRD_3T84S6318FMG	CNT_37H646PBTE4G	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 15	[]	The Apothecary Diaries: Volume 15	While pursuing the secret of the mysterious jade, Maomao and Jinshi found more than just the tablet's owner—they've also discovered a forbidden book that has long lain hidden. As the book is gradually reconstructed, they discover that the knowledge and secrets within might be extremely important to someone very unexpected. Meanwhile, Maomao finds herself helping her father Luomen in what appears to be a large-scale drug trial...but what are they treating? And why?	Maomao and Jinshi have discovered a forbidden book, and the knowledge it contains might be extremely important to someone very unexpected. Maomao's father Luomen appears to be doing a large-scale drug trial...but what is he treating?And why?	01KGBQ8JHQFW55QDKHVN8V0V4C	15.0	2025-05-26T07:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 15	Copyright © Hyuganatsu 2024	2025-09-12T07:00:00.000Z
PRD_3ZY6YM9QKH3G	CNT_345H3YBCMNNG	The Apothecary Diaries CNT_2BGF8M42M370	CNT_2BGF8M42M370	2	2	1	Volume 2	[]	The Apothecary Diaries: Volume 2	Dismissed from the rear palace, Maomao returns to service in the outer court—as the personal serving woman to none other than Jinshi! That doesn't necessarily make her popular with the other ladies, but a bit of jealousy might be the least of her problems. A mysterious warehouse fire, an official with a very bad case of food poisoning, and the mysterious last will and testament of a deceased craftsman all demand her attention—but are these cases really separate, or do they share a troubling connection? Then there's the mysterious military man who continually visits Jinshi. He's strange, maybe even a little twisted... and he seems very interested in Maomao.	Maomao goes from the rear palace to the outer court, where she finds mysterious fires, officials with food poisoning, and a craftsman's perplexing last will and testament. Are these cases really separate, or do they share a troubling connection?	01KG9DZHS7B54AKNZJV92RQN70	2.0	2021-02-25T08:00:00.000Z	J-Novel Club LAB_30X9NTZYDFV0	GEO_1PQM5BDYSMG0	The Apothecary Diaries: Volume 2	Copyright(C) Natsu Hyuuga 2015	2021-06-03T07: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);