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_3AEKKRB25Z10"

descending

id ▼	content_id	series_id	parent_content_id	level	content_type	product_type	title	alt_titles	display_title	description	description_short	image_id	display_order	listed_at	label_id	geoblock_id	display_name	copyright	on_sale_at
PRD_06RHS3ZG6NF0	CNT_27MPSJ6HSRM0	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 2	[]	Lord Marksman and Vanadis Vol. 2	Tigre remains a prisoner of the Vanadis Elen, and his absence is being felt back home. Zion, a nobleman thought to be an ally, has begun an invasion of Tigre's territory in Brune. In order to save his homeland, Tigre must convince Elen to help him. But is the strength of Elen's sword and the accuracy of Tigre's bow enough to win, or are they simply pawns in someone else's game?	TROUBLE AT HOME	01KG98ADWVH8BZ0AYPS7X36E0P	2.0	2016-12-19T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 2	(C) Tsukasa Kawaguchi 2014, (C) Nobuhiko Yanai 2014	2016-12-19T15:00:00.000Z
PRD_0SY4H0B9KZ80	CNT_3ZF6Y8BE5JB0	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 3	[]	Lord Marksman and Vanadis Vol. 3	The “Vanadis” are warrior women who fight with powerful, dragon-hewn weapons. At Zhcted’s royal palace, three of these battle maidens?Sofy, Ludmila, and Elen?reunite. Ludmila and Elen exchange heated words, and it’s up to Sofy to settle the spat. But trouble still lurks, in the form of Elen’s archenemy, Ludmila. Will war erupt between the Wind Princess of Silver Flash and the Snow Princess of Frozen Ripple? Cheer on the battle of these fierce and beautiful warriors!	CLASH OF THE BATTLE MAIDENS	01KG9YXD5X8NSSW92TMRGZN3M7	3.0	2017-03-20T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 3	(C) Tsukasa Kawaguchi 2014, (C) Nobuhiko Yanai 2014	2017-03-20T15:00:00.000Z
PRD_16B4SJTX41N0	CNT_0BB5E23WGCSG	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 10	[]	Lord Marksman and Vanadis Vol. 10	The civil war for Brune rushes towards its climax. Count Tigre's army clashes with the partisans of Duke Thenardier for the succession of an entire country! With the King on his deathbed, Tigre and his war-maiden allies have no time to lose in reaching the capital city. If the monarch should die before recognizing Princess Regin, all the blood spilled in her name will have been for nothing. The Duke stands in fury against them--he hasn't forgotten the death of his son at Tigre's hands, and only blood will sate his wrath! Don't miss the clashing swords and whistling arrows in the final volume of Lord Marksman!	THE LEGEND OF THE KNIGHT OF MOONLIGHT	01KGA5NE7GC6556YB6RT44ZPHK	10.0	2019-02-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 10	Nobuhiko Yanai, Tsukasa Kawaguchi 2016	2019-04-02T07:00:00.000Z
PRD_1GSS6ZVVZ16G	CNT_0K7W28K9YD1G	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 6	[]	Lord Marksman and Vanadis Vol. 6	It’s time for another showdown with Roland, the Black Knight! This time, Elen and Sofy are both up against him--but it's an uphill battle. Is it time for Elen to brandish her Dragon Gear? Meanwhile, the border nation of Muozinel is mobilizing its forces. The target: Brune!	THE CLASH OF BATTLE!	01KGA1AZW979D1043Z4TW4B0NY	6.0	2018-01-08T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 6	(C) Nobuhiko Yanai, Tsukasa Kawaguchi 2014	2018-02-13T08:00:00.000Z
PRD_1GTZFSNEQQZ0	CNT_21RYEYKNRT40	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 1	[]	Lord Marksman and Vanadis Vol. 1	The country of Brune is on the brink of civil war, and their rival Zhcted has seized the opportunity to attack. Tigre, a nobleman, is dispatched to the battlefield where he encounters Elen, one of Zhcted's Vanadis- a group of women who fight with powerful weapons forged from dragons. While Tigre is overwhelmed by Elen's beauty and power, Elen is impressed by his archery skills and declares that he belongs to her! Will Tigre be able to turn the tides of battle or is he now simply the spoils of war?		01KG6ZJF7XDZRZRT9K19N1CS41	1.0	2016-09-13T06:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 1	(C) Tsukasa Kawaguchi 2014, (C) Nobuhiko Yanai 2014	2016-09-13T06:00:00.000Z
PRD_1RKK5YFY2BZG	CNT_2FKVH4SWVMPG	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 5	[]	Lord Marksman and Vanadis Vol. 5	The Silver Meteor Force is in mortal danger! The Black Knight Roland has never been bested, but now Tigre and the war maiden Elen find themselves face-to-face with him in battle. In the aftermath, Tigre must survive both a grave wound and a wily goddess of darkness in order to gain the power to fight another day. The high fantasy epic continues and a magical marksman awakens!	MAIDEN VS. KNIGHT	01KG9ZDSEE8KM0SX2BXZEHCFY7	5.0	2017-10-01T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 5	(C) Tsukasa Kawaguchi 2014, (C) Nobuhiko Yanai 2014	2017-10-12T07:00:00.000Z
PRD_1YGSQ1JGZB5G	CNT_11VYX43NA0DG	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 8	[]	Lord Marksman and Vanadis Vol. 8	After their clash with the armies of Muozinel, Tigre and his companions stand victorious. Yet on the very same night a new threat strikes from the shadows. An inhuman assassin seeks Tigre's head, and he fights with an unnatural strength. Worse yet, Duke Thenardier seals a pact with the same shadowy organization, seeking enough power to vanquish Tigre's Silver Meteor force once and for all!	A KNIFE IN THE DARK	01KGA4V80HD8P9XRTBEAVJBQGQ	8.0	2018-06-25T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 8	Nobuhiko Yanai, Tsukasa Kawaguchi 2015	2018-08-07T07:00:00.000Z
PRD_26XWK74P1D80	CNT_2XP2KAJMVJA0	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 9	[]	Lord Marksman and Vanadis Vol. 9	Duke Thenardier rides to battle, armed with the power of dragons! Outnumbered? and outgunned, Tigre's forces are hard-pressed to stand against the Duke's draconic might. Only the combined power of two war maidens may yet give Tigre a chance to break through, and prove the truth of Princess Reign's royal blood. It's a super-powered team-up when the maidens of frost and gale join hands to slay a rampaging dragon!	BY FANG AND CLAW	01KGA58S2XQZFN11MW5CH702HC	9.0	2018-08-26T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 9	Nobuhiko Yanai, Tsukasa Kawaguchi 2016	2018-12-04T07:00:00.000Z
PRD_3AZQ12YZJMY0	CNT_03VKGKHJ9XQ0	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 4	[]	Lord Marksman and Vanadis Vol. 4	Tigre and Elen's Silver Meteor Force struggles against the scheming dukes, who want to exploit Brune's civil war. Marquis Greast pays Tigre's camp a visit with an offer from Duke Ganelon, but when Tigre refuses, the Meteor Force is thrust into a hard-fought battle. Meanwhile, the Order of Navarre's formidable knight, Roland, is on the hunt for a traitor - the head of the Vom clan, Tigrevurmud!	THE WAR RAGES ON	01KG9Z7VY5PNZKFYZJ9MAE3GX0	4.0	2017-07-19T04:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 4	(C) Tsukasa Kawaguchi 2014, (C) Nobuhiko Yanai 2014	2017-07-19T04:00:00.000Z
PRD_3PPV4SK3P9VG	CNT_05FA6J9B04WG	Lord Marksman and Vanadis CNT_3AEKKRB25Z10	CNT_3AEKKRB25Z10	2	1	1	Volume 7	[]	Lord Marksman and Vanadis Vol. 7	The hosts of Muozinel march on Brune in their thousands, and all that stands in their way is Tigre and his loyal few. Drastically outnumbered, with no War Maidens at his back, Tigre will need every ounce of cunning and valor he can muster if he's to prevail. The survival of Brune is at stake, and Muozinel will show no mercy--not to Tigre, or to the hostages in their thrall!	THE BATTLE FOR BRUNE	01KGA3ACR0E31WVVBRB51Q1Q20	7.0	2018-03-12T15:00:00.000Z	Seven Seas Entertainment LAB_1WABW2X3770G	GEO_1PQM5BDYSMG0	Lord Marksman and Vanadis Vol. 7	Nobuhiko Yanai, Tsukasa Kawaguchi 2015	2018-05-01T07: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);