products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
8 rows where series_id = "CNT_08YJ06ZGZ42G"
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_0GEXDNRVTG40 | CNT_2GSBHEK1X2P0 | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 7 | [] | Blue Flag, Vol. 7 | Rumors spread like wildfire after Toma's shocking confession during the culture festival, and Taichi feels confused and uncertain. The others in their circle are soon affected as well. Meanwhile, Toma's brother Seiya sits him down for a frank talk. All the thoughts and emotions everyone has kept hidden are finally coming to light, and relationships begin to change. | 01KGBDR2Z0PSWYV3W8PYYWQMHV | 7.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 7 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_0MZDZ8TY6ZB0 | CNT_0G3RGR9A81Q0 | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 4 | [] | Blue Flag, Vol. 4 | Toma's older brother, Seiya, asks Taichi to find out why Toma doesn't want to go to college. On the day of Toma's release from the hospital, Taichi still hasn't found a way to broach the subject with Toma. Meanwhile, Futaba discovers Taichi's birthday is coming up, and she decides to invite the group to a fireworks festival so they can all celebrate. | 01KGBDQZKX4VBH3JDASATM699T | 4.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 4 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_0Y2CMEPAEX90 | CNT_0JR2KNNV2ZH0 | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 1 | [] | Blue Flag, Vol. 1 | For some reason, Taichi Ichinose just can't stand Futaba Kuze. But at the start of his third year in high school, he finds himself in the same homeroom as her, along with his childhood friend Toma Mita, a star athlete. But one day, Futaba opens up to Taichi and admits she has a crush on Toma. She then asks for his help in confessing to him! There's just one problem—Toma seems to already have a secret crush on someone else. | 01KGBD3NVS4P88ZBT2RY8CFP86 | 1.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 1 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2N4NHH534ZTG | CNT_1KRZ014EEH0G | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 5 | [] | Blue Flag, Vol. 5 | School is back in session after summer break, and Taichi and Futuba are slowly transitioning their relationship from friends to something more. Suddenly, Mami starts being unusually friendly with Taichi, leaving Futuba feeling anxious. Taichi, unsure of Mami's true intent, can't help but get dragged along in her wake. Their situation attracts attention, more people become involved and soon everyone is questioning everyone else's relationships! | 01KGBDQYKBBJ8YP9TD69DQ4FP0 | 5.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 5 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2PP56YBRRGVG | CNT_3GE20QE63J7G | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 6 | [] | Blue Flag, Vol. 6 | The culture festival begins, and Toma and Taichi talk about their futures, but it ends with the two not quite seeing eye to eye. Shortly after, Toma sits down with Mami for a serious discussion, and in response to her earnest openness, he makes a big decision that could change everything. Time keeps moving forward, pushing everyone to the cusp of making critical life choices. | 01KGBDR245XTZ31KZW15RVPSJX | 6.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 6 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_2SN434750YSG | CNT_3K3C0CTPXG1G | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 2 | [] | Blue Flag, Vol. 2 | The school sports festival is coming up, and Toma accepts the position of class 3-A's cheer squad captain on the condition that Futaba and Taichi serve as his vice-captains. Hoping to live up to Toma's faith in them, Taichi and Futaba diligently practice their squad's routine. But when the time comes to perform, Futaba hits a wall that threatens her very participation! | 01KGBDQX0B94210S9EZD0W4414 | 2.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 2 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3DR222YHYH50 | CNT_0HEYHWYSE3N0 | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 8 | [] | Blue Flag, Vol. 8 | Toma and Futaba have their first sit-down talk after the big fight at school. Meanwhile, Taichi struggles with the problems that have been dumped in his lap by his friend's choices, and he ends up distancing himself from Toma. Then, one day, Toma stops coming to school. Left in the lurch, what can Futaba and Taichi do? Everyone chooses their futures, and time marches on. Don't miss the heartfelt conclusion of Blue Flag! | 01KGBDR4CN5WVCWP92Z042EZEH | 8.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 8 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08:00:00.000Z | 0 | 0 | |||||
| PRD_3RK6JF8D6Q30 | CNT_0XG0MEV709F0 | Blue Flag CNT_08YJ06ZGZ42G | CNT_08YJ06ZGZ42G | 2 | 1 | 1 | Volume 3 | [] | Blue Flag, Vol. 3 | Toma gets seriously injured diving in front of a car to save Taichi, leaving Taichi racked with guilt over not just getting his best friend hurt, but also stealing his last chance at making the summer baseball tournament. Guilty and angry, the two boys clash in an emotionally raw argument. Futaba, worried about both of them, invites Taichi out in an attempt to cheer him up. | 01KGBDRFNJM95XH73PDK65Q6ZY | 3.0 | 2024-11-26T08:00:00.000Z | VIZ Media LAB_15X2T7H1V07G | GEO_1PQM5BDYSMG0 | Blue Flag, Vol. 3 | AO NO FLAG © 2017 by KAITO/SHUEISHA Inc. | 2024-11-26T08: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);