--
-- Host: localhost    Database: horsestoday
-- ------------------------------------------------------


--
-- 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(50) DEFAULT NULL,
  `image` varchar(50) DEFAULT NULL,
  `old_id` smallint(4) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=45 DEFAULT CHARSET=latin1;

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

INSERT INTO `Category` VALUES (1,0,0,0,18,NULL,NULL,'Top Level',NULL,0),(18,0,3,6,37,'',NULL,'<b>VIDEOS</b>','',0),(22,0,3,44,0,'',NULL,'Training Videos','',0),(6,0,3,36,0,'',NULL,'<b>BOOKS</b>','postersandbooks.jpg',0),(39,0,3,22,0,'',NULL,'Julie Goodnight','juliegoodnight2.jpg',0),(44,0,3,0,0,'',NULL,'New!!! Don\'t Miss','',0),(37,0,3,39,0,'<p>Al Dunning has participated, supported and served as a leader for the local and national horse industry for over thirty years. During that time Al and his students have garnered 21 World Titles.</p><p> <a href=\"http://www.aldunning.com\">Visit Al\'s Site Here!!!</a></P> \r\n',NULL,'Al Dunning','Aldunning.jpg',0),(36,0,4,0,0,'',NULL,'<b>JEWELRY</b>','',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=407 DEFAULT CHARSET=latin1;

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

INSERT INTO `Inventory` VALUES (90,1,19),(384,2,6),(106,3,19),(107,4,19),(91,7,19),(92,8,19),(93,9,19),(94,10,19),(95,11,19),(96,12,19),(97,13,19),(98,14,19),(99,15,19),(100,16,19),(101,17,19),(24,18,9),(102,19,19),(380,96,39),(386,22,6),(387,23,6),(115,24,16),(114,25,15),(378,94,37),(383,93,44),(385,28,6),(381,29,22),(198,30,17),(390,31,6),(388,32,6),(389,33,6),(382,34,22),(373,89,37),(372,88,37),(401,43,36),(375,90,37),(377,92,37),(403,52,36),(220,51,31),(376,91,37),(379,95,39),(186,55,32),(395,60,36),(396,61,36),(398,62,36),(397,63,36),(392,64,36),(399,65,36),(393,68,36),(400,69,36),(236,70,33),(402,71,36),(404,73,36),(405,74,36),(394,75,36),(406,76,36),(208,77,34),(215,79,34),(207,80,34),(391,86,6);

--
-- 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=121 DEFAULT CHARSET=latin1;

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

INSERT INTO `Invoice` VALUES (3,'2002-11-25 18:01:34',10,10,1,'Shipping',5.00,'',NULL,NULL),(4,'2002-12-17 14:42:33',11,11,1,'Shipping',5.00,'',NULL,NULL),(5,'2003-09-15 11:25:23',29,29,1,'Shipping',5.00,'',NULL,NULL),(6,'2003-10-22 21:40:33',31,32,1,'Shipping',5.00,'Thanks for expediting my order',NULL,NULL),(13,'2003-12-12 23:57:54',41,41,1,'Shipping',0.00,'',NULL,NULL),(12,'2003-12-12 10:50:01',40,40,1,'Shipping',3.00,'',NULL,NULL),(11,'2003-12-03 11:57:03',39,39,1,'Shipping',15.00,'',NULL,NULL),(16,'2003-12-20 09:55:34',44,44,1,'Shipping',0.00,'',NULL,NULL),(15,'2003-12-18 16:02:01',43,43,1,'Shipping',0.00,'',NULL,NULL),(17,'2003-12-30 14:25:38',45,45,1,'Shipping',0.00,'',NULL,NULL),(18,'2004-01-03 21:03:27',46,47,1,'Shipping',0.00,'',NULL,NULL),(82,'2006-01-15 12:53:05',145,145,1,'Shipping',0.00,'',NULL,NULL),(20,'2004-01-05 13:47:08',49,49,1,'Shipping',5.00,'',NULL,NULL),(21,'2004-01-13 17:20:15',50,50,1,'Shipping',5.00,'',NULL,NULL),(25,'2004-03-12 12:26:01',57,57,1,'Shipping',5.00,'9720',NULL,NULL),(23,'2004-02-15 18:21:55',54,54,1,'Shipping',0.00,'',NULL,NULL),(24,'2004-02-22 21:34:51',56,56,1,'Shipping',2.00,'',NULL,NULL),(26,'2004-03-16 08:50:36',58,58,1,'Shipping',0.00,'',NULL,NULL),(27,'2004-04-09 12:34:01',59,59,1,'Shipping',0.00,'',NULL,NULL),(28,'2004-04-12 16:37:04',60,60,1,'Shipping',0.00,'',NULL,NULL),(29,'2004-04-26 09:18:03',61,61,1,'Shipping',0.00,'',NULL,NULL),(30,'2004-04-27 11:25:07',62,63,1,'Shipping',5.00,'',NULL,NULL),(31,'2004-05-01 19:18:52',64,64,1,'Shipping',10.00,'',NULL,NULL),(32,'2004-05-11 19:09:22',65,65,1,'Shipping',0.00,'',NULL,NULL),(33,'2004-06-01 18:21:02',66,66,1,'Shipping',0.00,'',NULL,NULL),(34,'2004-06-07 09:33:04',67,67,1,'Shipping',0.00,'',NULL,NULL),(35,'2004-06-18 11:47:15',69,69,1,'Shipping',3.00,'',NULL,NULL),(36,'2004-08-13 20:35:28',70,71,1,'Shipping',0.00,'Happy Birthday Alli',NULL,NULL),(37,'2004-08-18 11:13:06',72,73,1,'Shipping',5.00,'',NULL,NULL),(38,'2004-08-28 22:09:04',74,74,1,'Shipping',0.00,'',NULL,NULL),(39,'2004-09-17 14:07:12',77,77,1,'Shipping',0.00,'Thank you. Please call if item is backordered or no longer available. Thanks!! Cindy',NULL,NULL),(40,'2004-10-26 16:34:51',81,81,1,'Shipping',0.00,'',NULL,NULL),(41,'2004-11-03 09:02:01',83,83,1,'Shipping',5.00,'',NULL,NULL),(42,'2004-11-22 15:24:48',84,84,1,'Shipping',0.00,'',NULL,NULL),(43,'2004-11-23 15:34:27',85,85,1,'Shipping',5.00,'',NULL,NULL),(44,'2004-11-26 19:58:15',86,86,1,'Shipping',0.00,'',NULL,NULL),(45,'2004-12-09 10:47:21',87,87,1,'Shipping',0.00,'',NULL,NULL),(46,'2004-12-13 19:37:03',88,88,1,'Shipping',0.00,'',NULL,NULL),(47,'2004-12-15 11:59:17',89,89,1,'Shipping',10.00,'',NULL,NULL),(48,'2004-12-15 13:18:30',90,90,1,'Shipping',0.00,'',NULL,NULL),(49,'2005-02-22 07:51:24',93,93,1,'Shipping',5.00,'',NULL,NULL),(50,'2005-03-02 04:01:43',94,94,1,'Shipping',5.00,'',NULL,NULL),(51,'2005-03-05 03:33:57',95,95,1,'Shipping',0.00,'',NULL,NULL),(52,'2005-03-07 10:53:26',96,96,1,'Shipping',0.00,'',NULL,NULL),(53,'2005-03-13 16:27:08',98,98,1,'Shipping',5.00,'',NULL,NULL),(54,'2005-03-17 07:44:17',99,100,1,'Shipping',5.00,'thank you',NULL,NULL),(55,'2005-03-28 16:32:24',101,101,1,'Shipping',0.00,'',NULL,NULL),(56,'2005-04-04 17:39:49',103,103,1,'Shipping',0.00,'',NULL,NULL),(57,'2005-05-07 16:26:49',106,106,1,'Shipping',0.00,'',NULL,NULL),(58,'2005-05-27 10:07:42',108,108,1,'Shipping',0.00,'',NULL,NULL),(61,'2005-07-05 08:45:24',114,114,1,'Shipping',0.00,'',NULL,NULL),(60,'2005-06-21 14:10:27',112,113,1,'Shipping',0.00,'',NULL,NULL),(62,'2005-07-21 13:49:37',116,116,1,'Shipping',5.00,'',NULL,NULL),(63,'2005-08-09 20:51:45',118,119,1,'Shipping',5.00,'',NULL,NULL),(64,'2005-08-11 15:30:29',120,120,1,'Shipping',0.00,'',NULL,NULL),(65,'2005-10-08 21:07:18',123,123,1,'Shipping',15.00,'',NULL,NULL),(66,'2005-10-20 10:48:30',124,124,1,'Shipping',10.00,'',NULL,NULL),(67,'2005-11-23 14:59:41',128,129,1,'Shipping',5.00,'',NULL,NULL),(68,'2005-11-24 19:10:43',130,130,1,'Shipping',4.00,'',NULL,NULL),(69,'2005-11-27 12:00:55',131,131,1,'Shipping',5.00,'',NULL,NULL),(70,'2005-12-01 12:52:50',132,132,1,'Shipping',0.00,'',NULL,NULL),(71,'2005-12-01 14:22:56',133,133,1,'Shipping',0.00,'',NULL,NULL),(73,'2005-12-09 09:58:00',135,136,1,'Shipping',5.00,'I am shipping to my office so it isnt left outside my home.',NULL,NULL),(74,'2005-12-10 20:45:43',137,137,1,'Shipping',0.00,'',NULL,NULL),(75,'2005-12-12 14:10:16',138,138,1,'Shipping',0.00,'',NULL,NULL),(77,'2005-12-14 09:38:57',140,140,1,'Shipping',0.00,'',NULL,NULL),(78,'2005-12-20 13:18:17',141,141,1,'Shipping',0.00,'',NULL,NULL),(79,'2005-12-26 17:22:17',142,142,1,'Shipping',0.00,'',NULL,NULL),(80,'2006-01-07 16:19:44',143,143,1,'Shipping',0.00,'',NULL,NULL),(83,'2006-02-18 09:01:11',147,147,1,'Shipping',5.00,'',NULL,NULL),(84,'2006-03-10 20:47:55',148,148,1,'Shipping',0.00,'',NULL,NULL),(85,'2006-04-18 11:15:59',149,149,1,'Shipping',0.00,'',NULL,NULL),(86,'2006-05-13 17:39:23',150,151,1,'Shipping',0.00,'',NULL,NULL),(90,'2006-11-01 11:17:49',163,163,1,'Shipping',0.00,'',NULL,NULL),(88,'2006-09-15 13:11:26',159,159,1,'Shipping',0.00,'',NULL,NULL),(91,'2006-11-02 11:03:52',164,164,1,'Shipping',0.00,'',NULL,NULL),(99,'2007-04-17 11:13:12',174,174,1,'Shipping',5.00,'PRIORITY MAIL please',NULL,NULL),(100,'2007-06-30 05:55:17',176,176,1,'Shipping',10.00,'',NULL,NULL),(103,'2008-05-23 21:26:05',187,187,1,'Shipping',0.00,'',NULL,NULL),(105,'2008-06-08 15:35:57',190,190,1,'Shipping',5.00,'',34.97,2.87),(106,'2008-10-05 10:23:16',205,205,1,'Shipping',5.00,'',34.97,2.87),(107,'2009-02-23 14:43:14',215,215,1,'Shipping',5.00,'',39.95,3.28),(108,'2009-08-16 14:18:10',227,228,1,'Shipping',5.00,'',34.97,2.87),(109,'2009-11-10 13:58:38',230,230,1,'Shipping',4.00,'',29.95,2.46),(110,'2010-01-22 15:16:41',231,232,1,'Shipping',0.00,'THANKS',39.95,3.28),(111,'2010-03-22 10:27:59',235,235,1,'Shipping',6.00,'',59.95,4.92),(112,'2010-09-17 12:53:35',245,246,1,'Shipping',6.00,'',69.95,5.74),(113,'2010-10-04 08:57:54',247,247,1,'Shipping',6.00,'',39.95,3.28),(116,'2010-12-07 22:32:11',252,252,1,'Shipping',6.00,'Cancel this order if it can not be delivered before Dec. 25th.',39.95,3.28),(117,'2011-02-02 11:48:18',256,256,1,'Shipping',8.00,'',25.00,2.05),(118,'2011-02-09 14:19:43',258,258,1,'Shipping',12.00,'',109.90,9.01),(119,'2011-02-12 21:43:59',259,259,1,'Shipping',6.00,'',69.95,5.74);

--
-- 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=14 DEFAULT CHARSET=latin1;

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

INSERT INTO `Page` VALUES (1,'<p align=\"center\"><font color=\"#000000\" size=\"6\"><strong>Welcome to our General Store </strong></font></p>\r\n<p align=\"center\"><font size=\"3\">We offer the very best and latest videos and books for your horse training needs.&nbsp;<hr />\r\n</font></p>\r\n<p align=\"center\">&nbsp;<strong><font size=\"3\">Join our World Champion Trainers in our Video Section. </font></strong></p>\r\n<p align=\"center\"><strong><font size=\"3\">Browse our carefully selected Book Section.</font></strong></p>\r\n<p align=\"center\"><font size=\"3\"><strong>Don\'t forget our&nbsp;fashion forward Jewelry Section.</strong> </font><hr />\r\n</p>\r\n<p>&nbsp;</p>\r\n<p align=\"center\"><font size=\"4\"><font size=\"3\">Check out these exciting video\'s featuring these</font> </font></p>\r\n<p align=\"center\"><strong><u><font size=\"3\">World Champion Trainers</font></u></strong></p>\r\n<p align=\"center\"><strong><font size=\"5\">AL DUNNING /&nbsp;</font></strong><strong><font size=\"5\">LYNN PALM /&nbsp;</font></strong><strong><font size=\"5\">JULIE GOODNIGHT</font></strong></p>\r\n<p><font size=\"5\">&nbsp;</font></p>',3,0,'','','95,89,93','',NULL,NULL),(2,NULL,0,2,NULL,NULL,NULL,NULL,'<b>HOME</b>','http://www.horsestoday.com'),(3,NULL,0,2,NULL,NULL,NULL,NULL,'<b>CLASSIFIED ADDS</b>','http://horsestoday.com/search.asp'),(4,NULL,0,2,NULL,NULL,NULL,NULL,'<b>HORSE TALK</b>','http://horsestoday.com/newsletter.asp'),(5,NULL,0,2,NULL,NULL,NULL,NULL,'<b>JOIN THE HERD</b>','http://horsestoday.com/links.asp'),(6,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(7,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(8,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(9,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(10,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(11,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(13,'<b>Privacy Policy </b> \r\n<p>At Horses Today, we value our customers\' trust and respect your privacy. The \r\n  following includes information about our privacy policy:</p>\r\n<p><b>Personal Information </b><br>\r\n  When visiting our site you can view our web pages without telling us who you \r\n  are or transferring any personal information. We may track IP addresses to analyze \r\n  trends and usage; however, IP addresses are not linked to personally identifiable \r\n  information.<br>\r\n  If you place an order, we will ask you to provide a credit card number and other \r\n  relevant information. Some of that information is mandatory and some voluntary. \r\n  If you do not provide the mandatory data with respect to purchasing you will \r\n  not be able to complete the purchase. The information is used for billing purposes \r\n  and to fill your orders. If we have questions regarding processing an order, \r\n  this contact information is used to get in touch with you. </p>\r\n<p><br>\r\n  <b>Protection of your personal information</b><br>\r\n  The personal information that you provide in connection with purchasing a product \r\n  from (Insert Business Name Here), Inc. is classified information. Your information \r\n  is protected in several ways. Your credit card information resides on a secure \r\n  (Insert Business Name Here) server. When your information is transmitted to \r\n  our server from this site, (Insert Business Name Here) encrypts your personal \r\n  information and thereby prevents unauthorized parties from viewing such information \r\n  when it is transmitted.</p>\r\n<p><b>Information Sharing</b><br>\r\n  (Insert Business Name Here) will never sell or rent your name, address or e-mail \r\n  address to any third party companies. <br>\r\n  We may provide the necessary contact information with another party to provide \r\n  specific services for us, such as credit card processing and shipping. These \r\n  parties are only allowed to use personally identifiable information for purposes \r\n  of providing these services.</p>\r\n<p><br>\r\n  <b>E-Mail Communications</b><br>\r\n  We may e-mail you to communicate with you about your orders. You may also receive \r\n  occasional e-mail communications regarding our site, special offers, services, \r\n  or products. If you do not wish to receive promotional e-mails you may e-mail \r\n  or write to us instructing us to take you off our list.<br>\r\n  Links From Our Website</p>\r\n<p><br>\r\n  As a convenience to you, The Horsestoday.com website contains links to other \r\n  sites. We are not responsible for the contents or privacy policies of these \r\n  linked sites. We encourage you to always read the policy statements of every \r\n  website that collects personal information.<br>\r\n</p>',3,1,'',NULL,NULL,'Privacy Policy','Privacy Policy',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=97 DEFAULT CHARSET=latin1;

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

INSERT INTO `Product` VALUES (1,'Show  HT101','101','Colorado Horse Drive <br>\r\nBlind Trust<br>\r\nPicture This, Robert Dawson - Photographer<br>\r\n ',NULL,NULL,1,1,'','',14.95,'','','HFacesweb.jpg','',0.0000,1,1,'Go On a Colorado Horse Drive <br> Every year wranglers go on a two day drive to bring over four hundred heard of horses in from their summer pasture and you can be there with them.<br><br>\r\nPicture This<br> Capturing \"The Romance of the Horse\" is what photographer, Robert Dawson\'s, pictures are all about and the Horse Drive is the ideal place.<br><br>\r\nBlind Trust <br> A rider with a vision is Sam Madden.  Although she is blind, Sam rides and competes with able bodied riders and gets no special treatment.  She shows how the love of horses can conquer all obstacles. <br>\r\n ',5.00,1,NULL,NULL),(2,'THE LONG WAY TO LOS GATOS','0','For Verne Albright, his famous ride from Peru to California was a personal adventure, but to many it was the event that introduced the Peruvian Paso to North America. Thirty-three years later, this incredible story is the subject of an extraordinary book. ',NULL,NULL,1,1,'','',25.00,'','','Gatos1.jpg','',0.0000,1,1,'The Best Horse Adventure Book Around! Picture a man riding horses all by himself from Peru to California, finding new adventures around every bend in the road. Travel with him through the Peruvian Desert, the high Andes in Ecuador, the tropical heat of Panama and revolution torn Nicaragua! Meet a cast of characters that includes a witch doctor, two bandit gangs, a smuggler, a bullying sheriff, a television camera crew and a beautiful American girl named Emily. Enjoy a wonderful adventure, told by a great storyteller, a book that reads like fiction but is the true tale of a horsemen\'s challenging journey. The lively pace and vivid images make this book difficult to put down. For 392 riveting pages, you will experience all that happened during the odyssey of brave and noble animals that found themselves in a new and  strange world, trusting in and depending upon their owner\'s care and passion for horses.<br><br>\r\nGreat Adventure as Told by a Great Storyteller, Verne Albright!\r\n\r\n',8.00,17,0,NULL),(96,'GOODNIGHT\'S PRINCIPLES OF RIDING: VOLUME 2 <small>COMMUNICATION AND CONTROL FROM THE SADDLE</small>','0','\"Communicating with the horse clearly and effectively can be a difficult task, but the more clear and consistant your signals, the better able he is to respond.\" - Julie Goodnight',NULL,NULL,1,1,'','',39.95,'','','Juliegoodnightdvd2.jpg','',0.0000,1,1,'Julie teaches that when you and your horse are centered and in balance you will be synchronized and move in rhythm.<p>With her upbeat and personable teaching style she puts riders on the road to sucess of achieving balance, rhythm, communication, control, and a harmonious relationship with their horse.</p>',6.00,96,0,NULL),(3,'Best of Horses Today Volume 1','B001','Cowboy’s Shoot it out in Tombstone<br>\r\nINSIDE the Race at Turf Paradise',NULL,NULL,1,1,'','',18.95,'','','Best01.jpg','',0.0000,1,1,'Cowboy’s Shoot Their 45’s in Tombstone \r\n<br><br>\r\nCowboy Mounted Shooting at Tombstone Cowboys gather in  Tombstone to compete on their horses. They ride fast and shoot with 45\'s while dressing in the styles of the 1800\'s. <BR><br>From the Backside to the Race at \r\nTurf Paradise<BR><BR>\r\nTake a peek behind the scenes and see what it takes to put together all the spectical, action and excitement of thoroughbred horse racing at its best! ',5.00,2,NULL,NULL),(4,'Best of Horses Today Volume 2','B002','Those Beautiful Arabians Compete<br>\r\nJumping High With AZ Hunter Jumpers\r\n',NULL,NULL,1,1,'','',18.95,'','','Best02a.jpg','',0.0000,1,1,'Those Beautiful Arabians <br><br>\r\nWatch those beautiful Arabians at the Scottsdale Horse Show.  Joanne Fox talks about why Arabians are her first choice.<br><br>\r\nJumping With AZ Hunter Jumpers  <br><br>\r\nThen see how high the jumps are at the AZ Hunter Jumper show.  Michael Page, previous Olympian, explains what he looks for as a judge. \r\n \r\n',5.00,3,NULL,NULL),(11,'Show HT106','106','Amazing Quarter Horses<br>Time to Get on Your Horse and Ride<br>What\'s Important in a Pre-purchase Exam',NULL,NULL,1,1,'','',14.95,'','','quarter_horses.jpg','',0.0000,1,1,'<b>Amazing Quarter Horses</b>-Each year over 1500 Quarter Horses go to Arizona to have fun in the sun.  This is where you can find the largest group of World Champion winners meet.<br><br><b>Time to Get on Your Horse and Ride</b>-Joanne Fox continues her expert training that any rider, no matter what their riding level, can learn from.<br><br><b>The Pre-Purchase Exam</b>-Veterinarian, Dr. Scott Taylor, shows step by step how a pre-purchase exam should be done and what to look for before buying your horse.',5.00,10,NULL,NULL),(12,'Show HT107','107','The Man Who Listens - Monty Roberts<br>Horses Help Children',NULL,NULL,1,1,'','',14.95,'','','show111.jpg','',0.0000,1,1,'<b>Join Up with Monty Roberts</b>-He trains horses using a language they understand-their own.  With his gentle manner he demonstrates a kinder way for that first time saddle, bridle & bit and spreads the word for more humane treatment of horses.<br><br><b>Horses Help</b>-Most kids would love to get to ride a horse.  But for the kids that ride horses at Horses Help, it is even more special.  Riding a horse not only helps them mentally and phsically, it lets them do something that most of their siblings and friends can only dream of doing.  Dedicated volunteers give of their time and are rewarded with the happy smiling faces that appear on each child when they ride.',5.00,11,NULL,NULL),(13,'Show HT108','108','Reining with World Champion\'s in Oklahoma City<br>Steering and Stopping Your HOrse<br>USTRC Promotes Junior Roping',NULL,NULL,1,1,'','',14.95,'','','reiners.jpg','',0.0000,1,1,'<b>',5.00,12,NULL,NULL),(14,'Show HT109','0','Hershberger Trains Quarterhorses<br>Kylie and Barrel Racing<br>Completing the Pre-purchase Exam',NULL,NULL,1,1,'','',14.95,'','','HershRope.jpg','',0.0000,1,1,'<b>Jason & Nikki Hershberger - Today\'s Young Ranchers!</b>  Through hard work and good planning Jason & Nikki reached out and built their dream ranch.  On it they are raising their son, Wyatt, and passing on to him the values taught to them by their parents.  They kept the price for their land down by being willing to live close to Luke Air Force Base.  The jet flying overhead don\'t both them - or their horses.<br><br><b>Kylie and Barrel Racing</b>  Although she\'s barrel racing at a very young age Kylie shows she has the majurity she needs to do it well.  She also is responsible and compassonate way beyond her years.    ',5.00,13,NULL,NULL),(15,'Show HT110','110','\"Riding on a Cloud\" - The Peruvian Paso',NULL,NULL,1,1,'','',14.95,'','','Peru110.jpg','',0.0000,1,1,'\"Riding on a Cloud\"  It sounds too good to be true but, if you are looking for the smoothest equine ride in the world, the Peruvian Paso could be the horse for you.  The Peruvian Paso has been bred in Peru for over four hundred fifty years and are known for their strength, energy and \"brio\" attitude.  Their gait is natural from birth.  During competition all horses are required to use the same tack with each piece having it\'s own interesting history.',5.00,14,NULL,NULL),(16,'Show HT111','111','<b>PAT PARELLI - PART ONE<BR><BR>Sharing the Savvy<br>Learning the Savvy<br>Understanding and Teaching Savvy</b>',NULL,NULL,1,1,'','',14.95,'','','Parelli111.jpg','',0.0000,1,1,'<I>Savvy</I> means knowing when to be, where to be, why to be...and what to do when you get there!<br><br>At his beautiful ranch in Pagosa Springs, Colorado Pat Parelli shares his pathway to savvy with horses.  Through play with horses he shows how savvy is not about holding horses back or blocking their natural instincts, or protecting them from their natural responses.  It\'s about helping horses gain confidence and feel calm in the human environment.  It\'s about knowing how to turn those natural prey animal instincts into positive traits.<br><br>Stephanie Anderson shares her remarkable experience in learning to communicate with her horse through Savvy.  Before bringing her horse to Colorado she was heartbroken that she was going to have to sell her horse because he had become dangerous.<br><br>So don\'t miss this special opportunity to \"Savvy Up\"!',5.00,15,NULL,NULL),(7,'Show HT102','102','Those Beautiful Arabians<br>\r\nMeet the Riding Instructor-Joanne Fox<br>\r\nSaving a Race Horses Future\r\n',NULL,NULL,1,1,'','',14.95,'','','beautiful_arabians.jpg','',0.0000,1,1,'<b>Those Beautiful Arabians</b><br> They\'re bold, they\'re beautiful and they arrive with an entourage that rivals rock and movie stars.  Yes, they are athletes-the equine kind. Every year, Scottsdale welcomes almost 2000 of the worlds most beautiful Arabian horses and all the trappings that come along.  Most call it \"Scottsdale Fever\".  Whatever you call it, you will want to experience the Annual Scottsdale Arabian Horse Show.<br><br><b>Meet the Riding Instructor</b><br>Go to Inez,California and see how Joanne Fox enjoys life as a trainer living on a beautiful ranch with many interesting animals.<br><br><b>Saving a Rance Horses Future</b><br>Dr. Mark Anderson is the one who knows what it takes to keep a race horse healthy and fit.  Everyone knows that performing surgery on a horse is never a simple matter but sometimes it is necessary.',5.00,4,NULL,NULL),(8,'Show HT103','103','From the Backside to the Race<br>What Type of Riding for You?<br>Girls and Their Horses',NULL,NULL,1,1,'','',14.95,'','','turf_paradise.jpg','',0.0000,1,1,'<b>From the Backside to the Race</b><br><br>Many race tracks are only open a few months of the year but at Turf Paradise over 2000 horses are boarded on site for the nine month race season.  It\'s a town to itself with just about everything people and horses need.<br>Trainer, Dwain Grissom, knows what it takes to train great race horses.  Seven days a week he is up and started by 6:00am, exercising, bathing and checking for any injuries or soreness.  If any of his horses are racing, he is there for the race and if he\'s lucky he may get to take a short break during the day.  But every evening he\'s back to make sure the horses are fed and everything is okay.<br><br>Pay Per View is Dwain\'s newest filly and is racing for the first time on the turf at Turf Paradise.  Dwain\'s hoping she will take first and just maybe she will.',5.00,7,NULL,NULL),(9,'Show HT104','104','Cowboy\'s Shoot Their 45\'s in Tombstone<br>Get the Exam Before You Purchase Your Horse<br>Al Dunning - The Trainer-Cutter',NULL,NULL,1,1,'','',14.95,'','','tombstone.jpg','',0.0000,1,1,'<b>Ride, Shoot and Hoot at Tombstone</b><br><br>If you want to ride with the Cowboy Mounted Shooter, you gotta dress like they did in the 1880\'s and be able to barrel race while shooting balloons with two single action 45\'s. <br><b>It\'s as close as it gets to being in the Wild , Wild West</b><br><br><b>Get the Exam Before You Purchase Your Horse</b><br>Veterinarian, Dr. Scott Taylor explains why and how you should get a horse examined before you purchase it.<br><br><b>Al Dunning - The Trainer-Cutter</b><br>Most horsemen hope for the one special big win that will be the high point in their equestrian career, a world championship.  Repeat performances are very difficult and winning twenty world championships in twenty-three years is unheard of - but that\'s what Al Dunning achieved at the 1999 World Show.<br><br>Al shows how an excellent traiing program is a combination of great horses, education, patience and time.  Each ingredient plays an important role in the climb to success. ',5.00,8,NULL,NULL),(10,'Show HT105','105','Riding Bulls & Bronc\'s with the Women of the Women\'s Pro Rodeo<br>Reaching Kids Through the Rodeo',NULL,NULL,1,1,'','',14.95,'','','riding_bullsandbroncs.jpg','',0.0000,1,1,'<b>Riding Bulls & Bronc\'s</b><br>The women of the Women\'s Professional Rodeo Association don\'t hold back when riding bareback or bulls.  This is their first time at the La Fiesta delos Vaqueros Rodeo.  The top competitors in the country go up against one another in barrel racing, breakaway and tie-down calf and team roping. Then thye compete one against one with the bareback and bull riding.<br><br><b>Reach Kids Program</b> \"Cowboy Up\", that\'s what the Reach Kids Program is all about.  It\'s a fun, informative and educational way to reach children from Kindergarten through sixth grade through the rodeo experience. ',5.00,9,NULL,NULL),(17,'Show HT112','112','<b>Pat Parelli - Part II</b)<br><br>Visting Pat\'s in Colorado<br>Playing the Games<br>Why Natural Horse-Man-Ship<br>Success with Savvy',NULL,NULL,1,1,'','',14.95,'','','Parelli112.jpg','',0.0000,1,1,'This is \"Natural Horse-Man-Ship\" at it\'s best.  Pat Parelli and his wife, Linda, teach, \"What\'s important to people is not important to horses.  What interests people does not interest horses, what frightens horses doesn\'t frighten people.  We need to learn and recognize these differences so we start to understand <I>why</I> horses do what they do\".<p>Feel, timing, balance, knowledge, understand, savvy...the qualities that master horsemen take for granted are the things most riders are never taught.  To find what it takes to ride your horse without bridle or bit watch \"Sharing the Savvy\" on <I>Horses Today\"<I>',5.00,16,NULL,NULL),(18,'Show HT113','113','',NULL,NULL,1,1,'','',14.95,'','','','',0.0000,1,1,'',5.00,18,NULL,NULL),(19,'Show HT113','113','<H4>Flying High with Hunter-Jumpers!</H4>',NULL,NULL,1,1,'','',14.95,'','','jumpers.jpg','',0.0000,1,1,'',5.00,22,NULL,NULL),(24,'Robert Dawson Gift Post Card Set','0','Robert Dawson Post Card Gift Box Includes:\r\n12 Post Cards in a clear re-sealable bag.',NULL,NULL,1,1,'','',9.99,'','','Dawson_Post_Cards_2.jpg','',0.0000,1,1,'Robert Dawson Post Card Gift Box Includes:\r\n12 Post Cards in a clear re-sealable bag.\r\n',2.00,26,NULL,NULL),(22,'HORSE FOLLOW CLOSELY','0','In this magnificent book, GaWaNi Pony Boy illustrates the traditional training methods-methods that are steeped in common sense and age old wisdom-of his ancestors, America\'s first great horsemen.',NULL,NULL,1,1,'','',39.95,'','','Horse_Follow_Closely_72.jpg','',0.0000,1,1,'\"If we are to understand our relationship with the horse, we must first understand the relationship we have with the entire animal kingdom. The human species, directly or indirectly, affects all other species on the planet, even those species we don\'t directly come in contact with.\" -GaWaNi Pony Boy',8.00,23,0,NULL),(94,'WESTERN DRESSAGE','0','While demonstrating easy and achievable common sense methods, World Champion trainers Al Dunning and Lynn Palm bring together the similarities of Western and English training using dressage techniques.',NULL,NULL,1,1,'','',39.95,'','','allynnwesterndressageforweb.jpg','',0.0000,1,1,'<p>Dressage is the natural way to train your horse according to his natural instincts and habits.</p><p>Some of the great training tips and exercises they share to improve your own riding skills are; Natural Communication, Correct Balance and Alignment for Horse and Rider, Exercises for Suppleness and Confidence, Advanced Training Exercises for Success.</p> ',6.00,94,0,NULL),(95,'GOODNIGHT\'S PRINCIPLES OF RIDING: VOLUME 1 <small>BALANCE & RHYTHM FROM THE SADDLE</small>','0','\"Riding is one of the most challenging balance sports there is because it is a balance in motion and the synchronization between two animals, horse and human.\" - Julie Goodnight',NULL,NULL,1,1,'','',39.95,'','','Juliegoodnightdvd.jpg','',0.0000,1,1,'Balance is the number on skill- Learn how you and your horse can be a balance in motion. Julie Goodnight gives you the methods of good balance and how to use them to attain balance between you and your horse.<P>With her upbeat and personable teaching style she puts riders on the road to sucess of achieving balance, rhythm, communication, control and a harmonious relationship with their horse.</p>',6.00,95,0,NULL),(23,'OF WOMEN AND HORSES','0','Women from all walks of life delve into their hearts to explore the special love, admiration, and respect they have had for various horses. A GaWaNi Pony Boy Book.',NULL,NULL,1,1,'','',39.95,'','','ofwomen.jpg','',0.0000,1,1,'\"Throughout my life, there have been several ocassions in wich I found myself in awe of that wich exists between women and horses.\" - GaWaNi Pony Boy. ',8.00,25,0,NULL),(93,'WESTERN DRESSAGE','0','While demonstrating easy and achievable common sense methods, World Champion trainers Al Dunning and Lynn Palm bring together the similarities of Western and English training using dressage techniques.',NULL,NULL,1,1,'','',39.95,'','','allynnwesterndressageforweb.jpg','',0.0000,1,1,'<p>Dressage is the natural way to train your horse according to his natural instincts and habits.</p><p>Some of the great training tips and exercises they share to improve your own riding skills are; Natural Communication, Correct Balance and Alignment for Horse and Rider, Exercises for Suppleness and Confidence, Advanced Training Exercises for Success.</p> ',6.00,93,0,NULL),(25,'Robert Dawson Gift Note Cards','0','Robert Dawson Note Card Gift Box Includes: 10 Note Cards & Envelopes are uniquely packaged in clear view top/kraft bottom box and tied with twine.\r\n',NULL,NULL,1,1,'','',16.99,'','','Dawson_Note_Cards_2.jpg','',0.0000,1,1,'Robert Dawson Note Card Gift Box Includes:  10 Note Cards & Envelopes are uniquely packaged in clear view top/kraft bottom box and tied with twine.\r\n',2.00,30,NULL,NULL),(31,'YOUR HEALTHY AND HAPPY HORSE','0','An ultimate guide to caring for your horse especially for young equestrians. Written by Lesley Ward, the Editor of Young Rider® magazine.',NULL,NULL,1,1,'','',12.95,'','','Healthy_Happy_Horse.jpg','',0.0000,1,1,'This is the ultimate guide to caring for your horse written especially for young equestrians. It\'s loaded with colorful photos and tips that will help you have the best possible relationship with your equine friend.  You\'ll learn everything you need to know about choosing the right horse or pony for you and how to provide your horse with a happy and healthy life.  If you want to develop a lifelong relationship with your horse, then this is the book for you!',8.00,31,0,NULL),(28,'REINING <small>(COMPLETELY REVISED)</small>','0','In Western Horseman’s best selling book \"Reining\", Al Dunning discusses fast turn-arounds, smooth circles and long slides. This guide for training and showing winning reining horses is a must have.',NULL,NULL,1,1,'','',18.00,'','','Al_Dunning_Reining_Book.jpg','',0.0000,1,1,'\"Today\'s reining horse evolved from the cowboy\'s ranch horse, whose job is to gather,move,hold,and sort cattle on the open range. A cowboy needs an agile saddle horse who is quick on his feet, can be controlled by a light rein, and has an explosive start and stop.\" - \r\nAl Dunning In Western Horseman Magazines  best selling book \"Reining Completely Revised\"',8.00,20,0,NULL),(29,'HORSE, FOLLOW CLOSELY: NATIVE AMERICAN HORSEMANSHIP™ RELATIONSHIP TRAINING™ - THE FOUNDATION','0','GaWaNi Pony Boy combines Native American philosophy and history with step by exercises to do with your horse. (VIDEO BOX SET)',NULL,NULL,1,1,'','',59.95,'','','Horse_Fol_Box_Video_Set.jpg','',0.0000,1,1,'Following in the same tradition as the best selling book that launched the GaWaNi Pony Boy collection, the Horse, Follow Closely two-video gift box set combines Native American philosophy and history with step-by-step horse-training methods. Pony visually demonstrates the training excercises described in his book against a backdrop of glorious scenery. \r\nTwo VHS cassettes showcase the 90 minute demonstration.\r\n',6.00,34,0,NULL),(30,'Private Lessons with Julie Goodnight','0','Two training audio tapes or CD\'s:  \"Balance, Rythem & Communication with Your Horse\"\r\n\r\n\"The Hows and Whys of Good Horsemanship\"',NULL,NULL,1,1,'','',29.95,'','','Julie_Goodnight_Audio_2.jpg','',0.0000,1,1,'Julie Goodnight has been a full time equine professional for more than 20 years, with a varied background ranging from dressage and jumping to racing, reining, and wilderness riding.  Julie is known for her logical and straight forward style of teaching and her ability to bridge natural horsemanship techniques with the principles of classical riding with an understandable and practical approach.',4.00,32,NULL,NULL),(32,'CLOUD: WILD STALLION OF THE ROCKIES','0','WILD HORSES. Symbols of freedom and mystery. But not until Ginger Kathrens ventured into an isolated corner of the Rocky Mountains have we had the opportunity for such an intimate glimpse into the private lives of these magnificent animals.',NULL,NULL,1,1,'','',24.95,'','','Cloud_Book_2.jpg','',0.0000,1,1,'This story unfolds as we follow Cloud, the remarkable light-colored horse, from fragile newborn foal to five-year-old stallion. We find out how family bands are formed, how foals learn the rules of wild horse society, how bachelors fight to try to win mares, and how stallions protect their families. The drama comes alive with Ginger\'s words and photographs. We come to know the horses as if they were our friends. Breathtaking scenery, rugged terrain, and unpredictable weather remind us of how harsh yet fulfilling life can be for the wild horses.\r\n',8.00,28,0,NULL),(33,'RIDING FOR THE BLUE: A CELEBRATION OF HORSE SHOWS','0','This beautiful coffee table book by Cindy Hale, conveys the appeal, sportsmanship, delight, and competitiveness of the horse show world.',NULL,NULL,1,1,'','',39.95,'','','Riding_For_The_Blue_2.jpg','',0.0000,1,1,'Author and thirty year horse shoe veteran Cindy Hale examines why riders compete.  From breaking in a green horse to the excitement in the arena to packing up after a show and starting all over again, Hale evokes the passion for showing that drives every exhibitor.  Interwoven into the descriptive text are colorful, artistic photographs by Sharon Fibelkorn illustrating that regardless of what sort of saddle you ride in or what breed of horse you fall in love with, the desire to win the blue ribbon is universal.',8.00,29,0,NULL),(34,'ROPING TO WIN','0','World champion roper Kim Williamson gives inside tips on roping and working with your horse. A must-have video for anyone wanting to improve on their roping skills or learn about the sport of \"Breakaway Roping\".  ',NULL,NULL,1,1,'','',34.97,'','','Roping_To_Win_Video_2.jpg','',0.0000,1,1,'Roping to Win - Championship Breakaway Roping, a video by Kim Williamson.   Kim was the 2001 WPRA Breakaway Champion. This video will teach you how to speed up your times and get the most out of your horse. From ground work to scoring your horse, it is all included in this special video designed for the breakaway roping enthusiast. Learn what it takes to be one of the best and how to break that 2-second time barrier.',6.00,41,0,NULL),(43,'HORSE HINGE BRACELET','SB241','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 3/16 X 2 3/4 Inches.</p>',NULL,NULL,1,1,'','',53.95,'','','SB241HorseHingeBracelet.jpg','',0.0000,1,1,'<p>HORSE HINGE BRACELET</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 3/16 X 2 3/4 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $53.95</p> ',3.00,70,0,NULL),(52,'D-BIT BRACELET','BR1001S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 3/8 x 7 inches.</p>',NULL,NULL,1,1,'','',49.95,'','','BR1001SDBitBracelet.jpg','',0.0000,1,1,'<p>D-BIT BRACELET</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 3/8 x 7 inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $49.95</p> ',3.00,73,0,NULL),(51,'Horseshoe Nugget Bracelet','BR1004S','Horseshoe Nugget Bracelet - Dimensions: 5/16 x 7 inches.',NULL,NULL,1,1,'','',49.95,'','','BR1004S_HS_Nugget_Bracelet.jpg','',0.0000,1,1,'Horseshoe Nugget Bracelet - Dimensions: 5/16 x 7 inches.  An exclusive Sterling Silver design cast of de-ox for tarnish risistant wear.  This rugged bracelet would make an excellent gift.  Free priority mail shipping in the U.S.!    $49.95',0.00,51,NULL,NULL),(55,'STERLING SILVER SPUR EARRING JACKETS','EJ1019S','STERLING SILVER SPUR EARRING JACKETS - DIMENSIONS: 1/2 X 1 INCH',NULL,NULL,1,1,'','',9.95,'','','EJ1019SSpurEaringJackets.jpg','',0.0000,1,1,'STERLING SILVER SPUR EARRING JACKETS - DIMENSIONS: 1/2 X 1 INCH. \r\nTHESE STERLING JACKETS ARE CAST OF DE-OX STERLING FOR  TARNISH RESISTANT WEAR. REQUIRES STUD EARING. STUD NOT INCLUDED. FREE SHIPPING IN THE U.S.! $9.95\r\n',0.00,72,NULL,NULL),(60,'LOOKS LIKE A WINNER PENDANT','P1007S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 13/16 x 1 Inch.</p>\r\n',NULL,NULL,1,1,'','',17.95,'','','P1007SLooksLikeAWinnerPend.jpg','',0.0000,1,1,'<p>LOOKS LIKE A WINNER PENDANT </p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 13/16 x 1 Inch.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $17.95</p> \r\n',3.00,61,0,NULL),(61,'PRETTY AS A PICTURE PENDANT','P1010S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 3/8 X 1 1/4 Inches.</p>',NULL,NULL,1,1,'','',37.95,'','','P1010SPrettyAsAPicturePend.jpg','',0.0000,1,1,'<p>PRETTY AS A PICTURE PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 3/8 X 1 1/4 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $37.95</p> ',3.00,62,0,NULL),(62,'LITTLE ITCH PENDANT','P1010S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 3/4 x 3/4 inch.</p>\r\n',NULL,NULL,1,1,'','',14.95,'','','P1012SLittleItchPendant.jpg','',0.0000,1,1,'<p>LITTLE ITCH PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 3/4 x 3/4 inch.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $14.95</p> \r\n',3.00,64,0,NULL),(63,'MARE AND COLT PLAYING PENDANT','P1019S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 1/8 X 1 inch.</p>',NULL,NULL,1,1,'','',29.95,'','','P1019SMare_ColtPlaying.jpg','',0.0000,1,1,'<p>MARE AND COLT PLAYING PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 1/8 X 1 inch.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $29.95</p> ',3.00,63,0,NULL),(64,'RUNNING FREE PENDANT','P1020S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 2 X 1 1/2 Inches.</p>\r\n',NULL,NULL,1,1,'','',55.95,'','','P1020SRunningFreePendant.jpg','',0.0000,1,1,'<p>RUNNING FREE PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 2 X 1 1/2 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $55.95</p> ',3.00,52,0,NULL),(65,'LADY CUTTER PENDANT','P1032S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 1/4 X 1 1/8 Inch.</p>',NULL,NULL,1,1,'','',19.95,'','','P1032SLadyCutterPendant.jpg','',0.0000,1,1,'<p>LADY CUTTER PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 1/4 X 1 1/8 Inch.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $19.95</p> \r\n',3.00,65,0,NULL),(68,'TENNESSEE WALKER PENDANT','P1060S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 13/16 X 1 3/16 Inches.</p>',NULL,NULL,1,1,'','',15.95,'','','P1060STennesseeWalkerPend.jpg','',0.0000,1,1,'<p>TENNESSEE WALKER PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 13/16 X 1 3/16 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $13.95</p> \r\n',3.00,53,0,NULL),(69,'TEAM ROPER PENDANT','P1080S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 2 1/8 X 1/2 Inches.</p>\r\n',NULL,NULL,1,1,'','',24.95,'','','P1080STeamRoperPendant.jpg','',0.0000,1,1,'<p>TEAM ROPER PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 2 1/8 X 1/2 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $24.95</p> \r\n',3.00,66,0,NULL),(70,'Barrel Racer Pendant','P1086S','3/4\" x 3/4\" Barrel Racer Pendant',NULL,NULL,1,1,'','',12.95,'','','small_barrel_racer_copy.jpg','',0.0000,1,1,'3/4\" x 3/4\" Barrel Racer Pendant -- This unique design is cast of de-ox Sterling for tarnish resistant wear.  Free standard shipping in the U.S.! $12.95\r\n',0.00,74,NULL,NULL),(71,'JUMPER IN A LOOP PENDANT','P1101S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 3/4 X 3/4 Inches.</p>\r\n',NULL,NULL,1,1,'','',17.95,'','','P1101SJumperinLoopPendant.jpg','',0.0000,1,1,'<p>JUMPER IN A LOOP PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 3/4 X 3/4 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $17.95</p> \r\n',3.00,71,0,NULL),(73,'ENGLISH BOOT PENDANT','P1109S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1/2 x 1 1/8 Inches.</p>',NULL,NULL,1,1,'','',12.95,'','','P1109SEnglishBootPendant.jpg','',0.0000,1,1,'<p>ENGLISH BOOT PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1/2 x 1 1/8 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $12.95</p> \r\n',3.00,76,0,NULL),(74,'SMALL CORGI DOG PENDANT','P1111S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 3/4 X 1/2 Inch.</p>',NULL,NULL,1,1,'','',14.95,'','','P1111SmallCorgiDogPendant.jpg','',0.0000,1,1,'<p>SMALL CORGI DOG PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 3/4 X 1/2 Inch.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $14.95</p> \r\n',3.00,77,0,NULL),(75,'RUNNING ARABIAN PENDANT','P1112S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 x 1 1/4 Inches.</p>',NULL,NULL,1,1,'','',23.95,'','','P1112SRunningArabianPendant.jpg','',0.0000,1,1,'<p>RUNNING ARABIAN PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 x 1 1/4 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $23.95</p> \r\n',3.00,56,0,NULL),(76,'LARGE CORGI DOG PENDANT','P1113S','<p>Cast in Sterling Silver.</p>\r\n<p>Dimensions: 1 1/2 X 1 1/4 Inches.</p>\r\n',NULL,NULL,1,1,'','',34.95,'','','P1113SLargeCorgiDogPendant.jpg','',0.0000,1,1,'<p>LARGE CORGI DOG PENDANT</p>\r\n<p>This unique design is cast of De-Ox sterling silver for a tarnish resistant finish.</p>\r\n<p>Dimensions: 1 1/2 X 1 1/4 Inches.</p>\r\n<p>FREE STANDARD SHIPPING IN THE U.S. $34.95</p> ',3.00,78,0,NULL),(77,'SHAKEY CHAIN NECKLACE','CN005','16\" OR 18\" 1MM STERLING SILVER SHAKEY CHAIN NECKLACE',NULL,NULL,1,1,'LENGTH','',0.00,'16 INCH, 18 INCH','','CN005_1mm_Shakey_Chain_Neck.jpg','4.95, 5.95',0.0000,1,1,'16\" OR 18\" 1MM STERLING SILVER SHAKEY CHAIN NECKLACE. FREE STANDARD SHIPPING IN THE U.S. PLEASE SELECT LENGTH DESIRED.  $4.95/$5.95',0.00,80,NULL,NULL),(79,'Black Leather Cord Necklace','SN063','Black Leather Cord Necklace with a Sterling Silver catch.  16 inch length.',NULL,NULL,1,1,'Width','',0.00,'2 mm, 3 mm, 4mm','','SN063_BlackLeatherCordNeck.jpg','11.95, 12.95, 13.95',0.0000,1,1,'16 inch Black Leather Cord Necklace with Sterling Silver catch.  Please select your desired width.  Free standard shipping in the U.S.! ',0.00,82,NULL,NULL),(80,'TAN LEATHER CORD NECKLACE','SN062','16 INCH TAN LEATHER CORD NECKLACE WITH STERLING SILVER CATCH',NULL,NULL,1,1,'WIDTH','',15.95,'2 MM, 3 MM, 4MM','','SNj062_TanLeatherCordNeck.jpg','12.95, 13.95, 15.95',0.0000,1,1,'16 INCH TAN LEATHER CORD NECKLACE WITH STERLING SILVER CATCH.  PLEASE SELECT DESIRED LENGTH.  FREE STANDARD SHIPPING IN U.S.',0.00,86,NULL,NULL),(86,'LET\'S GO TO A SHOW','0','This is the ultimate guide for young equestians to read if they want to go horse shows, win ribbons, and have a good time!',NULL,NULL,1,1,'','',12.95,'','','Let::s_Go_a_Show.jpg','',0.0000,1,1,'This ultimate guide to going to horse shows is written especially for young equestrians -- no other book covers all aspects of horse showing for young people.  It\'s packed with exciting photos and great tips that will help you look and act like a pro.  With this easy-to-read, informative book you\'ll learn everything you need to know for successful horse show competition, including:  What clothing to wear, What tack you will need, How to find a show, Types of classes, How to prepare your horse or pony, How to act at a show, Show terms, How to organize a fun show, How to solve your showing problems.  This is the book to read if you want to win ribbons and have a good time at shows!',8.00,69,0,NULL),(88,'REINING FOR THE RIDER','0','<p>World Champion Trainer Al Dunning shares his secrets on how to rein. It takes a great rider to be a winning Reiner.</P> \r\n\r\n<p>Al\'s proven techniques and tips will help you learn how to improve show ring pressence and compete sucessfully.</P>',NULL,NULL,1,1,'','',39.95,'','','ReiningfortheRiderCover01.18.10.jpg','',0.0000,1,1,'<p>REINING FOR THE RIDER: It takes a Champion Rider to train a Champion Reining Horse.</p>\r\n\r\n<p>Al designed this DVD specifically for the rider. He demonstrates each manuver step by step, so a rider can develop the riding skills needed for a Champion Reining horse.</p>\r\n\r\n<p>Included are how to practice the right way and how and how to pick the right horse, equipment, and coach. \r\nWith Al\'s proven techniques and tips, riders learn how to improve show ring pressence and compete sucessfully.</p>\r\n\r\n<p>Running Time 63 Minutes/Color (c) 2002 Al Dunning Training Stables and Phoebus Productions,LLC, All Rights Reserved.</P>',6.00,88,0,NULL),(89,'TRAINING A CHAMPION: VOLUME 1','0','<p>Featuring World Champion Trainer Al Dunning</P>\r\n\r\n<p>REINERS GUIDE: TRAINING A CHAMPION VOLUME 1 - Two and Three Year olds in Training - Stops, Spins, Lead Changes, and More.</p>',NULL,NULL,1,1,'','',69.95,'','','AlDunningTrainChampVolOne01.18.10.jpg','',0.0000,1,1,'<p>TRAINING A CHAMPION VOLUME 1: Al takes you through his complete training process on a day to day basis at his ranch. As he works with each horse he analyzes their strong and weak points, and then advances them to the next level.</p>\r\n\r\n<p>From starting a colt, to training two year olds, to getting three year olds ready to compete-you will learn what to do every step of the way in this, the first of Al\'s new two volume training series.</p>\r\n\r\n<p>Running Time 98 Minutes/Color (c) 2006 Al Dunning Training Stables and Phoebus Productions,LLC, All Rights Reserved.</P>',6.00,89,0,NULL),(90,'TRAINING A CHAMPION: VOLUME 2','0','<p>Featuring World Champion Trainer Al Dunning</p>\r\n\r\n<p>REINERS GUIDE: TRAINING A CHAMPION VOLUME 2 - Train your horse to be a champion reiner - Advanced maneuvers and equipment</P>',NULL,NULL,1,1,'','',39.95,'','','AlDunningTrainChampVolTwo.01.18.10.jpg','',0.0000,1,1,'<p>TRAINING A CHAMPION VOLUME 2: Al demonstrates what it takes to advance four year old and older horses to the show ring. These horses have had their foundation training and are ready to go to the next level-becomming a winner.</p>\r\n\r\n<p>Al analyzes six horses, discussing their strong and weak points and then shows the techniques he has used to train World Champions.</p>\r\n\r\n<p>Running Time 73 Minutes/Color (c) 2006 Al Dunning Training Stables and Phoebus Productions,LLC, All Rights Reserved.</P>',6.00,90,0,NULL),(91,'ADVANCE TO THE HACKMORE','0','<p>Featuring World Champion Trainer Al Dunning</p>\r\n\r\n<p>ADVANCE TO THE HACKMORE: from the baisics to advanced manuevers, to winning a championship</P> ',NULL,NULL,1,1,'','',39.95,'','','AlDuningHackamore.01.18.10.jpg','',0.0000,1,1,'<p>ADVANCE TO THE HACKMORE: In this video Al Dunning will help you understand the mechanics of riding with a hackmore. You will gain insightful tips on how to pick the right hackmore and how to tie it correctly.</P>\r\n\r\n<p>Al will also demonstrate how to use the snaffle for a smooth transition to the bit and for advanced manuevers</P>\r\n\r\n<p>Running time 45 minutes/color (c)2002 Al Dunning Training Stables and Phoebus Productions,LLC, All Rights Reserved.</p>',6.00,91,0,NULL),(92,'CUTTING WITH THE MECHANICAL COW','0','<p>Featuring World Champion Trainer Al Dunning</p>\r\n\r\n<p>CUTTING WITH THE MECHANICAL COW: Learn to effectively train your cutting horse using the mechanical cow.</p> ',NULL,NULL,1,1,'','',39.95,'','','ADunningMechCow.01.18.10.jpg','',0.0000,1,1,'<p>CUTTING WITH THE MECHANICAL COW: Al shares his many years of experience and knowledge about how to use a mechanical cow to assist when training a cutting horse.</P>\r\n\r\n<p>Although there\'s no substitute for live cattle, the mechanical cow is a great way to train your horse in a controlled environment.</P>\r\n\r\n<p>Running time 55 minutes/color (c)2007 Al Dunning Training Stables and Phoebus Productions,LLC, All Rights Reserved.</P>',6.00,92,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=141 DEFAULT CHARSET=latin1;

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

INSERT INTO `Sale` VALUES (3,1,1,'Show #101','101',14.95,'','',3,NULL),(4,2,1,'The Long Way To Los Gatos','0',25.00,'','',4,NULL),(5,20,1,'The Rider’s Guide to Reining – So- You Want to be a Reiner','0',39.95,'','',5,NULL),(6,2,1,'The Long Way To Los Gatos','0',25.00,'','',6,NULL),(9,12,1,'Show HT107','107',14.95,'','',11,NULL),(10,14,1,'Show HT109','0',14.95,'','',11,NULL),(11,11,1,'Show HT106','106',14.95,'','',11,NULL),(12,29,1,'Horse Follow Closely Box Video Set','0',59.95,'','',12,NULL),(13,80,1,'TAN LEATHER CORD NECKLASS','SN062',15.95,'','',13,NULL),(14,54,1,'ENGLISH STIRRUP EARRING JACKETS','EJ1024S',9.95,'','',13,NULL),(15,68,1,'TENNESSEE WALKER PENDANT','P1060S',13.95,'','',15,NULL),(16,52,1,'D-BIT BRACELET','BR1001S',49.95,'','',16,NULL),(17,68,1,'TENNESSEE WALKER PENDANT','P1060S',13.95,'','',17,NULL),(99,80,1,'TAN LEATHER CORD NECKLACE','SN062',12.95,'2 MM','',82,NULL),(19,20,1,'The Rider’s Guide to Reining – So- You Want to be a Reiner','0',39.95,'','',20,NULL),(20,2,1,'The Long Way To Los Gatos','0',25.00,'','',21,NULL),(21,30,1,'Private Lessons with Julie Goodnight','0',29.95,'','',24,NULL),(22,34,1,'Roping To Win','0',34.97,'','',25,NULL),(23,71,1,'Jumper In A Loop Pendant','P1101S',17.95,'','',26,NULL),(24,79,1,'Black Leather Cord Necklace','SN063',11.95,'2 mm','',26,NULL),(25,43,1,'Horse Hinge Bracelet','SB241',53.95,'','',27,NULL),(26,79,6,'Black Leather Cord Necklace','SN063',12.95,' 3 mm','',28,NULL),(27,43,1,'Horse Hinge Bracelet','SB241',53.95,'','',29,NULL),(28,35,1,'Premium Pollen Nutrient','0',32.95,'','',30,NULL),(29,16,1,'Show HT111','111',14.95,'','',31,NULL),(30,17,1,'Show HT112','112',14.95,'','',31,NULL),(31,48,1,'SWIRL FRONT CLOSURE BRACELET','SB029',24.95,'','',32,NULL),(32,80,1,'TAN LEATHER CORD NECKLACE','SN062',12.95,'2 MM','',33,NULL),(33,58,1,'8mm CZ Round Stud Earrings','SE350',11.95,'','',34,NULL),(34,29,1,'Horse Follow Closely Box Video Set','0',59.95,'','',35,NULL),(35,71,1,'Jumper In A Loop Pendant','P1101S',17.95,'','',36,NULL),(36,79,1,'Black Leather Cord Necklace','SN063',11.95,'2 mm','',36,NULL),(37,34,1,'Roping To Win','0',34.97,'','',37,NULL),(38,55,1,'STERLING SILVER SPUR EARRING JACKETS','EJ1019S',9.95,'','',38,NULL),(39,79,1,'Black Leather Cord Necklace','SN063',13.95,' 4mm','',39,NULL),(40,73,1,'English Boot Pendant','P1109S',12.95,'','',40,NULL),(41,71,1,'Jumper In A Loop Pendant','P1101S',17.95,'','',40,NULL),(42,34,1,'Roping To Win','0',34.97,'','',41,NULL),(43,79,1,'Black Leather Cord Necklace','SN063',11.95,'2 mm','',42,NULL),(44,63,1,'Mare and Colt Playing Pendant','P1019S',29.95,'','',42,NULL),(45,17,1,'Show HT112','112',14.95,'','',43,NULL),(46,71,1,'Jumper In A Loop Pendant','P1101S',17.95,'','',44,NULL),(47,73,2,'English Boot Pendant','P1109S',12.95,'','',44,NULL),(48,79,2,'Black Leather Cord Necklace','SN063',11.95,'2 mm','',44,NULL),(49,55,1,'STERLING SILVER SPUR EARRING JACKETS','EJ1019S',9.95,'','',45,NULL),(50,52,1,'D-Bit Bracelet','BR1001S',49.95,'','',46,NULL),(51,17,1,'Show HT112','112',14.95,'','',47,NULL),(52,16,1,'Show HT111','111',14.95,'','',47,NULL),(53,77,1,'SHAKEY CHAIN NECKLACE','CN005',4.95,'16 INCH','',48,NULL),(54,64,1,'RUNNING FREE PENDANT','P1020S',29.95,'','',48,NULL),(55,21,1,'Advance to the Hackamore','0',39.95,'','',49,NULL),(56,2,1,'The Long Way To Los Gatos','0',25.00,'','',50,NULL),(57,51,20,'Horseshoe Nugget Bracelet','BR1004S',49.95,'','',51,NULL),(58,58,20,'8mm CZ Round Stud Earrings','SE350',11.95,'','',51,NULL),(59,77,1,'SHAKEY CHAIN NECKLACE','CN005',4.95,'16 INCH','',51,NULL),(60,77,20,'SHAKEY CHAIN NECKLACE','CN005',5.95,' 18 INCH','',51,NULL),(61,57,20,'10mm CZ Stud Earring','SE351',13.95,'','',51,NULL),(62,79,1,'Black Leather Cord Necklace','SN063',13.95,' 4mm','',52,NULL),(63,83,1,'Julie Goodnight Training Video Part 1 & 2','0',69.95,'2 Video Set','',53,NULL),(64,2,1,'The Long Way To Los Gatos','0',25.00,'','',54,NULL),(65,56,1,'Marcasite Horseshoe Post Earrings','ME039',23.95,'','',55,NULL),(66,57,1,'10mm CZ Stud Earring','SE351',13.95,'','',56,NULL),(67,53,1,'WESTERN STIRRUP STUD EARRING JACKETS','EJ1014S',9.95,'','',56,NULL),(68,55,1,'STERLING SILVER SPUR EARRING JACKETS','EJ1019S',9.95,'','',56,NULL),(69,79,1,'Black Leather Cord Necklace','SN063',11.95,'2 mm','',57,NULL),(70,47,1,'STERLING SILVER KNOB CUFF BRACELET','SB180',19.95,'','',58,NULL),(73,52,1,'D-Bit Bracelet','BR1001S',49.95,'','',61,NULL),(72,55,1,'STERLING SILVER SPUR EARRING JACKETS','EJ1019S',9.95,'','',60,NULL),(74,83,1,'Julie Goodnight Training Video Part 1 & 2','0',69.95,'2 Video Set','',62,NULL),(75,20,1,'The Rider’s Guide to Reining – So- You Want to be a Reiner','0',39.95,'','',63,NULL),(76,71,1,'Jumper In A Loop Pendant','P1101S',17.95,'','',64,NULL),(77,80,1,'TAN LEATHER CORD NECKLACE','SN062',12.95,'2 MM','',64,NULL),(78,2,1,'The Long Way To Los Gatos','0',25.00,'','',65,NULL),(79,21,1,'Advance to the Hackamore','0',39.95,'','',65,NULL),(80,83,1,'Julie Goodnight Training Video Part 1 & 2','0',69.95,'2 Video Set','',65,NULL),(81,4,1,'Best of Horses Today Volume 2','B002',18.95,'','',66,NULL),(82,19,1,'Show HT113','113',14.95,'','',66,NULL),(83,34,1,'Roping To Win','0',34.97,'','',67,NULL),(84,30,1,'Private Lessons with Julie Goodnight','0',29.95,'','',68,NULL),(85,2,1,'The Long Way To Los Gatos','0',25.00,'','',69,NULL),(86,73,1,'English Boot Pendant','P1109S',12.95,'','',70,NULL),(87,43,1,'Horse Hinge Bracelet','SB241',53.95,'','',71,NULL),(95,52,1,'D-Bit Bracelet','BR1001S',49.95,'','',78,NULL),(89,2,1,'The Long Way To Los Gatos','0',25.00,'','',73,NULL),(90,68,1,'TENNESSEE WALKER PENDANT','P1060S',13.95,'','',74,NULL),(91,43,1,'Horse Hinge Bracelet','SB241',53.95,'','',75,NULL),(93,77,1,'SHAKEY CHAIN NECKLACE','CN005',4.95,'16 INCH','',77,NULL),(94,70,1,'Barrel Racer Pendant','P1091S',12.95,'','',77,NULL),(96,52,1,'D-Bit Bracelet','BR1001S',49.95,'','',79,NULL),(97,44,1,'Round Link Toggle Sterling Silver Bracelet','SB020',32.95,'','',80,NULL),(98,47,1,'STERLING SILVER KNOB CUFF BRACELET','SB180',19.95,'','',80,NULL),(100,2,1,'The Long Way To Los Gatos','0',25.00,'','',83,NULL),(101,80,1,'TAN LEATHER CORD NECKLACE','SN062',15.95,' 4MM','',84,NULL),(102,63,1,'Mare and Colt Playing Pendant','P1019S',29.95,'','',85,NULL),(103,70,1,'Barrel Racer Pendant','P1091S',12.95,'','',85,NULL),(104,77,2,'SHAKEY CHAIN NECKLACE','CN005',4.95,'16 INCH','',85,NULL),(105,78,1,'ROUND SNAKE CHAIN','CH014',23.95,' 20 INCH','',86,NULL),(108,76,1,'Large Corgi Dog','P1113S',34.95,'','',90,NULL),(107,79,1,'Black Leather Cord Necklace','SN063',12.95,' 3 mm','',88,NULL),(109,55,1,'STERLING SILVER SPUR EARRING JACKETS','EJ1019S',9.95,'','',91,NULL),(117,21,1,'Advance to the Hackamore','0',39.95,'','',99,NULL),(118,21,1,'Advance to the Hackamore','0',39.95,'','',100,NULL),(119,20,1,'The Rider’s Guide to Reining – So- You Want to be a Reiner','0',39.95,'','',100,NULL),(122,68,1,'TENNESSEE WALKER PENDANT','P1060S',13.95,'','',103,NULL),(126,20,1,'The Rider’s Guide to Reining – So- You Want to be a Reiner','0',39.95,'','',107,NULL),(124,34,1,'Roping To Win','0',34.97,'','',105,NULL),(125,34,1,'Roping To Win','0',34.97,'','',106,NULL),(127,34,1,'Roping To Win','0',34.97,'','',108,NULL),(128,30,1,'Private Lessons with Julie Goodnight','0',29.95,'','',109,NULL),(129,92,1,'CUTTING WITH THE MECHANICAL COW','0',39.95,'','',110,NULL),(130,29,1,'HORSE, FOLLOW CLOSELY: NATIVE AMERICAN HORSEMANSHIP™ RELATIO','0',59.95,'','',111,NULL),(131,89,1,'TRAINING A CHAMPION: VOLUME 1','0',69.95,'','',112,NULL),(132,90,1,'TRAINING A CHAMPION: VOLUME 2','0',39.95,'','',113,NULL),(136,2,1,'THE LONG WAY TO LOS GATOS','0',25.00,'','',117,NULL),(135,94,1,'WESTERN DRESSAGE','0',39.95,'','',116,NULL),(137,89,1,'TRAINING A CHAMPION: VOLUME 1','0',69.95,'','',118,NULL),(138,88,1,'REINING FOR THE RIDER','0',39.95,'','',118,NULL),(139,89,1,'TRAINING A CHAMPION: VOLUME 1','0',69.95,'','',119,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(5) 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=545 DEFAULT CHARSET=latin1;

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

INSERT INTO `Shopping` VALUES (544,92,1429098726,1,'','horsestoday','');

--
-- Dumping events for database 'horsestoday'
--

--
-- Dumping routines for database 'horsestoday'
--


