database: products: 7 rows where series_id = "CNT

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

7 rows where series_id = "CNT_243S1RV5SW2G"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_0F8S12P97300	CNT_3XR3S1R79630	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 7	[]	Sherlock Bones 7	MURDER TAKES CENTER STAGE From petty theft to grisly murders, Takeru and Sherdog have tackled any mystery that comes their way. But after the elite detective, Kento Munakata, makes an astute deduction as to the truth behind Takeru and Sherdog's relationship, Takeru is left to handle his greatest challenge yet without his canine companion! This time, Takeru and Kento team up to solve the murder of a stage actor in a classic whodunit. Does the detective duo have what it takes to catch the culprit without the aid of the deductive dog detective! From the Trade Paperback edition.	01KG9YHRH0TXKGT1NKTGX6121N	7.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 7	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_1KS8CNKK3270	CNT_1X2GRKEFM5C0	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 5	[]	Sherlock Bones 5	LOOKS THAT KILL Takeru and Sherdog have once again found themselves in the midst of a mystery! This time, the prime suspect is the beautiful Mayor Takasugi, and with her iron-clad alibi, it looks like she has brains to match her looks. How will they solve the case to reveal the murderous devil that lies behind the angelic face of London's mayor? From the Trade Paperback edition.	01KG9YHQHEZ363MS0FF5M0C1K4	5.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 5	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_1PFRY8DNF160	CNT_3WDDRX4R34D0	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 3	[]	Sherlock Bones 3	MURDER ON THE GREEN ? At Takeru's first game at a real golf course, he has the fortune of meeting Hanabusa, a pro golfer who just won the Japan Masters. He agrees to play a round with Takeru and his father. Little do they know he is there for more than a game of golf.	01KG9YHPGW0XTB81W05FG5CGES	3.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 3	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_1TWB9VFZB050	CNT_1ZQTR8S0E3E0	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 1	[]	Sherlock Bones 1	DEDUCTIVE DOG DETECTIVE When Takeru adopts his new pet, he's in for a surprise-the dog is none other than the reincarnation of Sherlock Holmes, the famous detective. What's more, this ""Sherdog"" has decided that Takeru is the reincarnation of his long-time assistant, Dr. Watson. Takeru may think Sherdog (or he himself) is crazy, but with no one else able to communicate with Holmes, he's roped into becoming the canine's assistant all the same. Using his exceptional sleuthing skills, Holmes uncovers clues to solve the trickiest crimes.	01KG98EC8ZZ0EV2JW5Z16Q3XFD	1.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 1	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_2DG1TB1E53QG	CNT_0XDT9AKBFNWG	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 6	[]	Sherlock Bones 6	THIS JUST IN: MURDER IN LONDON TOWN With Takeru settling into his new job as a police officer, he and Sherdog take on their latest mystery in a case that involves the murder of a famous newscaster's wife. But as Takeru tries to pin this grisly murder on the newscaster, he finds himself in conflict with Kento Munakata, the hot-shot, genius detective in charge of the case. Takeru and Sherdog will do all they can to solve this case, even if it means going above the detective's head to get things done, but will Takeru's rash actions hurt or help him in the end? From the Trade Paperback edition.	01KG9YHR1MTAKW2RVFYK6R4P9G	6.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 6	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_3G6G5Y2G12PG	CNT_2WQQ8M9KTMXG	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 4	[]	Sherlock Bones 4	PICTURE PERFECT MURDER Takeru faces his greatest challenge yet when his friend is murdered. He and Sherdog trace the crime back to her manga artist boss, but before they can prove his guilt, the case takes a turn for the worse-Holmes loses his memory and starts acting like a normal dog!	01KG9YHQ242CVDFQ9DRVHXVT3Z	4.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 4	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07:00:00.000Z
PRD_3MQ0GJWTD1NG	CNT_0W2487ZW9KYG	Sherlock Bones CNT_243S1RV5SW2G	CNT_243S1RV5SW2G	2	1	1	Volume 2	[]	Sherlock Bones 2	A SCRIPT FOR MURDER When Takeru's crush Miki gets scouted for a bit part in a movie, he takes a job on the set to protect her from the dangers of show business, including the wiles of a the dashing lead actor. Takeru soon discovers he wasn't over-reacting when Sherdog witnesses a real-life murder.	01KG99C6TJRW56Z3Q7WQJRXE99	2.0	2016-10-25T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Sherlock Bones 2	(C)Yuma Ando / Yuki Sato / Kodansha Ltd.	2016-10-25T07: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);