products

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

11 rows where series_id = "CNT_1MF9CXH2FK50"

✎ 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_03Z1DR67A5R0 CNT_0FGHWQC624KG The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 5 []   The Case Files of Jeweler Richard Vol. 5   Back from England, Seigi must deal with the start of his third year of college--and with all his classmates starting to job hunt in earnest! Meanwhile, a familiar customer returns to Jewelry Étranger with a pale pink cameo he once received from an unrequited love, challenging Seigi and Richard to solve the mystery attached to the gift. PART-TIME JOB, FULL-TIME CONCERNS 01KGB7WA1CV3EPNNT5BA7DZMZX 5.0 2023-05-22T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 5 2017 by Nanako Tsujimura   2023-07-06T07:00:00.000Z   0 0
PRD_07V9VJ7T0HX0 CNT_27D4GATA1KZ0 The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 4 []   The Case Files of Jeweler Richard Vol. 4   Richard suddenly closes Jewelry etranger and vanishes, leaving Seigi stunned and alone. Acting on information from Saul, Seigi makes his way to England in pursuit of his wayward boss. When the beautiful jeweler's tortured past comes back to haunt him, what's his knight in shining armor to do?! THE MYSTERY OF THE MISSING JEWELER 01KGB67S9R54DD3507B6NEHRCV 4.0 2023-03-30T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 4 2017 by Nanako Tsujimura   2023-04-20T07:00:00.000Z   0 0
PRD_0EH528W6AHH0 CNT_08P18HNKCBE0 The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 6 []   The Case Files of Jeweler Richard Vol. 6   The reappearance of a complicated figure turns Seigi's life upside down--his birth father, Hisashi Shimeno. The man he wants nothing to do with will not leave him be, and Seigi would rather quit Jewelry Étranger for good than risk bringing trouble to Richard's door. That is, if Richard will let him go... DEADBEAT DAD 01KGASMEKZZ2J5SK8882T29JVV 6.0 2023-09-19T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 6 2018 by Nanako Tsujimura   2023-10-19T07:00:00.000Z   0 0
PRD_0WKF8XHRT3Z0 CNT_3ENXWGXS4JRG The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 10 []   The Case Files of Jeweler Richard Vol. 10   Octavia, the wealthy young lady who has stymied Richard at every turn, invites Richard and Seigi to a hotel in Nuwara Eliya, a city that boasts the finest mountain resorts in all Sri Lanka. The duo will need help from every ally they can summon, including Jeffrey and Henry, to thwart Octavia's schemes--but what exactly is the young mastermind planning? And what does this mean for Richard and Seigi's relationship? TANGLED WEBS AND TWISTED WORDS 01KG9QT4RW3YZ4A3K753RX901A 10.0 2025-02-21T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 10 © 2020 by Nanako Tsujimura   2025-03-06T08:00:00.000Z   0 0
PRD_110HWQNV3AD0 CNT_39MGAR8A8TS0 The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 7 []   The Case Files of Jeweler Richard Vol. 7   One month after arriving in the mountain city of Kandy to begin his studies as a jeweler, Seigi receives a strange e-mail from "Jeffrey," with the subject line "Help Richard." Within is an itinerary for a luxury cruise...that leaves in three days. What has the beautiful jeweler got himself into now?! And can Seigi come to his rescue yet again? BON VOYAGE 01KG9PPB809F8C3PD04ABZX3X6 7.0 2024-01-30T08:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 7 2018 by Nanako Tsujimura   2024-02-22T08:00:00.000Z   0 0
PRD_11CV6AZ7BG7G CNT_03EVP5Y1EK50 The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 2 []   The Case Files of Jeweler RichardVol. 2   Seigi's eye for cut, carat and clarity grows sharper by the day as he works under the beautiful and talented Richard. He'll need that keen eye for their next case involving a "cursed" emerald necklace that once belonged to a dead ballerina. Tasked by a famous ballet company to investigate the necklace, Richard and Seigi must, once again, plumb the multi-faceted depths of the human heart. Deadly Beauty 01KGAJ6ZXWDCDBTETJKE126BJ4 2.0 2022-07-15T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler RichardVol. 2 2016 by Nanako Tsujimura   2022-08-11T07:00:00.000Z   0 0
PRD_1A43Z9FMRJNG CNT_1RJ523KEBG20 The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 11 []   The Case Files of Jeweler Richard Vol. 11   An episode in the life of Shoko Tanimoto and her students in the science club at Okayama Junior High School. The saga of how Vincent sold Richard out to Jeffrey during his tenure as shop assistant in Hong Kong. Dispatches from Seigi, Richard, and Haruyoshi's everyday life, the tale of Richard and Jeffrey's stint at a Swiss boarding school, and a drama-filled date with destiny seen through Jeffrey's eyes--find all these and more in this sparkling collection of short stories about the Jeweler Richard cast! LOOK INSIDE THE JEWELRY BOX 01KGBW4GFP9AX8CMQCHEWXE4QR 11.0 2025-09-08T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 11 © 2021 by Nanako Tsujimura   2025-11-27T08:00:00.000Z   0 0
PRD_1Y6NH3NW3PB0 CNT_2VEEPGQS8SEG The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 8 []   The Case Files of Jeweler Richard Vol. 8   At the request of Richard's mother, Catherine, Seigi travels with Richard to her vacation home in Provence in the south of France to meet her. On arriving, however, they find a mystery awaiting them in the form of a strange girl named Octavia, and an even stranger treasure hunt Catherine has set up for them. Can they find the thirty gemstones hidden across the estate? And if so, what else might they unearth? THE SUMMER GARDEN 01KGBA281RSBAHQNMP9PYCN0FR 8.0 2024-05-16T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 8 © 2018 by Nanako Tsujimura   2024-06-13T07:00:00.000Z   0 0
PRD_24RVE5BQJ620 CNT_17AM8MBZWR80 The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 9 []   The Case Files of Jeweler Richard Vol. 9   A declaration of martial law in Sri Lanka sends Seigi temporarily back to Japan--until a strange message has him flying to Hong Kong to meet with one Vincent Lai, the man who seems as determined to betray Richard as he is to keep helping Seigi. What does Vincent truly want from them? And what will Seigi do once he reunites with Richard? STRANGE BEDFELLOWS 01KGBCQ1Y35ZEYMXY8QWQQYMNE 9.0 2024-09-18T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 9 © 2019 by Nanako Tsujimura   2024-10-24T07:00:00.000Z   0 0
PRD_3MCCFPDXE110 CNT_22QNCRVV4YNG The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 3 []   The Case Files of Jeweler RichardVol. 3   College student Seigi works part-time at Jewelry Etranger, run by the equally handsome and capable jeweler, Richard. All sorts of people visit the shop: a couple looking for a ring for their thirtieth wedding anniversary, a college student who's lost contact with her significant other, and a client looking for someone to attend a very special auction in their stead--an auction in which a man who knows of Richard's past is in attendance. What happens when Seigi and Richard's feelings clash in earnest for the first time?! BLAST FROM THE PAST 01KGAJTJYGQ7YSFQTGWWZKFN6R 3.0 2022-10-13T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler RichardVol. 3 2016 by Nanako Tsujimura   2022-11-10T08:00:00.000Z   0 0
PRD_3NA21HMJ69Z0 CNT_0PM1AFR6EBYG The Case Files of Jeweler Richard CNT_1MF9CXH2FK50 CNT_1MF9CXH2FK50 2 2 1 Volume 1 []   The Case Files of Jeweler Richard Vol. 1   Richard Ranashinghe de Vulpian is a brilliant and enigmatic British jewelry appraiser. Seigi Nakata is a young college student. Their worlds are as different as can be, but when a chance encounter leads Seigi to hire Richard to appraise a family heirloom, it sparks a partnership that goes well beyond that one job. Together, the duo investigate jewelry-related cases and solve mysteries, finding the secret messages hidden in the hearts of precious stones--and the hearts of those who possess them. Cut, Carat, Clarity 01KGAH0JE36FWCPSAM34Q4WXM9 1.0 2022-05-30T07:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PKAG51AEAQG The Case Files of Jeweler Richard Vol. 1 2015 by Nanako Tsujimura   2022-06-30T07: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);