products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
9 rows where series_id = "CNT_0GYDRQNB7TSG"
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_00GM6490ENCG | CNT_09PY2KAJEBS0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 1 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 1 | Living next door to my brother with no wall between us...!? | 01KGAFSP6WNCG6BPA294TZ1KHX | 1.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 1 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0W25MHFY2PDG | CNT_1PC131MA3CR0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 3 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 3 | Living next door to my brother with no wall between us...!? | 01KGAFSQTHT6YMGWX30TJ4088R | 3.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 3 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0XZBCG7JZR80 | CNT_0TVGB6JEGEYG | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 4 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 4 | Living next door to my brother with no wall between us...!? | 01KGAFTC242J1BHPCT8V808AFP | 4.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 4 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1NN7EPMSG2H0 | CNT_2Y4VM6A9D85G | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 8 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 8 | Living next door to my brother with no wall between us...!? | 01KGAFT5CNFEKE84ZVAFKQ0P08 | 8.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 8 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1NSHPQW56GPG | CNT_0DNCC1C4W670 | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 7 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 7 | Living next door to my brother with no wall between us...!? | 01KGAFSGVNTYN6BF6B5R12K39F | 7.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 7 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1RE00AYF2ZNG | CNT_2CZSFK2DB500 | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 5 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 5 | Living next door to my brother with no wall between us...!? | 01KGAFSFRKQC92162H1XXQCHX2 | 5.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 5 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3QG9WDD7RG70 | CNT_3DZNWRH0QPQG | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 9 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 9 | Living next door to my brother with no wall between us...!? | 01KGAFSHVQ0KZQZ5Z00VDMEAYP | 9.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 9 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3T6RF0FA4Z60 | CNT_1DA2WA792NGG | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 6 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 6 | Living next door to my brother with no wall between us...!? | 01KGAFSGA5N0FF28KQBDX8EEHB | 6.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 6 | (C) Meg/ WWWave | 2022-03-22T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3X5V46APCX40 | CNT_1FZCZ7KSWKJG | A Hole in the Wall ~ Don't Look at Me Brother! ~ CNT_0GYDRQNB7TSG | 3 | 1 | 1 | Chapter 2 | [] | A Hole in the Wall ~ Don't Look at Me Brother! ~ 2 | Living next door to my brother with no wall between us...!? | 01KGAF4YFWXHNEANXH9Z26DT5V | 2.0 | 2022-03-22T07:00:00.000Z | screamo LAB_1P9SZ7SPJ1SG | GEO_1PQM5BDYSMG0 | A Hole in the Wall ~ Don't Look at Me Brother! ~ 2 | (C) Meg/ WWWave | 2022-03-22T07: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);