database: products: 15 rows where series_id = "CNT

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

15 rows where series_id = "CNT_0W2NHTPFH1KG"

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_065PGRBFGK70	CNT_0QHFMG50DJ90	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 08	[]	The Apothecary Diaries 08	The truth of Maomao's birth is revealed?! Sly tactician Lakan's attempts at provocation lead to his own downfall when Maomao challenges him to elephant chess, only to outplay him in a game of wits! In a stupor from drinking "poison" as punishment for his loss, Lakan dreams of a long-lost past, his affair with a beautiful courtesan, and meeting her daughter for the very first time. Upon waking, he finds himself at Verdigris, where he is pressed to buy the freedom of a girl of his choosing and take her home as his wife! But will any of the flowers there catch his eye when his heart is in love with a memory?	01KGBRH2TNXJ2J62B93DN6XMBT	8.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 08	2025-07-03T07:00:00.000Z
PRD_0RG78ZDSCP20	CNT_2NJ8A9474NE0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 09	[]	The Apothecary Diaries 09	A festive atmosphere descends upon the Inner Court with the arrival of a long-awaited merchant caravan and its myriad wares. Though the excitement is contagious and even Maomao looks forward to making purchases of her own, she soon cottons on to something potentially sinister about the innocuous goods for sale. Before Maomao can tease out any evidence, however, her attention turns to mushrooms when Jinshi asks her to root out any poisonous varieties on the grounds. But is this request just a bit of landscaping or does it have anything to do with the rumors making the rounds about a court lady who has gone missing?	01KGBRH7CG3DK5EZTD9R4506D1	9.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 09	2025-07-03T07:00:00.000Z
PRD_153CAJ7RSNW0	CNT_0KPD0EJF9MC0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 14	[]	The Apothecary Diaries 14	After tangling with a ghost at the Diamond Palace and temporarily trading in her poisons for sweet treats, Maomao returns to the Jade Palace only to find a grave problem staring her in the face! Mere weeks before the heavily pregnant Consort Gyokuyo is due to bear her child, Maomao deduces that all is not well with the coming birth of the new Imperial addition. But even with her skills, Maomao knows she isn't up to the momentous task of seeing her lady through this trial. Who to turn to, then? The quack, sweet though he may be, is out of the question. That only leaves...Maomao's Pa! But while his plucky daughter would gladly vouch for Luomen, will the Inner Court really be willing to put the future of the empire into the hands of a criminal once more?	01KGBRPAPFQ8CJ4XKCH5M74EKP	14.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 14	2025-10-07T07:00:00.000Z
PRD_16NVF1NDPJ00	CNT_1VCHGS1XWH80	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 13	[]	The Apothecary Diaries 13	Maomao accompanies Jinshi on a hunting trip in which Jinshi is keeping his true identity a secret. But when they are suddenly shot at by unknown assailants and escape into a cave, Maomao learns one of the many secrets that Jinshi has been keeping. Now she has to work with Lihaku to identify their would-be assassins. Although she's able to work out their motive, could it be that there's much more to this incident than she realizes?	01KGBRMG6B0G8R51B22RW7GY7X	13.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 13	2025-07-03T07:00:00.000Z
PRD_1GFKA4200ZB0	CNT_18TKQAW20EN0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 01	[]	The Apothecary Diaries 01	Maomao, a young woman trained in the art of herbal medicine, is forced to work as a lowly servant in the inner palace. Though she yearns for life outside its perfumed halls, she isn't long for a life of drudgery! Using her wits to break a "curse" afflicting the imperial heirs, Maomao attracts the attentions of the handsome eunuch Jinshi and is promoted to attendant food taster. But Jinshi has other plans for the erstwhile apothecary, and soon Maomao is back to brewing potions and...solving mysteries?!	01KGBQT1FPWNW11JJCTEPC35FD	1.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 01	2025-07-03T07:00:00.000Z
PRD_1GPYT6DYXVE0	CNT_3KVN771S2AJ0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 04	[]	The Apothecary Diaries 04	Though Maomao has left the palace behind and returned to her home in the pleasure district, it seems the Inner Court can't do without her! Jinshi comes to the erstwhile food taster with a request involving the attempted poisoning of the Virtuous Consort during the garden banquet and the identity of the mastermind behind it!	01KGBREWZZ1BJGVHDW4EXA64KM	4.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 04	2025-07-03T07:00:00.000Z
PRD_1ZB1TR6ZETSG	CNT_126594FTHS7G	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 15	[]	The Apothecary Diaries 15	Maomao is missing! But she's not the only one, as it turns out. While her fate plays upon his mind, Jinshi searches for the handsome new eunuch, who is also nowhere to be found. When a lead about the vanished man unearths a connection with someone at the Inner Court, Jinshi stumbles upon yet another disappearance—this time, that of a principal consort! As the threads begin to intertwine, Jinshi may at last be on Maomao's trail... Meanwhile, as an unwilling guest at the hidden village Shisui calls home, Maomao herself indulges her insatiable curiosity, only for her zeal to lead her into trouble again! Entangled in treacherous schemes, the quirky apothecary starts to grasp that the events transpiring at the hidden village are tied to the recent happenings at the Inner Court. To get to the bottom of the conspiracy, Maomao must keep her wits about her if she wants to return to the Inner Court to tell the tale!	01KJQ2VDPQA8E3P1CH6PR833Y8	15.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 15	2026-03-17T07:00:00.000Z
PRD_207MFGB1FGTG	CNT_2YXAN5FK9Z6G	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 05	[]	The Apothecary Diaries 05	Forced to the leave the Inner Palace, Maomao finds herself in the employ of none other than Jinshi, the seemingly ever-present thorn in her side! Immune to his charms, Maomao sets about learning the ways of life in the Outer Palace, where government officials and military officers go about the daily business of running the country. Far from being fearful of her new surroundings, however, Maomao has her insatiable curiosity piqued by the soldier-occupied eastern wing, where she's been forbidden to go but where it seems further mysteries await...	01KGBRF4VE9XQQ08EQG6GZRWCQ	5.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 05	2025-07-03T07:00:00.000Z
PRD_28R24K4R1PJG	CNT_1FFHMEJNZ4YG	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 11	[]	The Apothecary Diaries 11	Summoned to attend the Emperor on an evening jaunt to an ancient shrine that functions as a rite of passage for the rulers of the land, Maomao makes quick work of the puzzle inside, acquitting herself with aplomb. Having learned more about the Imperial bloodline than a commoner has any right to know, Maomao returns to her post at the Jade Palace. But her aim to stay out of the business of her betters is foiled once again when the Empress Dowager comes calling! The mother of His Imperial Majesty seeks Maomao's aid in investigating yet another curse, one she fears she herself may have cast upon the infamous late Emperor...	01KGBRJXQ3XCWWTWCYTR45CT3C	11.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 11	2025-07-03T07:00:00.000Z
PRD_2FEJP662DNHG	CNT_3ETEQR8YA3ZG	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 10	[]	The Apothecary Diaries 10	When two beautiful foreign envoys with designs on the Emperor come calling with a tale of old about a spellbinding courtesan who captured the imagination of their family patriarch, it's up to Maomao to concoct a theatrical scheme to give the ladies a whopper of a story to take home! Later, Maomao goes back to sniffing around the Inner Court to find out the truth about the troubling prevalence of those foreign perfume oils that could spell disaster for the throne's future heirs...	01KGBRJVXD3KRP7KS6PTGAM3Y1	10.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 10	2025-07-03T07:00:00.000Z
PRD_2XNP4YHAPFS0	CNT_2B3EDPV6DY70	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 02	[]	The Apothecary Diaries 02	Maomao, a young woman trained in the art of herbal medicine, is forced to work as a lowly servant in the inner palace. Though she yearns for life outside its perfumed halls, she isn't long for a life of drudgery! Using her wits to break a "curse" afflicting the imperial heirs, Maomao attracts the attentions of the handsome eunuch Jinshi and is promoted to attendant food taster. But Jinshi has other plans for the erstwhile apothecary, and soon Maomao is back to brewing potions and...solving mysteries?!	01KGBRE97WFSVHVEZE0BW14RF1	2.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 02	2025-07-03T07:00:00.000Z
PRD_371W8BFXV0N0	CNT_3PJRRYYXMYV0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 12	[]	The Apothecary Diaries 12	Strong-armed into getting out more, Maomao attends a spooky soiree where court ladies share spine-tingling tales of terror as a diversion from their daily toil. While there are plenty of chills to go around, the thrills are perhaps few for the skeptical Maomao...until the evening takes an eerie turn! And still more thrills await when Jinshi requests Maomao's presence on a hunting trip. All is not as it seems when court intrigue and subterfuge are in play however, and master and servant find themselves in a very tight spot and uncomfortably close quarters when a break from a banquet on the hunt goes awry...	01KGBRKEMDWXSYN2M2NDD1WRRQ	12.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 12	2025-07-03T07:00:00.000Z
PRD_37PKGFHYM60G	CNT_2M5CHC87BN8G	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 03	[]	The Apothecary Diaries 03	After explaining to Jinshi the circumstances behind the poisoned cup at the garden party, Maomao returns home to the pleasure district for the first time in ten months, thanks to the ornate hairpin she received at the party. But there, she gets swept up in yet another mystery?!	01KGBREK40G33PX4J20EGKTA09	3.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 03	2025-07-03T07:00:00.000Z
PRD_3A0HV1BNDQ20	CNT_3VZ8RWWM7PE0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 06	[]	The Apothecary Diaries 06	Maomao has proven her worth to the denizens of the palace time and time again, but she's got her work cut out for her on this occasion! When the ever luminous Jinshi asks for Maomao's help in disguising himself to take care of business outside the palace walls, Maomao must dig deep to mar her employer's heavenly charms! And to make the ploy believable, Maomao herself is roped in to a spot of theater as Jinshi's companion. But Jinshi's "business" takes him right to the gates of the pleasure district! Has all Maomao's hard work been for a mere assignation, or is there another mystery afoot?	01KGBRFKT17X9M2MPM45SDB8TE	6.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 06	2025-07-03T07:00:00.000Z
PRD_3J3Y9TBQW2P0	CNT_2XNCF6Z280T0	The Apothecary Diaries CNT_0W2NHTPFH1KG	CNT_0W2NHTPFH1KG	2	1	1	Volume 07	[]	The Apothecary Diaries 07	Maomao succeeds in saving Jinshi from a horrific fate, proving herself indispensable to the palace once more! But while she is given the chance to explain herself, Maomao has yet to learn that the treachery of the plot she has uncovered is woven deep into the fabric of the very palace in which she serves! To truly unpick the mystery, Maomao will need her patience and her copious wits about her... She'll also need to watch her back, as she comes face-to-face with the sinister La Kan...	01KGBRHT1Q2H866H5T13FCJQWW	7.0	2025-07-03T07:00:00.000Z	SQUARE ENIX LAB_26KAVJENDCDG	GEO_1PQM5BDYSMG0	The Apothecary Diaries 07	2025-07-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);