BookWalker

home / database

products

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

6 rows where series_id = "CNT_228VFEG5XC3G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description_short, 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_0WQZHQMASM1G CNT_3SF3MH0S4GC0 World's End and Apricot Jam CNT_228VFEG5XC3G CNT_228VFEG5XC3G 2 1 1 Volume 6 []   World's End and Apricot Jam 6   Years have passed since Anzu boldly made their relationship public on stage, and Hina is now 19. As Anzu's wildly popular band prepares to start their national tour, both feel ready to take things to the next level … One night, Anzu asks if Hina wants to spend the night. Has their moment finally arrived?! Find out in the bold final chapter of this breakneck rollercoaster of a bittersweet love story between a high school girl and an older musician! Last volume! 01KGA7B7STNSTJQ8Q1Q95F8K61 6.0 2019-07-17T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG World's End and Apricot Jam 6 (C) Rila Kirishima / Kodansha Ltd.   2019-07-17T07:00:00.000Z   0 0
PRD_1G5T4QKEBA30 CNT_23TRX83QQ63G World's End and Apricot Jam CNT_228VFEG5XC3G CNT_228VFEG5XC3G 2 1 1 Volume 1 []   World's End and Apricot Jam 1   After breaking into Anzu Shinohara's apartment and smashing his already broken keyboard, Hina Sakata quickly finds herself in his debt. As she works to pay him back, Hina finds out that Anzu is a vocalist and becomes entranced, wanting to explore more of his unkown world. Will this unlikely couple last longer their 15 seconds of fame? Find out in World's End and Apricot Jam volume one.   01KG9B1GWRFD082WPZG2CXFV7X 1.0 2019-02-07T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG World's End and Apricot Jam 1 (C) Rila Kirishima / Kodansha Ltd.   2019-02-19T08:00:00.000Z   0 0
PRD_1Z18VBQ59NHG CNT_2X6AQBNG4GW0 World's End and Apricot Jam CNT_228VFEG5XC3G CNT_228VFEG5XC3G 2 1 1 Volume 2 []   World's End and Apricot Jam 2   Hina and Anzu, the frontman of a mega-popular rock band, are just starting to get to know each other when Hina's former crush Mu-chan makes a surprise reappearance and the three form an awkward triangle. As Hina finds herself more and more drawn to Anzu's warm smile, his romantically troubled past catches up to him and he tries to distance himself from her. Hopelessly smitten, she makes a bold move, but will her plan succeed?! Find out what happens between Hina and the dangerously sweet Anzu (spoiler: the bedroom is involved!) in the second installment of a love story moving faster than the speed of sound!   01KGA6JZBT415MX99S14SVF8KS 2.0 2019-03-06T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG World's End and Apricot Jam 2 (C) Rila Kirishima / Kodansha Ltd.   2019-03-12T07:00:00.000Z   0 0
PRD_2J9Z80XH9VQG CNT_10JH3N4RS6Y0 World's End and Apricot Jam CNT_228VFEG5XC3G CNT_228VFEG5XC3G 2 1 1 Volume 4 []   World's End and Apricot Jam 4   Anzu's new band manager has outlawed dating! Hina tries her best to support Anzu from behind the scenes...but neither of them can stand being away from each other! And...has Tatsuro fallen under her spell...? The Floating Air Plants's big debut is right around the corner, but can they hold it together?! Find out in volume 4 of World's End and Apricot Jam!   01KGA6Y36GYZJW2FZ8CD0QKEFA 4.0 2019-04-25T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG World's End and Apricot Jam 4 (C) Rila Kirishima / Kodansha Ltd.   2019-05-08T07:00:00.000Z   0 0
PRD_2ZD0BKSZS5D0 CNT_1NHBTHEJ4HHG World's End and Apricot Jam CNT_228VFEG5XC3G CNT_228VFEG5XC3G 2 1 1 Volume 3 []   World's End and Apricot Jam 3   While Anzu is on tour, Hina shows up unexpectedly and the two get closer together than ever! Hina searches for Anzu's true feelings, but it's clear...that she can't stop her love for him no matter how he feels. As their relationship matures how deep will the rabbit hole go...? Find out in the third installment of this love story moving faster than the speed of sound!   01KGA6P5WGX26QNX4K4BCZER0X 3.0 2019-03-29T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG World's End and Apricot Jam 3 (C) Rila Kirishima / Kodansha Ltd.   2019-04-09T07:00:00.000Z   0 0
PRD_37DJ7PH84Z9G CNT_1Z9WR3M3GBM0 World's End and Apricot Jam CNT_228VFEG5XC3G CNT_228VFEG5XC3G 2 1 1 Volume 5 []   World's End and Apricot Jam 5   A wedge drives itself deeper between Anzu and Hina ... and Tatsuro seems to be there to pick up the pieces! Will Anzu stay together with Hina through the coming trials ... or is it really better to let what you love fly away? Find out in World's End and Apricot Jam Volume 5!   01KGA76JGEKSH6DB08FK99MXDE 5.0 2019-05-23T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG World's End and Apricot Jam 5 (C) Rila Kirishima / Kodansha Ltd.   2019-06-04T07: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);
Powered by Datasette · Queries took 26.349ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS