--
-- Host: localhost    Database: turnapaige
-- ------------------------------------------------------


--
-- Table structure for table `Category`
--

CREATE TABLE `Category` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `protected` int(11) NOT NULL DEFAULT '0',
  `display` int(11) NOT NULL DEFAULT '0',
  `next` int(11) NOT NULL DEFAULT '0',
  `child` int(11) NOT NULL DEFAULT '0',
  `description` blob,
  `short_description` blob,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Category`
--

INSERT INTO `Category` VALUES (1,0,0,0,2,NULL,NULL,'Top Level',NULL,0),(2,0,3,0,3,'',NULL,'Online Catalog','',0),(3,0,3,0,0,'',NULL,'Our Books','TRMBeveledLogo.jpg',0);

--
-- Table structure for table `Inventory`
--

CREATE TABLE `Inventory` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `categoryID` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `categoryID` (`categoryID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Inventory`
--

INSERT INTO `Inventory` VALUES (32,3,3),(22,4,3),(31,5,3);

--
-- Table structure for table `Invoice`
--

CREATE TABLE `Invoice` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `purchasedby` int(11) NOT NULL DEFAULT '0',
  `deliverto` int(11) NOT NULL DEFAULT '0',
  `processed` int(11) NOT NULL DEFAULT '0',
  `shiptype` varchar(50) DEFAULT NULL,
  `shipcost` double(8,2) NOT NULL DEFAULT '0.00',
  `comment` blob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Invoice`
--

INSERT INTO `Invoice` VALUES (1,'2008-04-10 14:28:10',1,1,1,'Shipping',0.00,'',NULL,NULL),(2,'2008-04-10 15:49:44',2,2,1,'Shipping',0.00,'',NULL,NULL),(3,'2008-11-29 09:37:02',22,22,1,'Shipping',0.00,'',19.95,1.59),(4,'2008-12-07 17:01:44',23,23,1,'Shipping',0.00,'If possible I would like to have the author and the illustrator autograph our copy. Tom is my cousin and fellow former Jolly Troll employee!',39.95,3.18),(5,'2008-12-18 16:25:22',24,25,1,'Shipping',0.00,'',39.95,3.18),(6,'2008-12-18 16:28:56',26,27,1,'Shipping',0.00,'',39.95,3.18),(7,'2008-12-19 16:59:02',28,28,1,'Shipping',0.00,'',0.00,0.00),(8,'2009-11-25 09:58:25',61,61,1,'Shipping',0.00,'',19.95,1.59),(9,'2009-12-04 20:48:30',63,64,1,'Shipping',0.00,'',19.95,1.59);

--
-- Table structure for table `Page`
--

CREATE TABLE `Page` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `body` blob,
  `template` int(11) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT '0',
  `image` varchar(255) DEFAULT NULL,
  `label` varchar(50) DEFAULT NULL,
  `featured` varchar(255) DEFAULT NULL,
  `title` varchar(255) DEFAULT NULL,
  `linkname` varchar(50) DEFAULT NULL,
  `link` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=26 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Page`
--

INSERT INTO `Page` VALUES (1,'<font size=3><center>\r\n506 N. Criss Street, Chandler, Arizona 85226<BR>\r\nTelephone: 602-690-8192  Fax:  480-946-1204<BR>  \r\n<a href=\"mailto:reedmoore@turnapaige.com?subject=General Information\">Email: reedmoore@turnapaige.com</a> <BR></font></center>\r\n\r\n\r\n<BR><BR><H1><FONT COLOR=\"#800080\">Welcome!</H1><BR>\r\n<I>Turnapaige & Reed Moore</I> is an independent publishing company that is dedicated to publishing books that enhance family traditions, lift one\'s spirits, and make life just a little more enjoyable.<BR>\r\n<BR>Please feel free to browse our website, order online, or contact us--we welcome your words of wisdom and encouragement.<BR><BR>\r\nThank you and Enjoy!<BR><BR> \r\n<BR>\r\n\r\n<P Align=\"center\"><a href=\"mailto:reedmoore@turnapaige.com?subject=Wholesale Inquiry\"><img src=\"http://www.turnapaige.com/Images/wholesale.jpg\" border=0 alt=\"Click Here to Get More Information\"></a><BR><BR>\r\n\r\n\r\n',2,0,'TRMBeveledLogo.jpg','','','',NULL,NULL),(2,'<I>Turnapaige & Reed Moore</I> is an independent publishing company that is dedicated to publishing books that enhance family traditions, lift one\'s spirits, and make life just a little more enjoyable.<BR>\r\n<BR>\r\nOur current titles include:<BR><BR>\r\n\r\n<Font Color=\"800080\"><ul>\r\n<li><I>The Christmas Pickle: A Christmas Folktale</I<BR>\r\n<li><I>The Heavenly Plan: A Tale of Angelic Events</i>.<BR>\r\n<li><I>The Littlest Camel:  And the Journey of the Three Kings</I>\r\n</font></ul><BR>',1,1,'TRMBeveledLogo.jpg',NULL,NULL,'About Us','About Us',NULL),(3,'<b>The Christmas Pickle</b> <BR>\r\n<I>A Christmas Folktale</I><BR>\r\nBy:  Judy Lee Aguiar<BR><BR>\r\n<B>Dedicated to all those who have wondered, \"Why is there a pickle on our Christmas Tree?\"</B> <BR><BR>The Christmas Pickle reveals the Legend behind the Tradition of hiding a pickle ornament on the Christmas tree, and is sure to become a Christmas Classic!<BR><BR>\r\n\r\nIn this charming tale, you\'ll join Petra on a royal quest through the beautiful Prussian Kingdom of Vlassika.  It\'s a heartwarming journey filled with compassion, determination, and courage—a compelling story for all ages.\r\n<BR><BR>\r\n \r\n<I>The Christmas Pickle</I> will thoroughly entertain you while learning about old-world Christmas traditions—like nutcrackers, incense smokers, and the making of glass ornaments.  <i>The Christmas Pickle</i> will add a new delight to your Christmas joy and family traditions.\r\n<BR><BR>\r\n<P align=\"center\"><img src=\"http://www.turnapaige.com/Images/pickle1.gif\"> \r\n\r\nHard Copy (5.5\" x 8.25\" Portrait)<br>\r\n160 pages with over 100 black & white illustrations<br>\r\nCopyright 2002 by Judy Lee Aguiar * All Rights Reserved</p align><P align=\"right\"><a href=\"http://www.turnapaige.com/pk4/store.pl?view_product=3\"><img src=\"http://www.turnapaige.com/Images/OrderNowButton.jpg\" border=0 alt=\"Click here to place your order\"></a></P align>\r\n\r\n\r\n',1,1,'ChristmasPickleTiltedImage.jpg',NULL,NULL,'The Christmas Pickle','The Christmas Pickle',NULL),(4,'<B>The Heavenly Plan</B><BR>\r\n<I>A Tale of Angelic Events</I><BR>\r\nBy:  Judy Lee Aguiar<BR><BR>\r\n\r\n<B>DISCOVER THE SECRET THAT\r\nEVERY ANGEL KNOWS!<Br><BR>\r\n</B>\r\nFind out how the angels watch, guide,\r\nand protect everyone one of us.\r\n<I>The Heavenly Plan</i> allows us a glimpse\r\nof how the angels devised a plan:<br><BR>\r\n<Center>\"For the caring and guidance,<BR>\r\nOf the beings called,\r\n\'Man.\'\"</Center><br><BR>\r\n<I>The Heavenly Plan</I> will warm your heart\r\nand you’ll laugh with delight when you\r\ndiscover the secret.<BR><BR>\r\n<I>The Heavenly Plan</I> is an enchantment\r\nfor all ages. Its uplifting message is\r\nfor everyone— and is sure to become a\r\ntreasured tale to be enjoyed time and again.<BR>\r\n<BR>\r\n<P align=\"center\"><img src=\"http://www.turnapaige.com/Images/angel1.gif\"> \r\nHard Copy (5.5\" x 8.25\" Portrait)<br>\r\n91 pages with over 50 black & white illustrations<br>\r\nCopyright 2005 by Judy Lee Aguiar * All Rights Reserved<BR></p align><P align=\"right\"><a href=\"http://www.turnapaige.com/pk4/store.pl?view_product=4\"><img src=\"http://www.turnapaige.com/Images/OrderNowButton.jpg\" border=0 alt=\"Click here to place your order\"></a></P align>\r\n\r\n',1,1,'heavenlycovertilted400.jpg',NULL,NULL,'The Heavenly Plan','The Heavenly Plan',NULL),(5,'<b>The Littlest Camel</b><BR>\r\n<i>And the Journey of the Three Kings</i><BR>\r\n<BR>\r\nBy: Judy Lee Aguiar<BR>\r\nIllustrations by Thomas Rodriguez<BR>\r\n<BR>\r\n<BR>\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/Benjamin_Franklin_Finalist.jpg\"><BR><BR>\r\n<b>Finalist of the 2009 Benjamin Franklin Awards\r\n</b><BR><BR>\r\n<i>The Littlest Camel</i> has been nominated and chosen as a finalist for the 2009 Benjamin Franklin Awards in the Religion category. The final awards ceremony will take place in New York City on May 28, 2009, during the 2009 BOOK EXPO AMERICA. Gold, Silver, and Bronze winners will be announced at the event. <BR><BR>\r\n\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/Eric-Hoffer-Finalist-Banner.jpg\"><BR><BR><b>2009 Eric Hoffer Finalist for the da Vinci Eye Award for Best Cover</b><BR><BR><P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/HAdaVinci[1].gif\"><BR><BR>\r\n\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/seal_winner.jpg\"><BR><BR><b>National Best Book 2008 Award--Religion: Christian Inspirational</b><BR><BR>\r\n\r\n\r\n<b>An Epic Christmas Story for the Whole Family to Enjoy!</b><BR><BR>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is a journey over the Twelve Days of Christmas to see the Boy King—as seen through the littlest camel\'s eyes.  Sandy is the littlest camel in the caravan of the Three Kings.  Although Sandy is still very young and small, King Melchior takes him along on the journey.  Sandy learns how to adjust his stride to carry a pack, recognize the smell of water in an oasis, and sense approaching danger, among many other lessons.<BR><BR>  \r\n\r\nOn their journey, Sandy makes some very special friends and together they endure many hardships: perilous terrain, harsh weather, ferocious predators, and dangerous intrigues.  It is Sandy’s faith in God’s love that helps guide and inspire the entire caravan on their journey.\r\n<BR><BR> \r\n<b>A New Holiday Tradition for Twelfth Night</B><BR><BR>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is an Heirloom Christmas book that is written with the idea that a family will be reading it <u>every</u> Christmas season—a chapter a night—over the Twelve days of Christmas through Epiphany. <BR><BR> \r\n\r\nThe story also introduces a Twelfth Night tradition that includes gathering clothing, blankets, toys, and food for those who are in need, and extends the Christmas Spirit beyond the intimate family to the community at large.\r\n<BR><BR>\r\nExcerpt from, <i>The Littlest Camel: And the Journey of the Three Kings</i>:<BR><BR>\r\n\r\n<dir><i><b>“[T]hose who had gifts to give, \r\nplaced a star in their window or on their door to signal that they had something to give…many also placed a bucket of water for Sandy to drink…He would come to their homes, guided by the star, pick up their charitable gifts, and deliver them to those who desperately needed them.”</dir></i></b>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is a beautiful, high-quality book with amazing four-colour illustrations throughout on photo-quality paper.   It is a large format (9” by 12”) book with 176 pages and over 100 illustrations that are bound in a glossy hard-back cover that will be a handsome addition to anyone’s Christmas book collection. <BR><BR> \r\n\r\n\r\nJoin Sandy on a journey over the twelve days of Christmas to see the Boy King—as seen through the littlest camel\'s eyes.  <BR><BR>\r\nRead a chapter a night, over the Twelve Days of Christmas and Celebrate the Day of Three Kings (Epiphany--January 6th) the way it was meant to be celebrated, with friends and family.\r\n<BR><BR>\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/jerry_camel_walking_md_clr.gif\">Hard Cover (9\" x 12\" Portrait)<BR>\r\n176 pages with over 100 Full Color Illustrations<BR><BR>\r\nCopyright 2008 * Judy Lee Aguiar * All Right Reserved<BR><BR>\r\n\r\n \r\n<b>ORDER YOUR SIGNED, FIRST EDITION COPY NOW!</B> <BR><BR>\r\nShipments will begin April 20, 2008.<BR></p align><P align=\"right\"><a href=\"http://www.turnapaige.com/pk4/store.pl?view_product=5\"><img src=\"http://www.turnapaige.com/Images/OrderNowButton.jpg\" border=0 alt=\"Click here to place your order\"></a></P align><P>',1,1,'LittlestCamelTilted450.jpg',NULL,NULL,'The Littlest Camel: And the Journey of the Three Kings','The Littlest Camel',NULL),(6,'\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/benjamin_Franklin_Finalist.jpg\"><BR><BR><\r\n<b>Finalist of the 2009 Benjamin Franklin Awards\r\n</b><BR><BR>\r\n<i>The Littlest Camel</i> has been nominated and chosen as a finalist for the 2009 Benjamin Franklin Awards in the Religion category. The final awards ceremony will take place in New York City on May 28, 2009, during the 2009 BOOK EXPO AMERICA. Gold, Silver, and Bronze winners will be announced at the event. <BR><BR>\r\n<BR><BR>\r\n<BR>\r\n<center><img src=\"http://www.turnapaige.com/Images/calendar.gif\"></center>',1,1,'fireworks10.gif',NULL,NULL,'Events','Events',NULL),(7,'Currently, we are making preparations for our upcoming release of our third title, <I>The Littlest Camel: And the Journey of the Three Kings</I> on April 20, 2008. <BR><BR>\r\nAdditionally, we are in various production stages for our next two titles:<BR><BR>\r\n<ul>\r\n<li><I>The Christmas Spider</I>--a retelling of the Christmas classic that will be an addition to the ornament legend series, which includes the previously published title, <I>The Christmas Pickle</I>. <BR> <BR>\r\n<li><I>Jingle & Jangle: A Tale of Two Wayward Sleighbells</i>--will include a new tradition for the Christmas Season, as well as a fresh look at the role of Santa\'s sleighbells.<BR><BR><Font Color=\"800080\">Be sure to keep a look out for what new from <I>Turnapaige & Reed Moore</I>.</font>\r\n</ul> <BR><BR>\r\n\r\n<P align=\"right\"><img src=\"http://www.turnapaige.com/Images/bookstore.gif\"></p align>\r\n<BR><BR>\r\n',1,1,'schoolbooks.gif',NULL,NULL,'Upcoming Titles','Upcoming Titles',NULL),(8,NULL,0,2,NULL,NULL,NULL,NULL,'<Font size=4><bold>HOME</bold></Font>','http://www.turnapaige.com/index.html'),(9,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(10,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(11,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(12,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(13,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(14,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(15,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(16,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(17,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(18,'<BR>We ship USPS Media Mail and USPS Priority Mail.  USPS Media Mail Ground can take 2-9 working days to deliver.<BR><BR>\r\nDELIVERY CHARGES<BR><BR>Standard USPS Online Rates Apply<BR>\r\n\r\n<BR>If you request Special Services such as Overnight, 2-Day, or 3-Day Delivery, the rates increase and you will be charged accordingly.  Also, the rate may change if the item is of unusual weight or size.  You can select Special Services by indicating them in the Comment Section of the Order Form that follows.\r\n<BR>\r\n<BR>Overseas shipments are sent per Parcel Post or Global Express, Insured and charged accordingly.  Foreign Customs may apply.\r\n<BR><BR>\r\n\r\nIf you receive your shipment and an item is damaged, please retain ALL packaging materials for USPS or other shipper to inspect.</font></b><BR><BR>\r\nNotice of Availability<BR><BR>\r\nAll orders are subject to availability.  Typographical errors are subject to correction.  <BR><BR>\r\n\r\nYour shipment will be hand-inspected and carefully packed by skilled and experienced packers.  Under normal handling, it should reach you in the same perfect condition as it left our premises.  \r\n<BR><BR>\r\nYour package is sent with a reputable carrier and is fully insured for the value of the contents. \r\n<BR><BR> After your package leaves our premises, its SAFE, ACCUARATE, AND TIMELY DELIVERY is the SOLE RESPONSIBILITY OF THE CARRIER.  \r\n<BR><BR>\r\n\r\nWE DO NOT PROVIDE ANY GUARANTEE REGARDING DELIVERY SAFETY, ACCURACY, OR TIMELINESS.\r\n<BR><BR>\r\nACCURATE/TIMELY DELIVERY and ANY/ALL DAMAGES ARE THE SOLE REPONSIBILITY OF THE CARRIER who is liable for its SAFE, ACCUARATE, and TIMELY transport.  This includes any concealed damages that may have been caused by shock and vibration.\r\n<BR><BR>\r\nIF YOU DO NOT RECEIVE YOUR PACKAGE IN A TIMELY MANNER, IMMEDIATELY CONTACT THE CARRIER.\r\n<BR><BR>\r\nWHEN YOU RECEIVE YOUR PACKAGE:\r\n<BR><BR>\r\n1.  If you notice EXTERNAL DAMAGE to the package at the time of delivery, please ask the carrier delivery person to make a note of it.\r\n<BR><BR>\r\n2.  IMMEDIATELY UNPACK and EXAMINE the contents upon receipt.  If you discover damage, IMMEDIATELY NOTIFY US.  The carrier allows a MAXIMUM OF 15 DAYS AFTER THE RECEIPT OF GOODS for you to file a claim.\r\n<BR><BR>\r\nThey will FAX us a claim form and we will provide them with the necessary information.  They will contact you to inspect the damaged merchandise and packaging.\r\n<BR><BR>\r\n3.  SAVE ALL PACKAGING MATERIALS for inspection.  This include the outer carton, packaging popcorn, tissue, paper, bubble wrap, inner containers, and the damaged merchandise. This is required by the carrier for you to receive credit for your claim.\r\n<BR><BR><c>\r\nREMEMBER SAVE EVERYTHING—DO NOT RETURN ANY MERCHANDISE DIRECTLY TO US.</C><br><br> \r\nIf you return it to us, no claim can be filed by any party and no replacement or refund can be made.\r\n<BR><br>\r\nThank you for your cooperation.  We sincerely hope that no problems will arise, but if they do, we will be happy to assist you by providing tracking numbers and content/cost information for claim purposes.  \r\n<BR><BR>\r\nDamaged Items are covered under the insurance of the carrier and is the carrier\'s responsibility.\r\n<BR></f></font>',1,1,'mailman.gif',NULL,NULL,'Shipping','Shipping',NULL),(19,'<H1>About the Author</H1><BR>\r\n\r\nJudy Lee Maasch-Aguiar was born in Phoenix, Arizona on August 6, 1959.  Her parents, Arthur and Margrit Maasch and her sister, Janny, were born in Germany.  Judy grew up as first generation American—speaking two languages and trying to cling to the roots of her German heritage that was rich with old world customs and traditions.<BR><BR>\r\n\r\nJudy lived most of her life in Arizona, except for two years in high school when she lived in her family’s hometown of Karlsruhe, Germany.  It was in Karlsruhe, Germany where Judy experienced her first “White Christmas,” complete with ringing church bells at midnight—quite a contrast to the “original Christmas” of Arizona with sand and palm trees.\r\n<BR><BR>\r\nJudy graduated from Arizona State University and began her writing career as a Technical Writer/Multimedia Specialist in the Semiconductor Industry.  After 20 years of writing nonfiction, Judy’s writing career flourished with the debut of her first fiction book, The Christmas Pickle—A Christmas Folktale that reveals the Legend behind the Tradition of hiding a pickle ornament on the Christmas tree.  \r\n<BR><BR>\r\nJudy’s second book, The Heavenly Plan published in December of 2005 and has met with notable success.  Its uplifting message and playful imagery represents her love of life and her unshakable faith in angels and essence of “goodness” that surround us all.\r\n<BR><BR>\r\nThe Littlest Camel is her third fiction book.  It is a Christmas story that takes you on a remarkable and heart-warming adventure through the 12 days of Christmas as seen through the eyes of the littlest camel of the caravan.\r\n<BR><BR>\r\nIn addition to being a writer, Judy Aguiar is the owner of The European Christmas Market in Scottsdale, Arizona—making her well known in the community as an authority on Christmas traditions.  Local specialty clubs and charity organizations often request Judy as a guest speaker during the holiday season, and she has made numerous special appearances on the local news stations providing Christmas decorating tips and ideas. \r\n<BR><BR>\r\nIn addition, Judy participated as an expert on Christmas traditions and symbols in a nationwide curriculum broadcast for Elementary schools as presented by Prentice-Hall, Inc and the Educational Management Group. \r\n<BR><BR>\r\nJudy is busy preparing her next couple of books for publication, which include Jingle & Jangle—A Tale of Two Wayward Sleigh Bells and a retelling of the classic legend, The Christmas Spider.  \r\n<BR<BR>',1,1,'AuthorPhotoInterior2.jpg',NULL,NULL,'','About the Author',NULL),(20,'Tom Rodriguez was born and raised in Minneapolis, Minnesota and moved to Phoenix, Arizona to attend Collins College in 1984.  He has remained in the Phoenix area ever since and has truly made Arizona his home.<BR><BR>  \r\nTom began his graphic design career over 20 years ago, first working for private companies and later as a graphic artist for the City of Phoenix.  In 1997, Tom founded his own firm, TJR Designs (<a href=http://www.tjrdesigns.com>www.tjrdesigns.com</a>) in Phoenix, Arizona.  Through the years, the range of Tom’s design work has extended from logos, packaging design, and advertisements to promotional materials such as brochures, posters, and even billboards.<BR><BR>\r\nTJR Designs has a varied clientele including several small companies and assorted non-profit organizations such as The American Heart Association, Hospice of Arizona, Phoenix Guide Dog Raisers, Brother-to-Brother International, and the All Saints Catholic Newman Center.\r\nThe most notable of Tom’s patrons is Janet Napolitano (Arizona’s 21st Governor) for whom Tom designed a high-energy logo with a softer feel for her gubernatorial campaign.  Tom has since created several promotional pieces for The Tempe Governors’ Ball (benefiting local health organizations) as well as number of promotional materials for the cities of Phoenix, Chandler, Surprise, and El Mirage.<BR><BR>\r\nIn 2002, Turnapaige and Reed Moore commissioned Tom to design the cover for <I>The Christmas Pickle</I>, a book by Judy Aguiar and in 2005, Tom completed the cover and interior design for Judy Aguiar’s second book, \r\n<i>The Heavenly Plan</i>.  When Judy approached Tom with <i>The Littlest Camel</i>, Tom wanted to do much more.<BR><BR>\r\nA graphic artist by profession, Tom Rodriguez’ first love has always been illustration.  While he has frequently used his drawing talents in his graphic design work, <i>The Littlest Camel</i> was his first opportunity to illustrate a book in its entirety.  \r\n\r\n<BR><BR>\r\nAs a devout Catholic Christian, Tom approached this opportunity with great passion and joy.  Tom and Judy worked very closely together to capture the characters’ unique personalities in each illustration.<BR<BR>  \r\nAs an artist, Tom enjoys painting in oils, but he considers pencil illustration his forté.  Tom first used pencil to sketch and finalize all the illustrations featured in <i>The Littlest Camel</I>.  Tom then used the computer and several digital techniques to achieve a layered colorization of each vignette, resulting in a watercolor washed appearance with a rarely achieved depth of color. <BR><BR> \r\nTom married his wife, Julie in 1992 and in 1998, their son Michael was born.  In 2007, Michael was eight years old and he watched with great interest as <i>The Littlest Camel</i> came to life on paper, often asking about the fate of the littlest camel and his friends.  As a child, Michael eagerly looked forward to reading <i>The Littlest Camel</i> and expressed his hope that someday he would be able to share <i>The Littlest Camel</i> with his own children at Christmas time.\r\n',1,1,'Tom.jpg',NULL,NULL,'About the Illustrator','About the Illustrator',NULL),(21,'<P Align=\"center\"><a href=\"http://www.tjrdesigns.com\"><img src=\"http://www.turnapaige.com/Images/TJRDESIGNSBUTTON.jpg\" border=0 alt=\"Click Here to Access the TJR Designs Website\"></a><BR><BR>\r\n<P Align=\"center\"><a href=\"http://www.spannet.org\"><img src=\"http://www.turnapaige.com/Images/spanorg.jpg\" border=0 alt=\"Click Here to Access the SPAN Website\"></a><BR><BR>\r\n<a href=\"http://www.azbookpub.com\"><img src=\"http://www.turnapaige.com/Images/azbook.jpg\" border=0 alt=\"Click Here to Access the ABPA Website\"></a><BR><BR>\r\n<a href=\"http://www.cipabooks.com\"><img src=\"http://www.turnapaige.com/Images/CIPA.jpg\" border=0 alt=\"Click Here to Access the CIPA Website\"></a></P Align>\r\n\r\n<P Align=\"center\"><a href=\"http://www.europeanchristmas.com\"><img src=\"http://www.turnapaige.com/Images/EuropeanButton.jpg\" border=0 alt=\"Click Here to Access the European Christmas Website\"></a><BR><BR>\r\n\r\n<P Align=\"center\"><a href=\"http://www.theframeworkshop.com\"><img src=\"http://www.turnapaige.com/Images/frameworks.jpg\" border=0 alt=\"Click Here to Access the Frame Workshop Website\"></a><BR><BR>\r\n\r\n<P Align=\"center\"><a href=\"http://www.christmasinoldtown.com\"><img src=\"http://www.turnapaige.com/Images/newmexico.jpg\" border=0 alt=\"Click Here to Access the The Christmas Shop Website\"></a><BR><BR>\r\n\r\n<P Align=\"center\"><a href=\"http://www.bronners.com\"><img src=\"http://www.turnapaige.com/Images/bronners.jpg\" border=0 alt=\"Click Here to Access the Bronner\'s Website\"></a><BR><BR>\r\n\r\n<P Align=\"center\"><a href=\"http://www.christmasinprescott.com/index.html\"><img src=\"http://www.turnapaige.com/Images/PrescottChristmas.jpg\" border=0 alt=\"Click Here to Access the Christmas in Prescott website\"></a><BR><BR>\r\n\r\n<P Align=\"center\"><a href=\"http://www.tannenbaumshoppe.com/index.html\"><img src=\"http://www.turnapaige.com/Images/Tannenbaum.jpg\" border=0 alt=\"Click Here to Access the Tannenbaum Shoppe website\"></a><BR><BR>\r\n\r\n\r\n<P align=\"center\"><a href=\"http://www.animationplayhouse.com\"><img src=\"http://www.turnapaige.com/Images/AnimationPlayhouse.jpg\" border=0 alt=\"Click Here to Access the Animation Playhouse Website\"></a></P Align>\r\n',1,1,'',NULL,NULL,'Favorite Links','Favorite Links',NULL),(22,'\r\n<P Align=\"center\"><a href=\"mailto:reedmoore@turnapaige.com?subject=Wholesale Inquiry\"><img src=\"http://www.turnapaige.com/Images/wholesale.jpg\" border=0 alt=\"Click Here to Get More Information\"></a><BR><BR>\r\n\r\n',1,1,'',NULL,NULL,'Wholesale Inquiries','Wholesale',NULL),(25,'<b>The Littlest Camel</b><BR>\r\n<i>And the Journey of the Three Kings</i><BR>\r\n<BR>\r\nBy: Judy Lee Aguiar<BR>\r\nIllustrations by Thomas Rodriguez<BR>\r\n<BR>\r\n<BR>\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/Benjamin_Franklin_Finalist.jpg\"><BR><BR>\r\n<b>Finalist of the 2009 Benjamin Franklin Awards\r\n</b><BR><BR>\r\n<i>The Littlest Camel</i> has been nominated and chosen as a finalist for the 2009 Benjamin Franklin Awards in the Religion category. The final awards ceremony will take place in New York City on May 28, 2009, during the 2009 BOOK EXPO AMERICA. Gold, Silver, and Bronze winners will be announced at the event. <BR><BR>\r\n\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/Eric-Hoffer-Finalist-Banner.jpg\"><BR><BR><b>2009 Eric Hoffer Finalist for the da Vinci Eye Award for Best Cover</b><BR><BR><P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/Da_Vinci_Short_List.jpg\"><BR><BR>\r\n\r\n\r\n<P Align=\"Center\"><img src=\"http://www.turnapaige.com/Images/seal_winner.jpg\"><BR><BR><b>National Best Book 2008 Award--Religion: Christian Inspirational</b><BR><BR>\r\n\r\n',1,1,'LittlestCamelTilted450.jpg',NULL,NULL,'Awards & Honors','Awards & Honors',NULL),(23,'The staff at Turnapaige & Reed Moore is available to provide a variety of professional writing and editing services.  We have over thirty years of experience, and we are pleased to offer our expertise in writing, editing, and publishing.  Please call us at 602-690-8192 for information or email us at your convenience.<BR>\r\n<BR>\r\n<B>Writing & Editing Services</B><BR>\r\nAcademic Writing<BR>\r\nBiographies, Profiles, and Memoirs<BR>\r\nBusiness Writing<BR>\r\nCopywriting<BR>\r\nCritical Editing<BR>\r\nLegal Writing<BR>\r\nMarketing (Brochures, Newsletters, Press Releases)<BR>\r\nOnline Help<BR>\r\nPresentation and Training Materials<BR>\r\nProofreading<BR>\r\nPublishing<BR>\r\nReport Writing<BR>\r\nResume and Letter Writing<BR>\r\nScientific/Technical Writing<BR>\r\nStyle/Grammar Editing<BR>\r\nWeb Site Content Development<BR>\r\n<BR>\r\n<b>Our Prestigious and Satisfied Clientele:<BR></B>\r\nA & C Enercom<BR>\r\nAFM Chemical and Technical Products <BR>\r\nAmtech Systems Inc.<BR>\r\nConsolidated Edison<BR>\r\nCity of Surprise, Arizona<BR>\r\nHoneywell<BR>\r\nIntel Corporation<BR>\r\nJupiter Technology<BR>\r\nLong Island Lighting Company<BR>\r\nNational Semiconductor <BR>\r\nPhiladelphia Lighting Company<BR>\r\nSan Diego Lighting Company<BR>\r\nSkillSoft <BR>\r\nThe European Christmas Market<BR>\r\nThomson NETg<BR>\r\nU-Haul International<BR>\r\nWestech Systems, Inc.<BR>\r\n<BR>\r\n<B>Major Publications & Projects:<BR></B>\r\n1190 Facilities Management System Customization Reference Guide<BR>\r\n1190 Facilities Management System Operator\'s Guide<BR>\r\n1482 XY Table Instructor\'s Guide<BR>\r\n1482 XY Table Line Maintenance Training Manual<BR>\r\nAlliance 2000 System User\'s Guide<BR>\r\nApplication Monitor Online Help<BR>\r\nATMOSCAN Individual Boat Automated Loader (IBAL) Operator\'s Guide<BR>\r\nATMOSCAN Individual Boat Automated Loader (IBAL) Line Maintenance Guide<BR>\r\nBasic Host Communications Support-2 User\'s Guide<BR>\r\nBasic Host Communications Support-2 Technical Reference Manual<BR>\r\nBurn-In Instructor\'s Guide<BR>\r\nBurn-In Line Maintenance Training Manual<BR>\r\nCity of Surprise, Commercial Subdivision Application Guide<BR>\r\nCity of Surprise, Condominium Application Guide<BR>\r\nCity of Surprise, Correct Subdivision Plat Application Guide<BR>\r\nCity of Surprise, Final Plat Application Guide<BR>\r\nCity of Surprise, Glossary of Terms and Acronyms <BR>\r\nCity of Surprise, Minor Land Division Application Guide<BR>\r\nCity of Surprise, Online About Us <BR>\r\nCity of Surprise, Online Help Desk <BR>\r\nCity of Surprise, Online Reference Library <BR>\r\nCity of Surprise, Online Self-Service Center <BR>\r\nCity of Surprise, Preliminary Plat Application Guide<BR>\r\nCity of Surprise, Rural Subdivision Application Guide <BR>\r\nCity of Surprise, Site Plan Application Guide<BR>\r\nConsolidated Edison, EnerGraf System User\'s Guide<BR>\r\nConsolidated Edison, Tracking System User\'s Guide<BR>\r\nConsumers Power Company Residential Audit System, Version 2.00<BR>\r\nDCA IRMAtrac Network Sensor Installation Guide<BR>\r\nDCA IRMAtrac Network Sensor User Guide<BR>\r\nDocumentation Standards Guide<BR>\r\nDistributed Control of Batch Digesters (edit)<BR>\r\nDistributed Control of Continuous Digesters (edit)<BR>\r\nDry Stock Blending (edit)<BR>\r\nCalifone Portable Lectern Specifications<BR>\r\nCanon VR-20A VHS Recorder and VC-10A Video Camera Specifications<BR>\r\nColeman Crawdad Boat and Canoe Specifications<BR>\r\nElectric Pressure Washer Illustrated Parts Breakdown (IPB)<BR>\r\nF-350 Rear Wheel Bearing Installation and Adjustment<BR>\r\nFailure Analysis Training Manual<BR>\r\nFileReach MVS File Transfer Manager (MFTM) Installation and Configuration Guide<BR>\r\nFileReach MVS File Transfer Manager (MFTM) General Information Guide (edit)<BR>\r\nFileReach MVS File Transfer Manager (MFTM) Operator\'s Guide<BR>\r\nFileReach MVS File Transfer Manager (MFTM) Message Reference Guide<BR>\r\nGas Pressure Washer (GPW) Repair and Maintenance Service Manual<BR>\r\nHoneywell in Chemicals (edit)<BR>\r\nHoneywell in Electric Utilities (edit)<BR>\r\nHoneywell in Paper and Pulp (edit)<BR>\r\nHoneywell TDC 3000 System Overview (edit)<BR>\r\nHonda Repair and Maintenance Publications<BR>\r\nIBM PC Training Manual<BR>\r\nIntegrated Computer Network Systems, Marcel Dekker, Inc. Publishers (Copyright 1992)<BR>\r\nIntel How to Unpack (SCS PC Platform systems)<BR>\r\nIntel LANDesk Application Monitor Online Help<BR>\r\nIntel NetSight Network Management Concepts Training Course (Text, Foils, and Card Game)<BR>\r\nIntel NetSight Professional User\'s Guide (Network Analyzer in Ethernet & Token Ring Versions)<BR>\r\nIntel Professional Protocol Handbook (Hard-Copy and Hypertext)<BR>\r\nIntel NetSight Sentry User\'s Guide (Network Monitor in Ethernet & Token Ring Versions)<BR>\r\nIntel Multimedia Series Installation<BR>\r\nIntel Classic R-Series Installation<BR>\r\nIntel Classic S-Series Installation <BR>\r\nIntel X-Series Deskside Installation <BR>\r\nIntel X-Series Desktop Installation <BR>\r\nIntel X-Series Desktop Online Reference<BR>\r\nJupiter Technology Address Resolution Protocol (arp) Softblock User\'s Guide<BR>\r\nJupiter Technology FileReach MVS Transfer Manager (MFTM) General Information Guide<BR>\r\nJupiter Technology FileReach MVS Transfer Manager (MFTM) Installation and Configuration Guide<BR>\r\nJupiter Technology FileReach MVS Transfer Manager (MFTM) Message Reference Guide<BR>\r\nJupiter Technology FileReach MVS Transfer Manager (MFTM) Operator\'s Guide<BR>\r\nJupiter Technology File Transfer Protocol (ftp) Softblock User\'s Guide<BR>\r\nJupiter Technology Internet Protocol (ip) Softblock User\'s Guide<BR>\r\nJupiter Technology SNP/DOS System Administration Guide<BR>\r\nJupiter Technology SNP/Exchange LAN Gateway System Administration Guide<BR>\r\nJupiter Technology SNS Network Integration (SNS/TCPaccess) Version 1.0 Installation Guide<BR>\r\nJupiter Technology TCP Softblock User\'s Guide<BR>\r\nJupiter Technology Telnet Protocol (telnet) Softblock User\'s Guide<BR>\r\nJupiter Technology User Datagram Protocol (udp) Softblock User\'s Guide<BR>\r\nJupiter Technology 5600 Rack-Mountable Personal Computer Installation Guide<BR>\r\nJupiter Technology 9772 Optical Disk Subsystem (ODS) Emulation Manual<BR>\r\nJupiter Technology 9772 Optical Disk Subsystem (ODS) Installation Manual<BR>\r\nJupiter Technology 9772 Optical Disk Subsystem (ODS) Operator\'s Reference Manual<BR>\r\nJupiter Technology 9772 Optical Disk Subsystem (ODS) Pre-Installation Manual<BR>\r\nK&S Auto-Bonder Operator\'s Training Manual<BR>\r\nLaser Mark Line Maintenance Training Manual<BR>\r\nLog Spitter Specifications<BR>\r\nLong Island Lighting Company, EnerGraf Tracking System<BR>\r\nMask Production Line Maintenance Training Manual<BR>\r\nMainframe Design Verification System<BR>\r\nMulti-Purpose Saw (BSP) Specifications<BR>\r\nOpen Systems Architecture (edit)<BR>\r\nOverhaul of New Process 435 Transmission<BR>\r\nPhiladelphia Electric Company, EnerGraf Tracking System<BR>\r\nPOS Control System and Report/Cashier Accountability Guide<BR>\r\nPOS Control System Programmer\'s Reference Guide, Version 2.0<BR>\r\nPOS Control System User\'s Guide, Version 1.2<BR>\r\nPOS Control System User\'s Guide, Version 2.0, Dual Processor<BR>\r\nPOS Control System User\'s Guide, Version 2.0, Single Processor<BR>\r\nPOS Interface to Host Communications, Version 1.3<BR>\r\nProduct Transfer Training Manual<BR>\r\nRustproofing Safety<BR>\r\nSan Diego Electric Company, EnerGraf Tracking System<BR>\r\nSeries 3000 Communications Reference Guide<BR>\r\nShinkawa UTC-12 Instructor\'s Guide<BR>\r\nShinkawa UTC-12 Line Maintenance Training Manual<BR>\r\nShinkawa UTC-12 Operator\'s Training Manual<BR>\r\nSNP/DOS System Administration Guide<BR>\r\nSNP/Exchange LAN Gateway System Administration Guide<BR>\r\nSNS Network Integration (SNS/TCPaccess) Version 1.0 Installation Guide<BR>\r\nStarter Replacement — 6-Cylinder Engines<BR>\r\nStatic (ESD) Control Specification<BR>\r\nTC Truck Accelerator Pedal Repair<BR>\r\nTDC 3000 Process Manager (edit)<BR>\r\nThe Honeywell Story (edit)<BR>\r\nThomson NETg Fulfillment Wizard Training Guide<BR>\r\nThomson NETg EA Report Manger Reference Guide, (Customer Service Reports) <BR>\r\nThomson NETg EA Report Manger Reference Guide, (Finance Reports)<BR>\r\nThomson NETg Invoice Wizard Training Guide<BR>\r\nThomson NETg Payment Wizard Training Guide<BR>\r\nThomson NETg Security Wizard Training Guide<BR>\r\nThomson NETg OrderWizard Training Guide<BR>\r\nThomson NETg OrderWizard Developer\'s Guide<BR>\r\nThomson NETg Scheduler Training Guide<BR>\r\nThomson NETg Scheduler Quick Reference Guide (Maintenance Tab)<BR>\r\nThomson NETg Scheduler Quick Reference Guide (Registration Tab)<BR>\r\nThomson NETg Scheduler Quick Reference Guide (Reporting Tab)<BR>\r\nThomson NETg Scheduler Quick Reference Guide (Scheduling Tab)<BR>\r\nThomson NETg SkillSoft Presentation<BR>\r\nThomson NETg Order Processing Overveiw Presentation<BR>\r\nThomson NETg Softrax Field Reference Guide for CS<BR>\r\nThomson NETg Softrax Training Guide for CS<BR>\r\nThomson NETg Enterprise Application Policies and Procedures (edit)<BR>\r\nTotal Refinery Control (edit)<BR>\r\nWestech Model 372 Wafer Polisher, Carrier Pad Mounting System<BR>\r\nWestech Model 372 Wafer Polisher, Installation Guide<BR>\r\nWestech Model 372 Wafer Polisher, Operation and Maintenance Guide<BR>\r\nWestech Model 372 Wafer Polisher, pH-Controlled Slurry System<BR>\r\nWestech Model 372 Wafer Polisher, Printer/Terminal Interface<BR>\r\nWestech Model 372 Wafer Polisher, Programmer\'s Guide<BR>\r\nWestech Model 372 Wafer Polisher, SECS I & II Host Interface<BR>\r\nWestech Model 372 Wafer Polisher, Slurry Distribution System<BR>\r\nWestech Model 372 Wafer Polisher, Slurry Mixing System<BR>\r\nWestech Model 3800 Dual-Sided Wafer Cleaner, Installation Guide<BR>\r\nWheel Studs and Flange Lug Nuts Repair Standard<BR>\r\nU-Haul Tire Truck Specifications and Service Manual<BR>\r\n<BR>\r\n\r\n',1,1,'',NULL,NULL,'Writing and Editing Services','<B>Writing Services</b>',NULL),(24,'The knowledgeable staff at Turnapaige & Reed Moore is available to share their experience and expertise in the format of customized Corporate Seminars, Informal Classes, or for Individual Tutoring for adults and/or children.  We have over thirty years of experience, and we are pleased to offer our expertise in writing, editing, and publishing. Please call us at 602-690-8192 for information or email us at your convenience.<BR>\r\n<BR>\r\n<B>Seminars, Classes, and Tutoring Available<BR></b>\r\nBusiness Writing<BR>\r\nEnglish Grammar & Punctuation<BR>\r\nEssay Organization & Writing<BR>\r\nGeneral Writing Techniques<BR>\r\nLegal Writing<BR>\r\nNovel Writing<BR>\r\nPress Release Writing<BR>\r\nQuery Letter Writing<BR>\r\nReading Comprehension<BR>\r\nSelf-Publishing<BR>\r\nTechnical Writing<BR>\r\n\r\n\r\n',1,1,'',NULL,NULL,'Seminars, Classes, & Tutoring','<b>Writing  Seminars</b>',NULL);

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `short_description` blob,
  `linkname` varchar(50) DEFAULT NULL,
  `link` blob,
  `alloworder` smallint(6) DEFAULT NULL,
  `instock` smallint(6) DEFAULT NULL,
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `list1` longblob,
  `list2` longblob,
  `image` varchar(255) DEFAULT NULL,
  `prices` longblob,
  `weight` double(8,4) NOT NULL DEFAULT '0.0000',
  `display` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `long_description` blob,
  `shipcost` float(10,2) NOT NULL DEFAULT '0.00',
  `number` smallint(6) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  `inactive` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` VALUES (3,'The Christmas Pickle','ISBN 0-9725231-0-3','<Font size=1><b>The Christmas Pickle</b> <BR>\r\nFIRST EDITION SOLD OUT!!!!<BR><BR>\r\nReprint Coming Soon!!!!!<BR><BR>\r\n<I>A Christmas Folktale</I><BR>\r\nBy:  Judy Lee Aguiar<BR><BR>\r\n<B>Dedicated to all those who have wondered, \"Why is there a pickle on our Christmas Tree?\"</B> <BR><BR>The Christmas Pickle reveals the Legend behind the Tradition of hiding a pickle ornament on the Christmas tree, and is sure to become a Christmas Classic!<BR><BR>\r\n\r\nIn this charming tale, you\'ll join Petra on a royal quest through the beautiful Prussian Kingdom of Vlassika.  It\'s a heartwarming journey filled with compassion, determination, and courage—a compelling story for all ages.\r\n<BR><BR>\r\n \r\n<I>The Christmas Pickle</I> will thoroughly entertain you while learning about old-world Christmas traditions—like nutcrackers, incense smokers, and the making of glass ornaments.  The Christmas Pickle will add a new delight to your Christmas joy and family traditions.\r\n<BR><BR>\r\nHard Copy (5.5\" x 8.25\" Portrait)<br>\r\n160 pages with over 100 black & white illustrations<br>\r\nCopyright 2002 by Judy Lee Aguiar * All Rights Reserved<BR></font>\r\n\r\n',NULL,NULL,0,0,'','',19.95,'','','christmaspicklecover.jpg','',0.0000,1,1,'<Font size=2><b>The Christmas Pickle</b> <BR>\r\n<I>A Christmas Folktale</I><BR>\r\nBy:  Judy Lee Aguiar<BR><BR>\r\n<B>Dedicated to all those who have wondered, \"Why is there a pickle on our Christmas Tree?\"</B> <BR><BR>The Christmas Pickle reveals the Legend behind the Tradition of hiding a pickle ornament on the Christmas tree, and is sure to become a Christmas Classic!<BR><BR>\r\n\r\nIn this charming tale, you\'ll join Petra on a royal quest through the beautiful Prussian Kingdom of Vlassika.  It\'s a heartwarming journey filled with compassion, determination, and courage—a compelling story for all ages.\r\n<BR><BR>\r\n \r\n<I>The Christmas Pickle</I> will thoroughly entertain you while learning about old-world Christmas traditions—like nutcrackers, incense smokers, and the making of glass ornaments.  The Christmas Pickle will add a new delight to your Christmas joy and family traditions.\r\n<BR><BR>\r\nHard Copy (5.5\" x 8.25\" Portrait)<br>\r\n160 pages with over 100 black & white illustrations<br>\r\nCopyright 2002 by Judy Lee Aguiar * All Rights Reserved<BR></Font>',0.00,3,0,NULL),(4,'The Heavenly Plan','ISBN 0-9725231-1-1','<font size=1><B>The Heavenly Plan</B><BR>\r\n<I>A Tale of Angelic Events</I><BR>\r\nBy:  Judy Lee Aguiar<BR><BR>\r\n\r\n<B>DISCOVER THE SECRET THAT\r\nEVERY ANGEL KNOWS!<Br><BR>\r\n</B>\r\nFind out how the angels watch, guide,\r\nand protect everyone one of us.\r\n<I>The Heavenly Plan</i> allows us a glimpse\r\nof how the angels devised a plan:<br><BR>\r\n<Center>\"For the caring and guidance,<BR>\r\nOf the beings called,\r\n\'Man.\'\"</Center><br><BR>\r\n<I>The Heavenly Plan</I> will warm your heart\r\nand you’ll laugh with delight when you\r\ndiscover the secret.<BR><BR>\r\n<I>The Heavenly Plan</I> is an enchantment\r\nfor all ages. Its uplifting message is\r\nfor everyone— and is sure to become a\r\ntreasured tale to be enjoyed time and again.<BR>\r\n<BR>\r\nHard Copy (5.5\" x 8.25\" Portrait)<br>\r\n91 pages with over 50 black & white illustrations<br>\r\nCopyright 2005 by Judy Lee Aguiar * All Rights Reserved<BR></font>\r\n\r\n',NULL,NULL,1,1,'','',16.95,'','','heavenlyplancover.jpg','',0.0000,1,1,'<Font size=2><B>The Heavenly Plan</B><BR>\r\n<I>A Tale of Angelic Events</I><BR>\r\nBy:  Judy Lee Aguiar<BR><BR>\r\n\r\n<B>DISCOVER THE SECRET THAT\r\nEVERY ANGEL KNOWS!<Br><BR>\r\n</B>\r\nFind out how the angels watch, guide,\r\nand protect everyone one of us.\r\n<I>The Heavenly Plan</i> allows us a glimpse\r\nof how the angels devised a plan:<br><BR>\r\n<Center>\"For the caring and guidance,<BR>\r\nOf the beings called,\r\n\'Man.\'\"</Center><br><BR>\r\n<I>The Heavenly Plan</I> will warm your heart\r\nand you’ll laugh with delight when you\r\ndiscover the secret.<BR><BR>\r\n<I>The Heavenly Plan</I> is an enchantment\r\nfor all ages. Its uplifting message is\r\nfor everyone— and is sure to become a\r\ntreasured tale to be enjoyed time and again.<BR>\r\n<BR>\r\nHard Copy (5.5\" x 8.25\" Portrait)<br>\r\n91 pages with over 50 black & white illustrations<br>\r\nCopyright 2005 by Judy Lee Aguiar * All Rights Reserved<BR></font>',0.00,4,NULL,NULL),(5,'The Littlest Camel: And the Journey of the Three Kings','ISBN 978-9725231-2-7','<Font size=1><b>The Littlest Camel</b><BR>\r\n<i>And the Journey of the Three Kings</i><BR>\r\n<BR>\r\nBy: Judy Lee Aguiar<BR>\r\nIllustrations by Thomas Rodriguez<BR>\r\n<BR>\r\n<BR>\r\nFirst Edition Release Date:  April 20, 2008<BR><BR>\r\n<b>AN EPIC CHRISTMAS STORY FOR THE WHOLE FAMILY TO ENJOY!</b><BR>\r\n<BR>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is a journey over the Twelve Days of Christmas to see the Boy King—as seen through the littlest camel\'s eyes.  Sandy is the littlest camel in the caravan of the Three Kings.  Although Sandy is still very young and small, King Melchior takes him along on the journey.  Sandy learns how to adjust his stride to carry a pack, recognize the smell of water in an oasis, and sense approaching danger, among many other lessons.<BR><BR>  \r\n\r\nOn their journey, Sandy makes some very special friends and together they endure many hardships: perilous terrain, harsh weather, ferocious predators, and dangerous intrigues.  It is Sandy’s faith in God’s love that helps guide and inspire the entire caravan on their journey.\r\n<BR><BR> \r\n<b>A New Holiday Tradition for Twelfth Night</B><BR><BR>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is an Heirloom Christmas book that is written with the idea that a family will be reading it <u>every</u> Christmas season—a chapter a night—over the Twelve days of Christmas through Epiphany. <BR><BR> \r\n\r\nThe story also introduces a Twelfth Night tradition that includes gathering clothing, blankets, toys, and food for those who are in need, and extends the Christmas Spirit beyond the intimate family to the community at large.\r\n<BR><BR>\r\nExcerpt from, <i>The Littlest Camel: And the Journey of the Three Kings</i>:<BR><BR>\r\n\r\n<dir><i><b>“[T]hose who had gifts to give, \r\nplaced a star in their window or on their door to signal that they had something to give…many also placed a bucket of water for Sandy to drink…He would come to their homes, guided by the star, pick up their charitable gifts, and deliver them to those who desperately needed them.”</dir></i></b>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is a beautiful, high-quality book with amazing four-colour illustrations throughout on photo-quality paper.   It is a large format (9” by 12”) book with 176 pages and over 100 illustrations that are bound in a glossy hard-back cover that will be a handsome addition to anyone’s Christmas book collection. <BR><BR> \r\n\r\nJoin Sandy on a journey over the twelve days of Christmas to see the Boy King—as seen through the littlest camel\'s eyes.  <BR><BR>\r\nRead a chapter a night, over the Twelve Days of Christmas and Celebrate the Day of Three Kings (Epiphany--January 6th) the way it was meant to be celebrated, with friends and family.\r\n<BR><BR>\r\nHard Cover (9\" x 12\" Portrait)<BR>\r\n176 pages with over 100 Full Color Illustrations<BR><BR>Copyright 2008 * Judy Lee Aguiar * All Rights Reserved<BR><BR>\r\n<b>Winner of the National Best Book 2008 Award--Religion: Christian Inspirational\r\n\r\n</b><BR><BR>\r\n\r\n<b>\r\n<b>Finalist of the 2009 Benjamin Franklin Awards\r\n</b><BR><BR>\r\n<i>The Littlest Camel</i> has been nominated and chosen as a finalist for the 2009 Benjamin Franklin Awards in the Religion category. The final awards ceremony will take place in New York City on May 28, 2009, during the 2009 BOOK EXPO AMERICA. Gold, Silver, and Bronze winners will be announced at the event. <BR><BR></font>',NULL,NULL,1,1,'','',39.95,'','','LittlestCamelcover.jpg','',0.0000,1,1,'<font size=2><b>The Littlest Camel</b><BR>\r\n<i>And the Journey of the Three Kings</i><BR>\r\n<BR>\r\nBy: Judy Lee Aguiar<BR>\r\nIllustrations by Thomas Rodriguez<BR>\r\n<BR>\r\n<BR>\r\nFirst Edition Release Date:  April 20, 2008<BR><BR>\r\n<b>AN EPIC CHRISTMAS STORY FOR THE WHOLE FAMILY TO ENJOY!</b><BR>\r\n<BR>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is a journey over the Twelve Days of Christmas to see the Boy King—as seen through the littlest camel\'s eyes.  Sandy is the littlest camel in the caravan of the Three Kings.  Although Sandy is still very young and small, King Melchior takes him along on the journey.  Sandy learns how to adjust his stride to carry a pack, recognize the smell of water in an oasis, and sense approaching danger, among many other lessons.<BR><BR>  \r\n\r\nOn their journey, Sandy makes some very special friends and together they endure many hardships: perilous terrain, harsh weather, ferocious predators, and dangerous intrigues.  It is Sandy’s faith in God’s love that helps guide and inspire the entire caravan on their journey.\r\n<BR><BR> \r\n<b>A New Holiday Tradition for Twelfth Night</B><BR><BR>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is an Heirloom Christmas book that is written with the idea that a family will be reading it <u>every</u> Christmas season—a chapter a night—over the Twelve days of Christmas through Epiphany. <BR><BR> \r\n\r\nThe story also introduces a Twelfth Night tradition that includes gathering clothing, blankets, toys, and food for those who are in need, and extends the Christmas Spirit beyond the intimate family to the community at large.\r\n<BR><BR>\r\nExcerpt from, <i>The Littlest Camel: And the Journey of the Three Kings</i>:<BR><BR>\r\n\r\n<dir><i><b>“[T]hose who had gifts to give, \r\nplaced a star in their window or on their door to signal that they had something to give…many also placed a bucket of water for Sandy to drink…He would come to their homes, guided by the star, pick up their charitable gifts, and deliver them to those who desperately needed them.”</dir></i></b>\r\n<i>The Littlest Camel: And the Journey of the Three Kings</i> is a beautiful, high-quality book with amazing four-colour illustrations throughout on photo-quality paper.   It is a large format (9” by 12”) book with 176 pages and over 100 illustrations that are bound in a glossy hard-back cover that will be a handsome addition to anyone’s Christmas book collection. <BR><BR> \r\n\r\nJoin Sandy on a journey over the twelve days of Christmas to see the Boy King—as seen through the littlest camel\'s eyes.  <BR><BR>\r\nRead a chapter a night, over the Twelve Days of Christmas and Celebrate the Day of Three Kings (Epiphany--January 6th) the way it was meant to be celebrated, with friends and family.\r\n<BR><BR>\r\nHard Cover (9\" x 12\" Portrait)<BR>\r\n176 pages with over 100 Full Color Illustrations<BR><BR>Copyright 2008 * Judy Lee Aguiar * All Rights Reserved<BR><BR>\r\n\r\n\r\n<b>ORDER YOUR SIGNED, FIRST EDITION COPY NOW!</B> <BR><BR>\r\nShipments will begin April 20, 2008.<BR></font>',0.00,5,0,NULL);

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `price` double(8,2) NOT NULL DEFAULT '0.00',
  `label1` varchar(50) DEFAULT NULL,
  `label2` varchar(50) DEFAULT NULL,
  `invoiceID` int(11) NOT NULL DEFAULT '0',
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--

INSERT INTO `Sale` VALUES (1,5,2,'The Littlest Camel: And the Journey of the Three Kings','ISBN 978-9725231-2-7',39.95,'','',1,NULL),(2,5,1,'The Littlest Camel: And the Journey of the Three Kings','ISBN 978-9725231-2-7',39.95,'','',2,NULL),(3,3,1,'The Christmas Pickle','ISBN 0-9725231-0-3',19.95,'','',3,NULL),(4,5,1,'The Littlest Camel: And the Journey of the Three Kings','ISBN 978-9725231-2-7',39.95,'','',4,NULL),(5,5,1,'The Littlest Camel: And the Journey of the Three Kings','ISBN 978-9725231-2-7',39.95,'','',5,NULL),(6,5,1,'The Littlest Camel: And the Journey of the Three Kings','ISBN 978-9725231-2-7',39.95,'','',6,NULL),(7,3,1,'The Christmas Pickle','ISBN 0-9725231-0-3',19.95,'','',8,NULL),(8,3,1,'The Christmas Pickle','ISBN 0-9725231-0-3',19.95,'','',9,NULL);

--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `carrier` tinytext,
  `method` tinytext,
  `weight` double(16,2) DEFAULT NULL,
  `price` double(16,2) DEFAULT NULL,
  `record_type` tinyint(4) NOT NULL DEFAULT '0',
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `code` varchar(50) DEFAULT NULL,
  `class` varchar(5) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shipping`
--


--
-- Table structure for table `Shopping`
--

CREATE TABLE `Shopping` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `product` int(11) NOT NULL DEFAULT '0',
  `session` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `label1` tinytext,
  `sitename` tinytext,
  `label2` tinytext,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shopping`
--

INSERT INTO `Shopping` VALUES (33,5,1320348491,1,'','turnapaige','');

--
-- Dumping events for database 'turnapaige'
--

--
-- Dumping routines for database 'turnapaige'
--


