BookWalker

home / database

products

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

6 rows where series_id = "CNT_1TKWJM97XD70"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, listed_at, on_sale_at, 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_09KXYSCHAGD0 CNT_24N9XRSRHNQG Stories from the Shopping District CNT_1TKWJM97XD70   3 1 1 Chapter 6 []   Stories from the Shopping District, Chapter 6   After working as a chef in Italy, Shouta comes back to his old neighborhood in Japan to help out his family's restaurant. Upon returning, he is also reunited with his childhood friend, Makoto, who is now the local grocer to all the restaurants in the shopping district. But as it turns out, Makoto is providing more than just produce. The once teary-eyed and weak kid is now the backbone of this shopping district and "helping out" the restaurateurs by satisfying their libidos. And quite frankly, Shouta doesn't know what do with this information. It also doesn't help that he found out about it when he walks in on Makoto and the local butcher...   01KG9CED0B3SXV4MVA2ZY77MFS 6.0 2020-11-17T08:00:00.000Z MediBang LAB_2YZM2CTQ9JPG GEO_1PKAG51AEAQG Stories from the Shopping District, Chapter 6 (C)Sanba Maekawa/TORICO   2020-11-17T08:00:00.000Z   0 0
PRD_1QS7V6BN34A0 CNT_3YF8F8MSZGMG Stories from the Shopping District CNT_1TKWJM97XD70   3 1 1 Chapter 3 []   Stories from the Shopping District, Chapter 3   After hearing about his father's hospitalization, Shouta decided to leave his Pastaio job in Italy and inherit his family Western cuisine restaurant in Hurubita Shopping District. Not much has changed in the district, except probably his-used-to-be-innocent childhood friend, Makoto, who had now bloomed into an attractive guy everyone in the district wanted to sleep with. Makoto's casual sexual relationship with many young men in the district kinda drives Shouta crazy, but maybe... Just maybe Makoto still saves some of his innocence for the guy who hadn't been home for 7 years.   01KGA6Z981YXZ3906A5P1EF7Z5 3.0 2019-05-28T07:00:00.000Z MediBang LAB_2YZM2CTQ9JPG GEO_1PKAG51AEAQG Stories from the Shopping District, Chapter 3 (C)Sanba Maekawa/TORICO   2019-05-28T07:00:00.000Z   0 0
PRD_1TFP6S5ZF390 CNT_1HS5ET92DFNG Stories from the Shopping District CNT_1TKWJM97XD70   3 1 1 Chapter 1 []   Stories from the Shopping District, Chapter 1   After hearing about his father's hospitalization, Shouta decided to leave his Pastaio job in Italy and inherit his family Western cuisine restaurant in Hurubita Shopping District. Not much has changed in the district, except probably his-used-to-be-innocent childhood friend, Makoto, who had now bloomed into an attractive guy everyone in the district wanted to sleep with. Makoto's casual sexual relationship with many young men in the district kinda drives Shouta crazy, but maybe... Just maybe Makoto still saves some of his innocence for the guy who hadn't been home for 7 years.   01KGA5ZS5GT7567ET2YKKYQH9M 1.0 2019-05-28T07:00:00.000Z MediBang LAB_2YZM2CTQ9JPG GEO_1PKAG51AEAQG Stories from the Shopping District, Chapter 1 (C)Sanba Maekawa/TORICO   2019-05-28T07:00:00.000Z   0 0
PRD_24NTTW0A0JYG CNT_35N6248BW750 Stories from the Shopping District CNT_1TKWJM97XD70   3 1 1 Chapter 5 []   Stories from the Shopping District, Chapter 5   After working as a chef in Italy, Shouta comes back to his old neighborhood in Japan to help out his family's restaurant. Upon returning, he is also reunited with his childhood friend, Makoto, who is now the local grocer to all the restaurants in the shopping district. But as it turns out, Makoto is providing more than just produce. The once teary-eyed and weak kid is now the backbone of this shopping district and "helping out" the restaurateurs by satisfying their libidos. And quite frankly, Shouta doesn't know what do with this information. It also doesn't help that he found out about it when he walks in on Makoto and the local butcher...   01KG9DBXPNY8HEZQ56E1V5CVY6 5.0 2020-11-17T08:00:00.000Z MediBang LAB_2YZM2CTQ9JPG GEO_1PKAG51AEAQG Stories from the Shopping District, Chapter 5 (C)Sanba Maekawa/TORICO   2020-11-17T08:00:00.000Z   0 0
PRD_3HHZ2XRG55TG CNT_2YSHZ7SNS0V0 Stories from the Shopping District CNT_1TKWJM97XD70   3 1 1 Chapter 4 []   Stories from the Shopping District, Chapter 4   After hearing about his father's hospitalization, Shouta decided to leave his Pastaio job in Italy and inherit his family Western cuisine restaurant in Hurubita Shopping District. Not much has changed in the district, except probably his-used-to-be-innocent childhood friend, Makoto, who had now bloomed into an attractive guy everyone in the district wanted to sleep with. Makoto's casual sexual relationship with many young men in the district kinda drives Shouta crazy, but maybe... Just maybe Makoto still saves some of his innocence for the guy who hadn't been home for 7 years.   01KGA6Z9NDSNQMQ553S8PED642 4.0 2019-05-28T07:00:00.000Z MediBang LAB_2YZM2CTQ9JPG GEO_1PKAG51AEAQG Stories from the Shopping District, Chapter 4 (C)Sanba Maekawa/TORICO   2019-05-28T07:00:00.000Z   0 0
PRD_3M6EDGTT14SG CNT_0Y4EYHFY4040 Stories from the Shopping District CNT_1TKWJM97XD70   3 1 1 Chapter 2 []   Stories from the Shopping District, Chapter 2   After hearing about his father's hospitalization, Shouta decided to leave his Pastaio job in Italy and inherit his family Western cuisine restaurant in Hurubita Shopping District. Not much has changed in the district, except probably his-used-to-be-innocent childhood friend, Makoto, who had now bloomed into an attractive guy everyone in the district wanted to sleep with. Makoto's casual sexual relationship with many young men in the district kinda drives Shouta crazy, but maybe... Just maybe Makoto still saves some of his innocence for the guy who hadn't been home for 7 years.   01KGA6Z8QX8FCEB2RMYD0FJMSX 2.0 2019-05-28T07:00:00.000Z MediBang LAB_2YZM2CTQ9JPG GEO_1PKAG51AEAQG Stories from the Shopping District, Chapter 2 (C)Sanba Maekawa/TORICO   2019-05-28T07: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);
Powered by Datasette · Queries took 21.653ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS