products

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

3 rows where series_id = "CNT_0FKSD2BGAMR0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_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_19AV37ZVH5BG CNT_2WCQX2CNMJJ0 Durarara!! Yellow Scarves Arc CNT_0FKSD2BGAMR0 CNT_0FKSD2BGAMR0 2 1 1 Volume 2 []   Durarara!! Yellow Scarves Arc, Vol. 2   <P> The Yellow Scarves are threatened when an unknown individual infiltrates their hideout. Just when the Yellow Scarves have their quarry cornered, the Headless Rider, urban legend of Ikebukuro, comes to her rescue. The incident leaves the entire neighborhood unsettled once again, and the resulting turmoil forces Masaomi Kida, leader of the Yellow Scarves, to come face-to-face with the painful past from which he once fled... </P>   01KGAK8PP18YSSSG507AXX1HHP 2.0 2022-08-05T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1HZ7XSH80VJG Durarara!! Yellow Scarves Arc, Vol. 2     2022-08-30T00:00:00.000Z   0 0
PRD_3FJ3NGERZ5V0 CNT_3W2EDB7SX23G Durarara!! Yellow Scarves Arc CNT_0FKSD2BGAMR0 CNT_0FKSD2BGAMR0 2 1 1 Volume 1 []   Durarara!! Yellow Scarves Arc, Vol. 1   <P> The serial slashings in Ikebukuro have come to an end, and Anri is steadily recovering from her injuries. But life is far from &quot;back to normal&quot; for Kida. Enraged at the random violence that has shattered the peace of his neighborhood, Kida and his middle school crew, the Yellow Scarves, reunite to address the rise of organized gangs in town-the Dollars, the followers of Saika, and now the Yellow Scarves. When all is said and done, who will hold the power on the streets of Ikebukuro? </P>   01KGAJWBFRJAWX98QRNVGQ5EFC 1.0 2022-08-05T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1HZ7XSH80VJG Durarara!! Yellow Scarves Arc, Vol. 1     2022-08-30T00:00:00.000Z   0 0
PRD_3MFMT12SR3G0 CNT_0JKA38NMN06G Durarara!! Yellow Scarves Arc CNT_0FKSD2BGAMR0 CNT_0FKSD2BGAMR0 2 1 1 Volume 3 []   Durarara!! Yellow Scarves Arc, Vol. 3   <P> &quot;That&#39;s why I&#39;m Here.&quot; </P><P> To face the past and protect the present, Masaomi Kida, leader of the Yellow Scarves, heads to Izaya&#39;s apartment. His intention is to discover the true identity of the leader of the Dollars, but what he finds shocks him to his core! When the Yellow Scarves, the Dollars, and the followers of Saika all gather in one place, three best friends must confront the greatest challenge to their friendship... </P>   01KGB1GY410VJTH8FKXFQ3PJ6F 3.0 2022-08-10T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1HZ7XSH80VJG Durarara!! Yellow Scarves Arc, Vol. 3     2022-08-30T00: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);