products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
10 rows where series_id = "CNT_3BYRJ681AGJG"
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_07AT7FQTYK80 | CNT_08G2V520SYBG | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 2 | [] | Of the Red, the Light, and the Ayakashi, Vol. 2 | In the town of Utsuwa, bizarre phenomena like trains not stopping and people vanishing continue unabated. When an incident involving the sudden disappearance of a head kindergarten teacher occurs, the threesome of Yue, Tougo, and Akira undertake the investigation. But while trying to track down the missing teacher, the boys are unexpectedly attacked by a mysterious young man. Introducing himself as Sagano, the young man addresses Yue: "I need you to give me back my body"-- | 01K5G9X4EMMZ5SK9S9VEE3EVXD | 2.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 2 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0HXAC23A7W6G | CNT_2QG54CQC7ZDG | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 5 | [] | Of the Red, the Light, and the Ayakashi, Vol. 5 | After learning that Yoshiki, the person who saved Tsubaki's life, is inside him, Yue is shocked by the fact that he "ate" Yoshiki. While the shrine takes steps to keep Yue confined in preparation for the Meal, Kurogitsune plays his cards close to his chest, resolving to take action... Meanwhile, Sagano incites Akiyoshi to put out the light at the entrance to the shrine. Once there, Akiyoshi, with Tsubaki at his side, makes a decision--! The motives of ayakashi and the humans intersect, but where will that leave Yue and his friends...? | 01KG98AKV309S18QMGVBT3QWMT | 5.0 | 2016-12-27T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 5 | 2016-12-27T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0N9M6D97QG90 | CNT_1W59YYN5PKA0 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 6 | [] | Of the Red, the Light, and the Ayakashi, Vol. 6 | Both the Akujiki and Sagano descend upon the shrine of Utsuwa, now with its protective lamp out of commission and its barrier a distant memory. To save the captured Tsubaki, Yue goes up into the shrine with Akiyoshi, where he learns about the ties that bind ayakashi annihilator Sagano, Mikoto, and Shin, and the truth of the past that lies between the three. The beginning of the thread begins to unravel... | 01KG9YXF08J1HYTT44BCA866AC | 6.0 | 2017-03-20T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 6 | 2017-03-20T15:00:00.000Z | 0 | 0 | ||||||
| PRD_0ZDKZ669ZDN0 | CNT_2DT0D8G3AZY0 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 4 | [] | Of the Red, the Light, and the Ayakashi, Vol. 4 | When Tougo invites Akiyoshi and Yue over for dinner as a thank-you, all that's on the menu is food and fun. But when Tougo's father catches sight of Yue, he is startled and blurts out the name "Yoshiki." What exactly is the connection between this Yoshiki--to whom it seems Tougo owes his life--and Yue? And what kind of relationship existed between Yoshiki and Tougo's mother?! The secret behind the Meal is at long last revealed... | 01KG98857J1SE7QZ7E1JEQCY37 | 4.0 | 2016-09-26T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 4 | 2016-09-26T15:00:00.000Z | 0 | 0 | ||||||
| PRD_10FMN74T80G0 | CNT_17DJ9G7R99D0 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 7 | [] | Of the Red, the Light, and the Ayakashi, Vol. 7 | Yue makes for the shrine to rescue the captive Tsubaki. But there, he is met with the past of the man calling himself Sagano. Once upon a time, shrine master Mikoto herself saved Sagano's life when he went by the name "Akashi." But as a result, Sagano lost everything dear and had to stand by as his body became the vessel for Shin, the leader of the ayakashi. Now intent upon vengeance, Sagano raids the shrine and challenges Mikoto to a duel! Meanwhile, Yue decides on the path he must take! As the humans and ayakashi clash, the vagaries of fate accelerate... | 01KG9Z4WW2VB8DZJNDHJFX35R3 | 7.0 | 2017-06-19T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 7 | 2017-06-19T15:00:00.000Z | 0 | 0 | ||||||
| PRD_1M00CFG0HDGG | CNT_3RMMX4H6BQJ0 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 3 | [] | Of the Red, the Light, and the Ayakashi, Vol. 3 | The mystery of Utsuwa has been revealed-created by Shin, the peculiar town exists to ensure a source of sustenance for the local ayakashi. As Yue struggles with this new knowledge, Akiyoshi begins to have doubts about their friendship. But while his companions are occupied with their conflicting emotions, Tougo finds himself on the menu for a stray ayakashi's ultimate Meal!! | 01K5GB3QH5VZ7GF7Q28TX7218S | 3.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 3 | 2016-06-30T15:00:00.000Z | 0 | 0 | ||||||
| PRD_2GR5ARJWE850 | CNT_09N5JJ94AM20 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 10 | [] | Of the Red, the Light, and the Ayakashi, Vol. 10 | The final volume has arrived! Packed with short stories and bonus chapters, this is a must-read for fans of the series! | 01KGA3D6EVRTX57J2FN17FN2M6 | 10.0 | 2018-04-24T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 10 | 2018-04-24T07:00:00.000Z | 0 | 0 | ||||||
| PRD_38SFAV0BKQA0 | CNT_1DBKNT8TCFBG | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 9 | [] | Of the Red, the Light, and the Ayakashi, Vol. 9 | Within the barrier, Yue is up against an unexpected foe in his attempt to rescue Tougo-his dear friend Kurogitsune. To force Yue's hand in taking a Meal and saving himself, Kurogitsune casts Tougo into the camellia pond. But upon rushing after the helpless captive, Yue is confronted by the age-old conflict between the desire to protect and the desire to consume that befalls all humans who assume the role of yorishiro. What path will Yue choose? | 01KGA17MYJ1WEYWH16YZAXT0S7 | 9.0 | 2017-12-19T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 9 | 2017-12-19T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3BFEHQG96ZS0 | CNT_0JMS3TKGRRM0 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 8 | [] | Of the Red, the Light, and the Ayakashi, Vol. 8 | Satou declares a change in Tougo's fate: in order for Mikoto, the master of the ayakashi, to regain her power, Tougo will be sacrificed to the camellia pond. Held prisoner, the unconscious Tougo weeps in his dreams over his mother Akane's betrayal in running off with the mysterious Yoshiki. Will Abe-san and Company, tasked with Tougo, who is immersed in bleak thoughts, be unable to resist the temptation of a three-star Meal?! The truth looms ever closer... | 01KG9VN8ZH7RVEEPV4F9T0XGH4 | 8.0 | 2017-09-25T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 8 | 2017-09-25T15:00:00.000Z | 0 | 0 | ||||||
| PRD_3T3GEP83ZJZG | CNT_05RS4M6QZCV0 | Of the Red, the Light and the Ayakashi CNT_3BYRJ681AGJG | CNT_3BYRJ681AGJG | 2 | 1 | 1 | Volume 1 | [] | Of the Red, the Light, and the Ayakashi, Vol. 1 | In the curious town of Utsuwa, where spirits known as ayakashi roam, lives Yue, a sheltered boy born and raised at the local shrine. On the night of the winter festival, Yue descends the mountain for the first time and encounters two boys. Though Yue wants nothing more than to become friends with his new acquaintances, Mikoto, the master of the shrine who rules over Utsuwa, declares that Yue must choose one of the boys as his "Meal"! Faced with this incomprehensible decision, what will Yue do?! | 01KG931ZBXYCF3XT39ZC2MJ923 | 1.0 | 2016-06-30T15:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | Of the Red, the Light, and the Ayakashi, Vol. 1 | 2016-06-30T15:00:00.000Z | 0 | 0 |
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);