products

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

8 rows where series_id = "CNT_1WDQTB65VJQ0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, on_sale_at, 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_0P4HADBP2YWG CNT_1HAZH9F45960 Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 2 []   Kagerou Daze, Vol. 2   Takane Enomoto has a secret.Her life is pretty weird. She attends high school with only one other student in her class and has a teacher who takes "underachievement" to exciting new heights--and neither of the know the truth about her double life as a legendary gamer. Somehow, these three misfits are going to have to put on a show for the school festival. But how does that connect to Takane's secret? And more importantly, how does that secret connect to the Mekakushi-dan? And come to think of it, how did Shintaro and the rest of the Mekakushi-dan's trip to the amusement park finally play out? Find out as multimedia creator Jin's blockbuster novel series hurtles into its second volume!   01KG95JHK1YAX06VRTPRK7VJ68 2.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_0VP061KTEZ10 CNT_24FMJQYW8RW0 Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 7 []   Kagerou Daze, Vol. 7   Now you see her, now you don't!As a child, Tsubomi Kido rarely spoke. Just as she starts to find herself, with help from her older sister, tragedy strikes her home. When death approaches, Kido discovers the Kagerou Daze, where she meets a mysterious woman who grants her a powerful gift...or curse. In the outside" world of the present, the Mekakushi-dan gathers their combined strength to unravel the mystery that's ensnared them all!   01KG9Z7KCC6CSGSFEEV332SWCB 7.0 2017-07-24T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 7     2017-07-24T15:00:00.000Z   0 0
PRD_0W3E28G3074G CNT_2TB80ENMC2E0 Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 3 []   Kagerou Daze, Vol. 3   The past is never really gone.On a certain summer day, a certain boy and girl meet. What is it that lurks behind the strange experience they chance to have? What is the link that connects all of this? The truth is finally coming to light, but can the Mekakushi-dan, armed with only their eyes, solve the riddle? The third novel from Internet phenomenon and multimedia creator JIN is here!   01KG95GMQ297YVGTM2MTJC3VCC 3.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_1ENXCXNSP29G CNT_33GEE87KKX90 Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 1 []   Kagerou Daze, Vol. 1   Shintaro Kisaragi is about to have a terrible day.After two years of being an unemployed shut-in, Shintaro Kisaragi is forced out of his room and into the wide, uncaring world by a disastrous series of events involving his computer's keyboard and a bottle of soda. What begins as a simple errand soon spirals out of control as his luck turns from bad to worse. It starts with a hostage situation and only gets weirder from there--and it turns out Shintaro Kirasagi isn't the only person whose life is going to be changed forever this blistering summer afternoon!   01KG6ZFN3RAM81GEG6Z4DXTKFY 1.0 2016-06-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_1K70FWQ3XZ50 CNT_3KTHEJV3WJE0 Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 4 []   Kagerou Daze, Vol. 4   A certain boy and girl meet on a certain endless summer day. They thought they were alone, misunderstood by everyone, but the powers they hold in their eyes lead them to a group that does understand them: the Mekakushi-dan. They're not alone anymore, but now they have a new mystery to solve: What is the phenomenon of the "kagerou daze," and who is the shadowy figure behind it?   01KG984TM8XEVRNG84QHV7NY5S 4.0 2016-08-18T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 4     2016-08-18T15:00:00.000Z   0 0
PRD_1V6A0EE6ZHZG CNT_2BYY2YNCC44G Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 6 []   Kagerou Daze, Vol. 6   It was a never ending long, long summer day when Shintarou feels a sudden change in his body. While this is happening, he has a momentous meeting with his upperclassman, who tells Shintarou the secret truths about this world's past. What in the world is going on?   01KG98AVBNRJBPSQ9WQK0W0153 6.0 2017-01-30T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 6     2017-01-30T15:00:00.000Z   0 0
PRD_24R5EPCV5AAG CNT_3C40WEQRDD9G Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 5 []   Kagerou Daze, Vol. 5   Despite their youth, sorrow stalks Kano, Kido, and Seto. Their strange powers prevent them from fitting in at their orphanage, so finally, they escape. The trio is taken in by the Tateyama household, where the cheerful Ayano lives--but the peace is short-lived...   01KG9881RJD8VXJQ3CECYZQEXE 5.0 2016-09-26T15:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 5     2016-09-26T15:00:00.000Z   0 0
PRD_2RET37AHT2HG CNT_0824VSX3V6HG Kagerou Daze CNT_1WDQTB65VJQ0 CNT_1WDQTB65VJQ0 2 2 1 Volume 8 []   Kagerou Daze, Vol. 8   It was a certain summer day when they met. It was a day that would go on for a long time...forever. As their enemies stood in their path, members of the Mekukashi-dan fell one after another. After temporarily stalling their opponents, Azami came up with a radical plan to seal them away, but it could only succeed at the cost of the life of one of their own... As their enemies began advancing again, what fate with the Mekukashi-dan choose...?   01KGA5GYQ4R0DV6MNJVHR6Q2C8 8.0 2018-12-18T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kagerou Daze, Vol. 8     2018-12-18T08: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);