products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
6 rows where series_id = "CNT_0TSQ186KNE40"
This data as json, CSV (advanced)
Suggested facets: geoblock_id, 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_00YK8AZBJJFG | CNT_22KNCCV2RPG0 | A Witch's Printing Office CNT_0TSQ186KNE40 | CNT_0TSQ186KNE40 | 2 | 1 | 1 | Volume 5 | [] | A Witch's Printing Office, Vol. 5 | Mika has been trying to get home to Japan for a long time. But how did she first learn to wield the copy magic at the heart of Protagonist Press, and how did she meet Kiriko and Lio? As the group reminisces, new challenges keep their focus on the present-including a rival printing press, an assassin, as well as an ancient and powerful threat! | 01KG9H30HDMDX3G1XCRVZYNGQB | 5.0 | 2021-09-16T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PTQTSR31PRG | A Witch's Printing Office, Vol. 5 | 2021-11-16T08:00:00.000Z | 0 | 0 | ||||||
| PRD_1X8XMTZJNSEG | CNT_3J61QEH76CE0 | A Witch's Printing Office CNT_0TSQ186KNE40 | CNT_0TSQ186KNE40 | 2 | 1 | 1 | Volume 6 | [] | A Witch's Printing Office, Vol. 6 | <P> Ever since Mika was transported from Japan to a fantasy world, she’s beenrunning Magic Market in the hopes of finding a spell to take her home.But when all the world’s magic disappears, it’s up to Mika to deal with this crisis—and that means visiting the home of the fey. As the origin of human magic, the realm is full of surprises (including a fairy ruler who wants a Magiket booth!), but could it also be the key to granting Mika’s greatest desire? The book closes on A Witch’s Printing Office in this final volume! </P> | 01KGAGVM6VXYXB40TX0QTC6BPW | 6.0 | 2022-06-28T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1G5EK0KH20W0 | A Witch's Printing Office, Vol. 6 | 2022-07-12T00:00:00.000Z | 0 | 0 | ||||||
| PRD_1Z4AKHNJHFS0 | CNT_0JV46NPXMKF0 | A Witch's Printing Office CNT_0TSQ186KNE40 | CNT_0TSQ186KNE40 | 2 | 1 | 1 | Volume 4 | [] | A Witch's Printing Office, Vol. 4 | Protagonist Press is as busy as ever, thanks in part to Mika’s hugely successful Magic Market bookselling event-from magic-decrying warriors to tiny, meddling fairies, people from all walks of life are dipping their toes into the wonderful world of magical tomes. Despite the ever-growing size of Magiket’s crowd, the Prep Committee has the chaos well under control...until its faithful venue is suddenly double-booked, dumping Mika into a whole new crisis! | 01KG9DJ8V6WVEG22SDAXJBS7PJ | 4.0 | 2020-11-26T08:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | A Witch's Printing Office, Vol. 4 | 2020-12-15T08:00:00.000Z | 0 | 0 | ||||||
| PRD_3CRDXR9ADBW0 | CNT_2P52NC77900G | A Witch's Printing Office CNT_0TSQ186KNE40 | CNT_0TSQ186KNE40 | 2 | 1 | 1 | Volume 3 | [] | A Witch's Printing Office, Vol. 3 | Mika’s massively popular magic-focused event “Magiket” has grown again, continuing to bring her spells and mages from around the world—and also boatloads of work…But despite her Market’s ever-increasing reach, a surprise encounter comes from outside Mika’s purview! The last thing she expected was to meet another Japanese visitor—could this transplant also be seeking a way home? | 01KGA9737FPZF11Z33RZCXDWCH | 3.0 | 2020-05-21T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | A Witch's Printing Office, Vol. 3 | 2020-06-23T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3DBFRSKGBQE0 | CNT_1E6Q54CX49EG | A Witch's Printing Office CNT_0TSQ186KNE40 | CNT_0TSQ186KNE40 | 2 | 1 | 1 | Volume 2 | [] | A Witch's Printing Office, Vol. 2 | Dragons, typhoons, and demon lords, oh my! The popularity of Magic Market has boomed beyond expectation—in fact, it’s such a hit, news has reached even the highest echelon of the underworld. As the Holy Land teems with all manner of human and monster, will Mika be able to keep order and find a way back home, or will chaos ultimately reign under the arrival of the Demon Lord?! | 01KG9BKBCS6NF96A38SY3JA188 | 2.0 | 2020-03-10T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | A Witch's Printing Office, Vol. 2 | 2020-04-21T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3Z7NPASY8JB0 | CNT_1PHFE26HR41G | A Witch's Printing Office CNT_0TSQ186KNE40 | CNT_0TSQ186KNE40 | 2 | 1 | 1 | Volume 1 | [] | A Witch's Printing Office, Vol. 1 | What nerd wouldn’t enjoy exploring an RPG-style world? Not Mika Kamiya! She was just about to enjoy her post-Comic Market haul when fate whisked her away to a fantasy land. All Mika wants is to find a way home, so she’s hunting for spells—but rather than search all over, they’ll be coming to her to attend her magical-book-selling event, Magic Market! With a very “animated” catalog of guests, eccentric attendees, and out-of-control lines, what could possibly go wrong?! | 01KGA644JPV6BAQ35NDAWQ0Z45 | 1.0 | 2019-09-01T07:00:00.000Z | Yen Press LAB_0MPN6X9X3ADG | GEO_1PQM5BDYSMG0 | A Witch's Printing Office, Vol. 1 | 2019-12-24T08:00:00.000Z | 0 | 0 |
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);