products

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

5 rows where series_id = "CNT_0HW0PZJ2GHGG"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: listed_at, on_sale_at, 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_0CJ4M8JEB20G CNT_04ZKQ44ZYN3G Puella Magi Tart Magica CNT_0HW0PZJ2GHGG CNT_0HW0PZJ2GHGG 2 1 1 Volume 3 []   Puella Magi Tart Magica, Vol. 3   Taking the full impact of Flèche's great arrow, Tart's companions rally against the trio of powerful magical girls who are aiding the English forces. Melissa has accepted Cube's offer and become a magical girl herself, but will the addition of one novice be enough to tip the scales in La Pucelle's favor, assuming Tart can survive her injuries?!   01KG985PMQEKF9MJJA2VYAC2QC 3.0 2016-08-18T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Puella Magi Tart Magica, Vol. 3     2016-08-18T15:00:00.000Z   0 0
PRD_1HT80TAVT720 CNT_23G3Y0MYJGK0 Puella Magi Tart Magica CNT_0HW0PZJ2GHGG CNT_0HW0PZJ2GHGG 2 1 1 Volume 4 []   Puella Magi Tart Magica, Vol. 4   Fresh from victory at Orléans, the French forces rush to crown Dauphin Charles at Riems. The road soon leads them to Patay, where they will face their most challenging battle yet. The English and French magical-girl battle royal takes a turn for the worst when one of them becomes a witch! Does Tart's tale of hope end here...?   01KG9VQ31XX12MQV4FQZAPH1PC 4.0 2017-09-19T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Puella Magi Tart Magica, Vol. 4     2017-09-19T15:00:00.000Z   0 0
PRD_1K0Q7VFGQ17G CNT_24A0PQS8DMCG Puella Magi Tart Magica CNT_0HW0PZJ2GHGG CNT_0HW0PZJ2GHGG 2 1 1 Volume 1 []   Puella Magi Tart Magica, Vol. 1   Joan of Arc is revered as a hero of the Hundred Years' War and a saint of the Catholic church. But her leadership and strength of character in her time did not escape the notice of Kyubey, who, even in the fifteenth century, sought magical girl candidates for their valuable energies. With her friends and fellow magical girls fighting at her side, Joan fights the English occupiers of France--but will she soon find herself fighting something much more sinister?!   01KG6ZHB6XFAZ2CX6XJFFXA9ZR 1.0 2016-08-18T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Puella Magi Tart Magica, Vol. 1     2016-08-18T15:00:00.000Z   0 0
PRD_38C69GFV7G7G CNT_02ZJAQ0S19YG Puella Magi Tart Magica CNT_0HW0PZJ2GHGG CNT_0HW0PZJ2GHGG 2 1 1 Volume 5 []   Puella Magi Tart Magica, Vol. 5   The magical girls continue their conflicts across the French countryside in this fifth installment of the Tart Magica series!   01KG9VVJYJSDDWMHDA5Q1BG3M5 5.0 2017-11-14T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Puella Magi Tart Magica, Vol. 5     2017-11-14T08:00:00.000Z   0 0
PRD_3JVFEJWK92G0 CNT_14NA7EY474K0 Puella Magi Tart Magica CNT_0HW0PZJ2GHGG CNT_0HW0PZJ2GHGG 2 1 1 Volume 2 []   Puella Magi Tart Magica, Vol. 2   Tart presses onward in her quest to reach the Dauphin, the disinherited heir of France, and help restore him to the throne and thus her country to a state of peace. Her reputation as a fearless warrior and bringer of light has drawn loyal supporters who would stand and fight against England and the Duke of Burgundy. Tart's power grows, both as a beacon of hope and as a magical girl, but a country girl cannot hope to wield such power without facing opposition and consequences...   01KG985P5CVBR4T2M7T6V3QWDH 2.0 2016-08-18T15:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1PQM5BDYSMG0 Puella Magi Tart Magica, Vol. 2     2016-08-18T15: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);