products

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

3 rows where series_id = "CNT_1377XEBZB270"

✎ View and edit SQL

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_05SEZ5GQ9C8G CNT_1MDCM31XBFBG Thermae Romae CNT_1377XEBZB270 CNT_1377XEBZB270 2 1 1 Volume 2 []   Thermae Romae, Vol. 2   Whenever Roman architect Lucius is suddenly submerged in water, he always surfaces to find himself in the land of the "flat-faces," a people whose appreciation for the public bathhouse matches that of even the mighty Romans! (Little does he realize that the land of his watery journeys is in fact the Japan of 1,500 years in the future!) Observing the strange practices of these foreigners has allowed Lucius to revolutionize the Roman bathhouse, and public opinion on his innovations-and on Aelius Caesar, the emperor-to-be to whom these marvels are attributed-soars. But those in the Senate maintain strong reservations about the suitability of the emperor-to-be, and they mean to cut off the flow of support at its source-Lucius!   01KG9820PKERS1XTZZBJ2XAYGM 2.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1P6A9KWCPCY0 Thermae Romae, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_0Y89ZC3CBX90 CNT_10AJV38X5RAG Thermae Romae CNT_1377XEBZB270 CNT_1377XEBZB270 2 1 1 Volume 3 []   Thermae Romae, Vol. 3   Though he has been trapped in the twenty-first century for several weeks, Lucius is still amazed at the wondrous innovations of the flat-faced people, and meeting Satsuki has given him an even greater understanding of the things he has seen - not to mention an undeniable flutter in his heart. But despite his curiosity for this land, Lucius worries at the amount of time that has passed since he left Rome. The political atmosphere was already tense after the death of the emperor's heir, and Lucius fears what may befall Rome and the ailing Hadrian in his absence. Yet matters are no less precarious in the hot-springs town of Ito. With aggressive developers bullying the established inns, Lucius may be called upon to save the sacred appreciation for the bath both in the past and in the present in this final volume of THERMAE ROMAE!   01KG981CN9GSK0VWMN2T4BK1S8 3.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1P6A9KWCPCY0 Thermae Romae, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_14QBFGNZF6J0 CNT_2YT0RX2DF8H0 Thermae Romae CNT_1377XEBZB270 CNT_1377XEBZB270 2 1 1 Volume 1 []   Thermae Romae, Vol. 1   When Roman architect Lucius is criticized for his "outdated" thermae designs, he retreats to the local bath to collect his thoughts. All Lucius wants is to recapture the Rome of earlier days, when one could enjoy a relaxing bath without the pressure of merchants and roughhousing patrons. Slipping deeper into the warm water, Lucius is suddenly caught in the suction and dragged through the drainage at the bottom of the bath! He emerges coughing and sputtering amid a group of strange-looking foreigners with the most peculiar bathhouse customs...over 1,500 years in the future in modern-day Japan! His contemporaries wanted him to modernize, and so, borrowing the customs of these mysterious bath-loving people, Lucius opens what quickly becomes the most popular new bathhouse in Rome-Thermae Romae!   01KG6ZGCFN4PSHWPCGSJ3902MG 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1P6A9KWCPCY0 Thermae Romae, Vol. 1     2016-06-30T15: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);