products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_12374H7VS3F0"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_0YXTFRHSJFN0 | CNT_0DXGNTVCQ1WG | The Guy She Was Interested In Wasn't a Guy at All CNT_12374H7VS3F0 | CNT_12374H7VS3F0 | 2 | 1 | 1 | Volume 1 | [] | The Guy She Was Interested In Wasn't a Guy at All, Vol. 1 | Fashionable and upbeat high schooler Aya loves listening to rock, but no one else seems to share her interest…until she meets a cool, stylish employee at a CD shop. Dressed in black from head to toe, he has this air of mystery about him, and his taste in music is impeccable. Aya falls hard for him—not knowing her crush is actually her female classmate Mitsuki! For her part, Mitsuki generally keeps to herself and avoids standing out at school. But given that she sits right next to Aya, Mitsuki’s all too aware of the other girl’s feelings, and she’s afraid to reveal the truth. So why does she find herself talking with Aya more and more…? | 01KGB9V224SC91NFJ6RXMKA02J | 1.0 | 2024-05-24T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | The Guy She Was Interested In Wasn't a Guy at All, Vol. 1 | 2024-10-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_15H2KCQXW33G | CNT_0V0R1P6875FG | The Guy She Was Interested In Wasn't a Guy at All CNT_12374H7VS3F0 | CNT_12374H7VS3F0 | 2 | 1 | 1 | Volume 2 | [] | The Guy She Was Interested In Wasn't a Guy at All, Vol. 2 | Aya’s found out that the guy she was interested in isn’t a guy at all—and she’s also realized that she just can’t keep her cool around Mitsuki! The two haven’t quite put a name on their complex, earnest feelings, but they only grow as the pair continues to bond over the music they love. With their senior year at hand, future plans are coming into question…and Aya’s thrown for a loop when a mysterious woman shows up and wants Mitsuki to go overseas! | 01KGBD1KRDBDKTQF89XMB10EZN | 2.0 | 2024-09-26T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1KB2KYDQ0JGG | The Guy She Was Interested In Wasn't a Guy at All, Vol. 2 | 2025-02-18T00:00:00.000Z | 0 | 0 | ||||||
| PRD_3NAPDSNC5FX0 | CNT_1GFFG1PY232G | The Guy She Was Interested In Wasn't a Guy at All CNT_12374H7VS3F0 | CNT_12374H7VS3F0 | 2 | 1 | 1 | Volume 3 | [] | The Guy She Was Interested In Wasn't a Guy at All, Vol. 3 | After hearing Mitsuki’s song, an excited Aya encourages her to share it with the world! Mitsuki is more than a little hesitant to put herself out there, but with Aya’s support and inspiration from a music festival they attend together, she begins to pursue her passion in earnest. When a certain video of her singing goes viral, though, Mitsuki ends up becoming somewhat of a celebrity at school…and her newfound fame brings difficulties for both her and Aya. What trials await the pair in their final year of high school? | 01KGBP63EM4VWSBNZCHR420XQ6 | 3.0 | 2025-05-02T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | The Guy She Was Interested In Wasn't a Guy at All, Vol. 3 | 2025-12-23T08: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);