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

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_096VFHQ23CX0	CNT_215YJCQ6X81G	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 6	[]	Forbidden Scrollery, Vol. 6	A rush of unusual gossip is spreading to the heart of Gensokyo, and a few clever individuals are each trying to steer the chaos to their own advantage. At risk is the delicate balance between humans and demons...Are dark days ahead for Gensokyo, or will hope come over the horizon? It's no laughing matter when the very meaning of truth is in danger!	01KGA6F4E90VD8JTSK3DA7ANB0	6.0	2019-02-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 6	2019-02-19T08:00:00.000Z
PRD_0FD82HPWTT9G	CNT_0VWDD07DJF9G	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 5	[]	Forbidden Scrollery, Vol. 5	Suzunaan is making a killing from humans and demons alike, and Kosuzu is there as always to watch over the shop and secure some sales. But her insatiable curiosity about the unknown draws her ever closer to the bizarre rumors spreading throughout Gensokyo-and she's not the only one getting involved! Reimu, Marisa, and the other regulars are familiar faces, but where are all these never-before-seen characters coming from?!	01KG9ARYFY31K0XZNNVN94DTSV	5.0	2018-11-20T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 5	2018-11-20T08:00:00.000Z
PRD_19F3NGWE6GYG	CNT_3GF9BXQ0ZVSG	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 3	[]	Forbidden Scrollery, Vol. 3	In a world of spirits and demons, nothing is ever as it seems, whether it's the Seven Wonders of Honjo or the story of a kindly exorcist. Kousuzu, Reimu, and Marisa are eager to get down to the truth, but they will soon discover that peeling back the mysteries of Gensokyo only brings about more questions...	01KGA48BV06V3WB4Y3HTP6CP0C	3.0	2018-05-22T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 3	2018-05-22T07:00:00.000Z
PRD_1T48PRT0J760	CNT_2PR3YW5B8K8G	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 7	[]	Forbidden Scrollery, Vol. 7	"The human heart that fears demons gives them their existence." With the knowledge of the mysterious relationship between humans and demons, Kosuzu starts in pursuit of Gensokyo's "truth"...but what does she find waiting for her?!	01KGA71P3FJDXNDD8WMJ1N9RB0	7.0	2019-05-28T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 7	2019-05-28T07:00:00.000Z
PRD_1WKCFD77NMK0	CNT_11B4R74VKX20	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 1	[]	Forbidden Scrollery, Vol. 1	Where else would a girl with the power to translate any tome she sets in her lap reside except a library? Sure, some books may be more dangerous than others, but that's far from discouragement for a true bibliophile like Kosuzu Motoori!	01KG9VVYDXH7WJWN0AR7XBHZ04	1.0	2017-11-21T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 1	2017-11-21T08:00:00.000Z
PRD_2QFD90Z9GPN0	CNT_2NFK128RCAX0	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 4	[]	Forbidden Scrollery, Vol. 4	The poster child for book rental shop Suzunaan, Kosuzu today is brimming with curiosity for all things demonic...In other words, it's a day just like any other! From a string of dine-and-dash incidents and unfailingly accurate fortune-telling to the mysteries of Kokkuri-san and a hidden print-on-demand scheme, life in Gensokyo is never boring when Kosuzu is involved!	01KGA53SQYGTY2F59S546WQBTP	4.0	2018-08-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 4	2018-08-21T07:00:00.000Z
PRD_2YVFAK2MJ0JG	CNT_2E6F5JHG7BNG	Forbidden Scrollery CNT_2M1FKD2JRBAG	CNT_2M1FKD2JRBAG	2	1	1	Volume 2	[]	Forbidden Scrollery, Vol. 2	In the mystic realm of Gensokyo, library worker Kosuzuna awakens to her ability to read demon books. This volume crosses over with the games Double Dealing Character and Hopeless Masquerade of the Japanese hit franchise, Touhou!	01KGA3APH0BBWKD4R07A23CRD6	2.0	2018-03-27T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Forbidden Scrollery, Vol. 2	2018-03-27T07: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);