database: products: 11 rows where series_id = "CNT

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

11 rows where series_id = "CNT_1KYNZWP4B070"

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_05BY7N1DEEYG	CNT_3FPE4PP2EPCG	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 11	[]	The Gentlemen's Alliance †, Vol. 11	Haine goes to Shizumasa and Takanari's grandfather, the head of the Togu family, to ask him to release the twins from their fate. He tells her she must pass the same trial the twins went through for determining the Togu heir. Haine agrees, but little does she know that a former friend is now out for her life.	01KGBHWDG3VWG14P91SWNN9PCP	11.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 11	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1GZ8EFY3JB3G	CNT_11N57XRVQKFG	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 7	[]	The Gentlemen's Alliance †, Vol. 7	Determined to make Haine fall in love with him, Takanari tries to win her over at every opportunity. Haine is troubled by her growing feelings for Takanari, but she's even more concerned about her best friend Ushio's long list of paramours...	01KGBHW8YEAMVFVYS62V55H58H	7.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 7	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_1T14CPXV1770	CNT_2ZTZYM583FB0	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 5	[]	The Gentlemen's Alliance †, Vol. 5	Haine has been stripped of her Platinum status and ousted from the student council. Shizumasa refuses to acknowledge her, and she learns that even her adopted family has been lying to her. With nowhere else to turn, Haine returns to the man who sold her to save his business--her birth father, Kazuhito Kamiya.	01KGBHV84E8BSBJ39QF0BX2CTK	5.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 5	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2E43KKN7YVJG	CNT_3T62C49AN2RG	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 9	[]	The Gentlemen's Alliance †, Vol. 9	Learning the truth behind her parentage and the reason she was put up for adoption, Haine reverts to her yanki ways. She rejoins her gang and comes up with a plan to break into the Kamiya mansion to abduct her mother. The only thing standing in her way--the twins!	01KGBHVEZ6FVAB8H8BEG2MZCYB	9.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 9	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_2KR76TAPYJAG	CNT_37KA3TV7DAGG	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 2	[]	The Gentlemen's Alliance †, Vol. 2	Haine has been introduced to the entire academy as "Platinum," the title granted to Shizumasa's (albeit fake) girlfriend. Haine must now adapt to her newfound popularity among the students, as well as get along with the jealous Maguri--the boy Shizumasa jilted in favor of her!	01KGBHVSNMZAZS2YCHHSD4V7ND	2.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 2	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_33EJT40S0QQ0	CNT_22MFHZ91GYV0	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 3	[]	The Gentlemen's Alliance †, Vol. 3	Haine goes to the Togu mansion to talk to Shizumasa after their quarrel, but the guards won't even allow her inside the gates! Haine gets some help from Maora to sneak into the mansion grounds, but now she'll have to get past the family's final line of defense...	01KGBHW2BN2609PWZ8QNBAA6R1	3.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 3	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3DQ9NH3X71RG	CNT_3KE4BK3YQS2G	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 1	[]	The Gentlemen's Alliance †, Vol. 1	Haine has been in love with Shizumasa Togu since she read the fairy tale he wrote as a child. However, the Emperor is so well sequestered by the student council that she hasn't been able to speak to him in the three months she's been at the academy. And as rumor has it, he already has a lover...	01KGBGNX671HS0FCX4ZWVRCA17	1.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 1	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3H07RQ1NDWDG	CNT_0NTAZBG4D4XG	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 8	[]	The Gentlemen's Alliance †, Vol. 8	Haine breaks up with Takanari to be with her friend Ushio. But rather than being happy about it, Ushio starts to feel more alone than ever--and turns to an unexpected source for comfort.	01KGBHX8K0PKMZ07TYWZ2FC6BP	8.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 8	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3JP1N5FYMBC0	CNT_0E0EQMXQH3Y0	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 10	[]	The Gentlemen's Alliance †, Vol. 10	Haine's family has been reunited, but the estranged Togu family still retains many of its secrets. Shizumasa and Takanari are increasingly at odds with each other as each one tries to win Haine's love. Will the twins ever be able to reconcile when they're both in love with the same girl?	01KGBHW9J4J4G8H4WYW8BQYZ9D	10.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 10	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3RBKXY5CR9H0	CNT_23Z5P3YGP0S0	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 6	[]	The Gentlemen's Alliance †, Vol. 6	Haine learns Shizumasa's secret and must continue to act as if nothing has changed amidst her conflicting emotions. As the members of the student council plan a school play, will Haine be able to maintain Shizumasa's deception in front of the others?	01KGBHW5595J62CR9SA3CP23T5	6.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 6	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08:00:00.000Z
PRD_3REC5ZCRF7PG	CNT_3ZFPEX0C9Z4G	The Gentlemen's Alliance † CNT_1KYNZWP4B070	CNT_1KYNZWP4B070	2	1	1	Volume 4	[]	The Gentlemen's Alliance †, Vol. 4	Students at Imperial Academy are lining up for the "Confess Your Love" rally, during which students announce the name of the person they love to the entire student body, in hopes of winning over their beloved's heart. Maora wants to confess to Maguri, but Maguri already has plans to confess to Shizumasa!	01KGBHV79HSAQGWF2W634CX19A	4.0	2024-11-26T08:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	The Gentlemen's Alliance †, Vol. 4	THE GENTLEMEN ALLIANCE -CROSS- © 2004 by Arina Tanemura/SHUEISHA Inc.	2024-11-26T08: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);