database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_26JZ4M22MNK0"

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	copyright	on_sale_at
PRD_00XARAXQC00G	CNT_0ZJX6WD4CV20	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 7	[]	The Story of Saiunkoku, Vol. 7	Though Shurei and Eigetsu passed the Imperial Exam with high marks, they are being bullied as they go about their duties as new civil servants in the palace. But it seems the pair may have found an unlikely ally...	01KKTXYB4FBXGZWQFDVW3MWGMD	7.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 7	(C) Kairi YURA (2011)(C) Sai YUKINO (2011)	2015-01-20T15:00:00.000Z
PRD_0D7MKPNFWC4G	CNT_0GW10N460QE0	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 1	[]	The Story of Saiunkoku, Vol. 1	Shurei enters the palace as Ryuki's consort, but he has yet to seek her out. It is rumored that men, not women, share the emperor's bedchamber. Shurei must think of a way to stop the emperor from shirking his responsibilities, but she has to find him first!	01K5G77F1BR12ZWFJ9ANTT40S1	1.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 1	(C) Kairi YURA (2006)(C) Sai YUKINO (2006)	2015-01-20T15:00:00.000Z
PRD_0N9RHG40R33G	CNT_2XK67NCB7Y70	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 2	[]	The Story of Saiunkoku, Vol. 2	After realizing Ryuki has been faking his ignorance, an enraged Shurei demands to be sent home immediately. Ryuki then locks Shurei in her room, unaware he has now put his consort in great danger...	01KKTXYRHPVKKBEEN85SA96V51	2.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 2	(C) Kairi YURA (2007)(C) Sai YUKINO (2007)	2015-01-20T15:00:00.000Z
PRD_0SYB336B422G	CNT_0WXK772KJX00	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 8	[]	The Story of Saiunkoku, Vol. 8	Shurei has been falsely accused of cheating on the Imperial Exam by those who don't want women working as civil servants. Shurei must attend an inquiry to prove her innocence, but her opponents are plotting to make sure she never arrives at the palace.	01KKTXYPT141SHH1AB7FEHCVCG	8.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 8	(C) Kairi YURA (2011)(C) Sai YUKINO (2011)	2015-01-20T15:00:00.000Z
PRD_0WCTEP0D011G	CNT_2W806JRW1W10	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 4	[]	The Story of Saiunkoku, Vol. 4	Shurei has been disguising herself as a boy to assist Kijin Ko, the esteemed Minister of the Treasury. Despite Ryuki's plan to allow females to take the civil service exam, many remain opposed to the idea, including Kijin. Will Shurei be able to convince the discerning minister to change his mind?	01KKTXYC4EE247HR2CKTX06JE6	4.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 4	(C) Kairi YURA (2009)(C) Sai YUKINO (2009)	2015-01-20T15:00:00.000Z
PRD_21AJJKCMA0G0	CNT_1Z7KP588NAKG	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 3	[]	The Story of Saiunkoku, Vol. 3	Shurei has returned to her normal life at home, but once more the palace finds itself in need. She is asked to work as an assistant in the Ministry of the Treasury, but as women aren't allowed in, Shurei must pretend to be a boy!	01KKTXYBBCSTR8G8E2EZ9F6DS2	3.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 3	(C) Kairi YURA (2008)(C) Sai YUKINO (2008)	2015-01-20T15:00:00.000Z
PRD_25VDW6EYPFQ0	CNT_3YJ0HGYH09WG	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 6	[]	The Story of Saiunkoku, Vol. 6	The Blue Scarf Gang continues its attack on Kogaro. Yogetsu's strength during the battle gets the notice of the underworld bosses who want to recruit him, but Ryuki says the boy is already promised to him...?!	01KKTXY824Y8G01A04NM9WWYXE	6.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 6	(C) Kairi YURA (2010)(C) Sai YUKINO (2010)	2015-01-20T15:00:00.000Z
PRD_289WFS80JEP0	CNT_1HWXH2MSF8XG	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 9	[]	The Story of Saiunkoku, Vol. 9	While Shurei is receiving her assignment from the emperor, her father Shoka is visited by his younger brother Kuro. Kuro believes Shoka fled the Hong clan to shirk his duty as leader, remaining ignorant his older brother's dark past...	01KKTXY7TTTQ4XJTAQNF571QK9	9.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 9	(C) Kairi YURA (2012)(C) Sai YUKINO (2012)	2015-01-20T15:00:00.000Z
PRD_2Y7KMDH822J0	CNT_1WK9Q9XQVCHG	The Story of Saiunkoku CNT_26JZ4M22MNK0	CNT_26JZ4M22MNK0	2	1	1	Volume 5	[]	The Story of Saiunkoku, Vol. 5	Shurei falls ill and a group of indulgent yet inept men try to tend her. But while her family and the ministers from the court debate how to nurse her back to health, the emperor seizes the chance to sneak into her bedchamber for a visit.	01KKTXYBEFXBA6N7X27DX7MDHX	5.0	2015-01-20T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Story of Saiunkoku, Vol. 5	(C) Kairi YURA (2010)(C) Sai YUKINO (2010)	2015-01-20T15: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);