products
Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export)
6 rows where series_id = "CNT_2NCKB09AZRMG"
This data as json, CSV (advanced)
Suggested facets: level, description, display_order, 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_01VQPDE5WE90 | CNT_11Y33A9VRJMG | A Desperate Battle CNT_2NCKB09AZRMG | 3 | 1 | 1 | Chapter 3 | [] | A Desperate Battle (3) | A love battle set in the Japan Air Self-Defense Force between an officer and an enlisted soldier! Mamoru Yaotome discovered that the upperclassman in high school that he had always had a crush on, Shingo Akutagawa, had become an elite pilot after graduating from a military academy. Yaotome decided to follow in his footsteps by joining the Japan Air Self-Defense Force as a cadet and trained to be a mechanic. Even when they appeared on a matchmaking show on TV that was meant to promote the JASDF, he only had eyes for Akutagawa and paid no notice to the women around them. Despite the passionate gazes of love that Yaotome was constantly looking at him with, Akutagawa declared that he would never be able to return his feelings. Yaotome still wasn't discouraged, but he noticed a change in Akutagawa's behavior! However, there was a reason that Akutagawa could never accept his own feelings. This is a battle of love set in the Japan Air Self-Defence Force between a hot-and-cold officer and a puppy-like soldier! | 01KGBEBRZJ8QV6YW9CSXGTAHGE | 3.0 | 2024-10-01T07:00:00.000Z | BisouBisou Comics LAB_0JGPGQ3D936G | GEO_1PQM5BDYSMG0 | A Desperate Battle (3) | ©YOU OHIRA/BisouBisou Comics | 2024-10-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_04S494J8N4VG | CNT_2EV3VB9DX7S0 | A Desperate Battle CNT_2NCKB09AZRMG | 3 | 1 | 1 | Chapter 4 | [] | A Desperate Battle (4) | A love battle set in the Japan Air Self-Defense Force between an officer and an enlisted soldier! Mamoru Yaotome discovered that the upperclassman in high school that he had always had a crush on, Shingo Akutagawa, had become an elite pilot after graduating from a military academy. Yaotome decided to follow in his footsteps by joining the Japan Air Self-Defense Force as a cadet and trained to be a mechanic. Even when they appeared on a matchmaking show on TV that was meant to promote the JASDF, he only had eyes for Akutagawa and paid no notice to the women around them. Despite the passionate gazes of love that Yaotome was constantly looking at him with, Akutagawa declared that he would never be able to return his feelings. Yaotome still wasn't discouraged, but he noticed a change in Akutagawa's behavior! However, there was a reason that Akutagawa could never accept his own feelings. This is a battle of love set in the Japan Air Self-Defence Force between a hot-and-cold officer and a puppy-like soldier! | 01KGBE86JS8C8JYWW0QR1NN4WH | 4.0 | 2024-10-01T07:00:00.000Z | BisouBisou Comics LAB_0JGPGQ3D936G | GEO_1PQM5BDYSMG0 | A Desperate Battle (4) | ©YOU OHIRA/BisouBisou Comics | 2024-10-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_0KA01F41XF90 | CNT_1MB3HW08VKMG | A Desperate Battle CNT_2NCKB09AZRMG | CNT_2NCKB09AZRMG | 2 | 1 | 1 | A Desperate Battle | [] | A Desperate Battle | PLEASE NOTE: This volume contains multiple previously-released chapters. Please take care when you purchase to make sure you do not buy duplicate content from the serialized version of this comic. A love battle set in the Japan Air Self-Defense Force between an officer and an enlisted soldier! Mamoru Yaotome discovered that the upperclassman in high school that he had always had a crush on, Shingo Akutagawa, had become an elite pilot after graduating from a military academy. Yaotome decided to follow in his footsteps by joining the Japan Air Self-Defense Force as a cadet and trained to be a mechanic. Even when they appeared on a matchmaking show on TV that was meant to promote the JASDF, he only had eyes for Akutagawa and paid no notice to the women around them. Despite the passionate gazes of love that Yaotome was constantly looking at him with, Akutagawa declared that he would never be able to return his feelings. Yaotome still wasn't discouraged, but he noticed a change in Akutagawa's behavior! However, there was a reason that Akutagawa could never accept his own feelings. This is a battle of love set in the Japan Air Self-Defence Force between a hot-and-cold officer and a puppy-like soldier! | 01KGBD6YQ7ZFF6GSC431K08TH0 | 1.0 | 2024-10-01T07:00:00.000Z | BisouBisou Comics LAB_0JGPGQ3D936G | GEO_1PQM5BDYSMG0 | A Desperate Battle | ©YOU OHIRA/BisouBisou Comics | 2024-10-01T07:00:00.000Z | 0 | 0 | |||||
| PRD_1H36WG5150ZG | CNT_3GVH75ABA23G | A Desperate Battle CNT_2NCKB09AZRMG | 3 | 1 | 1 | Chapter 2 | [] | A Desperate Battle (2) | A love battle set in the Japan Air Self-Defense Force between an officer and an enlisted soldier! Mamoru Yaotome discovered that the upperclassman in high school that he had always had a crush on, Shingo Akutagawa, had become an elite pilot after graduating from a military academy. Yaotome decided to follow in his footsteps by joining the Japan Air Self-Defense Force as a cadet and trained to be a mechanic. Even when they appeared on a matchmaking show on TV that was meant to promote the JASDF, he only had eyes for Akutagawa and paid no notice to the women around them. Despite the passionate gazes of love that Yaotome was constantly looking at him with, Akutagawa declared that he would never be able to return his feelings. Yaotome still wasn't discouraged, but he noticed a change in Akutagawa's behavior! However, there was a reason that Akutagawa could never accept his own feelings. This is a battle of love set in the Japan Air Self-Defence Force between a hot-and-cold officer and a puppy-like soldier! | 01KGBE80ZDEVKTGR7QKT2MB8AR | 2.0 | 2024-10-01T07:00:00.000Z | BisouBisou Comics LAB_0JGPGQ3D936G | GEO_1PQM5BDYSMG0 | A Desperate Battle (2) | ©YOU OHIRA/BisouBisou Comics | 2024-10-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_1NHHE37B1FYG | CNT_1G6E6Q0KS1CG | A Desperate Battle CNT_2NCKB09AZRMG | 3 | 1 | 1 | Chapter 1 | [] | A Desperate Battle (1) | A love battle set in the Japan Air Self-Defense Force between an officer and an enlisted soldier! Mamoru Yaotome discovered that the upperclassman in high school that he had always had a crush on, Shingo Akutagawa, had become an elite pilot after graduating from a military academy. Yaotome decided to follow in his footsteps by joining the Japan Air Self-Defense Force as a cadet and trained to be a mechanic. Even when they appeared on a matchmaking show on TV that was meant to promote the JASDF, he only had eyes for Akutagawa and paid no notice to the women around them. Despite the passionate gazes of love that Yaotome was constantly looking at him with, Akutagawa declared that he would never be able to return his feelings. Yaotome still wasn't discouraged, but he noticed a change in Akutagawa's behavior! However, there was a reason that Akutagawa could never accept his own feelings. This is a battle of love set in the Japan Air Self-Defence Force between a hot-and-cold officer and a puppy-like soldier! | 01KGBD6E4P04K1S4VTM3N3Z2C1 | 1.0 | 2024-10-01T07:00:00.000Z | BisouBisou Comics LAB_0JGPGQ3D936G | GEO_1PQM5BDYSMG0 | A Desperate Battle (1) | ©YOU OHIRA/BisouBisou Comics | 2024-10-01T07:00:00.000Z | 0 | 0 | ||||||
| PRD_3VK1FBZ6FM5G | CNT_1CK9CZA9HRF0 | A Desperate Battle CNT_2NCKB09AZRMG | 3 | 1 | 1 | Chapter 5 | [] | A Desperate Battle (5) | A love battle set in the Japan Air Self-Defense Force between an officer and an enlisted soldier! Mamoru Yaotome discovered that the upperclassman in high school that he had always had a crush on, Shingo Akutagawa, had become an elite pilot after graduating from a military academy. Yaotome decided to follow in his footsteps by joining the Japan Air Self-Defense Force as a cadet and trained to be a mechanic. Even when they appeared on a matchmaking show on TV that was meant to promote the JASDF, he only had eyes for Akutagawa and paid no notice to the women around them. Despite the passionate gazes of love that Yaotome was constantly looking at him with, Akutagawa declared that he would never be able to return his feelings. Yaotome still wasn't discouraged, but he noticed a change in Akutagawa's behavior! However, there was a reason that Akutagawa could never accept his own feelings. This is a battle of love set in the Japan Air Self-Defence Force between a hot-and-cold officer and a puppy-like soldier! | 01KGBEA4M6XB9WYGMFK93VH247 | 5.0 | 2024-10-01T07:00:00.000Z | BisouBisou Comics LAB_0JGPGQ3D936G | GEO_1PQM5BDYSMG0 | A Desperate Battle (5) | ©YOU OHIRA/BisouBisou Comics | 2024-10-01T07: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);