database: products: 6 rows where series_id = "CNT

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

6 rows where series_id = "CNT_0P992FGYM2XG"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
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
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
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
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
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
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

Advanced export

JSON shape: default, array, newline-delimited, object

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