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

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_0K8RMZJ48TEG	CNT_1A49SK1TMZN0	If Witch, Then Which? CNT_0NCFYB4B9AS0	CNT_0NCFYB4B9AS0	2	1	1	Volume 1	[]	If Witch, Then Which?, Vol. 1	Ever since a lifesaving blood transfusion, Haruka Kuze has been indebted to Maruna Rinjou. The only problem: How do you show your gratitude to someone who barely gives you the time of day? So when he finds out she’s actually a witch, Haruka swears he’ll do whatever it takes to help her graduate from magic school—even if it means cross-dressing as a girl! But does Maruna really hate him, or is there another reason she gets so flustered when he’s around?	01KG9CBGYHRZW4T5RSK4EVEVZH	1.0	2020-08-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	If Witch, Then Which?, Vol. 1	2020-09-22T07:00:00.000Z
PRD_21M58FYE7SE0	CNT_3Z824R68ZM0G	If Witch, Then Which? CNT_0NCFYB4B9AS0	CNT_0NCFYB4B9AS0	2	1	1	Volume 2	[]	If Witch, Then Which?, Vol. 2	Although Haruka’s cross-dressing may have been good enough to get him into the Eastern Woods of the Sacred Witch Academy, keeping it secret is another matter, with his everyday life turning into a dance with danger! But while he focuses on dodging clingy classmates and communal baths, others are starting to notice Maruna’s powers. As the moon rises on Walpurgis Night, Haruka and Maruna are approached by the academy’s most brilliant prodigy with a request to help her investigate a deeply personal mystery…	01KG9E12XS5D181TH7GNPQ5DEA	2.0	2021-04-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	If Witch, Then Which?, Vol. 2	2021-06-01T07:00:00.000Z
PRD_32W8JK7NY5AG	CNT_3B4N61MT39N0	If Witch, Then Which? CNT_0NCFYB4B9AS0	CNT_0NCFYB4B9AS0	2	1	1	Volume 3	[]	If Witch, Then Which?, Vol. 3	Following their kiss, Haruka is still trying to clear the air with Maruna when his cross-dressing is exposed! Faced with expulsion, he’ll have to come to grips with his own feelings-does he just want to repay Maruna for saving his life, or is there another reason he seeks to be by her side? With a mysterious threat attacking the academy, the two will have to come together as one witch if they want to protect their friends!	01KG9FR9A8KWCBGNY5F1MN0VB8	3.0	2021-07-27T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	If Witch, Then Which?, Vol. 3	2021-08-31T07: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);