products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
3 rows where series_id = "CNT_2VPJ8JTTNG0G"
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_1J3VC4G76S8G | CNT_2V6TCKXP1EAG | I Hear the Sunspot: Limit CNT_2VPJ8JTTNG0G | CNT_2VPJ8JTTNG0G | 2 | 1 | 1 | Volume 1 | [] | I Hear the Sunspot: Limit Volume 1 | Because of a hearing disability, university student Kohei had made a habit of distancing himself from those around him. But after meeting the exceedingly cheerful Taichi, he gradually begins to embrace a more positive outlook on life. Kohei eventually begins to see Taichi as more than a friend, and after he finally confesses his love to Taichi, the feelings become mutual. In this new addition to the I Hear the Sunspot series, Kohei continues on as a student, while Taichi makes his way out into the working world to pursue his own calling and the two begin a new life together! | 01KG9AS0T72110WA191SWYZY7X | 1.0 | 2018-11-11T15:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1MP5F77DVBZG | I Hear the Sunspot: Limit Volume 1 | (c)2017 Yuki Fumino/France Shoin | 2018-11-16T08:00:00.000Z | 0 | 0 | |||||
| PRD_2CMZWAZK1QF0 | CNT_38CB6R9GX3QG | I Hear the Sunspot: Limit CNT_2VPJ8JTTNG0G | CNT_2VPJ8JTTNG0G | 2 | 1 | 1 | Volume 2 | [] | I Hear the Sunspot: Limit Volume 2 | Kohei is a college student who, because of his hearing loss, tends to distance himself from others. His attitude starts to change after he crosses paths with an ever- optimistic classmate named Taichi. And over time, the two begin to develop feelings for each other. As the story continues, the pair tries to balance their budding relationship alongside Taichi's inspiring new career and Kohei's continued studies at school. But the harder they try to make things work, the more misunderstandings they seem to encounter. | 01KGA7E61JBPGSRYW91JNYE9R4 | 2.0 | 2019-07-31T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1MP5F77DVBZG | I Hear the Sunspot: Limit Volume 2 | (c)2017 Yuki Fumino/France Shoin | 2019-08-09T07:00:00.000Z | 0 | 0 | |||||
| PRD_2SAA3DCDZ0S0 | CNT_09PWAD8XAANG | I Hear the Sunspot: Limit CNT_2VPJ8JTTNG0G | CNT_2VPJ8JTTNG0G | 2 | 1 | 1 | Volume 3 | [] | I Hear the Sunspot: Limit Volume 3 | Stunningly handsome Kohei Sugihara was outgoing and popular with the girls at school. But when a sudden illness left him with partial hearing loss" he grew quiet and reluctant to engage with others. At college a chance encounter with an ever-optimistic classmate named Taichi Sagawa helped Kohei open up once more. And over time the two began to develop feelings for each other. As the story continues the pair tries to balance their budding relationship alongside Taichis inspiring new career and Koheis continued studies. But things don`t always go as planned. One day seemingly out of nowhere " Kohei announces that maybe they should spend some time apart. By Yuki Fumino. Yuki Fumino's first manga" I Hear the Sunspot received a great deal of attention upon its publication in 2014 " quickly leading to the development of a feature film. The exceptional talent on display in her debut project has made her one of the most watched and up-coming manga-ka in the BL world. | 01KG9F28ZAFHXTN8BJ6Z9QVG2G | 3.0 | 2021-03-25T07:00:00.000Z | One Peace Books LAB_0KDKBQKJQBCG | GEO_1MP5F77DVBZG | I Hear the Sunspot: Limit Volume 3 | なし | 2021-04-06T07: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);