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

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	copyright	on_sale_at
PRD_1N4AJTJV21BG	CNT_2B8GGGX54130	Dra-Q CNT_3CY8DEWGAW1G	CNT_3CY8DEWGAW1G	2	1	1	Volume 2	[]	Dra-Q 2	In a twisted tale of star-crossed lovers, fate brought together Amelie, a soft-spoken vampire, and Pako, a high school delinquent. Yet even as they shared a tender moment, Pako's classmate Maria sank her teeth into his neck, turning him into a vampire's worst enemy: a werewolf! Will Pako's newfound hunger drive a stake between him and Amelie?	01KG9QARZ73NEPY0H5BRGAVJXY	2.0	2025-03-07T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Dra-Q 2	Chiyo/Kodansha Ltd.	2025-03-18T07:00:00.000Z
PRD_1V4AR388M7YG	CNT_3WAM32RPRZCG	Dra-Q CNT_3CY8DEWGAW1G	CNT_3CY8DEWGAW1G	2	1	1	Volume 1	[]	Dra-Q 1	High schooler Amelie Kurosaki isn't like the other girls. She's secretly a vampire, which means she can't smile (her fangs will show), she can't cry (her eyes will glow red), and she absolutely, positively cannot fall in love with a human (love leads to bloodlust). The problem is, Amelie can't help staring wistfully whenever she sees a certain third-year delinquent known as Pako. Then, a fateful incident after school results in a surprise confession, followed by an even more shocking attack that reveals Amelie's true nature. Can a rough-and-tumble delinquent and a strong vampire with a soft side make an un-life together?	01KG9SC50AC92SNKJ4EJ5HS254	1.0	2025-01-10T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Dra-Q 1	Chiyo/Kodansha Ltd.	2025-01-21T08:00:00.000Z
PRD_2QZTKVP23QMG	CNT_2PQYCNY5KAT0	Dra-Q CNT_3CY8DEWGAW1G	CNT_3CY8DEWGAW1G	2	1	1	Volume 3	[]	Dra-Q 3	For one brief moment, it seemed like Pako and Amelie might finally have their happy ending. Then an offhand comment from Amelie made Pako think her responsible for his father's death, leading him to run her through in a fit of rage and grief. Their ancient truce broken, the werewolves and vampires now prepare for war. Will history repeat itself, or can two lovers show their families a different path? FINAL VOLUME!	01KGBNGCR1CX7S6G684FYMJ6J6	3.0	2025-05-01T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Dra-Q 3	Chiyo/Kodansha Ltd.	2025-05-20T07: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);