database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_1G611XSQKZ20"

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_18Y311WZBA8G	CNT_0VKBKQH39DBG	Puella Magi Madoka Magica CNT_1G611XSQKZ20	CNT_1G611XSQKZ20	2	1	1	Volume 2	[]	Puella Magi Madoka Magica, Vol. 2	While Madoka continues to deliberate over the decision to join Akemi as a magical girl, her best friend, Sayaka, seizes the chance to wish for the recovery of the boy she loves. But when Sayaka is caught in a territory dispute with a more experienced (and more deadly) magical girl named Kyouko, Madoka is reminded that being a magical girl is more than a matter of donning a frilly costume and fighting evil...it is also a matter of life and death!	01KG985CNHXXQ4DJKXE70H1V1D	2.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Madoka Magica, Vol. 2	2016-08-18T15:00:00.000Z
PRD_397BTAFW9AR0	CNT_1V823RC7FWV0	Puella Magi Madoka Magica CNT_1G611XSQKZ20	CNT_1G611XSQKZ20	2	1	1	Volume 1	[]	Puella Magi Madoka Magica, Vol. 1	Madoka fans, rejoice! The original Puella Magi story that grabbed hearts is re-releasing in a new Omnibus edition. Return to the tale of Madoka Kaname and her mysterious new classmate… What would you give to have magical power beyond your very dreams?	01KG6ZH6Q76X05NZ07AWKJ49GC	1.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Madoka Magica, Vol. 1	2016-08-18T15:00:00.000Z
PRD_3APV8QDTDBS0	CNT_3VXN0EQZ0XT0	Puella Magi Madoka Magica CNT_1G611XSQKZ20	CNT_1G611XSQKZ20	2	1	1	Volume 3	[]	Puella Magi Madoka Magica, Vol. 3	Madoka is horrified to learn the true nature of the witches she and her friends, the Magical Girls, have been fighting-and the terrible fate that awaits any Magical Girl who accepts Kyubey's offer of power. Having watched countless Magical Girls sacrificed for the larger aims of his people, Kyubey is only interested in securing more girls to that end, and Madoka is left with his chilling reminder that she too is destined to be a Magical Girl of incredible power... Can Madoka and her friends escape this tragic fate?	01KG985D56Z6CMCJEM5F0V6VZT	3.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Puella Magi Madoka Magica, Vol. 3	2016-08-18T15: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);