BookWalker

home / database

products

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

6 rows where series_id = "CNT_0P992FGYM2XG"

✎ 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_0CRA6K3KDCJ0 CNT_09ZBMWF5S24G The Case Files of Jeweler Richard CNT_0P992FGYM2XG CNT_0P992FGYM2XG 2 1 1 Volume 2 []   The Case Files of Jeweler Richard Vol. 2   After helping out the impossibly elegant Englishman Richard Ranasinghe de Vulpian, Seigi accepts a job in Richard's jewelry store. One day, Takatsuki, a flashy-looking host, comes in looking for something to impress his clients. Takatsuki's eyes light on an amethyst, at which point Richard relates to him the legend behind the stone. What is the jewel's story, and how does it affect the haughty host's decision? JEWELS AREN'T JUST PRETTY 01KGAF0SDTFCCJJEVMGXT5WECZ 2.0 2022-04-01T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 2 Nanako Tsujimura, Utako Yukihiro/SHUEISHA, Mika Akatsuki/ICHIJINSHA   2022-04-12T07:00:00.000Z   0 0
PRD_13CZN3AJ3M8G CNT_0TVRDQJBACJG The Case Files of Jeweler Richard CNT_0P992FGYM2XG CNT_0P992FGYM2XG 2 1 1 Volume 6 []   The Case Files of Jeweler Richard Vol. 6   Seigi is a Japanese university student working at Richard's jewelry shop, Etranger. When Richard receives a new request from a client, Seigi finds himself tagging along to an auction for a piece of beautiful green jade that may be more special than it appears. GEMS ARE A MIRROR OF YOURSELF... 01KG9RCMRN4Q973RBEQQ64KW8J 6.0 2025-01-21T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 6 ©Nanako Tsujimura, Utako Yukihiro/SHUEISHA, ©Mika Akatsuki/ICHIJINSHA   2025-04-08T07:00:00.000Z   0 0
PRD_1T884PBJ13XG CNT_2GHBKPNH5JX0 The Case Files of Jeweler Richard CNT_0P992FGYM2XG CNT_0P992FGYM2XG 2 1 1 Volume 5 []   The Case Files of Jeweler Richard Vol. 5   Seigi Nakata, a Japanese economics student, is working at the shop of the beautiful jeweler, Richard Ranasinghe de Vulpian. Today's customers are an elderly couple, the Tamuras. To celebrate their thirtieth anniversary, they came to Richard's shop to find an imperial topaz. But something seems off about this cute couple... GEMSTONES BRING COLOR TO YOUR DAILY LIFE 01KH3EHXA64T6EE8NJCQYH6BVE 5.0 2023-06-21T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 5 Nanako Tsujimura, Utako Yukihiro/SHUEISHA, Mika Akatsuki/ICHIJINSHA   2023-06-27T07:00:00.000Z   0 0
PRD_2E73QRA2TGK0 CNT_2NEMVDN90V90 The Case Files of Jeweler Richard CNT_0P992FGYM2XG CNT_0P992FGYM2XG 2 1 1 Volume 4 []   The Case Files of Jeweler Richard Vol. 4   Seigi Nakata is a second-year student at Kasaba University who is majoring in economics. He works part-time at a jewelry shop run by the breathtakingly beautiful jeweler Richard. One day, while Seigi is talking to his schoolmate (and crush) Tanimoto, he meets her good friend Shinkai. Through a twist of fate, Seigi finds himself wrapped up with mysterious rumors of a cursed emerald at Shinkai's ballet troupe! VIVIDLY UNRAVEL THE MYSTERIES OF THE HEART THAT LIVE WITHIN SHIMMERING GEMS 01KGB29V30798DJPMY3DA2DTW4 4.0 2022-10-24T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 4 Nanako Tsujimura, Utako Yukihiro/SHUEISHA, Mika Akatsuki/ICHIJINSHA   2022-12-06T08:00:00.000Z   0 0
PRD_302X6KXVWAHG CNT_2FEZ389A6YJG The Case Files of Jeweler Richard CNT_0P992FGYM2XG CNT_0P992FGYM2XG 2 1 1 Volume 1 []   The Case Files of Jeweler Richard Vol. 1   When Seigi Nakata rescued a handsome young jewelry appraiser from a group of drunken assailants, he got more than he bargained for! The appraiser is Richard Ranasinghe de Vulpian, a brilliant and mysterious British jewelry expert. Seigi hires him to appraise a family heirloom...and that is just the beginning. Together, they unlock the secret messages hidden in the hearts of precious stones--and those who possess them. EVERY JEWEL HAS ITS SECRETS 01KGADEY7GSPEE6TT14PDCK2NK 1.0 2022-01-16T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 1 Nanako Tsujimura,Utako Yukihiro/SHUEISHA, Mika Akatsuki/ICHIJINSHA   2022-03-01T08:00:00.000Z   0 0
PRD_3QV02B1X1AQG CNT_2M9KR6HTK760 The Case Files of Jeweler Richard CNT_0P992FGYM2XG CNT_0P992FGYM2XG 2 1 1 Volume 3 []   The Case Files of Jeweler Richard Vol. 3   Seigi, an ordinary university student, works at a jewelry shop run by the decidedly not-ordinary Richard. One day, a young boy named Hajime walks in, takes out a small cat's eye gemstone, and asks Richard for a matching stone. What story lies behind this particular request? IN SEARCH OF THE PERFECT MATCH 01KGAJDZDANVQ3VQTPGFZH4BVT 3.0 2022-07-29T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 3 Nanako Tsujimura, Utako Yukihiro/SHUEISHA, Mika Akatsuki/ICHIJINSHA   2022-09-27T07: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 24.52ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS