database: products: 10 rows where series_id = "CNT

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

10 rows where series_id = "CNT_176R9ZVKQ6W0"

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_1Q6T31PXX2VG	CNT_29V3635S6XT0	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 6	[]	Smokin' Parade, Vol. 6	When they were sent to the Jackalopes' northern base, Youkou and Kotoharu had no idea they would be confronted by the most monstrous, massive spider they'd ever encountered. The "Lord," as it has come to be known, has been terrorizing their operatives in the north, leaving countless corpses in its wake. The northerners are way of their southern support, but they will have to learn to trust each other even with their most protected secrets if they want to uncover the provenance of the Lord-and how to kill it...	01KGA75EVBSFBQ3WS8J5X8K9GZ	6.0	2019-08-27T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Smokin' Parade, Vol. 6	2019-08-27T00:00:00.000Z
PRD_1V2VWTRQW5NG	CNT_2KVC5KFEA9YG	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 9	[]	Smokin' Parade, Vol. 9	As Amenotori’s fabricated Spider pandemic grips the globe, the Jackalopes focus on the very heart of the organization. Despite Amenotori’s attention and resources being spread worldwide, however, the organization has reserved an elite force for its defense, pushing the Jackalopes and their new Gears to their limits! And while fighting to expose the truth, one of the Jackalopes’ own must reveal their personal secrets—but what will it mean for the team?	01KGADB60TKVXT0MHW1AG80WTG	9.0	2022-01-18T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Smokin' Parade, Vol. 9	2022-03-22T00:00:00.000Z
PRD_28DT5QMJM910	CNT_2FYJ06ZFHW20	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 1	[]	Smokin' Parade, Vol. 1	Youkou lives in a future where organ transplants are common and available to all, but life's not as idyllic as it seems--it turns out a nefarious organization is using that technology for their own evil ends! Only the elite squad Jackalope has any chance of stopping them before it's too late.	01KG98KJTYV4ZA17KC2NYYFBRR	1.0	2017-02-20T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 1	2017-02-20T15:00:00.000Z
PRD_2DX0CRYYDT6G	CNT_0VR40WH9PD60	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 10	[]	Smokin' Parade, Vol. 10	On a misguided quest to “free” humanity of its inhibitions, the head of Amenotori has initiated a Spider pandemic that threatens to destroy the world. The Jackalopes are on the scene, but as long as the president controls the magatama, he controls the fate of them all. In their final confrontation, Youkou must face both humanity’s greatest threat and the reality of his own past…Will the man or the monster prevail when the smoke of blood clears?!	01KGAGH39D1KSSY94CRPD950Q9	10.0	2022-04-25T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1KB2KYDQ0JGG	Smokin' Parade, Vol. 10	2022-05-24T00:00:00.000Z
PRD_2MRAEGW170N0	CNT_34Y4R8BFHBSG	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 5	[]	Smokin' Parade, Vol. 5	"...Once I realized that, it was all over." In a certain part of the city outskirts, Akuta and Gagara come together without anyone else knowing about it. They grow close, pine for each other, hate each other, and then, finally... The two cogs who will never fit together begin their attempts to kill each other and end it. It's volume five of the grotesque battle action series!	01KGA5NT1RWMC5PX3BPX3ER772	5.0	2019-03-19T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 5	2019-03-19T07:00:00.000Z
PRD_33Z1CWAYH4XG	CNT_1WQT9H8WYXGG	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 2	[]	Smokin' Parade, Vol. 2	Armed with Gears--superpowered battle-ready prosthetics--Youkou has joined the Jackalopes in their fight against the monsters known as "Spiders." Humans transformed as a side effect of their own Amenotori-supplied transplants, the Spiders are becoming more and more active--and destructive. But one distinct group of Spiders, the Shikagura, is more organized than their randomly ruthless brethren, and they're honing in on one particular target...the Jackalopes!	01KG9Z72B5GXHGTS9MP1ECSFN9	2.0	2017-07-17T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 2	2017-07-17T15:00:00.000Z
PRD_39CQ3TQ3KZ70	CNT_3MWWFVX9B430	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 4	[]	Smokin' Parade, Vol. 4	After the Shikagura's deadly attack, the Jackalopes are more driven than ever to flush out the Spiders. The horror of seeing normal humans transformed into monsters is made even more terrible when those people were once friends and loved ones. For Youkou, it is his sister. For Akuta, a friend. And for Midari, now held captive and being tortured by a young boy she once hoped to save, fate has perhaps the cruelest lesson of all...	01KGA3GWAXK79F2E7MN7SC3KCM	4.0	2018-06-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 4	2018-06-26T07:00:00.000Z
PRD_3AFBKM72WPK0	CNT_3PKEA543C79G	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 7	[]	Smokin' Parade, Vol. 7	Unable to join the fight against the Spiders, the children of the Dome have been hitting the books instead! Now Bold Bolt’s smallest members have worked out a strategy for tackling their greatest enemy. Face-to-face with the Lord for the first time, the task has never seemed more impossible, but with the kids’ plan in place, there is real hope for victory! But when truth dawns with the rising sun, Bold Bolt’s familial bonds will be tested like never before…	01KGA7WZAGAS6GM6GYS063G2PZ	7.0	2020-02-25T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 7	2020-03-24T07:00:00.000Z
PRD_3X5X22ANFA50	CNT_3BCWAK614J8G	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 3	[]	Smokin' Parade, Vol. 3	Under Shiba's leadership, the Jackalopes launch a surprise attack against the Amenotori Manufacturing Facility, where the Shikagura are undergoing maintenance. Every one of the Jackalopes' moves has been carefully informed by their intel network, but the Shikagura prove themselves to be even more wily than anyone anticipated! United by bonds stronger than blood, the Spiders have woven a web of crazed malice-and the Jackalopes have walked right into it!!	01KGA18134Q4TDTSQYJ0PH9P1A	3.0	2017-12-19T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 3	2017-12-19T08:00:00.000Z
PRD_3YQFNH8KG5NG	CNT_138GDFBDCSY0	Smokin' Parade CNT_176R9ZVKQ6W0	CNT_176R9ZVKQ6W0	2	1	1	Volume 8	[]	Smokin' Parade, Vol. 8	A new, debilitating illness has brought society to a standstill as nations across the globe scramble to find a cure. But, wonder of wonders, a treatment has just been developed by Amenotori scientists, and the company is distributing the drug worldwide at no cost! Kurama suspects her employer’s benevolence masks an insidious plot, and the Jackalopes are inclined to agree! Brother and sister must reunite to curb the infection—before it’s too late!	01KG9CXMRR2KZX0XQ8XKP52BZH	8.0	2020-07-31T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Smokin' Parade, Vol. 8	2020-08-25T07: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);