database: products: 9 rows where series_id = "CNT

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

9 rows where series_id = "CNT_0QA7G3WQBNNG"

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_00V4XXX3S2EG	CNT_34P6KPFKXXM0	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 3	[]	Dragons Rioting, Vol. 3	It's time for the Cordial Competition, in which the winner gets to make any one school rule that they wish. The challenge is a dance-off, and Rintaro finds himself paired with one of the three dragons--Kyoka! But the challenge of undergoing special training with the highly exposed Kyoka in her enormous estate is something else altogether! What maladies, misconceptions, and mishaps await?! Will it be a never-ending survival dance in an overexposed hell??	01K5GB3Y5C0B7HK2KS0K1J4FVT	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 3	2016-06-30T15:00:00.000Z
PRD_06VR4EDCGQY0	CNT_0QGBW20B6T50	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 4	[]	Dragons Rioting, Vol. 4	This looks like a job for Furuhata...I mean, Rintaro Tachibana! A swimsuit thief strikes! But when Rintaro searches for the culprit, he accidentally accuses a legendary dragon: the Dragon of Severe Waves Ren--who is also the Dragon of Storming Jade Rino's older sister! While conducting her own investigation, Keiko is attacked by a mysterious black beast! Now there's a black shadow enveloping the school...! Oh boy, the culprit this time around is seriously tough. This looks like a job for Furuhata...er, that is, Rintaro Tachibana.	01KG986W3G059AS3VRH96TG2EK	4.0	2016-08-29T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 4	2016-08-29T15:00:00.000Z
PRD_06Z21373D3CG	CNT_3K57PD8D8PQG	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 5	[]	Dragons Rioting, Vol. 5	Having somehow survived his first semester, Rintaro returns home to enjoy a peaceful summer break. Except Ayane and Rurina decide to tag along--just in time for the annoying opening of the summer festival! But somehow...two people with knowledge of Ayane's past show up...?!	01KG989Z2M5Z6V0PGVAH63E31Z	5.0	2016-11-21T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 5	2016-11-21T15:00:00.000Z
PRD_0KTK0VHZDD30	CNT_1DGK9TWQ980G	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 1	[]	Dragons Rioting, Vol. 1	Rintaro's got a problem: Sexual arousal can be deadly for him. This is terribly inconvenient when he's admitted to a former girls' academy where 99 percent of the student body is female! And worse, school supremacy is a Vicious power struggle centered around three powerful girls--the Dragons!	01KG93271GPBERDJ5H1K4YS5QC	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 1	2016-06-30T15:00:00.000Z
PRD_1AG4HJH6N8TG	CNT_0DPX5HDP7ZT0	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 9	[]	Dragons Rioting, Vol. 9	Rintaro and the other Dragons of Nangokuren fight to save their school! Saizo and his forces are in trouble, but desperation makes for a dangerous enemy. Can Asuna use her extensive training from Rintaro to overcome the final opponent? And could Rintaro finally learn the secret to vanquishing his greatest enemy-his lethal erection? It all ends here in this final volume of Dragons Rioting!	01KGA17RKATV85N5K45DYATB5G	9.0	2017-12-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 9	2017-12-19T08:00:00.000Z
PRD_1WW5TMWPCFKG	CNT_0G8XCBR03SQ0	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 2	[]	Dragons Rioting, Vol. 2	If Rintaro falls prey to eye candy, he could die. So it's just his luck that Mell, his new arcade buddy, happens to be the heavenly ruling tiger, one of the few girls who can hold her own against the dragons. But when the dragon of storming jade, Rino, appears with her own agenda, it seems that she and Mell harbor a deep dark past--and now Rintaro's at the center of it...! It's a girl-ridden panic with no sign of escape!	01K5G9XBEER0EJXEF3W6EMPNAB	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 2	2016-06-30T15:00:00.000Z
PRD_22XJTKHJWSJG	CNT_1P8DWHG7F23G	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 8	[]	Dragons Rioting, Vol. 8	The school of Black Mist and Dark Skies have suddenly shown up at Nangokuren and a four on four fight is declared! Will Rintaro and the Dragons of Nangokuren make it out on top...?	01KG9VMXYA987GX1MCJE78APA0	8.0	2017-09-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 8	2017-09-18T15:00:00.000Z
PRD_39VY4QKBYD5G	CNT_2SQJRPDD9PRG	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 7	[]	Dragons Rioting, Vol. 7	Rintaro has declared his intent to become one of the Dragons of Nangokuren High School. and to achieve the necessary support, he's also running for student council president! But his opponent is the blond bombshell Ema, an American exchange student and mixed martial arts champion whose popularity is through the roof! Does Rintaro have any hope of winning, or will he have to concede this election?	01KG9Z4S8CE67DQCBR425W4XFK	7.0	2017-06-19T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 7	2017-06-19T15:00:00.000Z
PRD_3B7AC1PF7M50	CNT_1TV5W5Y42QE0	Dragons Rioting CNT_0QA7G3WQBNNG	CNT_0QA7G3WQBNNG	2	1	1	Volume 6	[]	Dragons Rioting, Vol. 6	Who will be on top? The second semester's begun for Rintaro, who soon discovers a dragon statue in his locker, and anyone who possesses it will rule the school! Caught in the middle of the battle between the dangerous girls of Nangokuren High School, Rintaro can't forget the most important thing--to him, their knockout bodies are literally lethal!	01KG9YXM4JCHVG3T88Q4DRWTQT	6.0	2017-03-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Dragons Rioting, Vol. 6	2017-03-20T15: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);