BookWalker

home / database

products

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

3 rows where series_id = "CNT_3WCE5AFKKKNG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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_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   0 0
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   0 0
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   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);
Powered by Datasette · Queries took 20.968ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS