products

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

15 rows where series_id = "CNT_1AQB3WZYQJX0"

✎ 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_04B9J7MBVWKG CNT_2W5TF5V6XD80 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 7 []   Silver Spoon, Vol. 7   Thanks to Hachiken's meticulous notes, Ezo Ag Fest has gone off without a hitch, even if Hachiken himself didn't get to enjoy any of it. No one even saved him a slice of oven-baked pizza!! His parents' visit to the hospital has left Hachiken doubting himself and his choice to attend Ezo Ag once again, but hearing stories of how the festival visitors left with newfound appreciation for horses and the farming community reminds Hachiken why Ezo Ag- and so many of the people there-have become so dear to him...   01KGA8JWYJ392C7F7KAFPDGB7M 7.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 7     2020-02-07T08:00:00.000Z   0 0
PRD_08SRXTPE7VJG CNT_0ZFQEQHF8C90 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 3 []   Silver Spoon, Vol. 3   A few weeks into his summer job at Mikage Ranch, Hachiken has proven himself a hard worker, even under the skeptical gaze of Aki's father. His first term at Ezo AG has given him a great deal to think about-the future, the fate of Pork Bowl-but open pastures and fresh air provide a very different backdrop to his worries than his previous life in the city. Still, when he chose not to go home for summer break, Hachiken hardly expected home to come to him!   01KGA8JT4M7FS4R9CESK9MRDA3 3.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 3     2020-02-07T08:00:00.000Z   0 0
PRD_0FEBFDKG3THG CNT_2YT4E17QQBA0 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 9 []   Silver Spoon, Vol. 9   With no goals of his own, Hachiken is devoted to helping his friends—especially Mikage—achieve theirs. To prepare her for the college entrance exams as promised, Hachiken swallows his pride and calls in a ringer: Tokyo U dropout and academic genius Shingo Hachiken. But collecting his brother’s old notes means returning home for the first time since he started high school…Has everything he’s learned at Ezo Ag readied him enough to face his past…?   01KGA8JRPDZZKEYYVMNV9XGRJJ 9.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 9     2020-02-07T08:00:00.000Z   0 0
PRD_1KWVT0DTFSGG CNT_0Y4HECW02AB0 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 5 []   Silver Spoon, Vol. 5   The second Ezo Ag cleanup of the year yields a surprise even greater than the first! Once again, Hachiken makes the find that has the whole school talking-and fawning-when he uncovers an abandoned puppy in a rubbish pile. After a bath and blow-dry, the pup takes up residence in the stables as the unofficial mascot of the Equestrian Club. But with all the attention, the new "Vice Prez" threatens to usurp the authority of his master! And no one hates losing more than Hachiken!!   01KGA8JNKXFJ0ZB2NFKFABY54Z 5.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 5     2020-02-07T08:00:00.000Z   0 0
PRD_1N3TQ696M7PG CNT_0GSV988GW8N0 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 11 []   Silver Spoon, Vol. 11   As their second year looms large, the first-years of Ezo Ag are taking a serious look at their future plans. A casual remark about starting a business gives Hachiken a spark of inspiration. He’s already passionate about helping his friends achieve their goals: Could that become his goal? With only a half-formed not-quite-an-idea, Hachiken sets off to create a business plan that will meet not just his father’s strict standards for approval, but also those of his equally fearsome consultant—Tamako!!   01KGA8JK3ZY8CFGSFJQBSG9YM5 11.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 11     2020-02-07T08:00:00.000Z   0 0
PRD_1PDA5KFWBRQG CNT_2HFE9YJ8H9M0 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 2 []   Silver Spoon, Vol. 2   The discovery of a brick oven on campus prompts the only logical response from the students of Ooezo Agricultural High School: a pizza party!!! City-boy Hachiken has been nominated to oversee the process, but he quickly discovers how much work is involved in securing each and every ingredient that goes into making the perfect pizza. United by a common hunger, students from every discipline contribute the necessary flour, cheese, meat, and other toppings. Everyone is waiting expectantly-but can Hachiken deliver?!   01KGA8JMAKY8G12F312ZW8YYY2 2.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 2     2020-02-07T08:00:00.000Z   0 0
PRD_2621SX56XWW0 CNT_1WG3Z302MXRG Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 13 []   Silver Spoon, Vol. 13   As Silver Spoon prepares for its official launch, Hachiken has decided to pay homage to the event that first sparked his passion for bringing people together and showcasing their individual efforts—by throw-ing a massive pizza party! Unlike that memorable first-year food fest, however, the tasters’ reactions will be crucial to creating the most delectable German-style pizza—and setting Silver Spoon on the path to success!   01KGA8JY5BA05DV09KSBSQEVF6 13.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 13     2020-02-18T08:00:00.000Z   0 0
PRD_2910P30K5T20 CNT_1Z5DYRCKEVTG Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 1 []   Silver Spoon, Vol. 1   Defying the expectations of family and teachers, Yuugo Hachiken chooses to leave the city and enroll at Ooezo Agricultural High School. Having always been at the top of his class, Yuugo assumes a rural school will be a breeze, but mucking out stables, gathering eggs, and chasing errant calves takes a lot out of him-and fills him with something he's never experienced before. Surrounded by endless fields and fresh air, Yuugo discovers a new connection to the land and to life...Springtime begins at Ezo AG!!   01KG9BQGNT4HB3AQQGTEQ5GCHH 1.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 1     2020-02-07T08:00:00.000Z   0 0
PRD_2AGG4G78SV30 CNT_3ZTGZEPB3WSG Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 6 []   Silver Spoon, Vol. 6   To connect hearts with partner who cannot speak...and then leap through the air to witness a view never seen before-that is what horseriding is all about...! If it's just as a test, it'll be fine. Except it isn't! With his first equestrian experience happening in competition, the curtain falls on Hachiken's debut. To face off against others is to face oneself.   01KGA8JTZ17ERBYPT7009MYXQ3 6.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 6     2020-02-07T08:00:00.000Z   0 0
PRD_2DQK1P2N1S10 CNT_3YFTYA2VXTVG Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 8 []   Silver Spoon, Vol. 8   Dairy work has been a struggle for Hachiken, but farming may be better than he thought! But real life isn't always fun and games. There are frustrating and challenging times. Through it all, Hachiken strives to stand strong even when it seems everything is falling apart.   01KGA8JQM6B0BR2N4KNNK8T6QV 8.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 8     2020-02-07T08:00:00.000Z   0 0
PRD_2T5CE6WCBDNG CNT_0YEMQP940YP0 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 14 []   Silver Spoon, Vol. 14   November 30 looms large on the horizon—a day that will determine the path of Hachiken’s and Mikage’s futures! With their pasture-raised pork and meticulously selected ingredients, Silver Spoon is ready for their public pizza debut! Creating a good first impression is critical to securing new customers, not to mention certain investors! Meanwhile, Mikage’s preparations (and nerves!) are tested to their limits as she sits for the college entrance exam. If only all the questions could be about horses!!   01KGA8XQ70A8KJYKHHHEK0E8G1 14.0 2020-03-31T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 14     2020-04-28T07:00:00.000Z   0 0
PRD_3G43KAWZDR00 CNT_1HSQSNQ48T4G Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 4 []   Silver Spoon, Vol. 4   By purchasing Pork Bowl, Hachiken takes a step forward in reconciling a farmer's care and concern for livestock that will ultimately be eaten. But Pork Bowl has yielded a whole lot more than a pork bowl's worth-or even a dozen pork bowls' worth!-of meat, and all of Ezo Ag is more than happy to help with the surplus! Hachiken may raise a lot of tough questions, but he sure knows how to make a mean batch of bacon...   01KGA8JMXAE33CMWRZ8N5HC3T7 4.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 4     2020-02-07T08:00:00.000Z   0 0
PRD_3MTJYXY1P770 CNT_3H44S7DCQS5G Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 12 []   Silver Spoon, Vol. 12   Funding continues to be a major obstacle as Hachiken tries to get his business up and running. Ookawa—still unemployed—has pinned all his hopes on Hachiken’s new venture, so when proposal after proposal comes back rejected, he suggests a new source of funding: good, honest hard work. Picking up whatever part-time jobs he can, Hachiken pours every ounce of energy into realizing his goal. The year seems to fly by, but when spring comes again, will his efforts finally blossom into reality?   01KGA8JKPXR4CMPZ1PHJ9N0HDN 12.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 12     2020-02-07T08:00:00.000Z   0 0
PRD_3VBD9GRBJ660 CNT_1GEHRH3N2R6G Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 10 []   Silver Spoon, Vol. 10   Year’s end is traditionally the time when students return home to ring in the new year with their families—the very last thing Hachiken wants to do! He’ll be the only one staying in the dorms, but after all, on a farm, someone always has to stick around to care for the animals. Little does he know that when the students are away, the teachers have their own holiday tradition: a year-end feast of the bounties of Ezo Ag! Happy New Year, indeed!!   01KGA8JH0N1RD23H8HXMMDRT61 10.0 2020-02-04T08:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 10     2020-02-07T08:00:00.000Z   0 0
PRD_3VDCTTXXMH5G CNT_2PVEWK9ZV6E0 Silver Spoon CNT_1AQB3WZYQJX0 CNT_1AQB3WZYQJX0 2 1 1 Volume 15 []   Silver Spoon, Vol. 15   Hachiken’s last-minute decision to apply to Ooezo University of Animal Husbandry has him scrambling to cram as much studying as he can into a few short months! Over the course of his Ezo Ag career, Hachiken has never been one to shy away from hard work, from organizing pizza parties to making festival preparations to starting his own business—not to mention slaving away in service of the livestock! This final push will set Hachiken and Silver Spoon on the path to a successful future!!   01KG9D2CCE0MJZ5HKDCKQ9B8VG 15.0 2020-09-14T07:00:00.000Z Yen Press LAB_0MPN6X9X3ADG GEO_1MXE9VYAYQ0G Silver Spoon, Vol. 15     2020-09-22T07: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);