database: products: 8 rows where series_id = "CNT

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

8 rows where series_id = "CNT_2EXCYA92A3R0"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	image_id	display_order	listed_at	label_id	geoblock_id	display_name	on_sale_at
PRD_05MRWRGW2FPG	CNT_0XGP1N2CSHXG	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 1	[]	Scum's Wish, Vol. 1	Mugi and Hanabi are the perfect high school couple...but their relationship is built on a single shared secret: They're each in love with someone else.	01KG98HCSHTV7BKBBDYVT716EX	1.0	2016-10-25T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 1	2016-10-25T15:00:00.000Z
PRD_1680Z901YJRG	CNT_3HTF80CG5XZG	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 7	[]	Scum's Wish, Vol. 7	After Hanabi is heartbroken, she goes to Karuizawa with Ebato. This journey is guiding the two towards an end to their relationship. Elsewhere, even after Mugi conveyed all of his feelings to Akane, the free spirited girl didn't reply in kind. Who is the one that holds the keys to her heart?	01KGA3ESBJK2NHK3KAHFMA2B1D	7.0	2018-05-22T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 7	2018-05-22T07:00:00.000Z
PRD_1P2CKS2BF790	CNT_2V3CZ1CZGH40	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 4	[]	Scum's Wish, Vol. 4	After seeing Akane's true self, Hanabi makes a decision. For want of the one she loves, a convenient substitute presents a warmth she cannot resist. Love and desire intertwine, and the red string of fate is lost in the tangle...	01KG9Z785BD7YDET7NB8WSRXNQ	4.0	2017-07-24T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 4	2017-07-24T15:00:00.000Z
PRD_2G61Q2DED8XG	CNT_1VV52EC0JHGG	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 5	[]	Scum's Wish, Vol. 5	Twisted love causes problems. Hanabi and Mugi are supposed to be dating, but Ebato's love confession has confused Hanabi. Moka's love for Mugi is still unrequited, a painful thorn hiding beneath the blossoms of love. As all around them people are changing their shape, will their feelings change also...?	01KG9VSHY03GY52SA456GQ2T94	5.0	2017-11-07T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 5	2017-11-07T08:00:00.000Z
PRD_2MD60G0RBR70	CNT_14PHG589Y400	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 6	[]	Scum's Wish, Vol. 6	Hanabi has decided to confess. Mugi is confronted with Moka's feelings. Ebato still pines after Hanabi. They want to go forward, they want to stop, they want it all to end...or do they? It's not uncommon to be a coward when it comes to love.	01KGA1DMM7DC5H9SBDBVZXG395	6.0	2018-02-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 6	2018-02-27T08:00:00.000Z
PRD_30SJKTNZCK8G	CNT_138YM99R8RAG	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 8	[]	Scum's Wish, Vol. 8	Can one person change another...? When someone says it's impossible, is that only because they failed...? But people never stay the same, no matter how much you may love them the way they are. As new lives open up for those around them, Hanabi and Mugi must pick up the pieces of their shattered hopes. When they finally find a way to walk forward, will it be hand in hand or...?	01KGA4ZVH2N8YM7SQT76EG2MRB	8.0	2018-08-21T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 8	2018-08-21T07:00:00.000Z
PRD_34WKTGFEVFEG	CNT_3Y2V4KFE8JNG	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 2	[]	Scum's Wish, Vol. 2	Mugi and Hanabi are in a relationship in spite of (and because) they're in love with other people. As this deception continues, are they going to hurt the ones they care for most?	01KG9YV97WWCQ83Z5N44BPX9XC	2.0	2017-01-26T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 2	2017-01-26T15:00:00.000Z
PRD_3FBHZHH3XBY0	CNT_18PPHBPDE4Q0	Scum's Wish CNT_2EXCYA92A3R0	CNT_2EXCYA92A3R0	2	1	1	Volume 3	[]	Scum's Wish, Vol. 3	Mugi and Hanabi's faux relationship continues, with the players secure in the knowledge that their true feelings lie elsewhere. When the objects of their affections begin crafting a new story, though, what will be the fallout?	01KG9Z0DRTR8GAACCNP2XVWJKP	3.0	2017-04-17T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PQM5BDYSMG0	Scum's Wish, Vol. 3	2017-04-17T15:00:00.000Z

Advanced export

JSON shape: default, array, newline-delimited, object

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);