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

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_148V2SKHSDRG	CNT_1AG0C1WHVQT0	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 4	[]	Zero's Familiar Vol. 4	Louise and her spellbinding companions have been sent on a top secret mission to the Kingdom of Albion, where the royal family is besieged on all sides by rebelling nobles. They are accompanied by the dashing Viscount Wardes, who is not only caprain of the Griffin Corp, but is also Louise's longtime fiance. Saito can't help but feel jealous of the impressive captain, but there's a more pressing concern: will they find rhe Prince of Albion in time before the kingdom is lost?	A Witch... and Her Boy Toy	01K5GAS1CFFG9KS406MEFXHDH0	4.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 4	(C) Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15:00:00.000Z
PRD_1FFTZZFY1BYG	CNT_1D5AFX72NP40	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 2	[]	Zero's Familiar Vol. 2	In a world where sorcery reigns supreme, bumbling witch-in-training Louise Francoise Le Blanc de La Valliere is known by her classmates at the Tristan Academy of Magic as “Louise the Zero.” During an important coming-of-age ritual where each student must summon a lifelong familiar, Louise proves that she’s the ultimate klutz when she mistakenly conjures a teenage boy from Earth. Now, whether they like it or not, Louise and her unwilling servant, Saito, are bound to each other by the laws of magic for all eternity!	A Witch... and Her Boy Toy	01K5GARYSRZWBEK5J5VSWP0PW1	2.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 2	(C) Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15:00:00.000Z
PRD_1X5R5KM5HFTG	CNT_1BV6D4G11SR0	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 6	[]	Zero's Familiar Vol. 6	Saito's been in hot water with Louise before, but things have never looked this bad! Siesta, and the rest of the gang take Saito on a treasure hunt that could fix his romantic problems once and for all, but he finds more than he bargained for--the first real clue that could lead him back to his homeworld. Meanwhile, the small nation of Tristain is on the brink of war with the Albion Empire whose underhanded tactics threaten to push hostilities over the edge. Can a mage called Zero and her legendary familiar come together to prevent a catastrophe?	A Witch... and Her Boy Toy	01K5GAS2T92WYJ1P7J3A2NKSZK	6.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 6	(C) Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15:00:00.000Z
PRD_33D0YW7AZEA0	CNT_2BGWXDB5699G	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 1	[]	Zero's Familiar Vol. 1	In a world where sorcery reigns supreme, bumbling witch-in-training Louise Francoise Le Blanc de La Valliere is known by her classmates at the Tristan Academy of Magic as “Louise the Zero.” During an important coming-of-age ritual where each student must summon a lifelong familiar, Louise proves that she’s the ultimate klutz when she mistakenly conjures a teenage boy from Earth. Now, whether they like it or not, Louise and her unwilling servant, Saito, are bound to each other by the laws of magic for all eternity!	A Witch... and Her Boy Toy	01K5G9TEYF0X8Y5B3FTQMEAG5A	1.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 1	(C) 2006 Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15:00:00.000Z
PRD_396J6PWS3BF0	CNT_0DFKZMDYF6MG	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 5	[]	Zero's Familiar Vol. 5	Louise and her spellbinding companions have been sent on a top secret mission to the Kingdom of Albion, where the royal family is besieged on all sides by rebelling nobles. They are accompanied by the dashing Viscount Wardes, who is not only caprain of the Griffin Corp, but is also Louise's longtime fiance. Saito can't help but feel jealous of the impressive captain, but there's a more pressing concern: will they find rhe Prince of Albion in time before the kingdom is lost?	A Witch... and Her Boy Toy	01K5GARZBWA0QE901HKMG4WCMH	5.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 5	(C) Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15:00:00.000Z
PRD_3AG3V22Q7C80	CNT_2A56WAQP07BG	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 7	[]	Zero's Familiar Vol. 7	Saito's been in hot water with Louise before, but things have never looked this bad! Siesta, and the rest of the gang take Saito on a treasure hunt that could fix his romantic problems once and for all, but he finds more than he bargained for--the first real clue that could lead him back to his homeworld. Meanwhile, the small nation of Tristain is on the brink of war with the Albion Empire whose underhanded tactics threaten to push hostilities over the edge. Can a mage called Zero and her legendary familiar come together to prevent a catastrophe?	A Witch... and Her Boy Toy	01K5GAS0VBTS6W1DN98HHZXGYY	7.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 7	(C) Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15:00:00.000Z
PRD_3WWHK950KFB0	CNT_086FX3PWVA8G	Zero's Familiar CNT_0E3VPE27HW90	CNT_0E3VPE27HW90	2	1	1	Volume 3	[]	Zero's Familiar Vol. 3	In a world where sorcery reigns supreme, bumbling witch-in-training Louise Francoise le Blanc de La Valliere is known by her classmates at the Tristain Academy of Magic as "Louise the Zero." During an important coming-of-age ritual, when each student must summon a lifelong familiar, Louise proves herself klutz when she mistakenly conjures a teenage boy from Earth. Now, whether they like it or not, Louise and her unwilling servant, Saito, are bound to each other by the laws of magic for all eternity!	A Witch... and Her Boy Toy	01K5GAS5DDJ0CQE1EP7P78YGF4	3.0	2015-11-13T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Zero's Familiar Vol. 3	(C) Nana Mochizuki, Noboru Yamaguchi / Media Factory, Inc.	2015-11-13T15: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);