products

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

3 rows where series_id = "CNT_1G74AMJ68JWG"

✎ 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_0ZKMKKYHZW9G CNT_2BJ2H7KNX790 Clamp School Detectives CNT_1G74AMJ68JWG CNT_1G74AMJ68JWG 2 1 1 Volume 3 []   Clamp School Detectives, Vol. 3   It's tough being Nokoru Imonoyama, the smartest kid at a school for geniuses. There's not a lot that can stimulate his mind. So what does he do? Start a detective agency to help damsels in distress! Nokoru's partners are his two best friends and fellow class board members: South Takamura, a master of martial arts, and Akira Ijyuin, detective by day, thief by night. And when Nokoru isn't trying to replace himself with a robot to get out of his paperwork, he's searching for the owner of a lost silk stocking (obviously a damsel of the highest class), investigating an elaborate surveillance system, and recalling the time he made his first real friend during a daring kidnapping escape.   01K5GASN8RMN53X8XG41DYZPKW 3.0 2015-12-01T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Clamp School Detectives, Vol. 3 (C) CLAMP／KADOKAWA (C) CLAMP・ShigatsuTsuitachi CO.,LTD. 1993   2015-12-01T15:00:00.000Z   0 0
PRD_2WGRW13E3YFG CNT_0KVE9NXTV9B0 Clamp School Detectives CNT_1G74AMJ68JWG CNT_1G74AMJ68JWG 2 1 1 Volume 1 []   Clamp School Detectives, Vol. 1   Meet the CLAMP school detectives: Nokoru Imonoyama, the world's smartest kid, who can detect a woman in distress from two kilometers away; Suoh Takamura, a martial arts master who's cool as ice; Akira Ijyuin, detective by day, master thief by night. Wherever there's a young lady in distress, they'll be there. After all, when you're as smart as they are, you don't have to study.   01K5G9ST5M78MV9V3VV3E97BFQ 1.0 2015-10-04T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Clamp School Detectives, Vol. 1 (C) CLAMP／KADOKAWA (C) CLAMP・ShigatsuTsuitachi CO.,LTD. 1992   2015-10-04T15:00:00.000Z   0 0
PRD_33MEEYP18AD0 CNT_0JHYDBGW85PG Clamp School Detectives CNT_1G74AMJ68JWG CNT_1G74AMJ68JWG 2 1 1 Volume 2 []   Clamp School Detectives, Vol. 2   The CLAMP School is famous not just for being the world's most prestigious academy, but also for its students' penchant for partying. Scarcely a week goes by whent here isn't a festival, dance or athletic event. With so much going on, there's plenty of opportunity for something to go wrong--fortunately the CLAMP School Detectives are eager to protect all the school's goings on...especially ones in which young ladies are likely to attend. Nokoru Imonoyama is founder and leader of the group--an uber-genius who can detect a woman in distress from two kilometers away. Suoh Takamura is a class secretary and a martial arts master. Akira Ijyuin may be the youngest detective, but he's also one of the world's top chefs. Celebrations, apparitions and gastronomic sensations--they're all part of the job for the CLAMP School Detectives!   01K5GAPW0X2XGCP03PHASYQ5E3 2.0 2015-10-26T15:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Clamp School Detectives, Vol. 2 (C) CLAMP／KADOKAWA (C) CLAMP・ShigatsuTsuitachi CO.,LTD. 1993   2015-10-26T15: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);