products

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

13 rows where series_id = "CNT_2S0N4YNV2YM0"

✎ View and edit SQL

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_0ZQYEJBWEH40 CNT_2TCHAB1FB30G Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 4 []   Farewell, My Dear Cramer 4   In the Saitama Prefecture Inter-High qualifying matches, the Walabis have managed to win all their games despite Nozomi's Onda's uneven play. But their opponent in the first round of the tournament is the crowned champion of Saitama, Hosei Urawa. Can the Warabis manage to slay the giant--the team whose absolute dominance has led to them not giving up even a single point in Saitama play the past two years?   01KG9BGGE0JMBMHNX8JDCXH5TE 4.0 2019-10-29T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 4 Naoshi Arakawa / Kodansha Ltd.   2019-11-12T08:00:00.000Z   0 0
PRD_12EMD810WJ90 CNT_3F8NPHRB86Z0 Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 12 []   Farewell, My Dear Cramer 12   Only a few minutes remain in the second half of the final game in the JKFB Interleague Tournament against Korenkan! With a player ejected and almost out of time, the Warabis managed to bring themselves one goal closer. Is it possible for the Warabis to pull off a come-from-behind win?!   01KG9DE2PYF8X6KWR1ERBHHWFW 12.0 2020-11-10T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 12 Naoshi Arakawa / Kodansha Ltd.   2020-11-24T08:00:00.000Z   0 0
PRD_1EAY1981VFHG CNT_3DMB5YVPY37G Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 13 []   Farewell, My Dear Cramer 13   The result of a fierce final match was a Warabi loss to Korenkan. But the girls have little time for tears as they're whisked away for a training camp in preparation for the Saitama qualifying matches of the All-Japan High School Girl's Soccer Championship. It's there that Fukatsu introduces a new tactic: Gegen Pressing...   01KG9ETXFCVZFERWTRZ0GS6NN7 13.0 2021-03-04T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 13 Naoshi Arakawa / Kodansha Ltd.   2021-03-23T07:00:00.000Z   0 0
PRD_1J3M21N5JQP0 CNT_2DN26FZVN8PG Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 7 []   Farewell, My Dear Cramer 7   The JKFB Interleague Tournament, a gathering of some of the strongest girls' soccer teams in the greater Tokyo area, have entered their semifinal rounds. And the roadblock standing in the Warabis way is Eisen Funabashi High School which is the very team that defeated Kunogi Academy! The Warabis have taken the first point from the vaunted Eisen Funabashi defensive block. Have they actually defeated Eisen Funabashi's trump card?   01KGA8HYQSRR0J0XNSR8K7RN02 7.0 2020-01-28T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 7 Naoshi Arakawa / Kodansha Ltd.   2020-02-11T08:00:00.000Z   0 0
PRD_1MRZSV0T95RG CNT_2KXKAYERJSV0 Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 10 []   Farewell, My Dear Cramer 10   The Warabis kick off their battle with Korenkan High School, and under Korenkan's forceful attack, the Warabis lose a quick two points. The girls of Seinan Warabi still have the fire of competition within them, but the danger of Korenkan is closing in.   01KG9CQHJRYBR7ARK3S4MXSW1R 10.0 2020-06-30T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 10 Naoshi Arakawa / Kodansha Ltd.   2020-07-07T07:00:00.000Z   0 0
PRD_1TGR2FWDVGZG CNT_1YJXF5TW6HW0 Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 3 []   Farewell, My Dear Cramer 3   Sumire Suo, Midori Soshizaki, and Non Onda enter a futsal tournament hoping to win the store credits to get themselves decent uniforms, but short handed, they form an improvised team, roping in Tsukuda and Ito from Kunogi Acadamy. They win their early matches, rising toward the finals, but waiting to play against them is a player who seems to hold a special grudge against Ito!   01KGA7M2WH3PC2B7NM0K5WDYM0 3.0 2019-10-03T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 3 (C) Naoshi Arakawa / Kodansha Ltd.   2019-10-08T07:00:00.000Z   0 0
PRD_25RQ52MWE3SG CNT_2HC50DH92QT0 Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 11 []   Farewell, My Dear Cramer 11   With their ace striker, Kurusu, leading the way, the Korenkan momentum seems unstoppable! But the girls of the Warabis stand up to them using their own tactics and techniques. What is the Warabis' new plan to pierce through the Korenkan line...?!   01KG9CTVWE99CEGJX1VA7SD1M3 11.0 2020-07-27T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 11 Naoshi Arakawa / Kodansha Ltd.   2020-07-28T07:00:00.000Z   0 0
PRD_27EH9SVTT8K0 CNT_13DFEJMXE99G Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 8 []   Farewell, My Dear Cramer 8   The Warabis needed a strategy to combat the ace of the Eisen Funabashi team, Tae Kokubu. And the Warabis' answer is to change position for Onda and send in ""Golgo the Assassin,"" Echizen. Can that turn around the game for them? On which team will the Goddess of Victory smile?   01KGA8QPKKM050X01F9AGFDTX2 8.0 2020-02-26T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 8 Naoshi Arakawa / Kodansha Ltd.   2020-03-10T07:00:00.000Z   0 0
PRD_2F7SH19BXY60 CNT_3FPNF30XA06G Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 5 []   Farewell, My Dear Cramer 5   In the first round of the Saitama Prefecture Inter-High tournament, Nozomi Onda is finally demonstrating her talent and closing in on the opponents' goal! But moments later, the ball is stolen by Urawa's Alice Adatara only to have Adatara score a goal. Down by a goal with very little time left, can the Warabis find someone with the consistent skills to tie the game back up?!   01KGA8915AH34H6TM2ZNDZRMS0 5.0 2019-11-26T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 5 Naoshi Arakawa / Kodansha Ltd.   2019-12-10T08:00:00.000Z   0 0
PRD_2Y78FCTFE8F0 CNT_3YSBMJ1XW4QG Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 1 []   Farewell, My Dear Cramer 1   With no soccer accomplishments to speak of during the entirety of Sumire Suo's junior high school years, the young wing gets an odd offer. Suo's main rival, Midori Soshizaki, invites her to join up on the same team in high school, with a promise that she'll never let Suo “play alone.” It's an earnest offer, but the question is whether Suo will take her up on it. Thus the curtain opens on a story that collects an enormous cast of individual soccer-playing personalities!   01KGA62FRWR9R4W8WD812WY2S5 1.0 2019-07-24T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 1 (C) Naoshi Arakawa / Kodansha Ltd.   2019-07-30T07:00:00.000Z   0 0
PRD_38YMENE8TJX0 CNT_3978VW1VC3ZG Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 6 []   Farewell, My Dear Cramer 6   The spirits of the girls of Warabi Seinan's girls' soccer team are far from broken, even after the loss against Urawa Hosei. They've even begun practice again. As a team the Warabis make an earnest effort to construct new offenses and defenses, but has any of the practice payed off? They'll find out as they take on the champion teams of the greater Tokyo area in an Interleague tournament!   01KGA8BVNPPSE2BW2FE8F40S8H 6.0 2020-01-07T08:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 6 Naoshi Arakawa / Kodansha Ltd.   2020-01-14T08:00:00.000Z   0 0
PRD_3BC3AD3CXQSG CNT_36Y7X3HBJRJ0 Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 9 []   Farewell, My Dear Cramer 9   The Warabis rack up a win against Eisen Funabashi in the Interleague semifinals, but their opponent in the finals is Korenkan High School. Led by their ace striker, Mika Kurusu, Korenkan took the title of ""best in Japan"" in the Inter-High tournament. The whistle blows on the showdown match!   01KGA8YWR8XJ5T6CJEMNZBW99Z 9.0 2020-04-07T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 9 Naoshi Arakawa / Kodansha Ltd.   2020-04-14T07:00:00.000Z   0 0
PRD_3T5WW2DPF6EG CNT_3YTH948EK2Q0 Farewell, My Dear Cramer CNT_2S0N4YNV2YM0 CNT_2S0N4YNV2YM0 2 1 1 Volume 2 []   Farewell, My Dear Cramer 2   The scene is Warabi Seinan, a high school in the Tokyo-adjacent prefecture of Saitama. And possibly because it is considered to be weak at women's soccer, the team is “blessed” with an abundance of first-year students with strong, individualistic personalities, including Sumire Suo, Midori Soshizaki, Nozomi Onda, etc. But it's with the addition of a new coach, the legend of Japanese women’s soccer, Naoko Nomi, that the Warabis are reborn. Still, in their baptismal first match, they are faced with the best high-school team in Japan, Kunogi Academy. The first-half score shows Kunogi’s overwhelming dominance, but can the Warabis turn it around in the second half?   01KGA7EQC5NGJ7EZR6BXVRN0FX 2.0 2019-08-09T07:00:00.000Z Kodansha LAB_0ZM7YN9KHCT0 GEO_1PKAG51AEAQG Farewell, My Dear Cramer 2 (C) Naoshi Arakawa / Kodansha Ltd.   2019-08-20T07: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);