database: products: 5 rows where series_id = "CNT

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

5 rows where series_id = "CNT_0Y25MV239Z3G"

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_1R8R70V0XHF0	CNT_15DZMX1W5WMG	Chaika: The Coffin Princess CNT_0Y25MV239Z3G	CNT_0Y25MV239Z3G	2	1	1	Volume 3	[]	Chaika: The Coffin Princess, Vol. 3	Chaika's true mission--as well as her true identity--is revealed at long last. Toru must make the tough decision to remain by the side of his traveling companion or risk the possibility of plunging the world into darkness again! But what good is a saboteur in a world without conflict? And just who is the mysterious figure helping Chaika from the shadows...?	01KG95HDZS6RVAFARN2RRHHT2G	3.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Chaika: The Coffin Princess, Vol. 3	2016-06-30T15:00:00.000Z
PRD_221B4GG9MVH0	CNT_0JZD3SB1GNJG	Chaika: The Coffin Princess CNT_0Y25MV239Z3G	CNT_0Y25MV239Z3G	2	1	1	Volume 2	[]	Chaika: The Coffin Princess, Vol. 2	"Attack the feudal lord's mansion!" With this bold declaration, Chaika affirms that she'll do whatever it takes--no matter how reckless--in order to fulfill her mission. "I want to leave proof that I lived." And with this solemn wish, Toru ensures that his journey with Chaika will change the world...	01KG95JCB23WNNDYKG19MYWSAK	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Chaika: The Coffin Princess, Vol. 2	2016-06-30T15:00:00.000Z
PRD_222Y3F8YEDKG	CNT_37EWBY961QQ0	Chaika: The Coffin Princess CNT_0Y25MV239Z3G	CNT_0Y25MV239Z3G	2	1	1	Volume 1	[]	Chaika: The Coffin Princess, Vol. 1	Five years of inconceivable peace after two hundred years of war left erstwhile saboteur Toru Acura without a job or a meaning in life--until he saves a mysterious wizard with a coffin on her back. But when the coffin-wielding, silver-haired Chaika Trabant hires Toru and his sister, Akari, to accompany her on a death-defying journey, Toru's life of mind-numbing, meaningless peace is about to end!	01KG94K2E5DXHWXFCDZ53GRP6S	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Chaika: The Coffin Princess, Vol. 1	2016-06-30T15:00:00.000Z
PRD_25J2SR6ZWKZG	CNT_185SBFX4YDV0	Chaika: The Coffin Princess CNT_0Y25MV239Z3G	CNT_0Y25MV239Z3G	2	1	1	Volume 4	[]	Chaika: The Coffin Princess, Vol. 4	A tip from the mysterious Guy leads Toru, Chaika, and Akari to a means of transportation--and the location of one of the heroes of the battle of the Gaz Imperial Capital, Dominica Skoda. But the journey to Dominica's residence is dangerous, and when the trio is ambushed by a group of monsters, they're saved in the nick of time by a mysterious female knight!	01K5G9XZD77HACQN4YA8GCPCE2	4.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Chaika: The Coffin Princess, Vol. 4	2016-06-30T15:00:00.000Z
PRD_2FNYVVS8GC5G	CNT_07R9FDYJ5FEG	Chaika: The Coffin Princess CNT_0Y25MV239Z3G	CNT_0Y25MV239Z3G	2	1	1	Volume 5	[]	Chaika: The Coffin Princess, Vol. 5	A blunt request by Toru results in both the end of Dominica Skoda's hospitality...and a battle over the remains of Arthur Gaz in her posession! Can Toru and his companions defeat a woman invulnerable to swords and magic? And could there be more to Dominica's true motivations than meets the eye...? The manga adaptation of Chaika: The Coffin Princess reaches its grand finale!!	01KG934ZAJG0S1X3Z4BGARN575	5.0	2016-10-03T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Chaika: The Coffin Princess, Vol. 5	2016-10-03T15: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);