products

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

9 rows where series_id = "CNT_3KKS7YJMEH2G"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, on_sale_at, 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_0XS9P0F9Y6MG CNT_270J3BFYYHKG Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 4 []   Kieli, Vol. 4   It's been a year and a half since Harvey left Kieli and the Corporal in Beatrix's care. Though she hasn't heard a word from him in all that time, Kieli can't forget the Undying who took her under his wing. When Beatrix receives a cryptic note from Harvey indicating that he's discovered information about Kieli's mother, Kieli abandons the Corporal and Beatrix in an effort to track Harvey down, but the passing of time has not been kind to the Undying. Will Harvey and Kieli have a second chance at a life together, or is this the end of their story?   01KGA3080JSMXCMDJRFXX43HFM 4.0 2018-02-27T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 4     2018-02-27T08:00:00.000Z   0 0
PRD_12PEDW32F3DG CNT_0JM89X741FAG Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 6 []   Kieli, Vol. 6   A lonely girl. An Undying soldier. An uncommon romance.Kieli is a reclusive girl isolated by her ability to see ghosts. Heronly friend is her "roommate," Becca, the precocious spirit of a formerstudent still residing in Kieli's dorm. Everything in Kieli's lifechanges suddenly when the girls meet the handsome but distant Harveywho, like Kieli, can see ghosts. He also turns out to be one of thelegendary Undying, an immortal soldier bred for war now being hunted bythe Church. When Kieli joins Harvey on a pilgrimage to lay to rest thespirit of a corporal possessing an old radio, as unlikely as it seems,she feels she may have finally found a place where she belongs in theworld. And in Kieli, Harvey may have found a reason to live again. The manga adaptation of Kieli was named to the Great Graphic Novels for Teens 2009 list by the Young Adult Library Services Association (YALSA)!   01KGA3A58AFAQYB0EZVY1VQB97 6.0 2018-03-27T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 6     2018-03-27T07:00:00.000Z   0 0
PRD_1F1BBP2S8V90 CNT_3TA3PRZHQ7E0 Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 3 []   Kieli, Vol. 3   Kieli and Harvey have settled into a normal life in a small town...at least as normal as life gets for a girl who can see ghosts and an immortal soldier. But when a face from Harvey's past surfaces, just how long can they hold on to the comfortable existence that they have carved out for themselves? Does Harvey even want to hold on to it? The shocking conclusion to this third installment of the Kieli series will change everything for this pair of unlikely companions!   01KGA2J5HB38S5YG104PXGXFHK 3.0 2018-01-30T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 3     2018-01-30T08:00:00.000Z   0 0
PRD_1Y1Z291R34EG CNT_2K9V9KJVKG9G Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 8 []   Kieli, Vol. 8   Kieli, Harvey, and the Corporal are on their way to the capital with Joachim in tow...though nobody seems too happy about it. But when undead monsters attack their train, the group is separated, leaving Kieli on her own - that is, until she meets her father! Now that she's reunited with her relative and her old friend Julius to boot, does this mean the end of Kieli's adventures with Harvey and the Corporal?   01KGA43KPGVKVN5EY6BMKMYHZS 8.0 2018-03-27T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 8     2018-03-27T07:00:00.000Z   0 0
PRD_264655ERFXC0 CNT_2VPFSQCRP5HG Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 1 []   Kieli, Vol. 1   Kieli is a reclusive girl isolated by her ability to see ghosts. Heronly friend is her "roommate," Becca, the precocious spirit of a formerstudent still residing in Kieli's dorm. Everything in Kieli's lifechanges suddenly when the girls meet the handsome but distant Harveywho, like Kieli, can see ghosts. He also turns out to be one of thelegendary Undying, an immortal soldier bred for war now being hunted bythe Church. When Kieli joins Harvey on a pilgrimage to lay to rest thespirit of a corporal possessing an old radio, as unlikely as it seems,she feels she may have finally found a place where she belongs in theworld. And in Kieli, Harvey may have found a reason to live again.   01KGA1GWJRCFJZW3H4EAE6HWVS 1.0 2017-12-19T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 1     2017-12-19T08:00:00.000Z   0 0
PRD_2ZG1XQW4G650 CNT_17BVK2MTR220 Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 5 []   Kieli, Vol. 5   (Volume 1)A lonely girl. An Undying soldier. An uncommon romance.Kieli is a reclusive girl isolated by her ability to see ghosts. Her only friend is her "roommate," Becca, the precocious spirit of a former student still residing in Kieli's dorm. Everything in Kieli's life changes suddenly when the girls meet the handsome but distant Harvey who, like Kieli, can see ghosts. He also turns out to be one of the legendary Undying, an immortal soldier bred for war now being hunted by the Church. When Kieli joins Harvey on a pilgrimage to lay to rest the spirit of a corporal possessing an old radio, as unlikely as it seems, she feels she may have finally found a place where she belongs in the world. And in Kieli, Harvey may have found a reason to live again.   01KGA308V08Y637YGRZFJR6WG7 5.0 2018-02-27T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 5     2018-02-27T08:00:00.000Z   0 0
PRD_3DEKW0DYPVRG CNT_0XZT61TNXPZG Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 2 []   Kieli, Vol. 2   Kieli, the girl who sees ghosts, and her Undying companion, Harvey, return in their second adventure - this time on the high seas of the Sand Ocean! Things are far from ship-shape, though, aboard the vessel carrying these two unusual travelers. Dark spirits are rising, but which is the greater threat - the souls of the dead or the intentions of the living? Kieli and Harvey will have to rely on each other now more than ever, but when their pasts come back to haunt them, will it prove to be more than either can bear?   01KGA2J4WS3C0P05603Q636P6R 2.0 2018-01-30T08:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 2     2018-01-30T08:00:00.000Z   0 0
PRD_3SRQ90PV55Z0 CNT_1KM4YAQQD0R0 Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 9 []   Kieli, Vol. 9   Kieli, Harvey, and their companions are trapped inside the Church's headquarters, which is still surrounded by monsters. But the biggest and most terrifying monster of all turns out to be an old friend-Jude. This is a fight that needs to be won before either Harvey or Kieli can move on, though they have very different ideas on how to go about securing victory...The manga adaptation of Kieli was named to the Great Graphic Novels for Teens 2009 list by the Young Adult Library Services Association (YALSA)!   01KGA43MB9BMDEBES7N78TWEKN 9.0 2018-03-27T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 9     2018-03-27T07:00:00.000Z   0 0
PRD_3W97MKGX14Y0 CNT_3JYHSMDZRZS0 Kieli CNT_3KKS7YJMEH2G CNT_3KKS7YJMEH2G 2 2 1 Volume 7 []   Kieli, Vol. 7   When the Corporal's wires get crossed and his memory begins to fail, Harvey and Kieli are forced to temporarily set aside their search for Beatrix to scout for pre-War parts for their afflicted comrade. Along the way, they encounter a strange beast who knows far too much about Undyings and has taken an unsettling interest in Harvey. But it may be a far more mundane menace from Kieli's past that threatens the couple's continuing journey...   01KGA43K5NWQY2PBKM03CD418W 7.0 2018-03-27T07:00:00.000Z Yen On LAB_0TB60FJ75DX0 GEO_1PTQTSR31PRG Kieli, Vol. 7     2018-03-27T07: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);