products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_23A2EF8845S0"
This data as json, CSV (advanced)
Suggested facets: copyright, 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_0G5V50R68WC0 | CNT_3DYE308TWQ2G | Nameless Asterism CNT_23A2EF8845S0 | CNT_23A2EF8845S0 | 2 | 1 | 1 | Volume 4 | [] | Nameless Asterism Vol. 4 | At long last, the story is told from Washio's perspective--starting from the first time she met Kotooka...to the moment her feelings are revealed! Meanwhile, what will Subaru do when he finds out that Tsukasa likes someone?! | SECRETS REVEALED! | 01KG9F07FJEDTZ7TYS59MM7490 | 4.0 | 2021-03-23T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PQM5BDYSMG0 | Nameless Asterism Vol. 4 | 2016 Kina Kobayashi / SQUARE ENIX CO., LTD. | 2021-03-30T07:00:00.000Z | 0 | 0 | ||||
| PRD_14B14XKK6GZG | CNT_089GGGCXHAP0 | Nameless Asterism CNT_23A2EF8845S0 | CNT_23A2EF8845S0 | 2 | 1 | 1 | Volume 2 | [] | Nameless Asterism Vol. 2 | Tsukasa doesn't know how to respond to Asakura's feelings. Should she give having a boyfriend a shot and give up on her hidden feelings for Washio? Tsukasa's not the only one dealing with a troubled heart. Kotooka has plenty of secrets of her own, and when Subaru finds himself on the same committee as Asakura-kun, things get really complicated. | SECRETS AS MANY AS THE STARS | 01KG9F0CGBC9DNKWJ6RSHM9EEV | 2.0 | 2021-03-23T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PQM5BDYSMG0 | Nameless Asterism Vol. 2 | 2016 Kina Kobayashi / SQUARE ENIX CO., LTD. | 2021-03-30T07:00:00.000Z | 0 | 0 | ||||
| PRD_33DE007BWH90 | CNT_19AD1XVGXW5G | Nameless Asterism CNT_23A2EF8845S0 | CNT_23A2EF8845S0 | 2 | 1 | 1 | Volume 3 | [] | Nameless Asterism Vol. 3 | With the help of a lolita outfit and a little online research, Subaru's got a plan to make Asakura give up on Tsukasa! Kotooka, burdened under the weight of all three girls' secrets, is making plans of her own--to ruin everything, all in one fell swoop! | ON A MISSION... | 01KG9F0EJPHKCS958B326WXTYS | 3.0 | 2021-03-23T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PQM5BDYSMG0 | Nameless Asterism Vol. 3 | 2016 Kina Kobayashi / SQUARE ENIX CO., LTD. | 2021-03-30T07:00:00.000Z | 0 | 0 | ||||
| PRD_363YKK1DRG80 | CNT_38MT1FHS8V6G | Nameless Asterism CNT_23A2EF8845S0 | CNT_23A2EF8845S0 | 2 | 1 | 1 | Volume 5 | [] | Nameless Asterism Vol. 5 | Thanks to a confrontation with a girl from another school, Tsukasa, Washio, and Kotooka are fighting! Will their close-knit trio fall apart? Meanwhile, Subaru and Asakura are still fighting, and they can't seem to find the right moment to make up... The tangled tale of lonely youths and their two love triangles comes to an end in the climactic finale! | THIS PAIN DOES NOT YET HAVE A NAME... | 01KG9F0D1B1YWW2HVF6NY9AH1W | 5.0 | 2021-03-23T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PQM5BDYSMG0 | Nameless Asterism Vol. 5 | 2017 Kina Kobayashi / SQUARE ENIX CO., LTD. | 2021-03-30T07:00:00.000Z | 0 | 0 | ||||
| PRD_3REFBTBZMKB0 | CNT_0PN360F03XVG | Nameless Asterism CNT_23A2EF8845S0 | CNT_23A2EF8845S0 | 2 | 1 | 1 | Volume 1 | [] | Nameless Asterism Vol. 1 | Shiratori, Washio, and Kotooka have been inseparable since they began junior high. However, Shiratori has a secret she's been keeping from her best friends--she actually has a big crush on Washio! Not wanting to risk their friendship, she planned to keep it a secret forever, but when Shiratori learns that Washio has a crush on Kotooka, her desire to support her friends now conflicts with her own feelings. First love blossoms in unexpected ways for these three young women and their circle of friends in this charming new romance! | LOVE IS AS BOUNDLESS AS SPACE! | 01KG9E5D4S2X0V7JMZQPSCP2Y6 | 1.0 | 2021-03-23T07:00:00.000Z | Seven Seas Entertainment LAB_1WABW2X3770G | GEO_1PQM5BDYSMG0 | Nameless Asterism Vol. 1 | 2016 Kina Kobayashi / SQUARE ENIX CO., LTD. | 2021-03-30T07: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);