database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_043NZDQGY420"

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_0MT76GZF09RG	CNT_1E0KWEYHKX70	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 4	[]	Lust Geass, Vol. 4	As summer break begins, Souta is drained more and more as he scrambles to satisfy the rampant sexual needs of Rikka, her friend Makoto, and now their teacher Shino. When Makoto learns of this third cursed lover, she hatches a plan to seek even greater depraved thrills. With Zepar’s help, she arranges an overnight camping trip to the beach. Trapped alone with Makoto and Shino, Souta will have no choice but to let his desires run wild…	01KGAD49JEE2V8MVGJMFPE0396	4.0	2021-10-27T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Lust Geass, Vol. 4	2021-11-30T08:00:00.000Z
PRD_10ZBWN0PVEFG	CNT_3MGMTWB9VKM0	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 1	[]	Lust Geass, Vol. 1	Souta Takatsuki and his neighbor Rikka Amanome have been like brother and sister since they were kids, but his feelings for her run much deeper. With her birthday coming up, he wants to find the perfect gift, which presents itself in the form of a book from a mysterious shop he happens across. The owner doesn’t even charge him, saying he’ll return to pay eventually…Souta is wholly unprepared for the insatiable passion the book inspires in Rikka, and it seems the ultimate price of this gift may be hefty indeed…	01KG9BV37XSXVJQEM8K09M81GK	1.0	2020-05-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Lust Geass, Vol. 1	2020-06-23T07:00:00.000Z
PRD_18WJEPG2A960	CNT_3NC771KBCZGG	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 5	[]	Lust Geass, Vol. 5	<P>There’s a new girl in school—Koyuki Nonomiya, a third-year transfer student with a reputation for debauchery. Bearing a curse from the demon Gremory, a rival of Zepar, she wants in on all the fun, and won’t take no for an answer! Faced with an experienced and aggressive partner, Souta finds himself increasingly pulled away from the other girls. Can he deny the pleasures set before him?</P>	01KGAEVV2AZP9NGGB49JJDFVJW	5.0	2022-02-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Lust Geass, Vol. 5	2022-03-22T00:00:00.000Z
PRD_284HM8HK746G	CNT_1YJCN8EFF8JG	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 2	[]	Lust Geass, Vol. 2	Souta and Rikka are officially going out now, and their relationship remains as steamy as ever due to Zepar’s curse of lust. But things heat up even more when Rikka’s friend Makoto comes across the grimoire— with her desires unleashed, nothing will stop her from taking what she wants! As he’s forced into a secret affair, can Souta find a way to break the spell on Makoto while staying true to his love for Rikka, or will he be sucked dry by the two girls’ passionate cravings first?!	01KG9DJG2659WPCPAQCNSB35Y8	2.0	2020-11-26T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Lust Geass, Vol. 2	2020-12-15T08:00:00.000Z
PRD_2FAG36GG1ZAG	CNT_3NZ9FT8QRB2G	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 6	[]	Lust Geass, Vol. 6	After catching Souta cheating on her with not one, not two, but three other women, a devastated Rikka starts to avoid him completely. And with the help of the demon Gremory, she finds that she doesn’t need him to feel pleasure anyway! What Rikka doesn’t realize, however, is that her fantasies aren’t all what they seem to be…Can Souta uncover the reasons behind her strange new behavior before it’s too late?	01KGB2PKVKE0A7EJY2VPHR73G6	6.0	2022-12-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Lust Geass, Vol. 6	2022-12-13T00:00:00.000Z
PRD_2JZVMXDQDWP0	CNT_2RF8XBKTW020	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 3	[]	Lust Geass, Vol. 3	After Makoto’s confession, Souta finds himself having to balance a delicate three-way relationship. Trying to keep both lust-crazed girls satisfied while also keeping his cheating a secret from Rikka is hard enough, but Zepar isn’t through with him yet…as the next to fall victim to her curse is none other than their homeroom teacher, Tateaki-sensei! Faced with the domineering charms of a lonely adult woman, will Souta be sucked into yet another immoral affair?	01KG9ETB0VFS11VE9J6FHVVMRS	3.0	2021-01-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Lust Geass, Vol. 3	2021-03-30T07:00:00.000Z
PRD_3S631AZBSCS0	CNT_3KY799R3YPJ0	Lust Geass CNT_043NZDQGY420	CNT_043NZDQGY420	2	1	1	Volume 7	[]	Lust Geass, Vol. 7	Souta plans to confess everything, though he may be too late, as a delirious Rikka is being led by Kanade to her comatose boyfriend’s hospital bed! With the group’s tangled knot of lust beginning to fray, Souta is offered a way out—but are he and Rikka prepared for what it may cost them…? Don’t miss the conclusion to this cursed tale of love as it climaxes in the final volume!	01KH3GWR8AK42BKS4KNJJCZYX0	7.0	2023-08-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Lust Geass, Vol. 7	2023-12-12T00: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);