BookWalker

home / database

products

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

27 rows where series_id = "CNT_3JBT7VHDQBTG"

✎ 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_056RM35R642G CNT_3Q4NTDBAM68G Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 24 []   Claymore, Vol. 24   Priscilla, whose monstrous savagery was reawakened in the previous battle, is bent on absorbing the power of those who fell in her wake and destroying the rebel Claymores. Raki and several former top warriors band together with a defensive plan, but even their skills may be no match against Priscilla's poisoned wrath. Meanwhile, the terrifying Yoma-based creature coalescing outside of the holy city of Rabona may seek to defeat Priscilla...but it may also be seeking the defeat of the rebel warriors!   01KGBDW2DY2TFM9HFSX9XMTHJ1 24.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 24 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_06G8AGBNT53G CNT_1QTRT3N297FG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 25 []   Claymore, Vol. 25   Three battles unfold around the holy city of Rabona as demonic forces seek to destroy one another, the rebel Claymores and the city itself. Seemingly intent on devouring all life, monsters of unprecedented strength rage on as the rebels struggle to contain them. Could the cause of this rage lie in a distant childhood memory?   01KGBDW44PARSSPNKAKF1T1JCT 25.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 25 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_06MTJHK10K10 CNT_33B9JYRXR590 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 1 []   Claymore, Vol. 1   A village is gripped by fear and paranoia when a Yoma claims six lives. The Claymore who is sent to slay the creature isn't what the villagers expect at all. In fact, she seems more monster than human.   01KGBD46349C2MN8DHF15FSTPR 1.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 1 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_09QB7P72231G CNT_1PF35Z1K359G Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 17 []   Claymore, Vol. 17   With the balance of power broken after Isley's defeat by the ferocious Abyss Feeders, the Organization, central hub of the Claymores, deploys Alicia and Beth to the West to go after the renegade Riful. In turn, Riful continues her scheme to Awaken the remains of the powerful Rafaela. As these dire powers all finally collide, Clare and her comrades must fight for their lives in the titanic battle that ensues.   01KGBDW1FHN4Q4R2J1ZB4KD1R5 17.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 17 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_0C5VH914E20G CNT_09SG5AQVE4AG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 15 []   Claymore, Vol. 15   Galatea's plans to eliminate the Awakened former number 2, "Bloody" Agatha, have failed, but the arrival of Clare and her comrades turns the tide of battle. In the aftermath, Miria decides to finally share her shocking discoveries about the true nature of the Yoma, of the Organization and of the Claymores themselves.   01KGBDW0F6QZMX1YHGWRSANZMK 15.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 15 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_0MBXF38J7BT0 CNT_07040FW52D00 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 11 []   Claymore, Vol. 11   In the northern town of Pieta, Clare and a force of Claymores battle a troupe of Awakened Ones to prevent them from advancing south. Their orders are to hold off the evil horde at all costs, while the Organization prepares a secret weapon. Clare and her comrades realize that theirs is a suicide mission. As their friends fall one by one, the warriors band together to make their last stand.   01KGBDX5JEE0YBFDWFDYV646TX 11.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 11 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_0MEFQ4GXDSZG CNT_1JGMRAY0NB3G Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 9 []   Claymore, Vol. 9   Clare and her fellow Claymores Galatea and Jean must battle the Awakened Beings that are holding them captive. In the process, they find their captors' true motive: by torturing the warriors, they want to force them to awaken and join them in a gathering of Yoma. Will Clare and her comrades be able to defeat the Awakened Beings without becoming one themselves?   01KGBDW927BQV0V7TWTV1E0K2W 9.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 9 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_0V3BARNJWPW0 CNT_11BJKQP4K8E0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 7 []   Claymore, Vol. 7   Fearing that she's no match for the deadly Claymore named Ophelia, Clare spirits her companion Raki away to relative safety. But no matter how far they run, they won't be able to escape Ophelia's heightened senses. And now that Ophelia knows that Clare has awakened, she will not rest until she has destroyed Clare.   01KGBDVFKD1FYMXBW959HP8NPK 7.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 7 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_12WMP9T6TDBG CNT_2ADH7D35HZQG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 4 []   Claymore, Vol. 4   Teresa, a powerful Claymore, saves a young girl from her bandit captors and leaves the child in the care of some villagers. But triumph quickly gives way to despair when the situation takes a tragic turn, and Teresa is forced to kill a human--an act that will condemn her to death at the hands of her own kind.   01KGBDVS2MJMPMWDGYFKKH363D 4.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 4 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_18G6Y2KNEA8G CNT_0CD81M5YPWJG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 18 []   Claymore, Vol. 18   After finding herself mysteriously drawn to the lair of Riful of the West, Clare made contact with the fused form of Rafaela and Luciela, which Awakened and transformed into the terrible being known as the Destroyer. Now, the entire land of Lautrec is subject to its dreadful, relentless assault. It seems that nothing, and no one, can halt the devastation. But there may be one force that is greater still...   01KGBDVMYJXJHS9RMT357B9AJM 18.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 18 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_1F6H9NDZA9FG CNT_2FQ517T75VKG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 14 []   Claymore, Vol. 14   In their hunt for Galatea, the Organization's former number 3, Clarice and Miata enter the Holy City of Rabona, but what they encounter there is far beyond anything they could have anticipated. Also included in this volume are bonus stories of Priscilla and Isley's first meeting, and of Clare's training at the Organization.   01KGBDVKW62NSA1ZRWKYHG6PZ2 14.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 14 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_20FJR70W2MHG CNT_23NK2NXSKNSG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 2 []   Claymore, Vol. 2   Claire and the orphan Raki travel to the town of Rabona, where a Yoma has been stalking the priests inside the cathedral. The creature could be one of the guards, or even a priest, but this time Claire won't be able to sense its aura. Does she stand a chance against the stealthy Yoma?   01KGBDVC5D6KQ1QJ9D4W25RWCQ 2.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 2 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_24SG3TTTR5K0 CNT_2QFZA4G6FPZ0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 22 []   Claymore, Vol. 22   Rebel Claymores, the Organization that created them, and a host of reanimated top-level warriors clash with savage intensity. The Claymores' demonic impulses are provoked, threatening to destroy their human consciousnesses. Meanwhile, Hysteria, animated by blind vengeance, grows stronger with each attack against her. Is it possible that the rebels will be defeated by their long-dead comrades?   01KGBDW3KP210N6DCYBQN6WSFT 22.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 22 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_24WDBT26EKGG CNT_030027J1YMTG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 19 []   Claymore, Vol. 19   Priscilla relentlessly pursues Clare's destruction, while Deneve and Helen remain just as determined to protect her. But when the combined form of Luciela and Rafaela attacks, Clare and her cohorts are pulled into the twisting mass. Meanwhile, in Rabona, Miria heads east to destroy the Organization. She encounters Rubel and his secret weapons: mysterious warrior twins who may be Alicia and Beth's successors, as well as the Organization's number 10—a deadly fighter who can read Miria's mind.   01KGBDVA9DZTTC42JA5EXCZ1MT 19.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 19 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_2BE3DDMX44J0 CNT_0PTCNP6ETNR0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 23 []   Claymore, Vol. 23   Rebel warrior Miria penetrates the headquarters of the secret Organization that created her, discovering the appalling truth about Yoma. Meanwhile, human warrior Raki joins the Claymores on the battlefield and seems closer than ever to his goal of reuniting with Clare, his Claymore companion. Yet the cycle of violence cannot be stopped—an epic battle is brewing and Priscilla, a powerful force for evil, is back in the fight!   01KGBDW1Z44AT53W2A986AMN4Z 23.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 23 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_2FWKR0P703H0 CNT_2P4SN1WQ9MS0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 16 []   Claymore, Vol. 16   After Miria's incredible revelations about the origins of the Yoma, the seven warriors split up to settle their affairs and say their goodbyes in preparation for the final battle against the Organization. Helen and Deneve fall in with a spirited young warrior of the current generation and soon find themselves confronting the Organization's latest, most terrible weapons.   01KGBDW10QJ670FMR4P35HHZ2P 16.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 16 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_2S8K314QTPKG CNT_21193RH8SQZG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 6 []   Claymore, Vol. 6   Clare and her fellow Claymores are nearing the end of their strength in their battle against the Awakened Being--a male ex-Claymore who can no longer control his Yoma powers. Not only is Clare the weakest among them, but she has taken the brunt of the creature's attacks as well, and yet she may be their only hope in discovering the Awakened Being's weakness.   01KGBDVDVHZT99MG6XZBJ1EKHH 6.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 6 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_2TQP8D32BRF0 CNT_2J6BBKS4VTK0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 10 []   Claymore, Vol. 10   Clare and a group of Claymores are sent to the north to battle a group of Yoma that have banded together under the command of Isley, a powerful Awakened Being. When the warriors arrive, they find their new enemies to be unusually dangerous. They are incredibly strong, well-organized, and seem to have a plan to dominate the entire region. Will the Claymores be able to stop this monstrous army?   01KGBDW8K9XFD1Z85MZZ2302NG 10.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 10 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_2TT0GEBDYPCG CNT_01PW0EV0ARYG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 8 []   Claymore, Vol. 8   Clare's battle with the awakened Ophelia ends with a surprising request from Ophelia. Ominous signs begin to emerge as Clare searches for Raki. Not only are the usually solitary Yoma joining forces, they appear to be preparing for battle. More mysteriously, Clare is taken captive by a male Awakened Being and held in a dungeon with other Claymores. Who are her captors, and what do they want?   01KGBDVG3H4799BXYMZJNB1BKS 8.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 8 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_33120JXRNZNG CNT_1YJ6YMWE4H5G Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 27 []   Claymore, Vol. 27   As rebel warrior Clare prepares to face former Claymore Priscilla in a climactic final battle, she is suddenly transformed by an unprecedented Yoma energy. Priscilla, whose brute and evil power once threatened to overwhelm Clare, is now matched against the reawakened spirit of another former Claymore elite—this one with strength beyond measure and the power of Clare within her!   01KGBDWJDV812ZAPX53Y9H5WRY 27.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 27 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_335Z8J5BRDV0 CNT_3A2QPQY9PF70 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 3 []   Claymore, Vol. 3   Clare's first battle with the Yoma of Rabona has left her body drained and shattered. With no time to recover, she must face the creature again after it chooses Raki as its next victim. Luckily, Raki remembers that he is carrying Clare's trusted broadsword and manages to get it into her hands. But unlike Clare, the Yoma is fighting at full strength and thirsting for blood...   01KGBDVR2D828C77EM4SR56QEA 3.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 3 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_37K0A4QQB0Q0 CNT_22C36BGV0HV0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 26 []   Claymore, Vol. 26   Former Claymores Cassandra and Priscilla appear to be headed toward an epic conflict, as the warriors protecting the Holy City of Rabona attempt to orchestrate a battle between these two savage elements in order to avert complete annihilation. However, when Clare and Raki step in, the Awakened Ones' fury is redirected toward them!   01KGBDXEEQHQY9Z31BCF0DTERE 26.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 26 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3A8Y5R0G0BS0 CNT_3CQHHKATGD10 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 21 []   Claymore, Vol. 21   A battle begins between rebel Claymore warriors and the Organization that created them. When the team of seven notorious rebel fighters is joined by an army of newly minted soldiers loyal to rebel leader Miria, it seems their victory is a foregone conclusion. Then the Organization releases its newest secret weapon: reanimated high-level warriors from past generations of Claymores.   01KGBDVP08NG1QRM96QA91N0A7 21.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 21 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3ESEQB2TCAR0 CNT_1C2EHYZ2ZC20 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 20 []   Claymore, Vol. 20   Rebel Claymores Deneve, Helen and Yuma return to the Holy City of Rabona and find it under attack by Yoma hordes. An all-out battle ensues, after which Galatea informs the recently returned Claymores about Miria's solitary and likely doomed quest to bring down the Organization. As Helen and Deneve investigate in separate assays, it becomes clear that the Organization is creating novel and terrifying breeds of Yoma warriors. Meanwhile, Miria returns with an ominous scar on her forehead.   01KGBDVMED7ZX4JX18MW4PDDKE 20.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 20 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3JD2BKG9C2G0 CNT_19EPMKJZMKT0 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 13 []   Claymore, Vol. 13   Audrey and Rachel continue their battle against Riful of the West, and Clare learns some surprising truths about Priscilla, Isley and the struggle for power amongst the Three Great Awakened Ones. Meanwhile, the Organization decides to send Miata and Clarice out on an important mission, but will Clarice be able to keep her unstable young charge in line?   01KGBDVYH98CZQC034C5DRYM87 13.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 13 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3PZ0D5A05KHG CNT_1X8JW25CGMSG Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 12 []   Claymore, Vol. 12   Seven years have passed since the devastating battle in Pieta, and now a new generation of warriors carries on the fight against the Awakened Ones. However, the mystery of Clare's fate, and that of her comrades, resurfaces after a surprising discovery made by a young Claymore.   01KGBDWQR82NVZQ1VTWF2X3E46 12.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 12 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08:00:00.000Z   0 0
PRD_3WQCXZB1WEM0 CNT_1ARTQ4818G60 Claymore CNT_3JBT7VHDQBTG CNT_3JBT7VHDQBTG 2 1 1 Volume 5 []   Claymore, Vol. 5   The Claymore warrior Teresa has broken the cardinal rule that forbids her kind from killing humans. In time, a group of Claymores comes to kill her, and yet Teresa defeats them all with her superior skill and experience. But rather than slay the powerful ringleader, Teresa decides to spare her instead--an act of human weakness that will have devastating consequences for them all.   01KGBDVSMHYEF593HV8T40E1FG 5.0 2024-11-26T08:00:00.000Z VIZ Media LAB_15X2T7H1V07G GEO_1PQM5BDYSMG0 Claymore, Vol. 5 CLAYMORE © 2001 by Norihiro Yagi/SHUEISHA Inc.   2024-11-26T08: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);
Powered by Datasette · Queries took 28.108ms · Data license: BookWalker Data Export License · Data source: BookWalker (ZSTD-compressed Database Export) · Terms of Service: Bookwalker ToS