database: products: 11 rows where series_id = "CNT

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

11 rows where series_id = "CNT_3JBX60AHH9R0"

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_06X7NGWBDK10	CNT_3YHDCR428P20	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 3	[]	Log Horizon: The West Wind Brigade, Vol. 3	The West Wind Brigade, a guild trapped in an online game, continues its adventures! A group of evil player killers is disrupting the peace, so it's the Brigade to the rescue--but awaiting them is a sinister trap. Guild master Soujirou must rise to the challenge (if only for the sake of the beautiful ladies in his guild)!	01KG9850J80FB9E94K04BWJDQJ	3.0	2016-08-18T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 3	2016-08-18T15:00:00.000Z
PRD_086Y6AATVGG0	CNT_11AJ95PSNJK0	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 4	[]	Log Horizon: The West Wind Brigade, Vol. 4	Trapped in the game world of Elder Tales, Soujirou and the fetching lasses of the West Wind Brigade are getting tired of the tasteless food. However, with the sudden appearance of a burger joint, it seems the bland monotony may be at an end--but the quest for the secret to tasty burgers is not going to be as easy as they'd like!	01KG9892CF1YSPTSMW80BCX0QK	4.0	2016-11-14T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 4	2016-11-14T15:00:00.000Z
PRD_0RYMX1NWXSMG	CNT_21JV175A6DYG	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 9	[]	Log Horizon: The West Wind Brigade, Vol. 9	After a thief known as the Equipment Hunter suddenly appears in the city of Akiba and attacks people, making off with some weapons and armor, the chase begins for the members of the West Wind Brigade! Soujirou comes along for the ride, along with a mysterious person who looks just like him...!? But there's no time to ask questions-the Knights of the Black Sword have arrived, and an all-out war is about to begin!	01KGA3HJRANFKVFPC5PG8FVNGP	9.0	2018-07-24T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 9	2018-07-24T07:00:00.000Z
PRD_1DV37MSWERM0	CNT_00DF6975NJZG	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 2	[]	Log Horizon: The West Wind Brigade, Vol. 2	A disastrous expansion of the online RPG Elder Tales has trapped thousands of players inside the game world--among them, the members of a guild known as the West Wind Brigade. As PKs run rampant and suspicious shadows engage in clandestine tactics, Soujirou makes a resolution...!	01K5G9XHMKSNFWR5YNJCRMGH97	2.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 2	2016-06-30T15:00:00.000Z
PRD_2CKN0M5WMVRG	CNT_0CPZDD1EV750	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 11	[]	Log Horizon: The West Wind Brigade, Vol. 11	After an unforeseen counterattack from the Equipment Hunter, Soujirou finds himself in a pinch! He is not alone, though, as the revived Kuroe comes to his rescue, backed up by the power of all their friends. As this battle to the death comes to a close, what will Soujirou and the West Wind Brigade lose...and what will they gain?	01KGA5P0DS72484VEA9ZTZA7DS	11.0	2019-03-26T07:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 11	2019-03-26T07:00:00.000Z
PRD_2G6M158FHVG0	CNT_3RPTHYSPYNKG	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 1	[]	Log Horizon: The West Wind Brigade, Vol. 1	The beautiful harem guild fights bravely!! In the online RPG world of Elder Tales, the West Wind Brigade is renowned among players for its skills, strength, and...gorgeous members! But when a disastrous expansion Pack traps thousands of players inside the game world, it's up to guild master Soujirou to keep his friends safe-from man and beast alike!!	01KG94JQYTFQKTM8ZEXFCJG89G	1.0	2016-06-30T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 1	2016-06-30T15:00:00.000Z
PRD_2Z5D6XZXSVS0	CNT_21Y43WTYVZS0	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 10	[]	Log Horizon: The West Wind Brigade, Vol. 10	The Equipment Hunter returns with his sights set on one thing - Kuroe. But no way is Soujirou going to let him take her! With the Equipment Hunter's natural enemy in tow, Soujirou and the West Wind Brigade are gonna give it all they've got in this second fight to the death!	01KGA5EM837C2Y4M0HZ6NPGA0J	10.0	2018-11-13T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 10	2018-11-13T08:00:00.000Z
PRD_31AAB98394W0	CNT_2MT7KRJCMDH0	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 7	[]	Log Horizon: The West Wind Brigade, Vol. 7	Soujirou is conducting special training in hopes of acquiring power from outside the system. However, right about then, an army of more than ten thousand Goblins appears on the Zantleaf Peninsula! In the face of this unprecedented situation, the West Wind Brigade musters its best fighters and sets off to guard the Ancient Court of Eternal Ice, where the nobles are assembled!	01KG9VWEVEQRC1M29NPZ0YSXA1	7.0	2017-11-21T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 7	2017-11-21T08:00:00.000Z
PRD_38GC6ER4SWJG	CNT_23241NCCGQNG	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 8	[]	Log Horizon: The West Wind Brigade, Vol. 8	A mysterious Person of the Earth maneuvers covertly in the shadows of the capture of the difficult quest, The Return of the Goblin King. Does he hold the secret to the Adventurers' resurrection?! Soujirou clashes with an eerie, formidable enemy with powers that surpass the common sense of the game! As sparks fly, how will the battle play out?!	01KGA1DRMJR4MTPMBXC9KC4XXR	8.0	2018-02-27T08:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 8	2018-02-27T08:00:00.000Z
PRD_3A7A9W50CHFG	CNT_2V8E862HGB6G	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 6	[]	Log Horizon: The West Wind Brigade, Vol. 6	An unforeseen crisis menaces the town of Akiba! When the west wind brigade assumes responsibility for the round table council's general affairs, Kurinon--driven by her obsession with girls--maneuvers secretly in the shadows. Her goal? To discredit Soujirou and create a female utopia! (It's somehow worse than it sounds...)	01KG9ZASDT37PZRNEX6RPV6XDS	6.0	2017-08-21T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 6	2017-08-21T15:00:00.000Z
PRD_3Q6D499JSQCG	CNT_2YWSFJQ01H1G	Log Horizon: The West Wind Brigade CNT_3JBX60AHH9R0	CNT_3JBX60AHH9R0	2	1	1	Volume 5	[]	Log Horizon: The West Wind Brigade, Vol. 5	Top guild masters gather in response to a summons from Machiavelli-with-glasses, Shiroe! At an ultra-important conference to determine the fate of the people trapped in the world of an online game, what will Soujirou, the West Wind Brigade guild master, do?!	01KG9Z2T01VHY9SP4K02SVKR6M	5.0	2017-05-22T15:00:00.000Z	Yen Press LAB_0MPN6X9X3ADG	GEO_1PTQTSR31PRG	Log Horizon: The West Wind Brigade, Vol. 5	2017-05-22T15: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);