products

Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)

3 rows where series_id = "CNT_2VPJ8JTTNG0G"

✎ View and edit SQL

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

CSV options: 

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);