database: products: 13 rows where series_id = "CNT

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

13 rows where series_id = "CNT_2ATFJJZZTT0G"

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_0APMZGJ1NS10	CNT_0C83S8NFB8TG	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 12	[]	Land of the Lustrous 12	Phosphophyllite is on the war path, determined to make Kongo pray at all costs. The other gems attempt to protect their precious Sensei, but can they stop the vicious onslaught? Meanwhile, on the moon, Cairngorm demands an explanation from Aechmea...		01KH3FG6CZKBDHSRGE5QH2RNW6	12.0	2023-08-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous 12	Haruko Ichikawa/Kodansha Ltd.	2023-08-22T07:00:00.000Z
PRD_0QQCG6AM5NYG	CNT_0JWPNBR42EQG	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 4	[]	Land of the Lustrous Volume 4	THE ROAD TO BRAVERY Spring has sprung, and the all the other gems are awake to see Phosphophyllite's transformation. They are impressed with Phos's new arms, and our hero can hardly stand the newfound popularity, especially when it attracts the scariest gem of all...Bort now wishes to be Phos's partner in battle.		01KG9VX052XQ6F5Y87F4E9WRNG	4.0	2017-12-04T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 4	(C) Haruko Ichikawa / Kodansha Ltd.	2017-12-26T08:00:00.000Z
PRD_138DKYY62KZG	CNT_16AWE5HSRQ00	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 11	[]	Land of the Lustrous 11	Two hundred years after a failed attack on the Lustrous, Phosphophyllite is reassembled and tries again to get Kongō to pray for the Lunarians. This attempt seems likely to succeed, and the Lunarians prepare to depart to nothingness, while the gemstones on the moon prepare to be left behind. Meanwhile, Euclase is awakened by the commotion between Phos and Kongō...		01KG9GFXGQGMEWS2TD7PDJ8769	11.0	2021-07-26T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous 11	Haruko Ichikawa / Kodansha Ltd.	2021-08-24T07:00:00.000Z
PRD_1GWKQA41AF60	CNT_3QCQGBCGHQN0	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 13	[]	Land of the Lustrous 13	Having inherited Kongo's memories and abilities. Phosphophyllite finally completes the long awaited prayer, sending the Lunarians into the void. Now truly alone, Phos can only await eternity in silence-that is, until an unfamiliar mineral lifeform comes along, inspiring deep contemplation of the events that have transpired over these thousands of years... FINAL VOLUME!		01KGC0WPMJJH73X0VWST4XAR4K	13.0	2025-10-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous 13	Haruko Ichikawa/KODANSHA LTD.	2025-11-04T08:00:00.000Z
PRD_1RB542V1ABYG	CNT_0P8NWBBMC04G	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 7	[]	Land of the Lustrous Volume 7	Now that Phosphophyllite's head has been taken to the moon, there's only one way to revive the defeated gem--with a risky head transplant. For better or worse, Lapis Lazuli's head is available, but more than half of Phos's original body has been lost. Assuming the transplant even works, will the resulting gem still be Phosphophyllite?	TWO HEADS ARE BETTER THAN ONE	01KGA5A362V1K9CVZENZRR0BY6	7.0	2018-10-16T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 7	(C) Haruko Ichikawa / Kodansha Ltd.	2018-11-13T08:00:00.000Z
PRD_1X2EAEEDKGX0	CNT_03ZF9Y0KKSG0	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 2	[]	Land of the Lustrous Volume 2	Phosphophyllite is determined to find a job more suited Cinnabar's many talents, but with no easy answers to be found on land, the quest turns seaward. Ventricosus the sea snail suggests that the creatures who live there may have the clue Phos is looking for. But the sea is hardly the optimal environment for a gemstone--will Phos make it back to shore in one piece?	UNDER THE SEA	01KG9Z9PFH7Q2VSYREA77WR09W	2.0	2017-08-07T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 2	Haruko Ichikawa / Kodansha Ltd.	2017-08-22T04:00:00.000Z
PRD_29Q2XZGG92H0	CNT_1PTG5A5KVDXG	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 8	[]	Land of the Lustrous Volume 8	The quest for the truth continues as Phosphophyllite finally begins the journey to the moon, hoping to communicate with the Lunarians after so many failed attempts. While the gem is shocked and angered to learn that the enemy has been able to speak all along, this also means that they can provide answers. Will Phos be able to handle the truth?	FROM THE EARTH TO THE MOON	01KGA5PD2CFGZ62AC37P68TMA9	8.0	2019-03-29T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 8	(C) Haruko Ichikawa / Kodansha Ltd.	2019-04-09T07:00:00.000Z
PRD_2BK4SREH51K0	CNT_2DJ73RV72NQ0	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 6	[]	Land of the Lustrous Volume 6	Phosphophyllite has been immobilized in battle, with no one but Ghost Quartz around for backup. Both must last through the Lunarians' relentless attack until help arrives, but it's a tall task for this newly-minted pair. Will Phos's partner be just another casualty in the ongoing war?	GIVE UP THE GHOST	01KGA3HAAMMF00PXXZ17HQEJGQ	6.0	2018-07-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 6	(C) Haruko Ichikawa / Kodansha Ltd.	2018-07-17T07:00:00.000Z
PRD_2H62Z9SNN4AG	CNT_3V3AXD4YS0B0	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 9	[]	Land of the Lustrous Volume 9	Phosphophyllite has formed a team of deserters to take back to the moon. While there, the gems learn the shattering truth of what happened to their captured comrades. If Phos can help the Lunarians accomplish their ultimate goal, their leader promises to make the gems whole again, but there’s a catch. Meanwhile, the Lustrous back on Earth form their own plans…	BROKEN	01KGA7HZ7ZT9G8SES4GHWZYKYJ	9.0	2019-09-03T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 9	(C) Haruko Ichikawa / Kodansha Ltd.	2019-09-24T07:00:00.000Z
PRD_2WVK20QB88R0	CNT_1T1AA3NVH1N0	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 1	[]	Land of the Lustrous Volume 1	SEARCHING FOR PURPOSE In a world inhabited by crystalline lifeforms called The Lustrous, every unique gem must fight for their way of life against the threat of lunarians who would turn them into decorations. Phosphophyllite, the most fragile and brittle of gems, longs to join the battle. When Phos is instead assigned to complete a natural history of their world, it sounds like a dull and pointless task. But this new job brings Phos into contact with Cinnabar, a gem forced to live in isolation. Can Phos's seemingly mundane assignment lead both Phos and Cinnabar to the fulfillment they desire?		01KG98NXPC1XMNTRTXR876908X	1.0	2017-06-05T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 1	(C) Haruko Ichikawa / Kodansha Ltd.	2017-06-27T05:00:00.000Z
PRD_302Q3FXTZ7JG	CNT_0XECR41DD03G	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 3	[]	Land of the Lustrous Volume 3	THE LONELY WINTER Now with new legs, Phosphophyllite is ready to go to battle. But when that new strength is needed the most, Phos is too scared to use it. Mortified by this failure, Phos undertakes the self-imposed punishment of staying awake all winter while the other gems are asleep. But winter has its own share of dangers...		01KG9VR3ETGKXC2MRM7MR43JQS	3.0	2017-10-02T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 3	(C) Haruko Ichikawa / Kodansha Ltd.	2017-10-24T07:00:00.000Z
PRD_36H4R7YG692G	CNT_3ZW6K0YVPTS0	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 10	[]	Land of the Lustrous 10	After failing to get Kongo to pray for the Lunarians, Phosphophyllite returns to the moon to regroup, but Padparadscha has been covered in Cinnabar's poison, and Yellow Diamond has taken a severe psychological blow. Now Phos must come up with a new plan, but ideas are in short supply. Meanwhile, Cairngorm and the other gems are finding life on the moon to be surprisingly agreeable ...		01KGA7WGTNSW0XKY826P7FA678	10.0	2020-02-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous 10	(C) Haruko Ichikawa / Kodansha Ltd.	2020-02-25T08:00:00.000Z
PRD_3FK1H4MW83ZG	CNT_1MEM1VA32ERG	Land of the Lustrous CNT_2ATFJJZZTT0G	CNT_2ATFJJZZTT0G	2	1	1	Volume 5	[]	Land of the Lustrous Volume 5	Phosphophyllite is determined to find the truth about Kongo. Despite the other gems' hatred of the Lunarians, Phos tries to get closer to them in an effort to communicate. But the work is dangerous, and Phos realizes this job might be more than one gem can handle...	SHADOW OF A DOUBT	01KGA1D4H7QNM1FS9HD4G5ZDN2	5.0	2018-02-12T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Land of the Lustrous Volume 5	(C) Haruko Ichikawa / Kodansha Ltd.	2018-03-13T08: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);