database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_1SJ2M8KF84DG"

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_0NCNSHCCEH10	CNT_093PZGE6PW2G	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 2	[]	Student Council's Discretion 2	The student council of Hekiyo Private Academy is chosen not through a normal election but through a popularity contest. Ken Sugisaki is the one student who managed to join the council through his good grades, and his wish is to create a harem! This second installment in the popular series that has been made into TV anime.	The second installment of the casual school story featuring a student council made up of beautiful girls, elected through a popularity contest, and one boy!	01KKTXXP2CT4JKYXEGFW1YC8V9	2.0	2014-12-23T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 2	(C)TOMO 2009 (C)SEKINA AOI, KIRA INUGAMI 2009	2014-12-23T15:00:00.000Z
PRD_0SX4B49PAG00	CNT_28E3Z24F5V3G	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 1	[]	Student Council's Discretion 1	The student council of Hekiyo Private Academy is chosen not through a normal election but through a popularity contest. Ken Sugisaki is the one student who managed to join the council through his good grades, and his wish is to create a harem! A casual school story about a very casual student council.	This casual school story features a student council made up of beautiful girls elected through a popularity contest and one boy!	01K5G77CK72SQF1TA91XXF2JNQ	1.0	2014-12-23T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 1	(C)TOMO 2009 (C)SEKINA AOI, KIRA INUGAMI 2009	2014-12-23T15:00:00.000Z
PRD_16CG288CMPEG	CNT_0MTZ2B7REHM0	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 5	[]	Student Council's Discretion 5	This extraordinary book includes stories that allow you to see all sides of the president, from a Lolita version to a version with a very nice body! With the announcement of its new anime, this series is as popular as ever, and the 5th installment is here with its distinctive laid-back style!!	The story of Sugisaki's efforts as he strives to make the gorgeous girls of the student council into his harem!	01KKTXXSP08K2DXYTHG8QEH8CN	5.0	2015-01-27T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 5	(C)TOMO 2011 (C)SEKINA AOI, KIRA INUGAMI 2011	2015-01-27T15:00:00.000Z
PRD_1AX3DV5PGNDG	CNT_2M5CDPW0XGN0	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 7	[]	Student Council's Discretion 7	This volume is full of dreams, from Sugisaki's wish to become a king, to Minatsu's former dream of becoming a bride. With Minatsu on the cover, this volume is packed full of Minatsu, showing her passion and her daily life with Class 2-B!	The seventh student council installment - We have limitless possibilities!	01KKTXXQ7F11V8QWGQ03914355	7.0	2015-01-27T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 7	(C)TOMO 2012 (C)SEKINA AOI, KIRA INUGAMI 2012	2015-01-27T15:00:00.000Z
PRD_1C02A112RMKG	CNT_2PSPCJ8HPEQ0	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 4	[]	Student Council's Discretion 4	Seven of the best episodes selected from the first three original novels! From a dramatic story about Sugisaki's past, to a story in a true fantasy style, the 4th installment, full of variety, has finally arrived!!	Laid-back and comfortable, and sometimes serious! This 4th installment is as popular as ever!	01KKTXXQ6QMMPJ3HBA80XXGR1P	4.0	2014-12-26T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 4	(C)TOMO 2010 (C)SEKINA AOI, KIRA INUGAMI 2010	2014-12-26T15:00:00.000Z
PRD_1RV6TFJY099G	CNT_2JVR3W6Z9M90	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 8	[]	Student Council's Discretion 8	Mafuyu's virtue is in danger! Will she be able to change clothes safely?! Or see some scenes of student council activities with just the president. And at last, the last scene of the comics! What kind of ending could it be?!	Of course it's the student council room 'til the end. The end of Ken Sugisaki's harem story!	01KKTXXTSDX7C3RQV6DCJNCFAA	8.0	2015-01-27T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 8	(C)TOMO 2013 (C)SEKINA AOI, KIRA INUGAMI 2013	2015-01-27T15:00:00.000Z
PRD_2VNXJVYHCHGG	CNT_18SDFS9AZBJ0	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 3	[]	Student Council's Discretion 3	Is he starting to grow closer with the gorgeous girls of the student council, including council president Kurimu Sakurano?! Aiming to create a harem, Ken Sugisaki chats (leads on?) with the girls as always...	The story of Sugisaki's efforts as he strives to make the gorgeous girls of the student council into his harem!	01KKTXXMW6229KGTMXX3EXKAJ3	3.0	2014-12-23T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 3	(C)TOMO 2010 (C)SEKINA AOI, KIRA INUGAMI 2010	2014-12-23T15:00:00.000Z
PRD_34NRMJTHJPY0	CNT_1MFNJC2WQ15G	Student Council's Discretion CNT_1SJ2M8KF84DG	CNT_1SJ2M8KF84DG	2	1	1	Volume 6	[]	Student Council's Discretion 6	On his way to the student council room as always, a bored Sugisaki dozes off... and finds himself in an RPG(-ish) world. Now, Sugisaki-the-Hero must fight against a demon king along with Summer, Winter, and the others!	Sometimes there are even intense stories?! Here's a record of a true adventure!	01KKTXXRZR7RC048R9RX857R3Z	6.0	2015-01-27T15:00:00.000Z	KADOKAWA MANGA LAB_1BHKQTTBX3Q0	GEO_1PQM5BDYSMG0	Student Council's Discretion 6	(C)TOMO 2012 (C)SEKINA AOI, KIRA INUGAMI 2012	2015-01-27T15: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);