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_3YZ20DKKPKP0"

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_06T6FJDDHTX0	CNT_3QP8YYPMCMHG	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 7	[]	FAKE, Volume 7	Dee and Ryo join Diana on her mission to protect Alicia, a key witness whose testimony could lead the FBI to shutting down one of the largest drug trafficking routes in the States. However, they soon find there is more than meets the eye behind this whole operation! The situation worsens by the minute as they are driven to and fro by Alicia who just doesn't seem to stay put. And will it be during this chaotic turn of events that Ryo finally confronts his yet-to-be-named feelings for Dee...?Final volume of Sanami Matoh's hit series "FAKE" with a special chapter "SHORT PIECE / side-F" included, showing a little peek into Dee and Ryo's future!	01KG9FNJVTEEK3855KAMNM4HC3	7.0	2021-06-15T07:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 7	(C) Sanami Matoh/COMPASS	2021-06-22T07:00:00.000Z
PRD_0PNJNNDQX7F0	CNT_3WPKJFASFJ7G	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 6	[]	FAKE, Volume 6	A psychopath preying on young girls is loose on the streets of New York. So far, all of his victims have turned up as corpses, all of them missing a hand from their bodies. At the same time, Cal notices a presence has been stalking her. Will Dee and Ryo make it in time to break this disturbing chain of events...? In the following act, Dee's bitter past and the incidents leading to his resolution to become a detective is revealed. Special chapter "FAKE side-R Section-3" also included!	01KG9F9AQNMWD23814DH2Y386Z	6.0	2021-05-18T07:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 6	(C) Sanami Matoh/COMPASS	2021-05-25T07:00:00.000Z
PRD_0WKJRVBSM260	CNT_2M3VM6WFJPJ0	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 3	[]	FAKE, Volume 3	A love rival appears!? The new commissioner Berkeley assigns Ryo to be his temporary buddy, teaming Dee up with Diana from the FBI. Dee is worried about the absent-minded Ryo being preyed on by Berkeley. Meanwhile, Ryo would never say it, but he starts to realize he might harbor special feelings for Dee...? As a lot of emotion is stirred up, another murderous case has them up in action!	01KG9DYJZSND41VF8SZRRG6X38	3.0	2021-02-15T08:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 3	(C) Sanami Matoh/COMPASS	2021-02-22T08:00:00.000Z
PRD_0ZSNDSHMWTH0	CNT_1FX52F9M5MDG	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 4	[]	FAKE, Volume 4	There is an explosion at Bikky's school! The bomber continues on to attack the 27th precinct and yet again the school. What drives the culprit to insistently make a target of them? Dee and Ryo go after the clues, but in the middle of the investigation, Dee is captured...with the timer ticking fast!Features a chapter on Bikky and Cal, with their still budding relationship, and a special chapter "FAKE side-R Section-1"!	01KG9F04QQ6ZQEZ7SXHHTJ0SMN	4.0	2021-03-23T07:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 4	(C) Sanami Matoh/COMPASS	2021-03-30T07:00:00.000Z
PRD_13KYD24Y02N0	CNT_0B4ZP97F1P30	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 1	[]	FAKE, Volume 1	Detective Randy "Ryo" Maclean has just arrived at the NYPD 27th precinct. It's not long before is he out on a narcotics case with his new buddy Dee Latener, the brash and self-confident troublemaker, who might be eager for more than just a business partnership with Ryo. Follow the NY cop duo Dee and Ryo in action against crimes, and for a possible romance-to-be...!?	01KG9CG7JVRMHWHWEGFB4D7XZ1	1.0	2020-12-15T08:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 1	(C) Sanami Matoh/COMPASS	2020-12-22T08:00:00.000Z
PRD_1CP79YT7RVF0	CNT_22ANB08DKP7G	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 5	[]	FAKE, Volume 5	Following the explosion at the 27th precinct, Dee and the team are temporarily staying at the Bronx precinct. Called out on yet another cold-blooded murder, they arrive at a shockingly brutal crime scene. Upon investigating the case, Ryo is reminded of an incident from the past. Dee is quick to pick up on his strange behavior, but will he be able to stop Ryo before he goes too far...? Special chapter "FAKE side-R Secion-2" included!	01KG9F51GSSDA6Z2180ZP3ZYCM	5.0	2021-04-20T07:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 5	(C) Sanami Matoh/COMPASS	2021-04-27T07:00:00.000Z
PRD_1JVD83K3M7J0	CNT_1PGYM6T4YV60	FAKE CNT_3YZ20DKKPKP0	CNT_3YZ20DKKPKP0	2	1	1	Volume 2	[]	FAKE, Volume 2	Dee and Ryo, a pair of New York City's finest, are off on vacation. They take a trip together to England, far from the demanding streets of NY, where Dee is desperate to make a move on Ryo. The two check into a cozy private hotel, but are soon surprised with news of a serial killing in the area. This unsolved case won't let the pair rest, especially when the victims have just one thing in common: their Japanese heritage!	01KG9DK964XCH1Q33J92GTZ0PP	2.0	2021-01-12T08:00:00.000Z	COMPASS LAB_1D0R022A7YRG	GEO_1PQM5BDYSMG0	FAKE, Volume 2	(C) Sanami Matoh/COMPASS	2021-01-19T08: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);