database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_0K3WDWMHJ5C0"

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	copyright	on_sale_at
PRD_0BP0NDZEE6RG	CNT_3C5415G720T0	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 7	[]	Kyo Kara MAOH!, Vol. 7	Everything seems to have calmed down for the Maoh, until Yuri returns to his castle and finds that he has a love child! Is he even old enough to have fathered a ten-year-old girl? If that wasn't bad enough, the tiny terror tries to kill Yuri and he twists his pivoting foot in the process. Eager to cheer Yuri up, Conrad arranges a trip to a famous human hot springs resort, but Yuri has stowed away his young assailant on board! Will she continue to attempt to assassinate Yuri or will Yuri's kindness win her over? And can Yuri even make it to the hot springs without getting himself into trouble?	01K5GA8ZKE75535CW3RKXE8JXT	7.0	2015-03-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 7	(C) Temari MATSUMOTO 2009 (C)Tomo TAKABAYASHI 2009	2015-03-30T15:00:00.000Z
PRD_0H2QPZNN907G	CNT_35AAM1VSTV30	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 2	[]	Kyo Kara MAOH!, Vol. 2	Temari Matsumoto's outrageous, gender-bending high-school alien love story continues! On the way to the border village, Yuri and the others run into Adalbert, who tries to convince Yuri to join the human side. But it turns out that Adalbert has lead the humans to the village to start a disturbance! Will this finally convince Yuri to become Maoh and put a stop to all this fighting?	01KKTXX3KJFFP25SPS1S3JNC43	2.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 2	(C) Temari MATSUMOTO 2006(C)Tomo TAKABAYASHI 2006	2014-10-28T15:00:00.000Z
PRD_0W896PR1XKW0	CNT_10QZEQN0EY7G	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 3	[]	Kyo Kara MAOH!, Vol. 3	The outrageously epic fantasy romance continues! In disguise on a luxury ship, Yuri, Conrad and Wolfram continue their voyage to Van de Veer island in search of the royal sword Morgif. But when pirates board the ship and raise Yuri's ire, can he keep from blowing his cover along with his top? And the sword of a demon king is going to have some nasty surprises of its own for our young hero!	01KKTXZRNHDV20S8BTVZ1W92RJ	3.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 3	(C) Temari MATSUMOTO 2007 (C)Tomo TAKABAYASHI 2007	2015-01-30T15:00:00.000Z
PRD_25G6C5Z7X2C0	CNT_0QHF1TTSYDQG	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 5	[]	Kyo Kara MAOH!, Vol. 5	Yuri and the three brothers set out to rescue Yuri's impostor, who is supposedly in the country of Sverlera. Along the way, Yuri and Gwendal are separated from the rest, only to be arrested for being elopers! Have they been lured into a trap? Only an abandoned bride and the true imposter will tell!	01K5GA68BS7GSXYHGWPGGEBSHF	5.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 5	(C) Temari MATSUMOTO 2008 (C)Tomo TAKABAYASHI 2008	2015-01-30T15:00:00.000Z
PRD_2CGM1AK0YJCG	CNT_3TNR8V3F9DP0	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 6	[]	Kyo Kara MAOH!, Vol. 6	Yuri's forced proximity to Gwendal (thanks to the handcuffs) leads to a better understanding between the two. But they are soon separated after their trial for ""elopement."" Yuri is sent to a labor camp consisting of only women, many of whom had been caught trying to elope with their Mazoku loveres. The injustice towards these women and their children sends Yuri into Maoh Mode and bent on retribution. Who stops Yuri this time from slaughtering cowardly soldiers with sand golems? And what about the Demon Flute? Will Yuri ever be able to play it and bring the rain?	01K5GA7483ZYYG7D8AG7X61Z2P	6.0	2015-03-02T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 6	(C) Temari MATSUMOTO 2008 (C)Tomo TAKABAYASHI 2008	2015-03-02T15:00:00.000Z
PRD_3E6J9T97TE4G	CNT_2DP252K02SE0	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 1	[]	Kyo Kara MAOH!, Vol. 1	Yuri Shibuya just can't catch a break. First, he had his head dunked in a toilet. Then he was transported to another world - where he finds himself king of the Mazoku's, a new race that expects him to lead them to war against all of humanity. And to top it all off, he's engaged - to a man! From the creator of Shinobu Kokoro comes an outrageous, gender-bending, high school demon love story!	01K5FVGBZR2WR6KGH4BR6AYXYR	1.0	2014-10-28T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 1	(C) Temari MATSUMOTO 2005(C)Tomo TAKABAYASHI 2005	2014-10-28T15:00:00.000Z
PRD_3T8GH4G29EQ0	CNT_38503X6418WG	Kyo Kara MAOH! CNT_0K3WDWMHJ5C0	CNT_0K3WDWMHJ5C0	2	1	1	Volume 4	[]	Kyo Kara MAOH!, Vol. 4	A king's job is never done! The quest to fully activate Morgif isn't over. As hard as Yuri tries to feed his strange sword human energy without taking unnecessary life, the duties of a King sometimes require unpleasant sacrifices. Can Yuri reconcile his true feelings with his new job?	01K5GA56E0BWR405FSVMAYQK1N	4.0	2015-01-30T15:00:00.000Z	VIZ Media LAB_15X2T7H1V07G	GEO_1PQM5BDYSMG0	Kyo Kara MAOH!, Vol. 4	(C) Temari MATSUMOTO 2007 (C)Tomo TAKABAYASHI 2007	2015-01-30T15: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);