products

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

4 rows where series_id = "CNT_17554714ZK3G"

✎ 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_1ANXZA6PJQ3G CNT_20XFKXGYFGJG Evergreen CNT_17554714ZK3G CNT_17554714ZK3G 2 1 1 Volume 1 []   Evergreen Vol. 1   Born with a congenital heart disease, and thus unable to join in activities that are too physical, Manga Club Captain Yoshimatsu Hotaka can only watch through the club room's window whenever the school swim team practices. Hotaka is enamored with swimming ace, Awaya Niki. But sickly, shy and extremely introverted, he feels all he can do is pine for her from afar. Seeing her as a sort of Goddess of Summer, he feels he isn't even worthy to share the same air with Niki, much less approach her. But when the gym teacher asks Hotaka to attend a special, after-school swim class to make up for not participating during regular classes-a supposed to be one-on-one student teacher session which the swim team unexpectedly crashes-it sets into motion events that may, quite surprisingly, result into Hotaka and Niki actually becoming friends. JUST ADD WATER 01KG9VF58WANNQ7CD3T4F7Q7P0 1.0 2017-10-01T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Evergreen Vol. 1 (C) Akira Caskabe / Yuko Takemiya 2012   2017-10-12T07:00:00.000Z   0 0
PRD_1DRWNG22TN1G CNT_23J9JTVF8EWG Evergreen CNT_17554714ZK3G CNT_17554714ZK3G 2 1 1 Volume 4 []   Evergreen Vol. 4   A brainy manga club captain and a beautiful swim club's ace seem like an improbable match. Yet despite their differences, Hotaka and Niki find that they have deep feelings for each other. Short after Niki's confession, the two excitedly set their first date. They agree to go to a summer festival together. But shocking revelations about Niki's true identity will drastically affect their relationship, in this heart-wrenching conclusion to the Evergreen series. TO YOU, I GIVE ETERNITY 01KG9VRKECPFSFRCZJTQZSDY5G 4.0 2017-10-01T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Evergreen Vol. 4 (C) Akira Caskabe / Yuko Takemiya 2015   2017-10-12T07:00:00.000Z   0 0
PRD_3QRN92A2ETEG CNT_0R4RSKABS47G Evergreen CNT_17554714ZK3G CNT_17554714ZK3G 2 1 1 Volume 2 []   Evergreen Vol. 2   The rumors of Awaya Niki befriending Yoshimatsu Hotaka as a way to get closer to the class hunk, Soga Shunsuke, have reached Hotaka himself. Inclined to believe the worst, Hotaka prepares to accept his pathetic lot in life. But a magical moment under the rain reveals the joyful truth: Niki is not using him and really, truly wants to be friends with Hotaka. Just as Hotaka is starting to think that life is beautiful, his two best friends, Soga and On-chan go at it in a very public confrontation that ends with one storming out and the other reduced to tears. Amidst all the conflict, Awaya Niki suddenly decides to break off her friendship with Hotaka without offering any explanation or reason. Love hurts! SUMMER SUCKS! 01KG9VR6T8T94A24W7RPYYSEWM 2.0 2017-10-01T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Evergreen Vol. 2 (C) Akira Caskabe / Yuko Takemiya 2013   2017-10-12T07:00:00.000Z   0 0
PRD_3X9A9VR5C9E0 CNT_1EKF0Z99F370 Evergreen CNT_17554714ZK3G CNT_17554714ZK3G 2 1 1 Volume 3 []   Evergreen Vol. 3   Hotaka is at his wits' end. Suddenly, improbably, he is befriended by Awaya Niki--the smoking queen of the swim team. But just as abruptly, she decides to drop out of his life without a warning. Though confounded and frustrated at first, Hotaka has resolved, by hook or by crook, to get an explanation on why Niki is avoiding him. But how is he to do that when she doesn't answer his texts or his invitations to meet up and talk? HOT AND COLD. SUN AND RAIN. 01KG9VRRNKBD5K1HSQVN01SWWR 3.0 2017-10-01T15:00:00.000Z Seven Seas Entertainment LAB_1WABW2X3770G GEO_1PQM5BDYSMG0 Evergreen Vol. 3 (C) Akira Caskabe / Yuko Takemiya 2014   2017-10-12T07: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);