-- ================================================================
--
-- @version $Id: structure.sql 2011-05-25 10:12:05 gewa $
-- @package Digital Downloads Pro
-- @copyright 2011.
--
-- ================================================================
-- Database data
-- ================================================================

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` (`id`, `name`, `parent_id`, `slug`, `description`, `position`, `metakeys`, `metadesc`, `active`) VALUES
(1, 'Cookbooks', 0, 'Cookbooks', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 1, 'Cookbooks', '', 1),
(14, 'Drama', 2, 'Drama', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 8, 'Drama', '', 1),
(2, 'Fiction', 0, 'Fiction', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 7, 'Fiction', '', 1),
(3, 'Biography', 0, 'Biography', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 12, 'Biography', '', 1),
(13, 'Horor', 2, 'Horor', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 9, 'Horor', '', 1),
(4, 'Vegetarian', 1, 'Vegetarian', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 6, 'Vegetarian', '', 1),
(10, 'Baking', 1, 'Baking', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 2, 'Baking', '', 1),
(5, 'Computers', 0, 'Computers', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 13, 'Computers', '', 1),
(6, 'Home &amp; Garden', 0, 'Home-Garden', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 14, 'Home &amp; Garden', '', 1),
(12, 'Deserts', 1, 'Deserts', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 3, 'Deserts', '', 1),
(7, 'Travel', 0, 'Travel', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 15, 'Travel', '', 1),
(8, 'Westerns', 0, 'Westerns', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 16, 'Westerns', '', 1),
(11, 'Wine &amp; Beverages', 1, 'Wine-Beverages', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 5, 'Wine &amp; Beverages', '', 1),
(15, 'Romance', 2, 'Romance', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 10, 'Romance', '', 1),
(16, 'World Literature', 2, 'World-Literature', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 11, 'World Literature', '', 1),
(17, 'Pies', 12, 'Pies', 'liquam in sapien non sem ultrices luctus. Vestibulum non orci ac nisl egestas ultrices quis eget mauris. Vestibulum commodo lorem eu nisl pellentesque faucibus. Vestibulum a erat nunc, eu cursus tellus.', 4, 'Pies', '', 1);

--
-- Dumping data for table `comments`
--

INSERT INTO `comments` (`id`, `pid`, `username`, `email`, `body`, `www`, `created`, `ip`, `active`) VALUES
(1, 39, 'Webmaster', 'webmaster@wojoscripts.com', 'First comment is on me.', 'http://www.wojoscripts.com', '2011-06-20 16:34:55', '127.0.0.1', 1),
(2, 39, 'Admin', 'webmaster@wojoscripts.com', '<pre>Cum sociis natoque penatibus et <strong>magnis dis parturient</strong> montes, </pre>nascetur ridiculus mus. Nam nec odio nulla. Cras ullamcorper suscipit justo, at mattis odio auctor quis.', '', '2011-06-24 16:34:55', '127.0.0.1', 1),
(3, 39, 'User1', 'user1@mail.com', 'Ut dictum, eros eu blandit pellentesque, nisi nisl dapibus mauris, sed feugiat enim urna sit amet nibh. Suspendisse sed tortor nisi. Nulla facilisi. In sed risus in est cursus ornare.', '', '2011-06-25 16:34:55', '127.0.0.1', 1),
(4, 39, 'User2', 'user2@mail.com', 'Etiam non lacus ac velit <em>lobortis rutrum sed</em> id turpis. <code>Ut dictum, eros eu blandit pellentesque, nisi nisl dapibus mauris,</code>sed feugiat enim urna sit amet nibh. Suspendisse sed tortor nisi. Nulla facilisi. In sed risus in est cursus ornare. Fusce tempor hendrerit commodo.', '', '2011-06-26 16:34:55', '127.0.0.1', 1),
(5, 39, 'User3', 'user3@mail.com', 'In hac habit***e platea dictumst.ivamus leo diam, dignissim eu convallis in, posuere quis magna. Curabitur mollis, lectus sit amet bibendum faucibus, nisi ligula ultricies purus', '', '2011-06-27 16:34:55', '127.0.0.1', 1),
(6, 39, 'User4', 'user4@mail.com', 'Morbi sodales accumsan arcu sed venenatis. Vivamus leo diam, dignissim eu convallis in, posuere quis magna. Curabitur mollis, lectus sit amet bibendum faucibus, nisi ligula ultricies purus, in malesuada arcu sem ut mauris. Proin lobortis rutrum ultrices.', '', '2011-06-30 16:34:55', '127.0.0.1', 0),
(7, 39, 'admin', 'webmaster@wojoscripts.com', 'Ut dictum, eros eu blandit pellentesque, nisi nisl dapibus mauris, sed feugiat enim urna sit amet nibh. Suspendisse sed tortor nisi. Nulla facilisi. In sed risus in est cursus ornare.', 'http://www.wojoscripts.com', '2011-07-25 17:02:24', '127.0.0.1', 1);


--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `title`, `code`, `discount`, `type`, `minval`, `created`, `active`) VALUES
(1, '25% discount on all items', '25off', '25', 0, '150.00', '2011-07-07 08:48:16', 1),
(2, '$10.00 off on all items', '10off', '10', 1, '15.00', '2011-07-07 10:14:18', 1);

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `question`, `answer`, `position`) VALUES
(1, 'Selling Applications', 'DDP is well suited for a range of selling applications and markets.  \nFrom simple single product ebook sites to complete music or software \nstorefronts, DDP has the selling features you need.', 1),
(2, 'Coupon / Discount Codes', 'Coupons can be worth either a fixed value price or a percentage of the cart total.', 2),
(3, 'Download Security Features', 'DDP&#039;s innovative system prevents download link sharing and discovery to prevent unauthorized download of your valuable products.', 3),
(4, 'Sell Downloads with PayPal', 'PayPal is the most popular payment processor in the world with millions of users. DDP supports PayPal transactions using the Website Payments Standard system that requires no additional monthly fees from PayPal. Vendors wishing to use PayPal as their payment processor must have a Business or Premiere PayPal account to use Website Payments Standard with DDP.', 4),
(5, 'Multi-Item Cart', 'DDP&#039;s multi-item checkout, compatible with&amp;nbsp; PayPal, MoneyBookers and AlertPay, offers full shopping cart functionality', 5);

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`id`, `name`, `alias`, `filesize`, `created`, `active`) VALUES
(1, 'testfile1.zip', 'Demo File 1', '19456', '2011-07-21 15:42:11', 1),
(2, 'testfile2.zip', 'Demo File 2', '23552', '2011-07-21 15:42:21', 1),
(3, 'testfile3.zip', 'Demo File 3', '11264', '2011-07-21 15:42:29', 1),
(4, 'testfile4.zip', 'Demo File 4', '7168', '2011-07-21 15:42:37', 1),
(5, 'testfile5.zip', 'Demo File 5', '9216', '2011-07-21 15:42:49', 1),
(6, 'testpdf1.pdf', 'Demo File 6', '19456', '2011-07-21 15:47:18', 1),
(7, 'testpdf2.pdf', 'Demo File 7', '23552', '2011-07-21 15:47:29', 1),
(8, 'testpdf3.pdf', 'Demo File 8', '11264', '2011-07-21 15:47:44', 1),
(9, 'testfilems1.doc', 'Demo File 9', '19456', '2011-07-21 15:51:16', 1),
(10, 'testfilems2.docx', 'Demo File 10', '23552', '2011-07-21 15:51:24', 1),
(11, 'testfilems4.xls', 'Demo File 11', '7168', '2011-07-21 15:51:32', 1),
(12, 'testfilems5.xlsx', 'Demo File 12', '9216', '2011-07-21 15:51:43', 1);

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` (`id`, `page_id`, `name`, `content_type`, `link`, `target`, `position`, `active`) VALUES
(1, 4, 'Contact Us', 'page', NULL, '', 4, 1),
(2, 1, 'Home', 'page', NULL, '', 1, 1),
(3, 2, 'About Us', 'page', NULL, '', 3, 1),
(4, 3, 'F.A.Q.', 'page', NULL, '', 2, 1);

--
-- Dumping data for table `news`
--

INSERT INTO `news` (`id`, `title`, `body`, `author`, `created`, `active`) VALUES
(1, 'Latest News Announcement', 'We are pleased to announce the new release of Digital Downloads Pro v 2.0.&lt;br/&gt;This version brings lot&#039;s of new features, as well as being completely rewritten from scratch. In this demo as you can see we are using DDP to sell e-books, but you can use it to sell software, audio/video products, images or anything else in downloadable format.&lt;br/&gt;&lt;br/&gt;We hope you find this version to your liking. To access admin area go to: &lt;a href=&quot;admin/login.php&quot;&gt;admin panel&lt;/a&gt; &lt;br/&gt;&lt;strong&gt;username/password&amp;nbsp;&amp;nbsp; admin/admin&lt;/strong&gt;', 'Administrator', '2011-07-10', 1);

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `title`, `slug`, `body`, `created`, `contact`, `faq`, `home_page`, `active`) VALUES
(1, 'Welcome to our site', 'Welcome-to-our-site', '&lt;p&gt;&lt;strong&gt;Welcome!&lt;/strong&gt;&lt;br/&gt;Quisque fringilla ullamcorper est, et egestas nunc luctus quis. In  cursus tortor arcu, quis fermentum ligula. &lt;br/&gt;Vestibulum rutrum diam ut  mauris gravida varius. Pellentesque id ligula ullamcorper velit laoreet  volutpat gravida sit amet nulla. &lt;br/&gt;&lt;br/&gt;Vivamus consequat feugiat viverra. In  nunc erat, convallis in viverra ac, placerat semper enim. &lt;br/&gt;Mauris euismod  lectus sed arcu ultrices egestas. Integer tempus posuere luctus. &lt;br/&gt;Ut at  malesuada mi. Integer mattis aliquet varius&lt;/p&gt;', '2011-07-17 00:00:00', 0, 0, 1, 1),
(2, 'About Us', 'About-Us', '&lt;p&gt;&lt;strong&gt;All about us!&lt;/strong&gt;&lt;br /&gt;&lt;br /&gt;Suspendisse vel nibh at eros blandit aliquet non vel ligula. Praesent  laoreet nibh sit amet neque imperdiet eu tempor felis pharetra. &lt;br /&gt;Class  aptent taciti sociosqu ad litora torquent per conubia nostra, per  inceptos himenaeos. &lt;br /&gt;&lt;br /&gt;Vivamus iaculis tristique sapien quis consectetur.  Curabitur sollicitudin, ante at sagittis suscipit, nulla risus facilisis  neque, eu consectetur mi sem sed lectus. Aliquam erat volutpat. Proin  in ante risus. Etiam pulvinar vestibulum laoreet. &lt;br /&gt;&lt;br /&gt;Vivamus venenatis  consectetur libero quis consequat. Vivamus ut lorem diam. Cras interdum  sem sed risus dictum fringilla. Sed sagittis turpis ut nisi faucibus  pellentesque. Nunc sit amet semper erat.&lt;/p&gt;', '2010-03-18 18:52:49', 0, 0, 0, 1),
(3, 'F.A.Q.', 'FAQ', 'Here you can find most common questions regarding DDP', '2010-03-18 18:56:30', 0, 1, 0, 1),
(4, 'Contact Us', 'Contact-Us', '&lt;p&gt;&lt;strong&gt;Need to contact us?&lt;/strong&gt;&lt;/p&gt;\n&lt;p&gt;Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris congue  vehicula enim id condimentum. &lt;br/&gt;Integer at leo lobortis libero fermentum  cursus. Mauris nulla nibh, condimentum ac cursus ac, ullamcorper eu  orci. &lt;br/&gt;&lt;br/&gt;Nunc at ligula erat. Nunc tempor dictum commodo. Nulla aliquam  scelerisque luctus. Donec non suscipit enim. &lt;br/&gt;Donec diam turpis,  facilisis et pretium vitae, adipiscing id nibh. Nullam vel orci vitae  erat mattis mattis. &lt;br/&gt;&lt;br/&gt;Quisque at vehicula ante. Pellentesque habitant  morbi tristique senectus et netus et malesuada fames ac turpis egestas.  Sed turpis felis, egestas vitae tincidunt nec, ullamcorper non nisi.&lt;/p&gt;', '2010-03-02 14:21:07', 1, 0, 0, 1),
(5, 'Other page', 'Other-page', '&lt;p&gt;Sed eu lorem ut diam feugiat vulputate sed a enim. Aenean interdum, dui a  varius facilisis, metus est imperdiet justo, pharetra auctor ipsum  lorem non mauris. Mauris laoreet lectus lacus. Maecenas ut enim diam,  non malesuada sapien. Fusce ullamcorper pretium risus, eu volutpat dolor  dapibus sit amet&lt;/p&gt;', '2010-03-18 18:59:31', 0, 0, 0, 1);

--
-- Dumping data for table `photos`
--

INSERT INTO `photos` (`id`, `pid`, `caption`, `thumb`, `ordering`, `active`) VALUES
(1, 39, 'Demo Gallery Image 1', 'IMG_0DC5BE-C779C3-53E733-F184CC-67B3D8-6C85A3.jpg', '0', 1),
(2, 39, 'Demo Gallery Image 2', 'IMG_55C0EB-6C81FF-4EBD06-16E117-669DCB-23EAEE.jpg', '0', 1),
(3, 39, 'Demo Gallery Image 3', 'IMG_707C00-BC84AF-C32774-7A6167-8C45E5-BE7637.jpg', '0', 1),
(4, 39, 'Demo Gallery Image 4', 'IMG_8DD25C-8E9BC0-C37DCE-0125E5-AA27B3-658220.jpg', '0', 1);

--
-- Dumping data for table `products`
--

INSERT INTO `products` (`id`, `cid`, `title`, `slug`, `price`, `description`, `body`, `file_id`, `thumb`, `audio`, `youtube`, `expiry`, `created`, `hits`, `vote_up`, `vote_down`, `rating`, `metakeys`, `metadesc`, `active`) VALUES
(1, 1, 'Crock Pot Cookbook', 'Crock-Pot-Cookbook', '0.99', 'The book has been organized by category (Beef, Casseroles, Chicken &amp; Turkey, Desserts, Dips &amp; Fondues, Pasta, Pork, Sausage, Seafood, Soups/Stews/Chili, and Vegetable Recipes) with a table of contents that makes it easy to find what you want.', 'The book has been organized by category (Beef, Casseroles, Chicken &amp;amp; Turkey, Desserts, Dips &amp;amp; Fondues, Pasta, Pork, Sausage, Seafood, Soups/Stews/Chili, and Vegetable Recipes) with a table of contents that makes it easy to find what you want.  &lt;br/&gt;&lt;br/&gt;So, if you&#039;ve got a chicken sitting in your fridge screaming at you to do something before it gets too old you can go to the &quot;Chicken and Turkey&quot; section and scan through the titles or click on the first one and start glancing at the recipes until you find something that strikes your fancy.&lt;br/&gt;', 1, 'IMG_7FDD27-1264DB-1AC810-BDE154-BECDDF-8A506D.jpg', '', '', 'D365', '2011-07-21 22:32:14', 2, 0, 0, 0, '', '', 1),
(2, 1, 'Ultimate Casseroles', 'Ultimate-Casseroles', '0.99', 'Ultimate Casseroles is a collection of over 500 casserole recipes. Everyone loves casseroles, and here you&#039;ll find plenty to satisfy everyone&#039;s taste - Beef, Lamb, Chicken, Turkey, Pork, Sausage, Seafood, Vegetable, and Fruit casseroles', 'Ultimate Casseroles is a collection of over 500 casserole recipes. Everyone loves casseroles, and here you&#039;ll find plenty to satisfy everyone&#039;s taste - Beef, Lamb, Chicken, Turkey, Pork, Sausage, Seafood, Vegetable, and Fruit casseroles - all categorized with an easy-to-use, clickable table of contents. &lt;br/&gt;&lt;br/&gt;This cookbook is an excellent addition to your library or to have on your computer.&lt;br/&gt;', 2, 'IMG_229BAE-D09F91-8E0B8F-3B4A93-CEEDE9-6734DC.jpg', '', '', '200', '2011-07-21 22:37:10', 3, 0, 0, 0, '', '', 1),
(3, 10, 'Artisan Bread in Five Minutes', 'Artisan-Bread-in-Five-Minutes', '12.99', 'There&#039;s nothing like the smell of freshly baked bread to fill a kitchen with warmth, eager appetites, and endless praise for the baker who took on such a time-consuming task. Now, you can fill your kitchen with the irresistible aromas of a French bakery every day with just five minutes of active preparation time, and Artisan Bread in Five Minutes a Day will show you how.', '&lt;p&gt;There&rsquo;s nothing like the smell of freshly baked bread to fill a kitchen with warmth, eager appetites, and endless praise for the baker who took on such a time-consuming task. Now, you can fill your kitchen with the irresistible aromas of a French bakery every day with just five minutes of active preparation time, and &lt;em&gt;Artisan Bread in Five Minutes a Day&lt;/em&gt; will show you how.&lt;/p&gt;&lt;p&gt;Coauthors Jeff Hertzberg and Zo&euml; Fran&ccedil;ois prove that bread baking can be easier than a trip to the bakery. Their method is quick and simple, bringing forth scrumptious perfection in each loaf. Delectable creations will emerge straight from your own oven as warm, indulgent masterpieces that you can finally make for yourself. In exchange for a mere five minutes of your time, your breads will rival those of the finest bakers in the world.&lt;/p&gt;&lt;p&gt;With nearly 100 recipes to put this ingenious technique to use, &lt;em&gt;Artisan Bread in Five Minutes a Day&lt;/em&gt; will open the eyes of any potential baker who has sworn off homemade bread as simply too much work. Crusty baguettes, mouth-watering pizzas, hearty sandwich loaves, and even buttery pastries can easily become part of your own personal menu, and this innovative book will teach you everything you need to know.  &lt;/p&gt;', 3, 'IMG_CCF94C-6DE2E9-B63851-8F416B-4ED975-9221A9.jpg', '', '', '100', '2011-07-21 22:39:02', 3, 0, 0, 0, '', '', 1),
(4, 10, 'Artisan Breads Every Day', 'Artisan-Breads-Every-Day', '11.99', 'Peter Reinhart&#039;s Artisan Breads Every Day distills the renowned baking instructor&#039; s professional techniques down to the basics, delivering artisan bread recipes that anyone with flour and a fridge can make and bake with ease.', 'Peter Reinhart&#039;s Artisan Breads Every Day distills the renowned baking instructor&#039; s professional techniques down to the basics, delivering artisan bread recipes that anyone with flour and a fridge can make and bake with ease. &lt;p&gt;Reinhart begins with the simplest French bread, then moves on to familiar classics such as ciabatta, pizza dough, and soft sandwich loaves, and concludes with fresh specialty items like pretzels, crackers, croissants, and bagels. Each recipe is broken into &quot;Do Ahead&quot; and &quot;On Baking Day&quot; sections, making every step--from preparation through pulling pans from the oven&ndash;a breeze, whether you bought your loaf pan yesterday or decades ago. These doughs are engineered to work flawlessly for busy home bakers: most require only a straightforward mixing and overnight fermentation. The result is reliably superior flavor and texture on par with loaves from world-class artisan bakeries&ndash;and all with little hands-on time. &lt;/p&gt;&lt;p&gt;America&#039;s favorite baking instructor and innovator Peter Reinhart offers new time-saving techniques accompanied by full-color, step-by-step photos throughout so that in no time you&#039;ll be producing fresh batches of: &lt;br/&gt;&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Sourdough Baguettes &lt;/li&gt;&lt;li&gt;50% and 100% Whole Wheat Sandwich Loaves&lt;/li&gt;&lt;li&gt;Soft and Crusty Cheese Bread &lt;/li&gt;&lt;li&gt;English Muffins &lt;/li&gt;&lt;li&gt;Cinnamon Buns &lt;/li&gt;&lt;li&gt;Panettone &bull; Hoagie Rolls &lt;/li&gt;&lt;li&gt;Chocolate Cinnamon Babka &lt;/li&gt;&lt;li&gt;Fruit-Filled Thumbprint Rolls &lt;/li&gt;&lt;li&gt;Danish&lt;/li&gt;&lt;li&gt; Best-Ever Biscuits &lt;/li&gt;&lt;/ul&gt;', 4, 'IMG_F72CE2-FE3A1A-AFF5CC-A0DC64-73646F-688E5D.jpg', '', '', 'D15', '2011-07-21 22:40:47', 20, 0, 0, 0, '', '', 1),
(5, 12, 'Hello, Cupcake!', 'Hello-Cupcake', '9.99', 'America&#039;s favorite food photography team, responsible for the covers of America&#039;s top magazines, shows how to create funny, scary, and sophisticated masterpieces, using a zipper lock bag and common candies and snack items.With these easy-to-follow techniques, even the most kitchen-challenged cooks can', '&lt;p&gt;Witty, one-of-a-kind imaginative cupcake designs using candies from the local convenience store.&lt;/p&gt;&lt;p&gt;America&rsquo;s favorite food photography team, responsible for the covers of America&rsquo;s top magazines, shows how to create funny, scary, and sophisticated masterpieces, using a zipper lock bag and common candies and snack items.With these easy-to-follow techniques, even the most kitchen-challenged cooks can&lt;/p&gt;&lt;p&gt;&bull; raise a big-top circus cupcake tier for a kid&rsquo;s birthday &bull; plant candy vegetables on Oreo earth cupcakes for a garden party &bull; trot out a line of confectionery &ldquo;pupcakes&rdquo; for a dog fancier &bull; serve sausage and pepperoni pizza cupcakes for April Fool&rsquo;s Day &bull; bewitch trick-or-treaters with chilly ghost chocolate cupcakes &bull; create holidays on icing with turkey cupcake place cards, a white cupcake Christmas wreath, and Easter egg cupcakes&lt;/p&gt;&lt;p&gt;No baking skills or fancy pastry equipment is required. Spotting the familiar items in the hundreds of brilliant photos is at least half the fun.  &lt;/p&gt;', 5, 'IMG_8E69B0-DE3561-F02322-2E2600-BB885F-5F0B56.jpg', '', '', 'D25', '2011-07-21 22:44:38', 1, 0, 0, 0, '', '', 1),
(6, 12, 'Betty Crocker Desserts', 'Betty-Crocker-Desserts', '9.99', 'You can do way more with Betty Crocker mixes than just make cakes and cupcakes, like Chocolate Mousse-Raspberry Cake, Southern Apple Crumble, Chocolate-Marshmallow Pillows, and Red Velvet Cupcakes with Cream Cheese Frosting. Delectable fresh-from-the-oven desserts are as easy as 1-2-3. Betty Crocker Fix-with-a-Mix Desserts provides easy recipes for making all kinds of moist and mouthwatering goodies-all fast and easy with a Betty Crocker mix', '&lt;p&gt;An incredible array of swoon-worthy sweets, all starting with a mix! &lt;/p&gt;&lt;p&gt;You can do way more with Betty Crocker mixes than just make cakes and cupcakes, like Chocolate Mousse-Raspberry Cake, Southern Apple Crumble, Chocolate-Marshmallow Pillows, and Red Velvet Cupcakes with Cream Cheese Frosting. Delectable fresh-from-the-oven desserts are as easy as 1-2-3. &lt;em&gt;Betty Crocker Fix-with-a-Mix Desserts &lt;/em&gt;provides easy recipes for making all kinds of moist and mouthwatering goodies-all fast and easy with a Betty Crocker mix. There&#039;s also a bonus chapter that shows you how to make great-tasting treats with Betty Crocker&#039;s new and incredibly popular line of gluten-free mixes.&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Includes 100 recipes with a luscious full-color photo of every recipe&lt;/li&gt;&lt;li&gt;All recipes start with Betty Crocker&#039;s trusted mixes, including SuperMoist&reg; Cake Mix, angel food cake mix, brownie mix, cookie mix, Bisquick&reg;, and all-new gluten-free mixes for cookies, brownies, and cakes&lt;/li&gt;&lt;li&gt;Accompanying sidebars offer creative ideas for decorating cupcakes, types of frosting for cookies, and special-occasion toppers for fruit desserts&lt;/li&gt;&lt;li&gt;A handy index by mix lets readers pick recipes based on the mixes they already have in their pantry&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;There&#039;s almost nothing you can&#039;t do with Betty Crocker&#039;s wide variety of dessert mixes. With &lt;em&gt;Betty Crocker Fix-with-a-Mix, &lt;/em&gt;you&#039;ll never run out of yummy options!  &lt;/p&gt;', 9, 'IMG_03B0DD-F700E9-F06C72-6628FF-B29E5D-B32194.jpg', '', '', '25', '2011-07-21 22:52:33', 1, 0, 0, 0, '', '', 1),
(7, 12, 'The Cake Mix Doctor Returns', 'The-Cake-Mix-Doctor-Returns', '9.99', 'What could be better than a phenomenon? The return of a phenomenon. Ten years ago Anne Byrn&#039;s The Cake Mix Doctor began its extraordinary run as one of the most popular baking books of all time. Now Anne Byrn is back with the all-new Cake Mix Doctor Returns!', 'What could be better than a phenomenon? The return of a phenomenon. Ten years ago Anne Byrn&#039;s &lt;em&gt;The Cake Mix Doctor&lt;/em&gt; began its extraordinary run as one of the most popular baking books of all time. Now Anne Byrn is back with the all-new &lt;em&gt;Cake Mix Doctor Returns!&lt;/em&gt; From the beloved author who showed home bakers how adding a touch of sweet butter or a dusting of cocoa powder, a dollop of vanilla yogurt or flurry of grated lemon zest could transform the ordinary into the extraordinary. Here are 160 brand-new recipes&mdash;that&rsquo;s right, 160 amazing cake mix recipes&mdash;for luscious layer cakes, sheet cakes, brownies, bars, cookies, and more.&lt;p&gt;And the book is needed more than ever. Today 90 percent of home cooks use prepackaged mixes, while the economy is creating a perfect excuse to let them eat cake&mdash;cake equals happiness. And what cakes! 40 layer cakes, from Tiramisu Cake to The Best Red Velvet Cake, Strawberry Refrigerator Cake to Chocolate Swirled Cannoli Cake. 35 sheet cakes. 38 bundt and pound cakes. 16 cupcakes and muffins, plus the cult classic Whoopie Pie. And brownies, bars, and cookies, including Spice Drop Cookies, Angel Food Macaroons, and Chocolate Espresso Biscotti. There&#039;s even a wedding cake, a frequent request from the author&#039;s passionate online community.&lt;/p&gt;&lt;p&gt;The Cake Mix Doctor is back&mdash;just say ahhhhh!  &lt;/p&gt;', 9, 'IMG_D51BAF-D1701E-E3B2B9-3C895F-FD928B-61D0F3.jpg', '', '', '25', '2011-07-21 22:53:52', 1, 0, 0, 0, '', '', 1),
(8, 11, 'The Beer Devotional', 'The-Beer-Devotional', '7.99', 'As Ben Franklin said, beer is a sign that God loves us and wants us to be happy. Now beer lovers everywhere can hoist a cold one while browsing this informative guide to their favorite beverage. For each day of the year, beer expert and homebrewer Jess Lebow lists a beer, information on its history, taste, price, and where to find it.', 'As Ben Franklin said, beer is a sign that God loves us and wants us to be happy. Now beer lovers everywhere can hoist a cold one while browsing this informative guide to their favorite beverage. For each day of the year, beer expert and homebrewer Jess Lebow lists a beer, information on its history, taste, price, and where to find it. He suggests food pairings and includes trivia, brewing tips, and information about beer-related events, as well as quotations about the ease and contentment beer brings to our lives. &lt;p&gt;Every state in the union is represented in this book, which unlocks the secrets of stouts, lembics, IPAs, and porters. The Beer Devotional offers you an inspirational daily guide to the joys of beer.  &lt;/p&gt;', 9, 'IMG_767F1D-DC58D8-FD7B49-E0B3E3-491BAC-7FD8A2.jpg', '', '', '10', '2011-07-21 22:57:15', 2, 0, 0, 0, '', '', 1),
(9, 11, 'The Billionaire&#039;s Vinegar', 'The-Billionaires-Vinegar', '12.99', 'It was the most expensive bottle of wine ever sold. In 1985, at a heated auction by Christie&#039;s of London, a 1787 bottle of Ch&acirc;teau Lafite Bordeaux&mdash;one of a cache of bottles unearthed in a bricked-up Paris cellar and supposedly owned by Thomas Jefferson&mdash;went for $156,000 to a member of the Forbes family.', 'It was the most expensive bottle of wine ever sold. In 1985, at a heated auction by Christie&rsquo;s of London, a 1787 bottle of Ch&acirc;teau Lafite Bordeaux&mdash;one of a cache of bottles unearthed in a bricked-up Paris cellar and supposedly owned by Thomas Jefferson&mdash;went for $156,000 to a member of the Forbes family. The discoverer of the bottle was pop-band manager turned wine collector Hardy Rodenstock, who had a knack for finding extremely old and exquisite wines. &lt;br/&gt;&lt;br/&gt;But rumors about the bottle soon arose. Why wouldn&rsquo;t Rodenstock reveal the exact location where it had been found? Was it part of a smuggled Nazi hoard? Or did his reticence conceal an even darker secret? It would take more than two decades for those questions to be answered and involve a gallery of intriguing players&mdash;among them Michael Broadbent, the bicycle-riding British auctioneer who speaks of wines as if they are women and staked his reputation on the record-setting sale; Serena Sutcliffe, Broadbent&rsquo;s elegant archrival, whose palate is covered by a hefty insurance policy; and Bill Koch, the extravagant Florida tycoon bent on exposing the truth about Rodenstock.  &lt;br/&gt;&lt;br/&gt;Pursuing the story from Monticello to London to Zurich to Munich and beyond, Benjamin Wallace also offers a mesmerizing history of wine, complete with vivid accounts of subterranean European laboratories where old vintages are dated and of Jefferson&rsquo;s colorful, wine-soaked days in France, where he... ', 8, 'IMG_61F641-EBA8C3-54FCC3-AF2D93-DD4453-07E845.jpg', '', '', '15', '2011-07-21 22:58:36', 1, 0, 0, 0, '', '', 1),
(10, 4, 'Cookouts Veggie Style', 'Cookouts-Veggie-Style', '8.99', 'Sounds like the perfect all-American cookout--unless you&#039;re a vegetarian. With more people adopting a mainly vegetarian diet, the choices might seem limited for all those great outdoor parties. Whether it&#039;s a barbecue or a picnic in the park, it&#039;s time to get creative with meatless summer meals! Inside are mouthwatering recipes', '&lt;em&gt;Hamburgers, hot dogs, and barbecue ribs.&lt;/em&gt;&lt;p&gt;Sounds like the perfect all-American cookout--unless you&#039;re a vegetarian. With more people adopting a mainly vegetarian diet, the choices might seem limited for all those great outdoor parties. Whether it&#039;s a barbecue or a picnic in the park, it&#039;s time to get creative with meatless summer meals! Inside are mouthwatering recipes such as:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Grilled Seitan with Apple Salsa&lt;/li&gt;&lt;li&gt;Creole Slaw&lt;/li&gt;&lt;li&gt;Grilled Eggplant Panini&lt;/li&gt;&lt;li&gt;Halloumi Skewers with Parsley &amp;amp; Lemon Salsa&lt;/li&gt;&lt;li&gt;Barley Burgers on Rye Bread&lt;/li&gt;&lt;/ul&gt;&lt;p&gt;Forget boring Boca burgers and bland pasta salad! This book shows you how to make delicious, unique, and fresh vegetarian meals so you&#039;ll never miss the burgers and dogs again!  &lt;/p&gt;', 7, 'IMG_14B242-66347D-C37C16-9B90CB-C09A3E-6A2EB6.jpg', NULL, '', 'D10', '2011-07-21 23:02:53', 1, 0, 0, 0, '', '', 1),
(11, 4, 'Forks Over Knives', 'Forks-Over-Knives', '6.99', 'For decades, that question has fascinated a small circle of impassioned doctors and researchers&mdash;and now, their life-changing research is making headlines in the hit documentary Forks Over Knives. Their answer? Eat a whole-foods, plant-based diet&mdash;it could save your life.', '&lt;strong&gt;What if one simple change could save you from heart disease, diabetes, and cancer?&lt;/strong&gt;&lt;p&gt; &lt;/p&gt;&lt;p&gt;For decades, that question has fascinated a small circle of impassioned doctors and researchers&mdash;and now, their life-changing research is making headlines in the hit documentary &lt;em&gt;Forks Over Knives&lt;/em&gt;. Their answer? Eat a whole-foods, plant-based diet&mdash;it could save your life.&lt;/p&gt;&lt;p&gt;It may overturn most of the diet advice you&rsquo;ve heard&mdash;but the experts behind &lt;em&gt;Forks Over Knives&lt;/em&gt; aren&#039;t afraid to make waves. In his book &lt;em&gt;Prevent and Reverse Heart Disease&lt;/em&gt;, Dr. Caldwell Esselstyn explained that eating meat, dairy, and oils injures the lining of our blood vessels, causing heart disease, heart attack, or stroke. In &lt;em&gt;The China Study&lt;/em&gt;, Dr. Colin Campbell revealed how cancer and other diseases skyrocket when eating meat and dairy is the norm&mdash;and plummet when a traditional plant-based diet persists. And more and more experts are adding their voices to the cause: There is nothing else you can do for your health that can match the benefits of a plant-based diet.&lt;/p&gt;&lt;p&gt;Now, as &lt;em&gt;Forks Over Knives&lt;/em&gt; is introducing more people than ever before to the plant-based way to health, this accessible guide provides the information you need to adopt and maintain a plant-based diet. Features include:&lt;/p&gt;&lt;p&gt; &lt;/p&gt;&lt;ul&gt;&lt;li&gt;Insights from the &lt;strong&gt;luminaries behind the film&lt;/strong&gt;&mdash;Dr. Neal Barnard, Dr. John McDougall, The Engine 2 Diet author Rip Esselstyn, and many others&lt;/li&gt;&lt;li&gt;&lt;strong&gt;Success stories&lt;/strong&gt; from converts to plant-based eating&mdash;like San&rsquo;Dera Prude, who no longer needs to medicate her diabetes, has lost weight, and feels great!&lt;/li&gt;&lt;li&gt;The many &lt;strong&gt;benefits of a whole-foods, plant-based diet&lt;/strong&gt;&mdash;for you, for animals and the environment, and for our future&lt;/li&gt;&lt;li&gt;A helpful primer on crafting a healthy diet rich in unprocessed fruits, vegetables, legumes, and whole grains, including &lt;strong&gt;tips on transitioning&lt;/strong&gt; and essential kitchen tools&lt;/li&gt;&lt;li&gt;&lt;strong&gt;125 recipes&lt;/strong&gt; from 25 champions of plant-based dining&mdash;from Blueberry Oat Breakfast Muffins and Sunny Orange Yam Bisque to Garlic Rosemary Polenta and Raspberry-Pear Crisp&mdash;delicious, healthy, and for every meal, every day.&lt;/li&gt;&lt;/ul&gt;', 6, 'IMG_6EDE94-2AEB78-D3CDE8-9F8EF1-52186F-95B195.jpg', '', '', '10', '2011-07-21 23:04:03', 1, 0, 0, 0, '', '', 1),
(12, 4, 'Becoming Vegetarian', 'Becoming-Vegetarian', '6.99', 'The evidence is in -  millions of people are moving toward a vegetarian diet because it offers a healthful and environmentally sound alternative to the standard diet. Becoming Vegetarian is the ultimate source for making this valuable and beneficial life change.', 'The evidence is in -&amp;nbsp; millions of people are moving toward a vegetarian diet because it offers a healthful and environmentally sound alternative to the standard diet. &lt;em&gt;Becoming Vegetarian&lt;/em&gt; is the ultimate source for making this valuable and beneficial life change. Packed with authoritative vegetarian and vegan nutrition information from established and savvy experts, this powerful book takes the worry out of making an important, healthy transition.&lt;br/&gt;&lt;p&gt;Here&#039; what&#039;s inside:&lt;/p&gt;&lt;ul&gt;&lt;li&gt;Vegetarian food guide for optimal nutrition and easy meal planning&lt;/li&gt;&lt;li&gt;Delicious, easy recipes&lt;/li&gt;&lt;li&gt;Helpful guidelines for those who are just starting out&lt;/li&gt;&lt;li&gt;Cutting edge scientific information for experienced vegetarians&lt;/li&gt;&lt;li&gt;Nutrition essentials from infancy through our senior years&lt;/li&gt;&lt;li&gt;Practical tips for weight control&lt;/li&gt;&lt;li&gt;Much, much more&lt;/li&gt;&lt;/ul&gt;This comprehensive update of an international bestseller is the one resource that contains everything you need to know about becoming a vegetarian or fine-tuning a vegetarian diet. From dealing with awkward social situations to making sure you&#039;re getting all the necessary nutrients, let &lt;em&gt;Vesanto Melina&lt;/em&gt; and &lt;em&gt;Brenda Davis&lt;/em&gt; give you the information you need to achieve a healthful vegetarian life with ease. Change the way you look at food and your health forever&mdash; start following the dynamic, easy-to-implement advice in &lt;em&gt;Becoming Vegetarian&lt;/em&gt; today.  ', 12, 'IMG_42130F-65AA04-153A36-A35B1E-2D4E6B-753C59.jpg', '', '', '25', '2011-07-21 23:05:29', 1, 0, 0, 0, '', '', 1),
(13, 2, 'A Dance with Dragons', 'A-Dance-with-Dragons', '16.99', 'Dubbed &quot;the American Tolkien&quot; by Time magazine, George R. R. Martin has earned international acclaim for his monumental cycle of epic fantasy. Now the #1 New York Times bestselling author delivers the fifth book in his landmark series&mdash;as both familiar faces and surprising new forces vie for a foothold in a fragmented empire.', '&lt;p&gt;Dubbed &ldquo;the American Tolkien&rdquo; by &lt;em&gt;Time&lt;/em&gt; magazine, George R. R. Martin has earned international acclaim for his monumental cycle of epic fantasy. Now the #1 &lt;em&gt;New York Times&lt;/em&gt; bestselling author delivers the fifth book in his landmark series&mdash;as both familiar faces and surprising new forces vie for a foothold in a fragmented empire. &lt;br/&gt; &lt;br/&gt;&lt;strong&gt;A Dance With Dragons: A Song of Ice and Fire: Book Five &lt;/strong&gt;&lt;/p&gt;&lt;p&gt;In the aftermath of a colossal battle, the future of the Seven Kingdoms hangs in the balance&mdash;beset by newly emerging threats from every direction. In the east, Daenerys Targaryen, the last scion of House Targaryen, rules with her three dragons as queen of a city built on dust and death. But Daenerys has thousands of enemies, and many have set out to find her. As they gather, one young man embarks upon his own quest for the queen, with an entirely different goal in mind.&lt;/p&gt;&lt;p&gt;Fleeing from Westeros with a price on his head, Tyrion Lannister, too, is making his way to Daenerys. But his newest allies in this quest are not the rag-tag band they seem, and at their heart lies one who could undo Daenerys&rsquo;s claim to Westeros forever.&lt;/p&gt;&lt;p&gt;Meanwhile, to the north lies the mammoth Wall of ice and stone&mdash;a structure only as strong as those guarding it. There, Jon Snow, 998th Lord Commander of the Night&rsquo;s Watch, will face his greatest challenge. For he has powerful foes not only within the Watch but also beyond, in the land of the creatures of ice.&lt;/p&gt;&lt;p&gt;From all corners, bitter conflicts reignite, intimate betrayals are perpetrated, and a grand cast of outlaws and priests, soldiers and skinchangers, nobles and slaves, will face seemingly insurmountable obstacles. Some will fail, others will grow in the strength of darkness. But in a time of rising restlessness, the tides of destiny and politics will lead inevitably to the greatest dance of all.  &lt;/p&gt;', 6, 'IMG_689883-F6A270-309C28-62482D-9C70EC-CD2EEC.jpg', '', '', '40', '2011-07-21 23:07:17', 1, 0, 0, 0, '', '', 1),
(14, 2, 'No Rest for the Dead', 'No-Rest-for-the-Dead', '16.99', 'More than twenty New York Times bestselling authors team up to create a first-rate serial novel -- a collaboration that combines the skills of America&rsquo;s greatest storytellers to produce a gripping, spellbinding mystery.', '&lt;p&gt;&lt;strong&gt;Alexander McCall Smith. Sandra Brown. Faye Kellerman. J.A. Jance. Jeffery Deaver. Kathy Reichs. Lisa Scottoline. Jeff Lindsay. &lt;/strong&gt;These are only a handful of the names that&lt;strong&gt; &lt;/strong&gt;make up the all-star lineup of authors behind&lt;strong&gt; &lt;/strong&gt;&lt;em&gt;No Rest for the Dead&lt;/em&gt;, a tale of&lt;strong&gt; &lt;/strong&gt;vengeance, greed, and love that flows seamlessly,&lt;strong&gt; &lt;/strong&gt;in the words of David Baldacci, &ldquo;as it passes from&lt;strong&gt; &lt;/strong&gt;one creator&#039;s mind to the next.&rdquo;&lt;/p&gt;&lt;p&gt;When\r\n Christopher Thomas, a ruthless curator at San Francisco&rsquo;s McFall Art \r\nMuseum, is murdered and his decaying body is found in an iron maiden in a\r\n Berlin museum, his wife, Rosemary, is the primary suspect, and she is \r\ntried, convicted and executed. Ten years later, Jon Nunn, the detective \r\nwho cracked the case, is convinced that the wrong person was put to \r\ndeath. In the years since the case was closed, he&#039;s discovered a web of \r\ndeceit and betrayal surrounding the Thomases that could implicate any \r\nnumber of people in the crime. With the help of the dead woman&#039;s friend,\r\n he plans to gather everyone who was there the night Christopher died \r\nand finally uncover the truth, suspect by suspect. Solving this case may\r\n be Nunn&rsquo;s last chance for redemption &hellip; but the shadowy forces behind \r\nChristopher&rsquo;s death will stop at nothing to silence the past forever. &lt;/p&gt;&lt;p&gt;In\r\n this innovative storytelling approach, each of these twenty-five \r\nbestselling writers brings their distinctive voice to a chapter of the \r\nnarrative, building the tension to a shocking, explosive finale. &lt;em&gt;No Rest&lt;/em&gt; &lt;em&gt;for the Dead &lt;/em&gt;is a thrilling, page-turning accomplishment that only America&rsquo;s very best authors could achieve. &lt;/p&gt;&lt;p&gt;From the Introduction of &lt;em&gt;No Rest for the Dead&lt;/em&gt;:&lt;/p&gt;&lt;p&gt;&lt;i&gt;There\r\n is always that case, the one that keeps me awake at night, the one that\r\n got away. It&rsquo;ll always be there, gnawing at the edges of my mind. It \r\ndoesn&rsquo;t matter that ten years have passed, it doesn&rsquo;t matter that the \r\ncase is officially closed. An innocent woman was executed, I was the one\r\n who helped make it happen, and on the sad night when the needle was \r\ninserted into her arm, injecting her with death, part of my life ended \r\ntoo.&lt;/i&gt;&lt;/p&gt;', 6, 'IMG_CC3B68-459651-409C44-6D5440-6AD94F-D88BDF.jpg', '', '', '40', '2011-07-21 23:09:18', 1, 0, 0, 0, '', '', 1),
(15, 2, 'Mile 81', 'Mile-81', '2.99', 'Mile 81 is a boarded up rest stop on a highway in Maine. It&#039;s a place where high school kids drink and get into the kind of trouble high school kids have always gotten into. It&#039;s the place where Pete Simmons goes when his older brother, who&#039;s supposed to be looking out for him, heads off to the gravel pit to play &quot;paratroopers over the side.&quot; Pete, armed only with the magnifying glass he got for his tenth birthday, finds a discarded bottle of vodka in the boarded up burger shack and drinks enough to pass out.', 'Mile 81 is a boarded up rest stop on a highway in Maine. It&#039;s a place where high school kids drink and get into the kind of trouble high school kids have always gotten into. It&#039;s the place where Pete Simmons goes when his older brother, who&#039;s supposed to be looking out for him, heads off to the gravel pit to play &quot;paratroopers over the side.&quot; Pete, armed only with the magnifying glass he got for his tenth birthday, finds a discarded bottle of vodka in the boarded up burger shack and drinks enough to pass out.&lt;p&gt;Not much later, a mud-covered station wagon (which is strange because there hadn&#039;t been any rain in New England for over a week) veers into the Mile 81 rest area, ignoring the sign that says &quot;closed, no services.&quot; The driver&#039;s door opens but nobody gets out.&lt;/p&gt;&lt;p&gt;Doug Clayton, an insurance man from Bangor, is driving his Prius to a conference in Portland. On the backseat are his briefcase and suitcase and in the passenger bucket is a King James Bible, what Doug calls &quot;the ultimate insurance manual,&quot; but it isn&#039;t going to save Doug when he decides to be the Good Samaritan and help the guy in the broken down wagon. He pulls up behind it, puts on his four-ways, and then notices that the wagon has no plates.&lt;/p&gt;&lt;p&gt;Ten minutes later, Julianne Vernon, pulling a horse trailer, spots the Prius and the wagon, and pulls over. Julianne finds Doug Clayton&#039;s cracked cell phone near the wagon door - and gets too close herself. By the time Pete Simmons wakes up from his vodka nap, there are a half a dozen cars at the Mile 81 rest stop. Two kids - Rachel and Blake Lussier - and one horse named Deedee are the only living left. Unless you maybe count the wagon.&lt;/p&gt;&lt;p&gt;With the heart of &lt;em&gt;Stand By Me&lt;/em&gt; and the genius horror of &lt;em&gt;Christine&lt;/em&gt;, &lt;em&gt;Mile 81&lt;/em&gt; is Stephen King unleashing his imagination as he drives past one of those road signs...  &lt;/p&gt;', 1, 'IMG_B4BC5A-35C5DA-A1BD81-61A80B-656CF9-7096B5.jpg', '', '', '50', '2011-07-21 23:11:04', 1, 0, 0, 0, '', '', 1),
(16, 14, 'Metamorphosis', 'Metamorphosis', '1.99', 'A man wakes up one day to find he has been changed into a large insect/beetle. The story follows his efforts to deal with this, and his family&#039;s reaction to the change. But it&#039;s not just a story about a man turning into a beetle, it&#039;s a clever way of writing about how a family would deal with the main breadwinner in the house becoming unable to work, and also on a wider scope', 'A man wakes up one day to find he has been changed into a large insect/beetle. The story follows his efforts to deal with this, and his family&#039;s reaction to the change. But it&#039;s not just a story about a man turning into a beetle, it&#039;s a clever way of writing about how a family would deal with the main breadwinner in the house becoming unable to work, and also on a wider scope, the way a family (and the world at large) reacts to someone who is disabled, or terminally ill.&lt;br/&gt;&lt;br/&gt;It could also be an analogy for how a family treats a member of the family who is now old and needs to be cared for. The man who is now a beetle, is forced to live in his room, shut away from the world, for fear that he will frighten anyone who enters the house.&lt;br/&gt;&lt;br/&gt;The man who once provided for the family, and thought of them above himself, has now become a burden on them, as they are now short of money, and have to find employment. The once able and hard-working man, transformed into a beetle, is now rejected, and his family blame him for their financial situation and the fact that they cannot move to a smaller house, because they need to have a room to keep him in.&lt;br/&gt;&lt;br/&gt;The descriptive quality of the writing is excellent, and although it is a sad and gruesome tale, it is also very funny in parts; I couldn&#039;t help laughing out loud a couple of times.&lt;br/&gt;&lt;br/&gt;The main thing that struck me, was that even though this story is nearly 100 years old, it is still totally relevant to today&#039;s world (and I&#039;m not sure that&#039;s something we should be proud of).', 12, 'IMG_3E3A24-62385B-F295BF-6E8646-24BEF9-2E322A.jpg', '', '', '50', '2011-07-22 10:57:06', 2, 0, 0, 0, '', '', 1),
(17, 13, 'Full Dark, No Stars', 'Full-Dark-No-Stars', '6.99', 'The one thing nobody asked in casual conversation, Darcy thought in the days after she found what she found in the garage, was this: How&#039;s your marriage?They asked how was your weekend and how was your trip to Florida and how&#039;s your health and how are the kids; they even asked how&#039;s life been treatin you, hon?', 'The one thing nobody asked in casual conversation, Darcy thought in the days after she found what she found in the garage, was this: How’s your marriage?They asked how was your weekend and how was your trip to Florida and how’s your health and how are the kids; they even asked how’s life been treatin you, hon? But nobody asked how’s your marriage?&lt;br/&gt;&lt;br/&gt;Good, she would have answered the question before that night. Everything’s fine.&lt;br/&gt;&lt;br/&gt;She had been born Darcellen Madsen (Darcellen, a name only parents besotted with a freshly purchased book of baby names could love), in the year John F. Kennedy was elected President. She was raised in Freeport, Maine, back when it was a town instead of an adjunct to L.L.Bean, America’s first superstore, and half a dozen other oversized retail operations of the sort that are called “outlets” (as if they were sewer drains rather than shopping locations). &lt;br/&gt;&lt;br/&gt;She went to Freeport High School, and then to Addison Business School, where she learned secretarial skills. She was hired by Joe Ransome Chevrolet, which by 1984, when she left the company, was the largest car dealership in Portland. She was plain, but with the help of two marginally more sophisticated girlfriends, learned enough makeup skills to make herself pretty on workdays and downright eye-catching on Friday and Saturday nights, when a bunch of them liked to go out for margaritas at The Lighthouse or Mexican Mike’s (where there was live music).', 11, 'IMG_B01988-F44B7F-6F8E8A-A4025E-AD5756-BDF457.jpg', '', '', 'D50', '2011-07-22 11:00:00', 4, 0, 0, 0, '', '', 1),
(18, 15, 'The Duke And I with Bonus Material', 'The-Duke-And-I-with-Bonus-Material', '1.49', 'Simon Basset, the irresistible Duke of Hastings, has hatched a plan to keep himself free from the town&#039;s marriage-minded society mothers. He pretends to be engaged to the lovely Daphne Bridgerton.', 'Simon Basset, the irresistible Duke of Hastings, has hatched a plan to keep himself free from the town&#039;s marriage-minded society mothers. He pretends to be engaged to the lovely Daphne Bridgerton. After all, it isn&#039;t as if the brooding rogue has any real plans to marry - though there is something about the alluring Miss Bridgerton that sets Simon&#039;s heart beating a bit faster.&lt;br/&gt;&lt;br/&gt;And as for Daphne, surely the clever debutante will attract some very worthy suitors now that it seems a duke has declared her desirable. But as Daphne waltzes across ballroom after ballroom with Simon, she soon forgets that their courtship is a complete sham.&lt;br/&gt;&lt;br/&gt;And now she has to do the impossible and keep herself from losing her heart and soul completely to the handsome hell-raiser who has sworn off marriage forever!', 12, 'IMG_F46092-52A4FE-B83465-6954C6-2D64B6-759719.jpg', '', '', 'D10', '2011-07-22 11:02:10', 1, 0, 0, 0, '', '', 1),
(19, 15, 'Spying in High Heels', 'Spying-in-High-Heels', '0.49', 'Simon Basset, the irresistible Duke of Hastings, has hatched a plan to keep himself free from the town&#039;s marriage-minded society mothers. He pretends to be engaged to the lovely Daphne Bridgerton.', 'L.A. shoe designer, Maddie Springer, lives her life by three rules: Fashion. Fashion. Fashion. But when she stumbles upon the work of a brutal killer, her life takes an unexpected turn from Manolos to murder.&lt;br/&gt;&lt;br/&gt;And things only get worse when her boyfriend disappears - along with $20 million in embezzled funds - and her every move is suddenly under scrutiny by the LAPD&#039;s sexiest cop.&lt;br/&gt;&lt;br/&gt;With the help of her post-menopausal bridezilla of a mother, a 300 pound psychic and one seriously oversexed best friend, Maddie finds herself stepping out of her stilettos and onto the trail of a murderer. But can she catch a killer before the killer catches up to her...&lt;br/&gt;***BONUS MATERIAL*** Maddie&rsquo;s Guide to Essential Footwear for the Stylish Crime Fighter &amp;amp; &quot;Behind the Book&quot; Author Interview.', 11, 'IMG_1A7BBB-8701DF-2DF240-E6AB90-31F2AE-5DF190.jpg', '', '', '10', '2011-07-22 11:03:33', 1, 0, 0, 0, '', '', 1),
(20, 16, 'Conquistadora', 'Conquistadora', '12.99', 'As a young girl growing up in Spain, Ana Larragoity Cubillas is powerfully drawn to Puerto Rico by the diaries of an ancestor who traveled there with Ponce de Le&oacute;n. And in handsome twin brothers Ram&oacute;n and Inocente&mdash;both in love with Ana&mdash;she finds a way to get there.', '&lt;p&gt;An epic novel of love, discovery, and adventure by the author of the best-selling memoir&amp;nbsp;&lt;em&gt;When I Was Puerto Rican.&lt;br/&gt;\r\n  &lt;/em&gt;&lt;br/&gt;\r\n  As a young girl growing up in Spain, Ana Larragoity Cubillas is powerfully drawn to Puerto Rico by the diaries of an ancestor who traveled there with Ponce de Le&oacute;n. And in handsome twin brothers Ram&oacute;n and Inocente&mdash;both in love with Ana&mdash;she finds a way to get there. She marries Ram&oacute;n, and in 1844, just eighteen, she travels across the ocean to a remote sugar plantation the brothers have inherited on the island.&lt;/p&gt;\r\n&lt;p&gt;Ana faces unrelenting heat, disease and isolation, and the dangers of the untamed countryside even as she relishes the challenge of running Hacienda los Gemelos. But when the Civil War breaks out in the United States,&amp;nbsp;Ana finds her livelihood, and perhaps even her life, threatened by the very people on whose backs her wealth has been built: the hacienda&rsquo;s slaves, whose richly drawn stories unfold alongside her own. And when at last Ana falls for a man who may be her destiny&mdash;a once-forbidden love&mdash;she will sacrifice nearly everything to keep hold of the land that has become her true home.&lt;/p&gt;\r\n&lt;p&gt;This is a sensual, riveting tale, set in a place where human passions and cruelties collide: thrilling history that has never before been brought so vividly and unforgettably to life.&lt;/p&gt;', 10, 'IMG_4F2582-BAC5F7-C82AB2-8BB2B5-E68317-6D673B.jpg', '', '', '20', '2011-07-22 11:04:56', 1, 0, 0, 0, '', '', 1),
(21, 3, 'Bossypants', 'Bossypants', '12.99', 'Before Liz Lemon, before &quot;Weekend Update,&quot; before &quot;Sarah Palin,&quot; Tina Fey was just a young girl with a dream: a recurring stress dream that she was being chased through a local airport by her middle-school gym teacher. She also had a dream that one day she would be a comedian on TV.', '&lt;p&gt;Before Liz Lemon, before &quot;Weekend Update,&quot; before &quot;Sarah Palin,&quot; Tina Fey was just a young girl with a dream: a recurring stress dream that she was being chased through a local airport by her middle-school gym teacher. She also had a dream that one day she would be a comedian on TV.&lt;/p&gt;\r\n&lt;p&gt;She has seen both these dreams come true.&lt;/p&gt;\r\n&lt;p&gt;At last, Tina Fey&#039;s story can be told. From her youthful days as a vicious nerd to her tour of duty on&amp;nbsp;&lt;em&gt;Saturday Night Live&lt;/em&gt;; from her passionately halfhearted pursuit of physical beauty to her life as a mother eating things off the floor; from her one-sided college romance to her nearly fatal honeymoon -- from the beginning of this paragraph to this final sentence.&lt;/p&gt;\r\n&lt;p&gt;Tina Fey reveals all, and proves what we&#039;ve all suspected: you&#039;re no one until someone calls you bossy.&lt;/p&gt;\r\n&lt;p&gt;(&lt;em&gt;Includes Special, Never-Before-Solicited Opinions on Breastfeeding, Princesses, Photoshop, the Electoral Process, and Italian Rum Cake!)&lt;/em&gt;&lt;/p&gt;', 9, 'IMG_044B62-13BFD8-A7CC30-116E0F-744A1C-84D1E6.jpg', '', '', 'D20', '2011-07-22 11:06:21', 1, 0, 0, 0, '', '', 1),
(22, 3, 'Does the Noise in My Head Bother You?', 'Does-the-Noise-in-My-Head-Bother-You', '12.99', '&quot;I&#039;ve been mythicized, Mick-icized, eulogized and fooligized, I&#039;ve been Cole-Portered and farmer&#039;s-daughtered, I&#039;ve been Led Zepped and 12-stepped. I&#039;m a rhyming fool and so cool that me, Fritz the Cat, and Mohair Sam are the baddest cats that am. I have so many outrageous stories, too many', '&lt;p&gt;&quot;I&#039;ve been mythicized, Mick-icized, eulogized and fooligized, I&#039;ve been Cole-Portered and farmer&#039;s-daughtered, I&#039;ve been Led Zepped and 12-stepped. I&#039;m a rhyming fool and so cool that me, Fritz the Cat, and Mohair Sam are the baddest cats that am. I have so many outrageous stories, too many, and I&#039;m gonna tell &#039;em all. All the unexpurgated, brain-jangling tales of debauchery, sex &amp;amp; drugs, transcendence &amp;amp; chemical dependence you will ever want to hear.&quot;&lt;/p&gt;\r\n&lt;p&gt;The son of a classical pianist straight out of the Bronx of old Archie comics, Steven Tyler was born to be a rock star. Weaned on Cole Porter, Nat King Cole, Mick&mdash;and his beloved Janis Joplin&mdash;Tyler began tearing up the streets and the stage as a teenager before finally meeting his &quot;mutant twin&quot; and legendary partner Joe Perry. In this addictively readable memoir, told in the playful, poetic voice that is uniquely his own, Tyler unabashedly recounts the meteoric rise, fall, and rise of Aerosmith over the last three decades and riffs on the music that gives it all meaning.&lt;/p&gt;\r\n&lt;p&gt;Tyler tells what it&#039;s like to be a living legend and the frontman of one of the world&#039;s most revered and infamous bands&mdash;the debauchery, the money, the notoriety, the fights, the motels and hotels, the elevators, limos, buses and jets, the rehab. He reveals the spiritual side that &quot;gets lost behind the stereotype of the Sex Guy, the Drug Guy, the Demon of Screamin&#039;, the Terror of the Tropicana.&quot; And he talks about his epic romantic life and his relationship with his four children. As dazzling, bold, and out-on-the-edge as the man himself,&amp;nbsp;&lt;em&gt;Does the Noise in My Head Bother You?&lt;/em&gt;&amp;nbsp;is an all-access backstage pass into this extraordinary showman&#039;s life.&lt;/p&gt;\r\n', 5, 'IMG_031418-4BF800-9B162B-AD9E56-A8C942-26DF25.jpg', '', '', 'D20', '2011-07-22 11:07:28', 1, 0, 0, 0, '', '', 1),
(23, 5, 'How to Make Your Photos Look Like the Pros', 'How-to-Make-Your-Photos-Look-Like-the-Pros', '8.99', 'Scott Kelby, the man who changed the &quot;digital darkroom&quot; forever with his groundbreaking, #1 bestselling, award-winning book The Photoshop Book for Digital Photographers, now tackles the most important side of digital photography&mdash;how to take pro-quality shots using the same tricks today&#039;s top digital pros use (and it&#039;s easier than you&#039;d think).', '&lt;p&gt;Scott Kelby, the man who changed the &quot;digital darkroom&quot; forever with his groundbreaking, #1 bestselling, award-winning book The Photoshop Book for Digital Photographers, now tackles the most important side of digital photography&mdash;how to take pro-quality shots using the same tricks today&#039;s top digital pros use (and it&#039;s easier than you&#039;d think).&lt;/p&gt;\r\n&lt;p&gt;This entire book is written with a brilliant premise, and here&rsquo;s how Scott describes it: &quot;If you and I were out on a shoot, and you asked me, &#039;Hey, how do I get this flower to be in focus, but I want the background out of focus?&#039; I wouldn&#039;t stand there and give you a lecture about aperture, exposure, and depth of field. In real life, I&#039;d just say, &#039;Get out your telephoto lens, set your f/stop to f/2.8, focus on the flower, and fire away.&#039; You d say, &#039;OK,&#039; and you&#039;d get the shot. That&#039;s what this book is all about. A book of you and I shooting, and I answer the questions, give you advice, and share the secrets I&#039;ve learned just like I would with a friend, without all the technical explanations and without all the techno-photo-speak.&quot;&lt;/p&gt;\r\n&lt;p&gt;This isn&#039;t a book of theory&mdash;it isn&#039;t full of confusing jargon and detailed concepts: this is a book of which button to push, which setting to use, when to use them, and nearly two hundred of the most closely guarded photographic &quot;tricks of the trade&quot; to get you shooting dramatically better-looking, sharper, more colorful, more professional-looking photos with your digital camera every time you press the shutter button.&lt;/p&gt;\r\n&lt;p&gt;Here&#039;s another thing that makes this book different: each page covers just one trick, just one single concept that makes your photography better. Every time you turn the page, you&#039;ll learn another pro setting, another pro tool, another pro trick to transform your work from snapshots into gallery prints. There&#039;s never been a book like it, and if you&#039;re tired of taking shots that look &quot;OK,&quot; and if you&rsquo;re tired of looking in photography magazines and thinking, &quot;Why don&#039;t my shots look like that?&quot; then this is the book for you.&lt;/p&gt;', 4, 'IMG_905208-29C9ED-A773FD-5D7AE8-6AF938-62B87F.jpg', '', '', 'D20', '2011-07-22 11:09:18', 1, 0, 0, 0, '', '', 1),
(24, 5, 'Android Development For Dummies', 'Android-Development-For-Dummies', '16.99', 'Even if you&#039;ve never written a mobile application, this book has the know-how you need to turn your great ideas into cool apps for the Android platform. With millions of smartphone users and a cornucopia of carriers, Android is a great place to ply the app development trade.', '&lt;p&gt;Even if you&#039;ve never written a mobile application, this book has the know-how you need to turn your great ideas into cool apps for the Android platform. With millions of smartphone users and a cornucopia of carriers, Android is a great place to ply the app development trade. This book shows you from the ground up how to set up your environment and create an app. Read on to become an Android developer extraordinaire!&lt;/p&gt;\r\n&lt;ul&gt;\r\n  &lt;li&gt;Welcome to Android &mdash; learn what makes a great Android app, how to use the SDK, ways to work with mobile screens, and how the development process works&lt;/li&gt;\r\n  &lt;li&gt;Make users happy &mdash; find out how to design an interface that mobile users will love&lt;/li&gt;\r\n  &lt;li&gt;Learn the code &mdash; work with the activity lifecycle and Android framework classes, use the Eclipse debugger, and create a home screen widget for your app&lt;/li&gt;\r\n  &lt;li&gt;Beyond the basics &mdash; take your skills up a notch with apps that involve SQLite databases and multiple screens&lt;/li&gt;\r\n  &lt;li&gt;Price and publish &mdash; pick the right price for your app and get it into the Android Market&lt;/li&gt;\r\n&lt;/ul&gt;\r\n&lt;p&gt;Open the book and find:&lt;/p&gt;\r\n&lt;ul&gt;\r\n  &lt;li&gt;Cool ways to use the accelerometer in your app&lt;/li&gt;\r\n  &lt;li&gt;How to turn mobile limitations into opportunities&lt;/li&gt;\r\n  &lt;li&gt;Tips on installing and setting up the tools&lt;/li&gt;\r\n  &lt;li&gt;Step-by-step coding directions&lt;/li&gt;\r\n  &lt;li&gt;Ways to make your apps more marketable&lt;/li&gt;\r\n  &lt;li&gt;How to create really useful menus&lt;/li&gt;\r\n  &lt;li&gt;Advice on app pricing&lt;/li&gt;\r\n  &lt;li&gt;Ten great sample apps and SDKs, including code&lt;/li&gt;\r\n&lt;/ul&gt;\r\n&lt;p&gt;Learn to:&lt;/p&gt;\r\n&lt;ul&gt;\r\n  &lt;li&gt;Create apps for hot smartphones like Droid X, Galaxy S, and MyTouch&lt;/li&gt;\r\n  &lt;li&gt;Download the SDK and get Eclipse up and running&lt;/li&gt;\r\n  &lt;li&gt;Code Android applications&lt;/li&gt;\r\n  &lt;li&gt;Submit your apps to the Android Market&lt;/li&gt;\r\n&lt;/ul&gt;', 3, 'IMG_6F09A8-7BB651-894B0D-B14DBA-449216-4EDB89.jpg', '', '', '20', '2011-07-22 11:10:49', 1, 0, 0, 0, '', '', 1);
INSERT INTO `products` (`id`, `cid`, `title`, `slug`, `price`, `description`, `body`, `file_id`, `thumb`, `audio`, `youtube`, `expiry`, `created`, `hits`, `vote_up`, `vote_down`, `rating`, `metakeys`, `metadesc`, `active`) VALUES
(25, 5, 'Windows 7 For Dummies', 'Windows-7-For-Dummies', '16.99', 'Windows For Dummies is the all-time bestselling guide to the Windows operating system. Windows 7 For Dummies answers all your questions about the interface adjustments and all the new tools in Windows 7.', '&lt;p&gt;The perfect plain-English guide to the much-anticipated release of Windows 7&lt;/p&gt;\r\n&lt;p&gt;&lt;em&gt;Windows For Dummies&lt;/em&gt;&amp;nbsp;is the all-time bestselling guide to the Windows operating system.&amp;nbsp;&lt;em&gt;Windows 7 For Dummies&lt;/em&gt;&amp;nbsp;answers all your questions about the interface adjustments and all the new tools in Windows 7.&lt;/p&gt;\r\n&lt;p&gt;Whether you&#039;re new to computers or just eager to start using the newest version of Windows, expert author Andy Rathbone will walk you step by step through the most common Windows 7 tasks, including managing files, applications, media, and Internet access. If you&#039;ve never used Windows before, it shows you the things most books assume you already know, like how to navigate the interface, customize the desktop, and work with the file system. Then it helps you get comfortable using all aspects of Windows 7.&lt;/p&gt;\r\n&lt;ul&gt;\r\n  &lt;li&gt;Nearly ninety percent of the world&#039;s PCs use the Windows operating system&lt;/li&gt;\r\n  &lt;li&gt;Covers basic management of applications, files, and data; creating and printing documents; setting up an Internet connection and e-mail account; and online security&lt;/li&gt;\r\n  &lt;li&gt;Explores using Windows to edit and manage audio, video, and photo files, and how to create CDs, DVDs, and playlists with Media Center&lt;/li&gt;\r\n  &lt;li&gt;Helps you tweak and customize Windows 7 to operate your way and set up user accounts, build a home network, and maintain your PC&lt;/li&gt;\r\n  &lt;li&gt;Provides troubleshooting advice, helps you find missing files and use the Help system, and explains common error messages&lt;/li&gt;\r\n&lt;/ul&gt;\r\n&lt;p&gt;&lt;em&gt;Windows 7 For Dummies&lt;/em&gt;&amp;nbsp;will have you up and running on the newest version of Windows quickly and easily.&lt;/p&gt;', 3, 'IMG_62D3E8-C07202-710469-FC3FED-ACB5F6-D297B7.jpg', '', '', '30', '2011-07-22 11:13:37', 1, 0, 0, 0, '', '', 1),
(26, 6, 'Growing at the Speed of Life', 'Growing-at-the-Speed-of-Life', '11.99', 'With more than two dozen cookbooks and hundreds of television shows, lectures, and personal appearances devoted to promoting healthful cooking, award-winning chef and former &quot;Galloping Gourmet&quot; Graham Kerr literally starts from the ground up in this engaging', '&lt;p&gt;With more than two dozen cookbooks and hundreds of television shows, lectures, and personal appearances devoted to promoting healthful cooking, award-winning chef and former &quot;Galloping Gourmet&quot; Graham Kerr literally starts from the ground up in this engaging, inspiring, and highly informative introduction to the joys of the kitchen garden-and the pleasures of the table that start with growing your own food. &lt;br/&gt;\r\n  &lt;br/&gt;\r\n  While Kerr taps into the current trend of sustainability, eating locally and organically, and eschewing fast food, he recognizes that today&#039;s home cooks are savvier and more discerning than their predecessors in the back-to-the-land movement. And in this day of rampant obesity and related diseases, he understands how critical taking these vital steps toward wellness can be.&lt;/p&gt;\r\n&lt;p&gt;&lt;em&gt;Growing at the Speed of Life&lt;/em&gt;&amp;nbsp;takes you through the first year in his kitchen garden, sharing the lessons learned and the wisdom received from his circle of local knowledge providers. From digging up his &quot;south lawn&quot; and putting together a greenhouse to planting his first seeds and harvesting and sharing his first crop with others in need, Kerr provides a whirlwind tour through his gardening adventures. Along the way, he profiles sixty common-and not-so-common but readily available-garden vegetables, fruits, and herbs with useful advice and recommendations for care and feeding.&lt;/p&gt;\r\n&lt;p&gt;Once the harvest is done, Kerr takes you into the kitchen, offering guidance on the best cooking methods to create appealing dishes in his inimitable and spirited style. He includes more than one hundred recipes that are as simple and elegant as they are healthful-and that will certainly entice you to increase the amount of plant foods in your diet.&lt;/p&gt;', 1, 'IMG_E77059-9259D6-CED570-E3E5BE-588B33-CFB95A.jpg', '', '', '50', '2011-07-22 11:16:04', 18, 0, 0, 0, '', '', 1),
(27, 6, 'Green Thoughts', 'Green-Thoughts', '11.99', 'A classic in the literature of the garden, Green Thoughts is a beautifully written and highly original collection of seventy-two essays, alphabetically arranged, on topics ranging from &quot;Annuals&quot; and &quot;Artichokes&quot; to &quot;Weeds&quot; and &quot;Wildflowers.&quot; An amateur gardener for over thirty years, Eleanor Per&eacute;nyi draws upon her wide-ranging', 'A classic in the literature of the garden,&amp;nbsp;&lt;em&gt;Green Thoughts&lt;/em&gt;&amp;nbsp;is a beautifully written and highly original collection of seventy-two essays, alphabetically arranged, on topics ranging from &ldquo;Annuals&rdquo; and &ldquo;Artichokes&rdquo; to &ldquo;Weeds&rdquo; and &ldquo;Wildflowers.&rdquo; An amateur gardener for over thirty years, Eleanor Per&eacute;nyi draws upon her wide-ranging knowledge of gardening lore to create a delightful, witty blend of how-to advice, informed opinion, historical insight, and philosophical musing. &lt;br/&gt;&lt;br/&gt;There are entries in praise of earthworms and in protest of rock gardens, a treatise on the sexual politics of tending plants, and a paean to the salubrious effect of gardening (see &ldquo;Longevity&rdquo;). Twenty years after its initial publication,&amp;nbsp;&lt;em&gt;Green Thoughts&lt;/em&gt;remains as much a joy to read as ever.\r\n&lt;p&gt;This Modern Library edition is published with a new Introduction by Allen Lacy, former gardening columnist for&amp;nbsp;&lt;em&gt;The Wall Street Journal&lt;/em&gt;&amp;nbsp;and&amp;nbsp;&lt;em&gt;The New York Times&lt;/em&gt;and the author of numerous gardening books.&lt;/p&gt;', 1, 'IMG_BB80AB-C42D9D-60B253-4515B3-465BEE-DA34D0.jpg', '', '', 'D50', '2011-07-22 11:17:52', 1, 0, 0, 0, '', '', 1),
(28, 6, 'Grow More in Less Space', 'Grow-More-in-Less-Space', '8.99', 'Sure, there are ten new features in this all-new, updated book. Sure, it&#039;s even simpler than it was before. Of course, you don&#039;t have to worry about fertilizer or poor soil ever again because you&#039;ll be growing above the ground.', '&lt;p&gt;Do you know what the best feature is in &quot;All New Square Foot Gardening&quot;?&lt;/p&gt;\r\n&lt;p&gt;Sure, there are ten new features in this all-new, updated book. Sure, it&#039;s even simpler than it was before. Of course, you don&#039;t have to worry about fertilizer or poor soil ever again because you&#039;ll be growing above the ground.&lt;/p&gt;\r\n&lt;p&gt;But, the best feature is that &quot;anyone,&quot; &quot;anywhere&quot; can enjoy a Square Foot garden. Children, adults with limited mobility, even complete novices can achieve spectacular results.&lt;/p&gt;\r\n&lt;p&gt;But, let&#039;s get back to the ten improvements. You&#039;re going to love them.&lt;/p&gt;\r\n&lt;p&gt;&amp;nbsp;&lt;/p&gt;\r\n&lt;p&gt;1) New Location - Move your garden closer to your house by eliminating single-row gardening. Square Foot Garden needs just &quot;twenty percent&quot; of the space of a traditional garden.&lt;/p&gt;\r\n&lt;p&gt;2) New Direction - Locate your garden &quot;on top&quot; of existing soil. Forget about pH soil tests, double-digging (who enjoys that?), or the never-ending soil improvements.&lt;/p&gt;\r\n&lt;p&gt;3) New Soil - The new &quot;Mel&#039;s Mix&quot; is the perfect growing mix. Why, we even give you the recipe. Best of all, you can even &quot;buy&quot; the different types of compost needed.&lt;/p&gt;\r\n&lt;p&gt;4) New Depth - You only need to prepare a SFG box to a depth of 6 inches! It&#039;s true--the majority of plants develop just fine when grown at this depth.&lt;/p&gt;\r\n&lt;p&gt;5) No Fertilizer - The all new SFG does not need any fertilizer-ever! If you start with the perfect soil mix, then you don&#039;t need to add fertilizer.&lt;/p&gt;\r\n&lt;p&gt;6)New Boxes - The new method uses bottomless boxes placed aboveground. We show you how to build your own (with step-by-step photos).&lt;/p&gt;\r\n&lt;p&gt;7) New Aisles - The ideal gardening aisle width is about three to four feet. That makes it even easier to kneel, work, and harvest.&lt;/p&gt;\r\n&lt;p&gt;8) New Grids - Prominent and permanent grids added to your SFG box help you visualize the planting squares and know how to space for maximum harvest.&lt;/p&gt;\r\n&lt;p&gt;9) New Seed Saving Idea - The old-fashioned way advocates planting many seeds and then thinning the extras (that means pulling them up). The new method means planting a pinch- literally two or three seeds--per planting hole.&lt;/p&gt;\r\n&lt;p&gt;10) Tabletop Gardens - The new boxes are so much smaller and lighter (only 6 inches of soil, remember?), you can add a plywood bottom to make them portable.&lt;/p&gt;\r\n&lt;p&gt;Of course, that&#039;s not all. We&#039;ve also included simple, easy-to-follow instructions using lots of photos and illustrations. You&#039;re going to love it!&lt;/p&gt;', 2, 'IMG_0D44F9-057547-875B01-01C8F0-E2F9FD-C9C323.jpg', '', '', 'D100', '2011-07-22 11:18:56', 16, 0, 0, 0, '', '', 1),
(29, 7, 'Turn Left at the Trojan Horse', 'Turn-Left-at-the-Trojan-Horse', '0.00', 'A modern-day Odysseus in Kerouac clothing, Brad Herzog plunges into a solo cross-country search for insight. With middle age bearing down on him, he takes stock: How has he measured up to his own youthful aspirations? In contemporary America, what is a life well lived? What is a heroic life?', '&lt;em&gt;&quot;Turn Left at the Trojan Horse&lt;/em&gt;&amp;nbsp;had me howling with laughter and nodding at the razor-sharp observation.&quot; --Tahir Shah, author of&amp;nbsp;&lt;em&gt;The Caliph&#039;s House&lt;/em&gt;\r\n&lt;p&gt;&lt;em&gt;&quot;Go away. Figure it out,&quot; she was saying. &quot;Don&#039;t come back until you do.&quot; She looked at the calendar. &quot;You have thirty-one days.&quot;&lt;/em&gt;&lt;/p&gt;\r\n&lt;p&gt;With these words, like Helen of Troy launching a thousand ships across the Aegean, Brad Herzog&#039;s wife launched a Winnebago Aspect onto the open road.&lt;/p&gt;\r\n&lt;p&gt;A modern-day Odysseus in Kerouac clothing, Brad Herzog plunges into a solo cross-country search for insight. With middle age bearing down on him, he takes stock: How has he measured up to his own youthful aspirations? In contemporary America, what is a life well lived? What is a heroic life?&lt;/p&gt;\r\n&lt;p&gt;From the foothills of Washington&#039;s Mount Olympus, through the forgotten corners of America, and finally to his college reunion in Ithaca, New York, Brad shares his personal odyssey. Stopping in classically named towns, he meets everyday heroes, including a teacher in a one-room schoolhouse in Troy, Oregon; a modern-day hobo in Iliad, Montana; and a bomb-squad soldier in Sparta, Wisconsin. These encounters and Brad&#039;s effortlessly infused musings make for an exciting, one-of-a-kind ride.&lt;/p&gt;\r\n&lt;p&gt;&quot;A truly epic journey.&quot;--A.J. Jacobs, author of&amp;nbsp;&lt;em&gt;The Year of Living Biblically&lt;/em&gt;&lt;/p&gt;\r\n&lt;p&gt;&quot;As we sit in Herzog&#039;s passenger seat, we cannot help but stare out the window and even see our own reflection in the glass.&quot;--Liz Robbins, author of&amp;nbsp;&lt;em&gt;A Race Like No Other&lt;/em&gt;&lt;/p&gt;\r\n&lt;p&gt;&lt;strong&gt;Brad Herzog&lt;/strong&gt;&amp;nbsp;lives on California&#039;s Monterey Peninsula with his wife and their two sons. He has been described as a &quot;modern-day Steinbeck&quot; and a &quot;Picasso of the Winnebago,&quot; and Lonely Planet has ranked his travel memoirs among eight classics of the genre, along with books like Travels with Charley and On the Road. As an award-winning freelance writer, he has chronicled some of the nation&#039;s most unusual and intriguing subcultures, from nudists to North Pole explorers and from Pez collectors to pro mini golfers.&lt;/p&gt;', 3, 'IMG_0F5B4C-E6F9D6-3F985E-D63D2D-A01522-C0E6F5.jpg', '', '', 'D365', '2011-07-22 11:20:47', 8, 0, 0, 0, '', '', 1),
(30, 7, 'A Pedestrian in Paris', 'A-Pedestrian-in-Paris', '6.99', 'Thrust into the unlikely role of professional &quot;literary walking tour&quot; guide, an expat writer provides the most irresistibly witty and revealing tour of Paris in years.', '&lt;p&gt;Thrust into the unlikely role of professional &quot;literary walking tour&quot; guide, an expat writer provides the most irresistibly witty and revealing tour of Paris in years.&lt;/p&gt;\r\n&lt;p&gt;In this enchanting memoir, acclaimed author and long- time Paris resident John Baxter remembers his yearlong experience of giving &quot;literary walking tours&quot; through the city. Baxter sets off with unsuspecting tourists in tow on the trail of Paris&#039;s legendary artists and writers of the past.&lt;br/&gt;&lt;br/&gt; Along the way, he tells the history of Paris through a brilliant cast of characters: the favorite caf&eacute;s of Ernest Hemingway, F. Scott Fitzgerald, and James Joyce; Pablo Picasso&#039;s underground Montmartre haunts; the bustling boulevards of the late-nineteenth-century&lt;em&gt;fl&acirc;neurs&lt;/em&gt;; the secluded &quot;Little Luxembourg&quot; gardens beloved by Gertrude Stein; the alleys where revolutionaries plotted; and finally Baxter&#039;s own favorite walk near his home in Saint-Germain-des-Pr&eacute;s.&lt;/p&gt;\r\n&lt;p&gt;Paris, by custom and design, is a pedestrian&#039;s city&mdash;each block a revelation, every neighborhood a new feast for the senses, a place rich with history and romance at every turn.&amp;nbsp;&lt;em&gt;The Most Beautiful Walk in the World&lt;/em&gt;&amp;nbsp;is your guide, par excellence, to the true, off-the-beaten-path heart of the City of Lights.&lt;/p&gt;', 4, 'IMG_67D35E-A042D6-633513-D6FC0C-370787-BE778B.jpg', '', '', '365', '2011-07-22 11:26:47', 7, 0, 0, 0, '', '', 1),
(31, 7, 'Walking the Bible', 'Walking-the-Bible', '12.99', 'Its stories may be the best known in the world, but its locations have long been a mystery. Where did Noah&#039;s ark land? Where did Moses receive the Ten Commandments? Where are the lost cities of Sodom and Gomorrah? Now, inWalking the Bible: A Photographic Journey, New York Times bestselling author Bruce Feiler offers an unprecedented heart-stirring adventure through the landscape of some of history&#039;s most storied events.', '&lt;p&gt;&quot;The process of gathering these images reminded me of the Bible&#039;s effortless ability to reinvent itself for each generation and each new way of searching.&quot;&amp;nbsp;&lt;br/&gt;\r\n  &mdash;Bruce Feiler&lt;/p&gt;\r\n&lt;p&gt;Its stories may be the best known in the world, but its locations have long been a mystery. Where did Noah&#039;s ark land? Where did Moses receive the Ten Commandments? Where are the lost cities of Sodom and Gomorrah? Now, in&lt;em&gt;Walking the Bible: A Photographic Journey&lt;/em&gt;,&amp;nbsp;&lt;em&gt;New York Times&lt;/em&gt;&amp;nbsp;bestselling author Bruce Feiler offers an unprecedented heart-stirring adventure through the landscape of some of history&#039;s most storied events.&lt;/p&gt;\r\n&lt;p&gt;Featuring Bruce Feiler&#039;s own photography as well as his selections from professional collections,&amp;nbsp;&lt;em&gt;Walking the Bible: A Photographic Journey&lt;/em&gt;&amp;nbsp;brings together breathtaking vistas, intimate portraits, and fascinating panoramas, providing firsthand access to the inscrutable land where three of the world&#039;s great religions were born&mdash;and finally puts a face on the stories that have long inspired the human spirit.&lt;/p&gt;\r\n&lt;p&gt;Over several years, Feiler traveled nearly ten thousand miles through the deserts of the Middle East, which led first to his runaway national bestseller Walking the Bible. This new illustrated book follows his route, offering a thrilling photographic voyage through the actual places of some of the Bible&#039;s most memorable events&mdash;from the heights of Mount Ararat, where Noah&#039;s ark landed, to the desert outpost in Turkey, where Abraham first heard the words of God, to the summit where Moses overlooked the Promised Land.&lt;/p&gt;\r\n&lt;p&gt;&lt;em&gt;Walking the Bible: A Photographic Journey&lt;/em&gt;&amp;nbsp;chronicles a landscape that nurtured the relationship between humans and the divine, breathing new meaning into stories that have been a timeless source of inspiration.&lt;/p&gt;', 5, 'IMG_406FA7-1D5C38-B462B5-DBB8A8-1280CE-033638.jpg', '', '', '150', '2011-07-22 11:28:21', 15, 0, 0, 3, '', '', 1),
(32, 7, 'For All the Tea in China', 'For-All-the-Tea-in-China', '9.99', 'In 1848, the British East India Company, having lost its monopoly on the tea trade, engaged Robert Fortune, a Scottish gardener, botanist, and plant hunter, to make a clandestine trip into the interior of China-territory forbidden to foreigners-to steal the closely guarded secrets of tea horticulture and manufacturing.', '&lt;p&gt;&lt;strong&gt;A dramatic historical narrative of the man who stole the secret of tea from China&lt;/strong&gt;&lt;/p&gt;\r\n&lt;p&gt;In 1848, the British East India Company, having lost its monopoly on the tea trade, engaged Robert Fortune, a Scottish gardener, botanist, and plant hunter, to make a clandestine trip into the interior of China-territory forbidden to foreigners-to steal the closely guarded secrets of tea horticulture and manufacturing.&amp;nbsp;&lt;em&gt;For All the Tea in China&lt;/em&gt;&amp;nbsp;is the remarkable account of Fortune&#039;s journeys into China-a thrilling narrative that combines history, geography, botany, natural science, and old-fashioned adventure.&lt;/p&gt;\r\n&lt;p&gt;Disguised in Mandarin robes, Fortune ventured deep into the country, confronting pirates, hostile climate, and his own untrustworthy men as he made his way to the epicenter of tea production, the remote Wu Yi Shan hills. One of the most daring acts of corporate espionage in history, Fortune&#039;s pursuit of China&#039;s ancient secret makes for a classic nineteenth-century adventure tale, one in which the fate of empires hinges on the feats of one extraordinary man.&lt;/p&gt;\r\n', 3, 'IMG_71EF42-B6C9E1-911929-371D01-F8C840-772FE7.jpg', '', '', '15', '2011-07-22 11:34:57', 7, 0, 0, 0, '', '', 1),
(33, 7, 'Fodor&#039;s Italy', 'Fodors-Italy', '14.99', 'No place better epitomizes the greatness of the Renaissance than Florence, where there&#039;s a masterpiece around every corner, from Michelangelo&#039;s David to Botticelli&#039;s Venus. The central regions of Tuscany and Umbria are characterized by midsize cities and small hilltop towns, each with its rich history and art treasures.', 'No place better epitomizes the greatness of the Renaissance than Florence, where there&rsquo;s a masterpiece around every corner, from Michelangelo&rsquo;s&amp;nbsp;&lt;em&gt;David&lt;/em&gt;&amp;nbsp;to Botticelli&rsquo;s&amp;nbsp;&lt;em&gt;Venus&lt;/em&gt;. The central regions of Tuscany and Umbria are characterized by midsize cities and small hilltop towns, each with its rich history and art treasures. Highlights include the walled city of Lucca; Pisa and the Leaning Tower, Siena, home of the Palio; and Assisi, the city of St. Francis. In between, the gorgeous countryside produces some of Italy&rsquo;s finest wine.&lt;br/&gt;\r\n&lt;br/&gt;\r\nThe region of Campania is a popular place both to unwind on the pint-size island of Capri or the resort towns of the Amalfi Coast and to explore the past at the archaeological ruins of Pompeii, Herculaneum, and Paestum. In the middle of everything is the vibrant, chaotic city of Naples. Farther south, in the off-the-beaten-path regions of Puglia, Basilicata, and Calabria, you&rsquo;ll find attractive beaches, mysterious ancient dwellings, and the charming town of Lecce. Across a narrow straight from Calabria is Sicily. Baroque church-hopping could be a sport on the cacophonous streets of Palermo and Siracusa, and amid the almond groves of Agrigento stands one of the world&rsquo;s best-preserved Greek ruins.&lt;br/&gt;\r\n&lt;br/&gt;\r\nItaly&rsquo;s capital is one of the great cities of Europe. It&rsquo;s a large, busy metropolis that lives in the here and now, yet there&rsquo;s no other place on earth where you&rsquo;ll encounter such powerful evocations of a long and spectacular past, from the Colosseum to the dome of St. Peter&rsquo;s. With more masterpieces per square foot than any other city in the world, Rome presents a particular challenge for visitors: just as they begin to feel smitten by the city, they realize they don&rsquo;t have time to see more than a fraction of its treasures. Explore all the glories of Rome that you can, from Ancient Rome and the Vatican to Piazza Navona and Trastevere.', 4, 'IMG_25AB7D-E390F7-5FB26C-1B0FD5-976D59-4DCAE9.jpg', '', '', 'D15', '2011-07-22 11:36:25', 6, 0, 0, 0, '', '', 1),
(34, 7, 'Istanbul: Memories and the City', 'Istanbul-Memories-and-the-City', '10.99', 'Blending reminiscence with history; family photographs with portraits of poets and pashas; art criticism, metaphysical musing, and, now and again, a fanciful tale, Orhan Pamuk invents an ingenious form to evoke his lifelong home, the city that forged his imagination.', 'A portrait, by turns intimate and panoramic, of one of the world&rsquo;s great cities, by its foremost man of letters, author of the acclaimed novels&amp;nbsp;&lt;em&gt;Snow&lt;/em&gt;&amp;nbsp;and&amp;nbsp;&lt;em&gt;My Name Is Red&lt;/em&gt;.\r\n&lt;p&gt;Blending reminiscence with history; family photographs with portraits of poets and pashas; art criticism, metaphysical musing, and, now and again, a fanciful tale, Orhan Pamuk invents an ingenious form to evoke his lifelong home, the city that forged his imagination. &lt;br/&gt;\r\n  &lt;br/&gt;\r\n  He begins with his childhood among the eccentric extended Pamuk family in the dusty, carpeted, and hermetically sealed apartment building they shared. In this place came his first intimations of the melancholy awareness that binds all residents of his city together: that of living in the seat of ruined imperial glories, in a country trying to become &ldquo;modern&rdquo; at the dizzying crossroads of East and West. This elegiac communal spirit overhangs Pamuk&rsquo;s reflections as he introduces the writers and painters (among the latter, most particularly the German Antoine-Ignace Melling) through whose eyes he came to see Istanbul. &lt;br/&gt;\r\n  &lt;br/&gt;\r\n  Against a background of shattered monuments, neglected villas, ghostly backstreets, and, above all, the fabled waters of the Bosphorus, he presents the interplay of his budding sense of place with that of his predecessors. And he charts the evolution of a rich, sometimes macabre, imaginative life, which furnished a daydreaming boy refuge from family discord and inner turmoil, and which would continue to serve the famous writer he was to become. It was, and remains, a life fed by the changing microcosm of the apartment building and, even more, the beckoning kaleidoscope beyond its walls.&lt;/p&gt;\r\n&lt;p&gt;As much a portrait of the artist as a young man as it is an oneiric Joycean map of the city,&amp;nbsp;&lt;em&gt;Istanbul&lt;/em&gt;&amp;nbsp;is a masterful evocation of its subject through the idiosyncrasies of direct experience as much as the power of myth--the dazzling book Pamuk was born to write.&lt;/p&gt;', 4, 'IMG_ACFD51-E3DA7B-271ADE-482DC9-AC3511-D24D54.jpg', '', '', 'D40', '2011-07-22 11:39:22', 6, 0, 0, 0, '', '', 1),
(35, 7, 'Getting Stoned with Savages', 'Getting-Stoned-with-Savages', '0.00', 'With The Sex Lives of Cannibals, Maarten Troost established himself as one of the most engaging and original travel writers around. Getting Stoned with Savagesagain reveals his wry wit and infectious joy of discovery in a side-splittingly funny account of life in the farthest reaches of the world.', 'With&amp;nbsp;&lt;em&gt;The Sex Lives of Cannibals&lt;/em&gt;, Maarten Troost established himself as one of the most engaging and original travel writers around.&amp;nbsp;&lt;em&gt;Getting Stoned with Savages&lt;/em&gt;again reveals his wry wit and infectious joy of discovery in a side-splittingly funny account of life in the farthest reaches of the world. After two grueling years on the island of Tarawa, battling feral dogs, machete-wielding neighbors, and a lack of beer on a daily basis, Maarten Troost was in no hurry to return to the South Pacific. &lt;br/&gt;\r\n&lt;br/&gt;\r\nBut as time went on, he realized he felt remarkably out of place among the trappings of twenty-first-century America. When he found himself holding down a job&mdash;one that might possibly lead to a career&mdash;he knew it was time for him and his wife, Sylvia, to repack their bags and set off for parts unknown.&lt;br/&gt;\r\n&lt;em&gt;&lt;br/&gt;\r\nGetting Stoned with Savages&lt;/em&gt;&amp;nbsp;tells the hilarious story of Troost&rsquo;s time on Vanuatu&mdash;a rugged cluster of islands where the natives gorge themselves on kava and are still known to &ldquo;eat the man.&rdquo; Falling into one amusing misadventure after another, Troost struggles against typhoons, earthquakes, and giant centipedes and soon finds himself swept up in the laid-back, clothing-optional lifestyle of the islanders. &lt;br/&gt;\r\n&lt;br/&gt;\r\nWhen Sylvia gets pregnant, they decamp for slightly-more-civilized Fiji, a fallen paradise where the local chiefs can be found watching rugby in the house next door. And as they contend with new parenthood in a country rife with prostitutes and government coups, their son begins to take quite naturally to island living&mdash;in complete contrast to his dad.', 5, 'IMG_FE7611-90078A-C5E708-7BAE86-D4E0C8-C98A8E.jpg', '', '', '40', '2011-07-22 11:42:18', 13, 0, 0, 3, '', '', 1),
(36, 7, 'A Family&#039;s Adventure at Sea', 'A-Familys-Adventure-at-Sea', '11.99', 'John and Jean had hoped to use the trip as a teaching opportunity, with the Emerald Jane as a floating classroom in which to instruct their children in important lessons&ndash;not only about the natural world but about the beauty of human life when stripped down to its essence, far from the trappings of civilization.', '&lt;p&gt;An exhilarating true-life adventure of one family&rsquo;s extraordinary sea voyage of self-discovery and survival, tragedy and triumph&lt;/p&gt;\r\n&lt;p&gt;Successful businessman John Silverwood and his wife, Jean, both experienced sailors, decided the time was right to give their four children a taste of thrilling life on the high seas. And indeed their journey aboard the fifty-five-foot catamaran Emerald Jane would have many extraordinary and profound moments, whether it was the peaceful late-night watches John enjoyed under the stunning celestial sky or the elation shared by the whole family at the sight of blissful pods of dolphin and migrating tortoises. John and Jean had hoped to use the trip as a teaching opportunity, with theEmerald Jane as a floating classroom in which to instruct their children in important lessons&ndash;not only about the natural world but about the beauty of human life when stripped down to its essence, far from the trappings of civilization.&lt;/p&gt;\r\n&lt;p&gt;Yet rather than flourishing amid the new freedoms and responsibilities thrust upon them, the children were sometimes confused, frightened, resentful. The two oldest, fourteen-year-old Ben and twelve-year-old Amelia, missed their friends and the comfortable life left behind in San Diego, while the two youngest, Jack, seven, and Camille, three, picked up on the stressful currents running above and below the surface&ndash;for throughout the journey, the Silverwood family found its bonds tested as never before.&lt;/p&gt;\r\n&lt;p&gt;John and Jean, whose marriage had weathered its share of storms, would wonder again if they had taken on too much as the physical, emotional, and financial strains of caring for the expensive catamaran and their children brought old resentments to the surface.&lt;/p&gt;\r\n&lt;p&gt;John&rsquo;s dream trip that began on Long Island Sound ended almost two years later as a nightmare in treacherous waters off a remote atoll in French Polynesia, where, in an explosion of awesome violence, the terrifying brunt of the ocean&rsquo;s anger fell upon the Emerald Jane.&lt;/p&gt;\r\n&lt;p&gt;Gradually, in the crucible of the sea, a stronger, more closely knit unit was forged. The Silverwoods became a crew. Then they became a family again. But just as it seemed to them that they had mastered every challenge, their world was shattered in a split-second of unimaginable horror. Now their real challenge began, forcing them to fight for their very lives.&lt;/p&gt;\r\n', 5, 'IMG_886B43-7DF7CC-61B22E-C6CDDE-832E46-A6CD1D.jpg', '', '', '60', '2011-07-22 11:43:36', 27, 1, 0, 4, '', '', 1),
(37, 7, 'Fodor&#039;s Switzerland', 'Fodors-Switzerland', '11.99', 'Get inspired and plan your next trip with Fodor&#039;s ebook travel guide to Switzerland (including Z&uuml;rich, Eastern Switzerland and Liechtenstein, Graub&uuml;nden, Ticino, Luzern and Central Switzerland, Basel, Fribourg and Neuch&acirc;tel, Bern, Berner Oberland, Valais, Vaud, and Geneva).', 'Get inspired and plan your next trip with Fodor&rsquo;s ebook travel guide to Switzerland (including Z&uuml;rich, Eastern Switzerland and Liechtenstein, Graub&uuml;nden, Ticino&lt;strong&gt;,&amp;nbsp;&lt;/strong&gt;Luzern and Central Switzerland, Basel, Fribourg and Neuch&acirc;tel, Bern, Berner Oberland, Valais, Vaud, and Geneva).&lt;strong&gt;&lt;/strong&gt;&lt;br/&gt;\r\n&lt;strong&gt;&lt;br/&gt;\r\nWhat&rsquo;s Covered? Get to Know Switzerland&lt;/strong&gt;: Z&uuml;rich is surprisingly small, but its wealth of cultural riches&mdash;like luxurious Alstadt (Old Town), Grossm&uuml;nster cathedral, and the modern art at the B&uuml;hrle Museum&mdash;make up for its size. East of Z&uuml;rich, discover the old Rhine city of Schaffhausen and its medieval frescoes, the busy textile center of St. Gallen, and princely Liechtenstein.&lt;br/&gt;\r\n&lt;br/&gt;\r\nIn Graub&uuml;nden, take the gorgeous train ride to Arosa, visit Heidi country in Maienfeld, or ski and be seen in glitzy St. Moritz. Ticino&rsquo;s lakes, like the beauteous Lugano, serene Locarno, and elegant Ascona, are perhaps its greatest attraction. Central Switzerland is the most-visited region in the country, with Vierwaldst&auml;ttersee lake, R&uuml;tli Meadow, fabled Wilhelm Tell chapel, and the medieval town of Luzern.&lt;br/&gt;\r\n&lt;br/&gt;\r\nBasel is home to great modern art, at Museum Tinguely and Fondation Beyeler. The largely undiscovered cantons of Fribourg and Neuch&acirc;tel are a favorite western Switzerland getaway, with treasures like the picturesque castle at Gruy&egrave;res, lakeside Neuch&acirc;tel, and the medieval center of Fribourg. Bern, Switzerland&rsquo;s federal capital, offers famed sandstone arcades, painted fountains, the Zytglogge performing mechanical clock, the Gothic M&uuml;nster, and the art-filled Zentrum Paul Klee.&lt;br/&gt;\r\n&lt;br/&gt;\r\nBerner Oberland, a summit of summits, includes the peaks of Eiger, M&ouml;nch, and Jungfrau as well as glam Gstaad. Valais is home to the country&#039;s most photographed icon, the Matterhorn, in Zermatt. Don&rsquo;t miss the resort luxury of Saas-Fee, Verbier, and Crans-Montana. Vaud is centered around Lac L&eacute;man (Lake Geneva) and harbors alpine villages, glamorous lake resorts, and verdant vineyards. Be sure to visit the Old Town and hyperactive waterfront of Lausanne, harbor-front Vevey, Riviera-like Montreux, and Switzerland&rsquo;s most fabled castle, Ch&acirc;teau de Chillon. &lt;br/&gt;', 9, 'IMG_E125B0-A050C3-EF9680-40B9C8-FAF328-B419B2.jpg', '', '', 'D60', '2011-07-22 11:45:50', 43, 0, 1, 5, '', '', 1),
(38, 7, 'India: A Million Mutinies Now', 'India-A-Million-Mutinies-Now', '2.99', 'Arising out of Naipaul&#039;s lifelong obsession and passion for a country that is at once his and totally alien, India: A Million Mutinies Now relates the stories of many of the people he met traveling there more than fifty years ago.', '&lt;p&gt;Nobel laureate V. S. Naipaul&rsquo;s impassioned and prescient travelogue of his journeys through his ancestral homeland, with a new preface by the author.&lt;br/&gt;\r\n  &lt;br/&gt;\r\n  Arising out of Naipaul&rsquo;s lifelong obsession and passion for a country that is at once his and totally alien,&amp;nbsp;&lt;em&gt;India: A Million Mutinies Now&amp;nbsp;&lt;/em&gt;relates the stories of many of the people he met traveling there more than fifty years ago. He explores how they have been steered by the innumerable frictions present in Indian society&mdash;the contradictions and compromises of religious faith, the whim and chaos of random political forces. &lt;br/&gt;\r\n  &lt;br/&gt;\r\n  This book represents Naipaul&rsquo;s last word on his homeland, complementing his two other India travelogues,&amp;nbsp;&lt;em&gt;An Area of Darkness&lt;/em&gt;and&amp;nbsp;&lt;em&gt;India: A Wounded Civilization&lt;/em&gt;.&lt;/p&gt;\r\n&lt;h4&gt;Annotation&lt;/h4&gt;\r\nNaipaul, of Indian heritage, was born and raised in Trinidad, but he recognized that it was his ancestral culture that governed who he was and how he thought. In this passionate portrait of a culture, a society, and a country, he returns to India, a nation in turmoil.', 10, 'IMG_D816E9-31B45A-B4BCA4-A08089-9F264D-A1DAA6.jpg', '', '', 'D60', '2011-07-22 11:48:02', 25, 2, 0, 3, '', '', 1),
(39, 7, 'Life on a Very Small Island', 'Life-on-a-Very-Small-Island', '6.99', 'After seventeen years at sea, Linda Greenlaw figured it was time to take a break from her career as a swordboat captain. She felt she needed to return to Isle au Haut - a tiny island seven miles from the Maine coast with a population of 70 year-round residents, 30 of whom were her relatives.', '&lt;p&gt;After seventeen years at sea, Linda Greenlaw figured it was time to take a break from her career as a swordboat captain. She felt she needed to return to Isle au Haut - a tiny island seven miles from the Maine coast with a population of 70 year-round residents, 30 of whom were her relatives. She would pursue a simpler life; move back in with her parents and get to know them again; become a professional lobsterman; and find a guy, build a house, have kids, and settle down.&lt;/p&gt;\r\n&lt;p&gt;But all doesn&#039;t go as planned. The lobsters resolutely refuse to crawl out from under their rocks and into the traps she and her stern man (AKA, her father) have painstakingly set. Her fellow Islanders, an extraordinary collection of characters, draw her into their bizarre Island intrigues. &lt;br/&gt;&lt;br/&gt;Guys prove even more elusive than lobsters. And as mainlanders increasingly fish waters that are supposed to be reserved for Islanders, she realizes the that the Island might be heading for a &quot;gear war,&quot; a series of attacks that had in the past escalated from sabotage of equipment to extreme violence.&lt;/p&gt;\r\n&lt;p&gt;Then, just when she thinks things couldn&#039;t get much worse, something happens that forces her to reevaluate everything she thought she knew about life, luck, and lobsters.&lt;/p&gt;', 11, 'IMG_E822DD-BAF049-275E36-EE6B10-71CF6E-FAB571.jpg', 'AUD_424C57-435E7E-5B3CB7-561936-045879-F2B2BD.mp3', 'XSGBVzeBUbk', '100', '2011-07-22 11:49:33', 513, 16, 6, 14, '', '', 1);

--
-- Dumping data for table `tags`
--

INSERT INTO `tags` (`pid`, `tag`) VALUES
(39, 'war'),
(39, 'lobster'),
(39, 'life'),
(39, 'island'),
(39, 'greenlaw'),
(39, 'gear'),
(39, 'chronicles');

--
-- Dumping data for table `transactions`
--

INSERT INTO `transactions` (`id`, `txn_id`, `pid`, `uid`, `downloads`, `file_date`, `ip`, `created`, `payer_email`, `payer_status`, `item_qty`, `price`, `mc_fee`, `currency`, `pp`, `memo`, `status`, `active`) VALUES
(1, '', 1, 1, 13, 1225200679, NULL, '2011-06-29 08:27:14', 'webmaster@myemail.com', 'verified', 1, '19.99', '0.00', 'USD', 'PayPal', 'This is a note section', 1, 1),
(2, '', 2, 1, 15, 1225200679, NULL, '2011-07-27 08:27:14', 'webmaster@myemail.com', 'verified', 1, '29.99', '0.00', 'USD', 'MoneyBookers', NULL, 1, 1),
(3, '', 32, 1, 7, 1267485224, NULL, '2011-07-01 18:13:44', 'webmaster@myemail.com', 'verified', 1, '1.00', '0.00', 'USD', 'PayPal', 'this is a note...', 1, 1),
(4, '', 4, 1, 5, 1268412378, NULL, '2011-07-12 11:46:18', 'webmaster@myemail.com', 'verified', 1, '1.99', '0.00', 'USD', 'AlertPay', 'This is client note', 1, 1),
(5, '123', 1, 1, 0, 1268892404, NULL, '2011-07-14 12:10:15', 'webmaster@myemail.com', 'verified', 1, '8.99', '0.00', 'USD', 'MoneyBookers', NULL, 1, 1);