database: products: 14 rows where series_id = "CNT

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

14 rows where series_id = "CNT_3ZCPD5PRD7RG"

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_05RKAQBDABTG	CNT_2Q47248YMDY0	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 11.5	[]	Classroom of the Elite Vol. 11.5	Despite the school's tampering, Class C made it through the special exam without anyone being expelled. Now, they face the final event of their first year--the graduation ceremony. Horikita struggles to decide what to say to her brother before he leaves, while Ayanokouji puts in motion his plan to deal with Tsukishiro, seeking allies in the form of the other homeroom instructors. Meanwhile, his classmates' suspicions about him grow--including one girl who might be getting a little too fascinated by him.	KEEP YOUR FRIENDS CLOSE	01KH3RWJQJ8YVW19SQYAK2QXKT	11.5	2024-04-26T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 11.5	© Syougo Kinugasa 2019	2024-05-14T07:00:00.000Z
PRD_0J9BYGN0H6EG	CNT_11KT419BMH1G	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 4.5	[]	Classroom of the Elite Vol. 4.5	The grueling summer vacation special tests are finally at an end. As the clock ticks down on the last glorious days of summer, the students of the Tokyo Metropolitan Advanced Nurturing High School frantically try to squeeze in all the things they've left undone and unsaid. Get a glimpse into the secret lives of supporting characters and watch romantic confessions and pool-side drama unfold in this volume of short stories that bridges crucial gaps between the end of first semester--and the start of the second.	I KNOW WHAT YOU DID THIS SUMMER	01KGASKVV9BY4P20DW2ZK2N907	4.5	2023-09-15T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 4.5	Syougo Kinugasa 2016	2023-11-23T08:00:00.000Z
PRD_0QYYDGTCXQ7G	CNT_2NXTGYF781RG	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 7	[]	Classroom of the Elite Vol. 7	The end of the second semester is near, and Ryuuen's manhunt for Class D's mastermind is only getting more aggressive. When he and his goons decide to torture an answer out of Karuizawa, Ayanokouji decides it's finally time to step forward--if, that is, Karuizawa doesn't break under the pressure first!	THE SCHEMER, REVEALED!	01KGAVBJWX0XWF6QE2HYSM51WY	7.0	2023-12-04T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 7	Syougo Kinugasa 2017	2024-02-01T08:00:00.000Z
PRD_0TFEZ3QPSP6G	CNT_0N7QG85FQ0SG	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 5	[]	Classroom of the Elite Vol. 5	The second semester kicks off, and the students hit the ground running--literally, with a school-wide sports festival! With Class-D's future on the line, Ayanokouji has to decide how far he'll go to avoid the limelight--and reckon with the consequences of letting everyone glimpse his true abilities on the field!	ON YOUR MARKS, GET SET, GO!	01KGATD83Y7585E0XG7TNM671J	5.0	2023-12-04T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 5	Syougo Kinugasa 2017	2024-01-04T08:00:00.000Z
PRD_0Z0VF5DVZ500	CNT_0H21F7SDV5P0	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 9	[]	Classroom of the Elite Vol. 9	Sakayanagi puts her plan to crush Ichinose into motion, spreading rumors of her alleged criminal history through the school like wildfire. With Class B at a loss, and Ichinose herself uncharacteristically reluctant to fight back, can Ayanokouji step in to save her reputation? Meanwhile, Kushida makes contact with student council president Nagumo in what might prove to be a very dangerous alliance, indeed.	The Many Crimes of Ichinose Honami	01KGAZ84V94G9SEC6VWM276YTB	9.0	2024-02-01T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 9	Syougo Kinugasa 2018	2024-03-07T08:00:00.000Z
PRD_0ZA5T5WHV8VG	CNT_0GNM5AM247Q0	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 1	[]	Classroom of the Elite Vol. 1	Students of the prestigious Tokyo Metropolitan Advanced Nurturing High School are given remarkable freedom--if they can win, barter, or save enough points to work their way up the ranks! Ayanokoji Kiyotaka has landed at the bottom in the scorned Class D, where he meets Horikita Suzune, who's determined to rise up the ladder to Class A. Can they beat the system in a school where cutthroat competition is the name of the game?	The cutthroat school drama light novels that inspired an anime!	01KGB6VGXT09SVEXFYZX4HHN8B	1.0	2023-05-26T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 1	Syougo Kinugasa 2015	2023-06-20T07:00:00.000Z
PRD_1AX0F0EQASS0	CNT_0F9SN33PM3P0	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 4	[]	Classroom of the Elite Vol. 4	The second half of the special summer test finds the students duking it out aboard a luxurious cruise ship. Divided into twelve groups patterned after the signs of the Zodiac, all four classes are faced with a devilishly difficult test of their thinking skills. They may have survived the island, but they're not out of hot water yet!	SIGNS OF TROUBLE	01KGASKZYZ3RF0ZSYK03TTHW3A	4.0	2023-09-15T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 4	Syougo Kinugasa 2016	2023-10-19T07:00:00.000Z
PRD_1D379K95K9H0	CNT_3JXQ1BZTMKE0	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 6	[]	Classroom of the Elite Vol. 6	There's upheaval in the air as another special exam approaches and Nagumo officially replaces Horikita Manabu as student council president. Meanwhile, Ryuuen is out for blood, and he's set his sights on Horikita Suzune as the next possible candidate for Class D's mysterious mastermind!	SHAKING THINGS UP	01KGAVBP99QZ7HYPCQ3X12NGGJ	6.0	2023-12-04T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 6	Syougo Kinugasa 2017	2024-01-04T08:00:00.000Z
PRD_1G84ZQ0RQFA0	CNT_0N0Z8NV09ZW0	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 7.5	[]	Classroom of the Elite Vol. 7.5	School may be on vacation, but the scheming never stops! Christmas draws near, and Karuizawa and Satou compete for Ayanokouji's affections while new student council president Nagumo makes his first sinister moves. Don't miss this bonus volume of short stories, covering the events of a winter break that will decide the balance of power in the upcoming third semester!	MISTLETOE AND MACHINATIONS	01KG9PPBQZ07M0J3A7B6QF156P	7.5	2024-02-01T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 7.5	Syougo Kinugasa 2018	2024-02-08T08:00:00.000Z
PRD_1SXNV50RRX4G	CNT_2C0FZ87WYR7G	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 3	[]	Classroom of the Elite Vol. 3	Having survived their final exams, Ayanokoji and the others are looking forward to an idyllic school-sponsored summer vacation aboard a cruise ship. But nothing is ever quite as it seems with the Tokyo Advanced Nurturing High School, and the cruise turns out to be the cover for a series of special tests! What grueling new challenges await them out at sea?!	CRUISING FOR A BRUISING	01KH3FY4JXA1X7XB4NZ1JQYT2K	3.0	2023-07-24T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 3	Syougo Kinugasa 2016	2023-09-14T07:00:00.000Z
PRD_27K8GER8CBB0	CNT_1QF0J3DTFYEG	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 11	[]	Classroom of the Elite Vol. 11	Still reeling from the shock of their first expulsion, the first-years head into the last special exam of the year--a seven-event gauntlet that sees Class A facing off against Class C, and Class B against Class D. With each class's elected commander facing expulsion if they lose, Ayanokouji volunteers for the role to quell his classmates' suspicion about the events of the last exam. And with Sakayanagi captaining Class A, making this the right place and right time for their long-anticipated personal showdown--he might just need that Protection Point before too long.	CHECKMATE	01KH3QRHXQTHZEX29REWGBTH6Y	11.0	2024-04-26T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 11	© Syougo Kinugasa 2019	2024-05-14T07:00:00.000Z
PRD_2QZJ4NP0NA60	CNT_3YBKA4ED5T5G	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 2	[]	Classroom of the Elite Vol. 2	Class D has conquered the midterms, but their celebration is cut short when three Class C students falsely accuse Sudou of assaulting them! With their friend facing expulsion, and the class's points on the line, Ayanokoji, Horikita, and Kikyou must team up to gather evidence to prove his innocence.	THE RELUCTANT WITNESS	01KGB7X358976ZK717NA1W23ZN	2.0	2023-05-26T07:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 2	Syougo Kinugasa 2015	2023-07-27T07:00:00.000Z
PRD_2YVGPV2PH6GG	CNT_3HDAZYY9JP6G	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 10	[]	Classroom of the Elite Vol. 10	It's spring, and for the first time in the school's history, no one has been expelled after the third semester exams. As a result, the Advanced Nurturing High School sets a cruel test--each class must choose one of their own members to be expelled. Chaos consumes the first-years as Hirata tries and fails to keep the class from turning on each other, Ichinose strikes a costly bargain with Nagumo, and Ryuuen's classmates seem ready to throw him to the wolves. Can Class C make it out of this unscathed--or will they be undone by traitors within?	Popularity Contest	01KGAZ85CGXV92670DCGHB192C	10.0	2024-02-01T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 10	Syougo Kinugasa 2019	2024-04-04T07:00:00.000Z
PRD_3PHCG1KXNFSG	CNT_1MNNRYP4EFDG	Classroom of the Elite CNT_3ZCPD5PRD7RG	CNT_3ZCPD5PRD7RG	2	4	2	Volume 8	[]	Classroom of the Elite Vol. 8	The third semester kicks off in high gear with a special boot camp deep in the mountains. Forcibly separated into groups along grade and gender lines, the first, second and third years alike must work together to survive the rugged terrain. Even worse? The leader of the group that comes in last will be expelled. Can Class D make it back to campus intact, or is this where they finally say goodbye to one of their own?	ROUGHING IT	01KGAZ7Y67XZBMMAP810J6KB2J	8.0	2024-02-01T08:00:00.000Z	Seven Seas Siren LAB_13Q4428H6SGG	GEO_1PKAG51AEAQG	Classroom of the Elite Vol. 8	Syougo Kinugasa 2018	2024-03-07T08: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);