products

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

4 rows where series_id = "CNT_3X3TTSHXCKP0"

✎ 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_00DC5TASS860 CNT_3E4MBX8183DG Servant x Service CNT_3X3TTSHXCKP0 CNT_3X3TTSHXCKP0 2 1 1 Volume 1 []   Servant x Service, Vol. 1   On any given day in a certain city, in a certain public services office building down in the Health and Welfare Department, you just might run into a clerk with a tongue twister of a name, a huge flirt, a bundle of insecurity, and a cosplay maniac?!   01KG6ZFP2VTQSBRXMP0ZP9JFWE 1.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Servant x Service, Vol. 1     2016-06-30T15:00:00.000Z   0 0
PRD_0E6YDK08DNB0 CNT_104BA4ATH08G Servant x Service CNT_3X3TTSHXCKP0 CNT_3X3TTSHXCKP0 2 1 1 Volume 2 []   Servant x Service, Vol. 2   Office romance is afoot! Hasebe has his sights set on Lucy, but she's not too eager to get close to the office "playboy" her co-workers have been warning her about... Ichimiya and Chihaya are already an item......or are they really?? And it seems one of the office's patrons has a grandson all lined up for Miyoshi... ......Does any work actually get done around this office...???   01KG95HK48XCTVVNM20HW6RV54 2.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Servant x Service, Vol. 2     2016-06-30T15:00:00.000Z   0 0
PRD_13FVW6QD5ZD0 CNT_142SQTCCZTPG Servant x Service CNT_3X3TTSHXCKP0 CNT_3X3TTSHXCKP0 2 1 1 Volume 3 []   Servant x Service, Vol. 3   The time of reckoning is at hand! Hasebe's scored a proper date with Lucy! Chihaya's ready to come clean about her relationship with Touko's brother! ......But probably none of it's gonna work out quite right, and everybody will be just as confused as they were before......   01KG95HAXGHDJFCJ93XTEZ3X7V 3.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Servant x Service, Vol. 3     2016-06-30T15:00:00.000Z   0 0
PRD_193N4ZC39XJ0 CNT_361GP1D64QHG Servant x Service CNT_3X3TTSHXCKP0 CNT_3X3TTSHXCKP0 2 1 1 Volume 4 []   Servant x Service, Vol. 4   Okay...this time it's for reals! Will Hasebe come clean about the big secret he's been hiding from Lucy?? Will Ichimiya and Touko come clean about the secrets they've been hiding from one another?? Will Chihaya manage to turn Ichimiya into a proper boyfriend?? It's the last volume, people! Make it happen!   01KG95GWZ590EZ7YW2M7M8HM6X 4.0 2016-06-30T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Servant x Service, Vol. 4     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);