products

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

5 rows where series_id = "CNT_0A9BW7XRB8K0"

✎ View and edit SQL

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_0MN0FQCAX78G CNT_3HVKQMHBMTBG Twinkle Stars CNT_0A9BW7XRB8K0 CNT_0A9BW7XRB8K0 2 1 1 Volume 1 []   Twinkle Stars, Vol. 1   Sakuya Shiina lives with Kanade, her male cousin and foster parent. In times of pain and sadness, she's always taken comfort in looking up at the stars. One day, a mysterious boy suddenly shows up at Sakuya's house for her birthday. He leaves her with kind words, but she has no idea who he is! All she has to go on is his name--Chihiro! Not one to let that deter her, she sets out in search of him with the reluctant help of her two best friends, Yuuri and Sei. Everyone says that Sakuya should just forget him, but she's oddly drawn to the curious boy. Then, a twist of fate allows them to meet once more! Will this meeting bring them closer together...or will the feelings between these lone stars remain forever in the dark?   01KG98J1QHTV3JS89DFZ5HFY9S 1.0 2016-11-21T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QWC5EST6G90 Twinkle Stars, Vol. 1     2016-11-21T15:00:00.000Z   0 0
PRD_1KNCVS71HGBG CNT_17GXC7ACSWCG Twinkle Stars CNT_0A9BW7XRB8K0 CNT_0A9BW7XRB8K0 2 1 1 Volume 5 []   Twinkle Stars, Vol. 5   Sakuya and Chihiro are growing closer, and Yuuri's getting uneasy. With not much time left, he makes up his mind to tell Sakuya how he feels!   01KGA1EF39AERGT9686H491KAN 5.0 2018-03-01T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QWC5EST6G90 Twinkle Stars, Vol. 5     2018-03-13T07:00:00.000Z   0 0
PRD_2MMG2NEG9QWG CNT_3V5JDR291GHG Twinkle Stars CNT_0A9BW7XRB8K0 CNT_0A9BW7XRB8K0 2 1 1 Volume 4 []   Twinkle Stars, Vol. 4   The second semester of school is starting, and Chihiro's kinder attitude toward Sakuya is making her heart race! When he recommends her a book to read, she's positively overjoyed. But on the way home from a night of stargazing with the Star Appreciation Club, Chihiro suddenly approaches her! What does he want to talk about...?   01KG9VSE1274JYAC5QM8H9XQMG 4.0 2017-10-11T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QWC5EST6G90 Twinkle Stars, Vol. 4     2017-11-07T08:00:00.000Z   0 0
PRD_2Q0CD4Y29HSG CNT_0WFKENT1G3TG Twinkle Stars CNT_0A9BW7XRB8K0 CNT_0A9BW7XRB8K0 2 1 1 Volume 2 []   Twinkle Stars, Vol. 2   Things get unpleasant for Sakuya when Kanade finds out about Chihiro. Though her cousin is a hothead, Sakuya asks him to meet Chihiro once more and give him another chance. Next on the agenda: summer vacation! Sakuya is studying hard for finals, since low scores mean she won't be able to participate in the last summer camp of her high school career. But then-an unexpected visitor...!?   01KG9YXFKM2VJN68531ZSA7JST 2.0 2017-03-20T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QWC5EST6G90 Twinkle Stars, Vol. 2     2017-03-20T15:00:00.000Z   0 0
PRD_3HN4TGK60RSG CNT_1VDPFRHVA1MG Twinkle Stars CNT_0A9BW7XRB8K0 CNT_0A9BW7XRB8K0 2 1 1 Volume 3 []   Twinkle Stars, Vol. 3   It's the day of the fireworks display, and Chihiro's come down with a fever! At Saki's recommendation, a worried Sakuya decides to visit him at home. But when the ill Chihiro opens up to her about his painful past, will Sakuya be able to accept the real, more vulnerable Chihiro, or will the two drift apart in the aftermath of his shocking confession?   01KG9Z78WMSFGNZKH6PT20RJZK 3.0 2017-07-31T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1QWC5EST6G90 Twinkle Stars, Vol. 3     2017-07-31T15: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);