database: products: 4 rows where series_id = "CNT

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

4 rows where series_id = "CNT_23RRT2SEP4JG"

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_05VQB0X8KTQ0	CNT_1AH0PKXWSDN0	I Want a Gal Gamer to Praise Me CNT_23RRT2SEP4JG	CNT_23RRT2SEP4JG	2	1	1	Volume 3	[]	I Want a Gal Gamer to Praise Me, Vol. 3	As Raito prepares for an afternoon of retro games with his friend Yuu, she has her eyes set on a different prize… They’re all alone in Raito’s home, and he’s got nowhere to run from the sultry teasing she’s about to unleash. But before Yuu can move in for the kill, a flustered Rion hot drops into the fray! Shields down and no cover in sight, Raito’s caught in the cross fire between childhood friend and God-gamer beauty. As the final circle closes in, it’s anyone’s guess who’ll come out on top…!	01KGBBQXSSCBJG7DJ3T67A9ZFX	3.0	2024-07-04T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	I Want a Gal Gamer to Praise Me, Vol. 3	2024-11-19T08:00:00.000Z
PRD_0WJT5CXPRQ0G	CNT_07CZX6ZVN9KG	I Want a Gal Gamer to Praise Me CNT_23RRT2SEP4JG	CNT_23RRT2SEP4JG	2	1	1	Volume 4	[]	I Want a Gal Gamer to Praise Me, Vol. 4	Raito may have clutched his way out of the 2v1 in his room the other night, but the battle is far from over. Yuu is getting more daring by the day, and now that she’s joined the gaming club, Raito is caught in a cross fire of teasing and praise! Lucky for him, Rion’s been too busy preparing for the big tournament to pay him much mind. But after Raito heroically comes to her rescue at school, even the steady hands of a seasoned gamer like her won’t stop shaking. Rion knows what his fingers are capable of from all their hours of coaching—and her imagination’s running wild!	01KGBG16SQ91D3XGYJ4P92MS3B	4.0	2024-10-23T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	I Want a Gal Gamer to Praise Me, Vol. 4	2025-04-22T07:00:00.000Z
PRD_18SBFHPMZZB0	CNT_04ZAQSRG1A40	I Want a Gal Gamer to Praise Me CNT_23RRT2SEP4JG	CNT_23RRT2SEP4JG	2	1	1	Volume 1	[]	I Want a Gal Gamer to Praise Me, Vol. 1	When high school shut-in Raito Sasaki hires a pro gamer coach to help hone his FPS skills, he never expected that the one knocking on his door would be Rion Suzuki—a cute and fashionable beauty the same age as him! With such a charming and supportive gamer gal cheering him on, can Raito take his game to the next level, or will the pressure of being up close and personal with a bombshell like Rion lead him to throw?	01KGATG68BQB51T67V0G3VNQBZ	1.0	2023-10-30T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	I Want a Gal Gamer to Praise Me, Vol. 1	2024-03-19T00:00:00.000Z
PRD_2S45PZX47EYG	CNT_13FDZH7QSE8G	I Want a Gal Gamer to Praise Me CNT_23RRT2SEP4JG	CNT_23RRT2SEP4JG	2	1	1	Volume 2	[]	I Want a Gal Gamer to Praise Me, Vol. 2	Having leveled up from coach and student to gaming buddies in the same school club, Raito and Rion are having a blast! But as Raito emerges from his shell, Rion can’t help but get this totally weird sensation when he hangs with her other gal pals… Just what could this feeling be?!	01KG9PMRDA297D8FE6Y0EK1607	2.0	2024-01-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	I Want a Gal Gamer to Praise Me, Vol. 2	2024-07-23T00: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);