database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_00Y9XBJC6Z4G"

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_04388FT98780	CNT_10TTD6SMYH50	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 3	[]	Clockwork Planet Volume 3	After Naoto, RyuZU, Marie, and Halter's mission to save Kyoto succeeded, the group must lie low. Branded as terrorists and with Marie presumed dead, the new allies decide to gather more information while acting out the daily lives of high school students--something Marie isn't used to! While undercover, Marie receives valuable information through a coded message: The government is still abusing core parts to endanger civilians. Meanwhile, RyuZU wishes to find her little “sister,” AnchoR, but when the fellow automaton appears, is she a friend or foe?	Codes and Classrooms	01KG9Z5F7DSPZVWZ8P8F398RHD	3.0	2017-06-19T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 3	Yuu Kamiya/Tsubaki Himana/Sino/Kuro / Kodansha Ltd.	2017-06-27T04:00:00.000Z
PRD_07DEVACPJT60	CNT_178FTP5SE610	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 7	[]	Clockwork Planet Volume 7	Amid all the conspiracies and plots, the government is forced to come to a stalemate. When threats from mysterious parties and all-powerful weapons seem impossible to overcome, the leader of the military coup starts calling the shots. What's more, the leader's intent behind the coup is more dangerous to humanity than any could have imagined. Japan's national crisis has hit its peak, and Naoto and his friends stand at the core!	DEEPER DESCENT	01KGA1CY0K92GE66HRHGVHAF76	7.0	2018-02-05T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 7	(C) Yuu Kamiya / Tsubaki Himana / Sino / Kuro / Kodansha Ltd.	2018-02-27T08:00:00.000Z
PRD_0KPTS20FCET0	CNT_01020Z8YV7B0	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 2	[]	Clockwork Planet Volume 2	GEARS IN MOTION Naoto and RyuZU have a tense encounter with Marie Bell Breguet and her bodyguard, Vainney Halter, but they form a shaky alliance with the shared goal of fixing the Core Tower in Kyoto. With the city's most important structure in disrepair, Kyoto's entire population is at risk, but Naoto believes he can save it before the city undergoes a Purge. This unstoppable team of renegades may be able to save millions of lives, but acting against government orders may spark a dangerous conflict. Is Naoto's group ready to face the consequences of disrupting the order of the world itself?		01KG9Z1END34SK7369KWF9JSTP	2.0	2017-04-24T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 2	(C) Yuu Kamiya / Tsubaki Himana / Sino / Kuro / Kodansha Ltd.	2017-05-16T05:00:00.000Z
PRD_16D55TZPP250	CNT_0444RB08MBR0	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 5	[]	Clockwork Planet Volume 5	Even though AnchoR is RyuZU's little sister, her immense power poses a threat to Naoto and the crew. When the two siblings confront each other, an explosive battle ensues that bends time and space! Even RyuZU's Imaginary Time and her unique power, Mute Scream, may not be able to best an automaton built to destroy. Meanwhile, in Akihabara, a massive weapon appears, leaving the city's armed forces at a loss. If Grid Akihabara falls, all of Japan may be in danger. Can Naoto handle a weapon strong enough to break the entire Clockwork Planet?	TIME OUT	01KG9VPY7XDP37SJSW21W7W0XE	5.0	2017-09-18T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 5	Yuu Kamiya/Tsubaki Himana/Sino/Kuro / Kodansha Ltd.	2017-10-10T04:00:00.000Z
PRD_25HK21068GSG	CNT_3P2JR23MH2TG	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 1	[]	Clockwork Planet Volume 1	Naoto's a high school dropout and brilliant amateur tinkerer. He lives in a world that has been so over-exploited that the entire surface has become one vast machine. When a box crashes into his home containing a female automaton, it's a harbinger of change that will rock the entire globe, and give Naoto his chance to be a hero.		01KG98KZ1PF4KHD0G4GGB59TKN	1.0	2017-03-06T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 1	(C) Yuu Kamiya / Tsubaki Himana / Sino / Kuro / Kodansha Ltd.	2017-03-27T15:00:00.000Z
PRD_2JB7VBKE3W6G	CNT_041ARYMWFHCG	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 9	[]	Clockwork Planet Volume 9	Naoto and his crew continue their deep descent into the dark world of Shangri-La, where crime, betrayal, and peril run rampant. The two geniuses, Naoto and Marie, attract evil forces in the hellish underbelly of society, and their fates slowly become locked together like rusted cogs. Shangri-La runs on death, and its strongest leader wants Halter to execute a tricky tradeoff, but will the decision Halter makes be the right one...? And when an unfamiliar face from the Initial-Y series appears, RyuZU might be in trouble!	A TRADE OF FATE	01KGA5JEP272482A58V390NXVC	9.0	2018-12-12T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 9	(C) Yuu Kamiya/Tsubaki Himana/Sino/Kuro / Kodansha Ltd.	2018-12-25T08:00:00.000Z
PRD_2QVJPP0Q6EEG	CNT_0R60BBMHG3MG	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 10	[]	Clockwork Planet Volume 10	Naoto, Marie, and the crew are tangled up in the politics of the ruthless, violent city of Shangri-La. But when Second Upsilon gets down to business, they realize what's more important than turf wars and governments: Doing whatever they want! The two young geniuses and their mechanical comrades stir up wild mayhem and just might save the whole world while they're at it, too! FINAL VOLUME!	THE FINAL HOUR	01KGA6DS0FM974XWTV6KYG08JB	10.0	2019-02-05T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 10	(C) Yuu Kamiya/Tsubaki Himana/Sino/Kuro / Kodansha Ltd.	2019-02-26T08:00:00.000Z
PRD_2RRYC5E5FENG	CNT_08ECCQF38Q8G	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 6	[]	Clockwork Planet Volume 6	BENEATH THE SURFACE Everything seems to come to a standstill when an electromagnetic pulse magnetizes the clockwork the planet depends on. Not only the planet, but the automata, too, are knocked out of sync. The powerfully-built AnchoR is able to return to her senses, but RyuZU remains out of commission while Naoto and the crew plan their next step. Meanwhile, Marie's influence extends far and wide: from the government where a fellow meister gathers information, to the Imperial House, where a princess awaits Marie's aid. Amid the despair, this makeshift family finds time to have a day out on the town-and with adorable disguises, of course! But can Naoto really keep AnchoR smiling, when he himself is also in danger...?!		01KG9VW6Y97XH8DM4FYX003F52	6.0	2017-11-13T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 6	(C) Yuu Kamiya / Tsubaki Himana / Sino / Kuro / Kodansha Ltd.	2017-12-11T15:00:00.000Z
PRD_2TJKWP3C9B7G	CNT_3JCKS38AE03G	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 8	[]	Clockwork Planet Volume 8	The conspiracy plot in Tokyo comes to a conclusion, and Naoto and the crew make their way to crime-ridden Shangri-La on a bold new adventure! Though the world is shrouded in constant mystery, Naoto's incredible hearing skills, combined with Marie's genius engineering, will help lead them to the truth beneath the surface.	TROUBLE IN PARADISE	01KGA3HVEN1PCSTF2Y3TFT6B7B	8.0	2018-07-10T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 8	(C) Yuu Kamiya / Tsubaki Himana / Sino / Kuro / Kodansha Ltd.	2018-07-31T07:00:00.000Z
PRD_37R1EBTMXZKG	CNT_32YJRJG0782G	Clockwork Planet CNT_00Y9XBJC6Z4G	CNT_00Y9XBJC6Z4G	2	1	1	Volume 4	[]	Clockwork Planet Volume 4	With the sudden appearance of AnchoR, the “sister” of the Initial-Y series are reunited, but it may not be a happy meeting! Whatever her intentions, this tense encounter means that underground conspiracies may finally come to light. From learning of hidden weapons and a nefarious plan of destruction, the group may be in for more than they bargained for. This time Naoto and his allies may have to go all the way to the top to find justice.		01KG9Z9MB9S4WD8NW03M34RB0C	4.0	2017-08-07T15:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Clockwork Planet Volume 4	Yuu Kamiya/Tsubaki Himana/Sino/Kuro / Kodansha Ltd.	2017-08-22T04: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);