products

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

5 rows where series_id = "CNT_34Z3NM958070"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at (date), on_sale_at (date)

id ▼ content_id series_id parent_content_id level content_type product_type title alt_titles subtitle display_title display_title_short description description_short image_id display_order listed_at label_id geoblock_id display_name copyright on_presale_at on_sale_at off_sale_at add_on add_on_campaign_only
PRD_10HDMNMC1NR0 CNT_0B2KD62G8QB0 Spell of Desire CNT_34Z3NM958070 CNT_34Z3NM958070 2 1 1 Volume 3 []   Spell of Desire, Vol. 3   When it becomes known that Kaoruko has received the power of the Witch Queen, she and Kaname are ordered to appear before the coven of the Black Witches. There, Kaoruko discovers that she must become a Black Witch in order to control her rampaging powers. But that means she will be offered up to an incubus—who presents himself as Kaname as he closes in on her!   01KGBHMC0TP4ZNZA28K0J8XNDV 3.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PZ1FZ4QK0N0 Spell of Desire, Vol. 3 MAJO NO BIYAKU © 2012 Tomu OHMI/SHOGAKUKAN   2024-11-26T08:00:00.000Z   0 0
PRD_1KT6FNV6EWQG CNT_0TY1B0KAPYCG Spell of Desire CNT_34Z3NM958070 CNT_34Z3NM958070 2 1 1 Volume 4 []   Spell of Desire, Vol. 4   In order to become a Black Witch, Kaoruko makes a pledge with Kaname. However, that means that Kaname will be breaking his pledge as a knight and betraying the Witch Queen! If the Witch Queen awakens, Kaname will suffer a terrible punishment... Meanwhile, Kaoruko is being stalked by someone who is after her powers!   01KGBHNFHPNRESZ82ZV0WMTWPG 4.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PZ1FZ4QK0N0 Spell of Desire, Vol. 4 MAJO NO BIYAKU © 2012 Tomu OHMI/SHOGAKUKAN   2024-11-26T08:00:00.000Z   0 0
PRD_2JMX607SB3YG CNT_2GVPQXQPDNNG Spell of Desire CNT_34Z3NM958070 CNT_34Z3NM958070 2 1 1 Volume 5 []   Spell of Desire, Vol. 5   When the Witch Queen awakens, Kaname is punished for falling in love with Kaoruko and betraying the Witch Queen! Kaname has his five senses and his memories of Kaoruko stripped from him, and Kaoruko is in despair... Can the two lovers find a way to break such a powerful spell and stay together?   01KGBHN2APXQWCE1Q53FXYFVE4 5.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PZ1FZ4QK0N0 Spell of Desire, Vol. 5 MAJO NO BIYAKU © 2012 Tomu OHMI/SHOGAKUKAN   2024-11-26T08:00:00.000Z   0 0
PRD_35F4RH0VBKEG CNT_3A26WTKWW65G Spell of Desire CNT_34Z3NM958070 CNT_34Z3NM958070 2 1 1 Volume 1 []   Spell of Desire, Vol. 1   Among the shocking news that Kaname imparts is that Kaoruko's mother is still alive and has entrusted Kaoruko with the immense power of the Witch Queen. As long as Kaoruko has that power, she will be the target of humans and demonic spirits alike. Kaname claims to be a "knight" that protects witches, but then he steals a kiss from Kaoruko...!   01KGBGMFSE3Z82R3NWWBDX0ZH5 1.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PZ1FZ4QK0N0 Spell of Desire, Vol. 1 MAJO NO BIYAKU © 2012 Tomu OHMI/SHOGAKUKAN   2024-11-26T08:00:00.000Z   0 0
PRD_36YMDY6HFMFG CNT_1AR9X8XMH74G Spell of Desire CNT_34Z3NM958070 CNT_34Z3NM958070 2 1 1 Volume 2 []   Spell of Desire, Vol. 2   The only thing that can keep Kaoruko's powers in check is a kiss from Kaname, but she can't help but be drawn to him! While Kaname struggles with his own growing attraction to Kaoruko, he suspects that Kaoruko's volatile powers will bring unwanted attention from the Black Witches Coven...with dangerous consequences for her!   01KGBHMBH79JKPCF7QREQ0NBTQ 2.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PZ1FZ4QK0N0 Spell of Desire, Vol. 2 MAJO NO BIYAKU © 2012 Tomu OHMI/SHOGAKUKAN   2024-11-26T08:00:00.000Z   0 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);