products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
5 rows where series_id = "CNT_2MWFCGWJFD60"
This data as json, CSV (advanced)
Suggested facets: copyright, 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_0TZCBCEJY2JG | CNT_3DQ55B734XK0 | A Very Fairy Apartment CNT_2MWFCGWJFD60 | CNT_2MWFCGWJFD60 | 2 | 1 | 1 | Volume 2 | [] | A Very Fairy Apartment Volume 2 | Who needs peace and quiet when you've got a pack of fairies and elder spirits to run amok in your own home! It's all happening here: a girls' night in between the four great spirits (who keep coming back for more... and more... and more...), Rusalka taking up tendency, and a mischievous Goblin, it's becoming A Very (Crowded) Fairy Apartment! | Who needs peace and quiet when you've got a pack of fairies and elder spirits to run amok in your own home! It's becoming A Very (Crowded) Fairy Apartment! | 01KGA7FJ56XNJRECQHWY7B0PMD | 2.0 | 2019-08-23T07:00:00.000Z | J-Novel Club LAB_30X9NTZYDFV0 | GEO_1PQM5BDYSMG0 | A Very Fairy Apartment Volume 2 | Copyright (C) 2018 Amakara Surume | 2019-11-06T08:00:00.000Z | 0 | 0 | ||||
| PRD_148DBNSQH130 | CNT_0DA4YYF9W61G | A Very Fairy Apartment CNT_2MWFCGWJFD60 | CNT_2MWFCGWJFD60 | 2 | 1 | 1 | Volume 5 | [] | A Very Fairy Apartment Volume 5 | Is everyone really leaving? Things are going to get lonely around here... It feels like it's been ages since we moved in here. At first it was only Pixie and Kobold, but before I knew it, the place was just bursting with fay. And now I've gotten so caught up with my thesis and getting ready for graduation... It's looking like the fun is going to be over as quickly as it started. All of a sudden, everyone's saying goodbye. As it turns out, however, I'm in for one last surprise in the form of a text from my uncle, the owner of the apartment building. It's going to be a VERY FAIRY grand finale! | Is everyone really leaving? Things are going to get lonely around here... It feels like it's been ages since we moved in here. At first it was only Pixie and Kobold, but before I knew it, the place was just bursting with fay. And now I've gotten so caught up with my thesis and getting ready for graduation... It's looking like the fun is going t... | 01KG9D90E8TXX2BYT7HP6C59XZ | 5.0 | 2020-10-02T07:00:00.000Z | J-Novel Club LAB_30X9NTZYDFV0 | GEO_1PQM5BDYSMG0 | A Very Fairy Apartment Volume 5 | Copyright (C) 2020 Amakara Surume | 2020-12-02T08:00:00.000Z | 0 | 0 | ||||
| PRD_1VAX3ETHEPT0 | CNT_37QZJD15ETTG | A Very Fairy Apartment CNT_2MWFCGWJFD60 | CNT_2MWFCGWJFD60 | 2 | 1 | 1 | Volume 4 | [] | A Very Fairy Apartment Volume 4 | The apartment is really hopping now! What new friends will show up this time? First there's the wine-loving Abbey Lubber, who really knows how to bring the house down—literally. Then MC gets stuck helping Ogre look for a job... It's just one pain after another! For a nice change of pace, Ellyllon invites MC to a fairy orchard to kick back and destress. Unfortunately, however, it's full of icky bug fay and more orthodox (?) fay who like to try and seduce humans. The fun never ends around here! | 01KG9CR75A38CB43R6XYFF7PF5 | 4.0 | 2020-07-03T07:00:00.000Z | J-Novel Club LAB_30X9NTZYDFV0 | GEO_1PQM5BDYSMG0 | A Very Fairy Apartment Volume 4 | Copyright (C) 2019 Amakara Surume | 2020-09-02T07:00:00.000Z | 0 | 0 | |||||
| PRD_30RHC2FTJ250 | CNT_20EZ0PXZJE9G | A Very Fairy Apartment CNT_2MWFCGWJFD60 | CNT_2MWFCGWJFD60 | 2 | 1 | 1 | Volume 1 | [] | A Very Fairy Apartment Volume 1 | What do you get when you put a down-to-earth college student in a supposedly vacant apartment that's actually full of some quirky, otherworldly creatures? A whole lot of trouble, a whole lot of cuteness, and a whole lot of fun. Sometimes cheap rent is enough to make you put up with the strangest of neighbors and roommates, but forget about sugar, spice, and everything nice; and get ready for potato chips, pranks, and everything messy! | What do you get when you put a down-to-earth college student in a supposedly vacant apartment that's actually full of some quirky, otherworldly creatures? A whole lot of trouble, a whole lot of cuteness, and a whole lot of fun. | 01KGA61BCYEXWRARSNGH8A4FS5 | 1.0 | 2019-06-11T15:00:00.000Z | J-Novel Club LAB_30X9NTZYDFV0 | GEO_1PQM5BDYSMG0 | A Very Fairy Apartment Volume 1 | Copyright (C) 2017 Amakara Surume | 2019-06-25T07:00:00.000Z | 0 | 0 | ||||
| PRD_3QZ0P5JE223G | CNT_3BTD675VK3R0 | A Very Fairy Apartment CNT_2MWFCGWJFD60 | CNT_2MWFCGWJFD60 | 2 | 1 | 1 | Volume 3 | [] | A Very Fairy Apartment Volume 3 | The apartment has gone from infested to overrun--it's practically overflowing with fay, both residents and visitors! There's hardly any room for the main character in his own digs these days... Perhaps that's why the crew's been going out more, but you know what that means, don't you? More fay friends! There's Kelpie at the river, Murian in the forest, and even Leanan Sidhe at the comic market. And, like it or not, MC's about to meet them all. | The apartment has gone from infested to overrun--it's practically overflowing with fay, both residents and visitors! Perhaps that's why the crew's been going out more, but you know what that means, don't you? More fay friends! | 01KG9BHQ9P5V3ZPC8PV4YVVFPP | 3.0 | 2020-02-02T15:00:00.000Z | J-Novel Club LAB_30X9NTZYDFV0 | GEO_1PQM5BDYSMG0 | A Very Fairy Apartment Volume 3 | Copyright (C) 2018 Amakara Surume | 2020-03-04T08: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);