database: products: 3 rows where series_id = "CNT

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

3 rows where series_id = "CNT_3WCE5AFKKKNG"

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_20JZN828KTDG	CNT_2M0JENVG6500	Pretty Boy Detective Club CNT_3WCE5AFKKKNG	CNT_3WCE5AFKKKNG	2	2	1	The Swindler, the Vanishing Man, and the Pretty Boys	[]	The Swindler, the Vanishing Man, and the Pretty Boys	From the renowed author NISIOISIN, the creator of BAKEMONOGATARI, Zaregoto Series and KATANAGATARI comes a new, innovative mystery series, Pretty Boy Detectives Club! A mysterious organization is operating behind the scenes at Yubiwa Academy the Pretty Boy Detective Club, comprised of President Manabu Sotoin, Vice President Nagahiro Sakiguchi, fearsome and fearless gourmand Michiru Fukuroi, angelic track star Hyota Ashikaga, and artistic genius/business prodigy Sosaku Yubiwa. One morning, new recruit Mayumi Dojima happens to see someone drop a mind-boggling bundle, and the game is afoot! The ensuing investigation takes the Pretty Boys into the heart of enemy territory, but will they be able to see (or not see) it through to the end? The Pretty Boy series continues with this exciting new chapter, pitting a sublime aesthetic against the superlative scam!	01KG9FNKWJP9GMM0H68464ASB8	2.0	2021-03-30T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Swindler, the Vanishing Man, and the Pretty Boys		2021-06-17T07:00:00.000Z
PRD_3C5VGD53N160	CNT_0CYXN0XACNAG	Pretty Boy Detective Club CNT_3WCE5AFKKKNG	CNT_3WCE5AFKKKNG	2	2	1	The Pretty Boy in the Attic	[]	The Pretty Boy in the Attic	From the renowed author NISIOISIN, the creator of BAKEMONOGATARI, Zaregoto Series and KATANAGATARI comes a new, innovative mystery series, Pretty Boy Detectives Club. Mayumi Doujima, a second-year student at Yubiwa Private Academy, is a girl on the hunt for a star that can only be seen once in every ten years. But it turns out that the "Pretty Boy Detective Club"--a mysterious, non-profit organization that is rumored to secretly solve trouble on campus--has decided to help Mayumi search for the star. These five vivacious pretty boys send her reeling, and set the stage for days of risky adventure!	01KG9HB065FXZSF6YGCBT65T75	3.0	2021-10-20T07:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	The Pretty Boy in the Attic	Pretty Boy Detective Club NISIOISIN-Kodansha Ltd.	2021-10-20T07:00:00.000Z
PRD_3XNG9G6HY9WG	CNT_2DP704VZEXMG	Pretty Boy Detective Club CNT_3WCE5AFKKKNG	CNT_3WCE5AFKKKNG	2	2	1	The Dark Star that Shines for You Alone	[]	Pretty Boy Detective Club: The Dark Star that Shines for You Alone	"I really have to give this book the highest marks I can... I could say buy this if you like Nisioisin or if you like mysteries or if you like amazing characters but I don't think it's for just any one type of person. Let me say, if you're reading this review: This book is for you... As far as the translation goes, I think they nailed it... To put it frankly, out of all Nisioisin's English releases, this is one of his top. To put it even simpler: It's beautiful. Five Out of Five Beautiful Dark Shining Stars." — No Good Nerds "The translation reads well with no issues to note... There is plenty to like and, as always, the author delivers an engrossing story with witty dialogue and interesting characters. I'm looking forward to seeing what kind of mysteries the Pretty Boy Detective Club tackle in the volumes to follow... Overall, Pretty Boy Detective Club offers another satisfying read for fans of NISIOISIN's works." — Anime UK News	01KG9E2NST5PAYFWNX8S3J9EKK	1.0	2021-01-27T08:00:00.000Z	Kodansha LAB_0ZM7YN9KHCT0	GEO_1PKAG51AEAQG	Pretty Boy Detective Club: The Dark Star that Shines for You Alone	NISIOISIN / Kodansha Ltd.	2021-02-09T08: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);