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_18MBJMKRZHHG"

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_09CP2HEBJDP0	CNT_342JZB3DWZX0	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 4	[]	The Honor Student at Magic High School, Vol. 4	At First High, progress continues toward a debate between the Alliance--who want to abolish discrimination on the basis of magical ability--and the student council--who prefer the status quo. But when the debate is interrupted by a terrorist attack, it's up to Miyuki and her friends to save the day!	01KG988BNGNTEARBA968KF71QM	4.0	2016-10-03T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 4	2016-10-03T15:00:00.000Z
PRD_0JAN97DVFJB0	CNT_1XGFZ1AMWN80	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 6	[]	The Honor Student at Magic High School, Vol. 6	With Shizuku's victory, First High is off to a great start in the Nine School Competition! But the students at Third High aren't going to take it lying down-Airi Isshiki is participating in Cloud Ball and ready to win! Who will win the Nine School Competition, where magic and athleticism meet?	01KG9YXJ844ZMZ7G9VX726M7AY	6.0	2017-03-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 6	2017-03-20T15:00:00.000Z
PRD_0TSJX1DBNB10	CNT_1C5X8P78362G	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 1	[]	The Honor Student at Magic High School, Vol. 1	A century has passed since magic--true magic, the stuff of legends--has returned to the world. It is spring, the season of new beginnings, and a new class of students is about to begin their studies at the First National Magic University Affiliated High School, nickname: First High.A manga spin-off of the immensely popularlight novel series The Irregular at Magic High School, The Honor Student at Magic High School follows the events of the original series as seen through the eyes of Miyuki Shiba, Tatsuya's sister. The life of an honor student comes with a lot of expectations...and unexpected hidden feelings?!	01KG9320DSDPYN9QDPPQ3D6MG8	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 1	2016-06-30T15:00:00.000Z
PRD_19TTDJPG6A70	CNT_3Q0VKPYKGP00	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 8	[]	The Honor Student at Magic High School, Vol. 8	The girls of First High are going strong at the Nine School Competition! Can Honoka overcome Touko Tsukushiin's mastery of water to become Battle Board champion? And who will emerge victorious in the all-First High finals of Ice Pillars Break? It's Miyuki's overwhelming power vs. Shizuku's technical ingenuity, with both sides eager to prove something!	01KGA3DDPWDM9JPHJCFTN71A6B	8.0	2018-04-24T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 8	2018-04-24T07:00:00.000Z
PRD_1HKH2WPYNEHG	CNT_1SA7XTWXWRH0	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 3	[]	The Honor Student at Magic High School, Vol. 3	Having discovered that Kinoe Tsukasa was behind the attack on Tatsuya, Honoka and her friends follow him--but it's a trap! Miyuki's intuition tells her something's wrong, but will she be able to act in time? Being an honor student at Japan's most prestigious magical high school hasn't made Miyuki's life any easier!	01K5GB3SNTJAGTYR7ZEX9341FK	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 3	2016-06-30T15:00:00.000Z
PRD_1XCW8K83PJTG	CNT_2P65YB1NYKH0	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 10	[]	The Honor Student at Magic High School, Vol. 10	<DIV>The Mirage Bat finals are drawing near, and Miyuki and Airi are the two front-runners! Airi's confident in her jumping ability, but she'll need a lot more than that to take down First High's star player, who has already stunned the crowd with her incredible flight magic!</DIV>	01KGA7NC2SJB5XCM3PAPRMRFKZ	10.0	2019-10-01T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1G5EK0KH20W0	The Honor Student at Magic High School, Vol. 10	2019-11-26T00:00:00.000Z
PRD_280XBB01RJYG	CNT_3BFPASKDDD40	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 2	[]	The Honor Student at Magic High School, Vol. 2	It hasn't taken long for Miyuki and her brother Tatsuya to start drawing attention at First High, though for very different reasons. When the student council takes an interest, the devoted Miyuki isn't about to sit idly by while her precious brother's talents go unrecognized! But can these two siblings change people's attitudes in a system specifically designed to separate the "Blooms" from the "Weeds"?	01K5G9X63DSD0T5HFRKZKACPWT	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 2	2016-06-30T15:00:00.000Z
PRD_2BA6TC6JREB0	CNT_2G4A1R0EF8VG	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 11	[]	The Honor Student at Magic High School, Vol. 11	All that remains in the Nine Schools Competition are the Monolith Code finals, but with Miyuki’s win, the champions have already been decided-First High! Yet, even in victory, not everyone’s celebrating: Miyuki can do nothing but worry about Tatsuya. He’s left to hunt down the dark organization pulling the strings behind the scenes of the competition, and he won’t stop until he’s had his revenge…With thoughts of Miyuki filling his head, will he emerge triumphant in this thrilling conclusion?	01KG9G62R33Q00B9GPFW3401EW	11.0	2021-06-23T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 11	2021-06-29T07:00:00.000Z
PRD_355FS4H1JE6G	CNT_06D5S4Q4TQZG	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 7	[]	The Honor Student at Magic High School, Vol. 7	The rivalry between First High and Third High escalates! Now that Miyuki has dazzled the audience, it's Amy's turn in the Ice Pillars Break event at the Nine School Competition. But she's up against a fierce opponent: Third High's Shiori Kanou! Can Amy's brawn defeat Shiori's brains, or will her chances of winning be stopped cold?	01KG9Z4T086XKZE4BZ5E48RE83	7.0	2017-06-19T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 7	2017-06-19T15:00:00.000Z
PRD_3A9R495VKZ1G	CNT_0NHE55PJY22G	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 5	[]	The Honor Student at Magic High School, Vol. 5	Miyuki heads to the Nine School Battle, but there's trouble waiting for her--trouble in the form of Third High School's Airi Isshiki. The competition is fierce enough already--what does Airi want besides victory? Family politics and magical intrigue abound as the Nine School Battle arc begins!	01KG9YR5FZPGZCY2E325Z2C91D	5.0	2016-12-27T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 5	2016-12-27T15:00:00.000Z
PRD_3HXBDB825FQG	CNT_34AEM3H7J3KG	The Honor Student at Magic High School CNT_18MBJMKRZHHG	CNT_18MBJMKRZHHG	2	1	1	Volume 9	[]	The Honor Student at Magic High School, Vol. 9	All eyes are on Tatsuya as he takes the stage for the first time in the Nine Schools Competition! With Miyuki watching with rapt attention, how will Tatsuya fare? Don't miss the tournament's thrilling climax!	01KGA5HAY655GWPNNTGFHQ4622	9.0	2018-12-11T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	The Honor Student at Magic High School, Vol. 9	2018-12-11T08: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);