--
-- Host: localhost    Database: jeraldpeterson
-- ------------------------------------------------------


--
-- 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,
  `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=26 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Category` VALUES (1,0,0,0,3,NULL,'Top Level',NULL,0),(6,0,8,16,0,'','Reproductions<BR>','',0),(3,0,8,6,0,'Original Oil Paintings by Jerald Peterson<BR><BR>Please call 918-810-3615 to inquire about availability and price','Oil Gallery<BR>','',0),(16,0,6,22,0,'Original watercolor paintings','Watercolors','',0),(25,0,1,0,0,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!','$100 Originals--free shipping','Cat_in_the_Window.jpg',0),(24,0,5,25,0,'Jerald loves to paint his Faith.  He has several of his oil paintings hanging in our parish, St. Brigid Catholic Church in Tahlequah, OK.  If you or your church would like to commission a painting, please contact me, Molly: 918-810-3615','Sacred Art<BR><BR>','Mother,_child,_snake.jpg',0),(22,0,1,24,0,'Once or twice a month, we offer a fun evening of painting a watercolor under the tutelage of Jerald Peterson, internationally known watercolorist.  You may indulge yourself with a delicious meal and beverage of your choice while you explore your artistic side, painting a watercolor you can frame and hang on your wall at home or office!  All your art supplies and instruction are included in the price of $30.  A delicious meal and glass of wine are complimentary.  We can handle up to 16 artists.  Call Molly at 918-810-3615 to reserve your spot.<BR><BR>Please consider letting us host your special events--birthdays, ladies\' night out, parties, etc.--at our Watercolor Barn.  Call Molly for details at 918-810-3615.  The schedule for our Watercolor Nights is:<BR><BR>May 22, June 19, July 17, Aug 21, Sept 18, Oct 9, Nov 13.<BR><BR>We may add more Watercolor Nights, based on demand.  Keep checking back to this schedule to see!','','wine_and_watercolor_students_painting.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=1339 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Inventory` VALUES (1300,32,6),(1040,3,6),(600,376,11),(1056,387,6),(1301,6,6),(1038,7,6),(1177,598,16),(1046,40,6),(660,412,13),(1043,34,6),(670,445,15),(1176,597,16),(649,429,14),(419,211,7),(1049,92,6),(1047,52,6),(657,432,14),(1307,690,16),(425,226,7),(422,218,7),(1254,592,3),(468,270,8),(1039,37,6),(1247,465,3),(1041,28,6),(1045,39,6),(1044,33,6),(671,446,15),(1048,89,6),(1053,342,6),(665,440,15),(1222,642,16),(1235,47,3),(650,427,14),(667,442,15),(632,414,13),(1236,120,3),(1243,407,3),(421,217,7),(1244,408,3),(664,439,15),(478,279,7),(240,83,4),(241,84,4),(1055,345,6),(663,438,12),(1248,466,3),(1240,401,3),(703,468,12),(687,462,11),(1274,653,16),(609,393,12),(608,392,12),(853,501,18),(1174,497,16),(605,388,12),(1163,478,16),(1050,113,6),(1239,343,3),(1302,686,16),(428,230,7),(666,441,15),(1224,654,16),(1304,688,24),(704,469,6),(431,233,7),(651,430,14),(467,269,8),(1194,410,3),(1306,689,3),(1054,344,6),(852,500,18),(627,409,12),(637,419,13),(347,155,4),(851,499,18),(1255,602,3),(424,220,7),(1051,145,6),(1052,146,6),(661,413,13),(423,219,7),(1237,184,3),(712,476,12),(418,210,7),(473,275,8),(430,232,7),(429,231,7),(420,216,7),(654,433,14),(636,418,13),(641,420,12),(1218,648,16),(1169,491,16),(1225,655,16),(1213,643,16),(652,431,14),(474,276,8),(469,271,8),(633,415,13),(470,272,8),(471,273,8),(472,274,8),(635,417,13),(596,379,11),(1238,340,3),(669,444,15),(634,416,13),(655,434,14),(656,435,14),(672,447,15),(673,448,15),(674,449,15),(675,450,15),(676,451,15),(677,452,15),(678,453,15),(679,454,15),(680,455,15),(681,456,15),(682,457,15),(683,458,15),(684,459,15),(685,460,15),(686,461,15),(1129,626,20),(1284,477,16),(850,498,18),(1249,473,3),(1305,680,24),(1057,475,6),(1164,480,16),(717,481,17),(718,483,17),(1165,484,16),(1214,644,16),(1271,486,16),(1256,606,3),(1168,488,16),(1285,494,16),(1170,492,16),(1126,623,16),(1172,495,16),(854,502,18),(855,503,18),(856,504,18),(857,505,18),(858,506,18),(859,507,18),(860,508,18),(861,509,18),(862,511,18),(863,512,18),(864,513,18),(865,514,18),(866,515,18),(867,517,18),(868,518,18),(869,519,18),(870,520,18),(871,522,18),(872,523,18),(873,524,18),(874,525,18),(875,527,18),(876,528,18),(877,529,18),(878,530,18),(879,531,18),(880,533,18),(881,536,18),(882,539,18),(883,540,18),(884,542,18),(885,543,18),(886,544,18),(887,545,18),(888,546,18),(889,547,18),(890,548,18),(891,549,18),(892,550,18),(893,551,18),(894,552,18),(895,554,18),(896,555,18),(897,556,18),(898,557,18),(899,558,18),(900,559,18),(901,560,18),(902,561,18),(903,562,18),(904,564,18),(905,565,18),(906,567,18),(907,568,18),(908,569,18),(909,570,18),(910,571,18),(911,572,18),(912,573,18),(913,574,18),(914,575,18),(915,576,18),(916,577,18),(1252,590,3),(1261,618,3),(1253,591,3),(1175,595,16),(1122,619,16),(1178,604,16),(1257,608,3),(1303,687,24),(1127,624,20),(1259,611,3),(1263,639,3),(1183,636,16),(1131,628,20),(1132,629,20),(1179,635,16),(1134,631,20),(1262,632,3),(1272,647,16),(1137,634,20),(1219,649,16),(1221,652,16),(1226,656,6),(1227,657,6),(1228,658,6),(1229,659,6),(1230,660,6),(1231,662,6),(1276,674,21),(1233,664,6),(1234,665,16),(1264,666,16),(1265,667,16),(1266,668,16),(1275,673,21),(1268,670,16),(1269,671,16),(1277,675,21),(1278,676,21),(1289,681,24),(1280,678,21),(1292,683,24),(1294,684,24),(1293,685,24),(1317,691,25),(1318,692,25),(1319,694,25),(1320,695,25),(1322,697,25),(1323,698,25),(1324,699,25),(1325,700,25),(1326,701,25),(1327,702,25),(1328,703,25),(1329,704,25),(1333,709,25),(1331,706,25),(1332,708,25),(1335,711,25),(1336,712,25);

--
-- 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` tinyblob,
  `cart_total` double(8,2) DEFAULT NULL,
  `tax` double(8,2) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

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


--
-- 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=53 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Page` VALUES (2,'</center><BR><BR>\"Victorian Woman\"<BR><BR>Here is Jerald\'s latest watercolor painting.  It is signed with Jerald\'s name and then, after Leighton.  He is giving credit to the artist who inspired the painting. Leighton is among the most well-known of Victorian artists.<BR><BR>This painting kicks off our \"$100 page--free shipping\"  Please click onto this page on our website: www.watercolorbarn.com to see these beautiful paintings that are priced to sell!  Most are paintings Jerald painted while teaching a workshop.  They are great for birthdays, graduations, gifts, etc.<BR><BR>Jerald Peterson is an acclaimed oil and watercolor painter who has won numerous awards at exhibitions and outdoor fine art festivals.  His subject matter varies--monasteries, arches, courtyards, barns, Mexico, Paris, Sacred art, and old world portraits.<BR><BR>If you like a piece you see on our website, call Molly at 918-810-3615.  Also if you have an idea of a painting that you would like to discuss with the artist, call us. Please peruse our website to see all the beautiful paintings and prints.<BR><BR>Jerald and Molly live in Tahlequah, OK, a small city in Oklahoma, home to Northeastern State University, and the capital of the Cherokee Nation. It is where they landed after living overseas for over 20 years in Peterson\'s first career as a Operations Officer for the C.I.A.<BR><BR>Jerald spends his days in his Watercolor Barn painting, teaching private students, and giving painting workshops.  He and Molly participate in several outdoor art festivals during the year.  <BR><BR>Jerald is a Non-Resident Artist member of the Salmagundi Club in NYC (www.salmagundi.org), a member of the Southwestern Watercolor Society in Dallas, Texas (www.swswatercolor.org),a member of Muskogee OK Art Guild (www.muskogeeartguild.org), and the Arts Council Tahlequah<BR><BR>',3,0,'Victorian_Woman_after_Leighton.jpg','','','Watercolor Barn<BR><BR><BR>',NULL,NULL),(38,'This information on this page is ongoing.  We will let you know as soon as we are accepted into the shows.\r\n\r\nArt in the Square, Southlake, TX Apr. 27-29',1,1,'',NULL,NULL,'Schedule 2012','',NULL),(39,'<center>Schedule of shows 2012</center><BR><BR>Art on the Square, Southlake, TX   April 27-29',1,1,'Booth_shot_Houston.jpg',NULL,NULL,'Schedule 2012','',NULL),(40,'<center>Schedule of shows 2012</center><BR><BR>Art on the Square, Southlake, TX   April 27-29',1,1,'Booth_shot_Houston.jpg',NULL,NULL,'Schedule 2012','',NULL),(5,'After a twenty-five year career serving as a political officer in Washington D.C. and U.S.Embassies in North Africa, Latin America, and Europe, Peterson retired in 1990 to pursue a second career as an artist.  His work can be found in the homes of diplomats, businessmen, journalists, and art lovers around the world.  \r\n\r\nA self-taught watercolor and oil painter, Peterson\'s representational style and earthy palette are distinctively his own.  Whether painting an Oklahoma farm, Colonial Mexico, or a French countryside or cityscape, Peterson draws on his unique experience to share with others the rustic beauty he finds in the humble, time-worn, and hand-hewn.\r\n\r\nJerald Peterson is a internationally known artist.  He is a frequent award winner at fine art exhibits and outdoor festivals from coast to coast.  His work can frequently be seen in Southwest Art Magazine.  He is a non-resident  artist member of the Salmagundi Club in New York City(www.salmagundi.org)and a member of the South West Watercolor Society in Dallas (www.swswatercolor.org).  Jerald and Molly have hosted Painting Workshops in their studio in Oklahoma and in San Miguel de Allende, Mexico. \r\n\r\nJerald Peterson has had exhibitions of his paintings in Mexico City, Paris, Santo Domingo, and many venues in the United States. He has an art studio/Watercolor Barn in Tahlequah, OK, where he lives with his wife and inspiration, Molly, and gives individual and group watercolor classes.  They also offer watercolor workshops of several days at a time which include Molly\'s international meals and artisan bread baked in the Watercolor Barn.',1,1,'Jerry_in_Garden.jpg',NULL,NULL,'Jerald Peterson<BR>','Jerald Peterson',NULL),(46,'Feb. 13  \"Wines of Winter Tasting and Art Showing\" Spider Art Gallery, Tahlequah, OK\r\n\r\nFeb. 14  \"Erotic Art Show\"  Iguana Cafe, Tahlequah, OK\r\n\r\nMarch 8  \"Starvin\' Artists\' Lunch\"  Watercolor Barn\r\n\r\nApril 12 \"Meet and Greet the Artists\" Downtown Art Gallery, Muskogee, OK\r\n\r\nApril 25-27   Art in the Square, Southlake, TX',1,1,'',NULL,NULL,'2014 Schedule','',NULL),(45,'Peterson Fine Art Studio and Watercolor Barn is located just outside of Tahlequah, OK, in the foothills of the Ozarks.  In this picturesque setting, Jerald Peterson teaches individuals and groups his classical painting techniques learned over many years of experience.  Special events and workshops are hosted here.',1,1,'Pic_of_Deck.jpg',NULL,NULL,'Watercolor Barn','Watercolor Barn<BR>',NULL),(47,'',1,1,'',NULL,NULL,'2014 Schedule','',NULL),(48,'This page will be updated as we find out what shows we have been accepted into:\r\n\r\n\r\nMay 7-8   Cottonwood Art Festival, Richardson, TX\r\n\r\nSept 8-Oct 27  Artist painting in San Miguel',1,1,'Woman_sweeping.jpg',NULL,NULL,'2016 Schedule','<BR> 2016 Schedule<BR>',NULL),(49,'Jerald shares his love of watercolor with others as he leads Watercolor Workshops.  The workshops are for all levels of expertise as Jerald gives personal guidance to each participant.  The goal is for the artist to turn out a painting worthy of framing and hanging in the home.  ',1,1,'Jerald_at_easel.jpg',NULL,NULL,'','',NULL),(50,'Jerald and Molly host \"Wine and Watercolor\" events in the Watercolor Barn about twice a month.  Participants come to learn how to paint a simple landscape. They are invited to have a glass of wine and some snacks, and all supplies are furnished at no charge. From 6-9, we visit, laugh, and explore our artistic side!  Participation is limited to 16, so it is a good idea to reserve your space early.  Our next event is Friday, Feb. 20th.  We are planning two events in March, on the 6th and 20th.  Cost is $30.  Call Molly at 918-810-3615 to reserve your place!<BR><BR>We will also schedule your \"special event\" such as birthday, reunion, etc.  You can choose the date.  The cost is only $400, and we can handle up to 16 painters.',1,1,'Feb_6_W_W.jpg',NULL,NULL,'Wine and Watercolor events','',NULL),(51,'Our \"Wine and Watercolor\" events are really catching on!  For only $30, you can paint a watercolor(under the watchful eye of Jerald Peterson, internationally known artist) suitable for framing and hanging on your wall.  The price includes all art supplies, a glass of wine or soda, and a delicious meal prepared by Molly.  We have room for 16 artists, so call early to reserve your spot! The hours are from 6-9 PM, usually on a Friday.\r\n\r\nWe also offer our Watercolor Barn with all of the above, for your special events, for example birthdays, reunions, girls\' night out, etc.  The price for the evening is $400 and we can welcome up to 16.',1,1,'',NULL,NULL,'Wine and Watercolor events','',NULL),(33,'',1,1,'',NULL,NULL,'','',NULL),(9,'This beautiful bridal portrait was commissioned by a collector who was married in Mexico.  He gave Jerald a lot of freedom to create the piece.  He furnished several photos of his beautiful bride and then just told Jerald that  there were flowers, arches, people, and musicians at the wedding.  You can see how artistically Jerald composed the painting.  This piece will retain its beauty and value for generations to come!',1,1,'Rosana::s_Wedding.JPG',NULL,NULL,'New Painting','',NULL),(25,'',1,1,'Barbara,_Diana,_and_Betty_painting_in_garden.jpg',NULL,NULL,'Workshops in San Miguel de Allende','',NULL),(20,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(8,'I have never been so reluctant to offer for sale one of Jerald\'s paintings as I have this one!  This is a piece so full of joy and friendship that one would never grow tired of looking at it. This piece, \"Compadres,\" (best friends) is an excellent example of the artist\'s \"moment in time\" paintings.  The absolute joy captured on the face of the man on the right is magnificent!  The comraderie is apparent among all three.  I believe anyone who views this painting will smile along with them.  The price of this piece is $5500.  ',1,1,'La_Cena.JPG',NULL,NULL,'Compadres','',NULL),(26,'',1,1,'',NULL,NULL,'Workshops in San Miguel','',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,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(19,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(10,'Vacation oil painting workshops in San Miguel de Allende, Mexico are now being formed for Fall 2003.  A maximum of 4 participants in each class will learn Jerald\'s techniques and secrets for successful oil painting.  Artists at all levels will be welcome, from beginners to advanced.<BR><BR><BR><BR>Room and board are included in the cost of the seven day workshop.  Workshop participants will stay in the Peterson home/studio located right in the central part of the city.  Meals will be prepared by Molly Peterson.  Her international specialities will delight your palate.  There will be plenty of free time to see and enjoy the gorgeous colonial city of San Miguel de Allende, Mexico.<BR><BR><BR><BR>We are now forming workshops for:<BR><BR>October 19-26, 2003<BR><BR>November 9-16, 2003<BR><BR><BR><BR>Call us at 918-810-3615 or email us at petersonfineart@aol.com to receive information about price of workshop, travel instructions, etc.\r\n',1,1,'View_of_Parroquia_corrected.JPG',NULL,NULL,'Woprkshops in San Miguel','',NULL),(30,'PETERSON FINE ART STUDIO  \r\nTahlequah, Oklahoma\r\nwhere everything that can be green, IS! \r\n \r\n \r\nDear Friends and Art-Lovers and Artists: \r\n\r\nMany of you have expressed an interest in participating in a painting workshop here in Oklahoma.  It is fun to be able to offer you something new--Painting Workshops in Our Studio here in Tahlequah, OK.  We have given workshops in Mexico for years, but now we will also offer them here.  We live and work in a spacious barn/studio with a large screened in deck.  We have room for 6-8 painters and would like to invite you to sign up!  Since there will be so few painters, your level of expertise is not important.  The teacher can spend plenty of time with you.\r\n \r\nWe are planning two 5-day workshops this fall:  Sept. 8-12 and Oct. 13-17.  The first workshop is an Oil Painting Workshop and the second is a Transparent Watercolor Workshop.  We will provide you with a materials list later.  The cost of the five days will be $600.  That includes 6 hours daily of working with Jerald, lunch and dinner, and many of your supplies.  If you travel with a non-painting spouse or friend, they can join us for meals and drinks for only $25 per day.\r\n \r\nAs you can see, this is more than a workshop--it is a retreat.  For five days, you will be surrounded by art, conversation about art, books about art, and art videos!  After class, we will sit at the table and share ideas, ambitions, and of course FOOD! Anyone who has eaten around the Peterson table will attest to Molly\'s culinary skills.  Her artisan bread will tempt you and there will be wine and beer for your enjoyment at the dinner meal. \r\n \r\nWe have given these kind of retreat/workshops for years, but in Mexico.  They have resulted in many lasting friendships among the artists and us.  We have shared our knowledge about marketing art with artists who have gone on to participate in Fine Art Festivals and competitions in their area.  \r\n \r\nYou will arrange your own lodging.  We have several fine motels here in Tahlequah.  Our favorite is the Holiday Inn Express.  The rate of $70 for double occupancy is quite fair, but since you know the discounted rate of $70, you can use Priceline to try for a further discount!  \r\n \r\nTahlequah is situated in northeastern Oklahoma, in the foothills of the Ozarks.  It is an historic little place.  It was the end of the trail of tears for the Cherokees.    Lake Tenkiller  is nearby for fishing, pontooning, swimming, etc. and the Illinois River  offers float trips and canoeing.  \r\n \r\nThe objective of the workshop is that you complete one beautiful painting in five days.  If you have time, you can paint a second one.  Subject matter will be decided by you.  If you have a photograph that you have always thought would make a good painting, or just have an idea in your mind, Jerald will help you transfer it to canvas or watercolor paper.  We have many photos of France and Mexico that you can look through, too, to find a scene you like.\r\n \r\nWe require a 25% non-refundable deposit to hold your place, with the balance due upon your arrival.  Jerald will want to talk to you about your participation, your level of expertise, art materials, etc.,  so please call him at 918-810-3615 to ask questions and get more information.  We look forward to welcoming  you at one of these art workshops!  \r\n \r\n\r\n \r\n \r\n\r\n \r\n\r\n',1,1,'Group_at_table_final.jpg',NULL,NULL,'Tahlequah Workshops','',NULL),(21,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(28,'',1,1,'',NULL,NULL,'Workshops in San Miguel','',NULL),(24,'We will be offering painting workshops in San Miguel de Allende, MX during the winter and summer months of 2011.  We will be in San Miguel June, July, and August 2010 to find suitable housing for the workshops.  \r\n\r\nStay tuned for more details!\r\n',1,1,'Barbara,_Diana,_and_Betty_painting_in_garden.jpg',NULL,NULL,'Workshops in San Miguel','',NULL),(22,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(27,'',1,1,'',NULL,NULL,'Workshops in San Miguel','',NULL),(23,'San Miguel Fine Art Printing and Posters is located on Zacateros #32 in San Miguel de Allende.  Here is Jerald standing in the doorway of the gallery which is our exclusive representative in San Miguel.  Our daughter and son-in-law, Ellie and Martin Vega, both artists, own the business and do fine art giclee prints on canvas and paper of Jerald\'s painting, their own paintings, and paintings and photos of clients.  Please go by and see the work!',1,1,'Jerry_in_front,_resized.jpg',NULL,NULL,'San Miguel Fine Art Printing and Posters','',NULL),(31,'PETERSON FINE ART STUDIO,<br><br>  \r\nTahlequah, Oklahoma<br><br>\r\nwhere everything that can be green, IS!<br><br> \r\n \r\nDear Friends and Art-Lovers and Artists:<br><br> \r\n\r\nMany of you have expressed an interest in participating in a painting workshop here in Oklahoma.  It is fun to be able to offer you something new--Painting Workshops in Our Studio here in Tahlequah, OK.  We have given workshops in Mexico for years, but now we will also offer them here.  We live and work in a spacious barn/studio with a large screened in deck.  We have room for 6-8 painters and would like to invite you to sign up!  Since there will be so few painters, your level of expertise is not important.  The teacher can spend plenty of time with you.<br><br>\r\n  \r\nWe are planning two 5-day workshops this fall:  Sept. 8-12 and Oct. 13-17.  The first workshop is an Oil Painting Workshop and the second is a Transparent Watercolor Workshop.  We will provide you with a materials list later.  The cost of the five days will be $600.  That includes 6 hours daily of working with Jerald, lunch and dinner, and many of your supplies.  If you travel with a non-painting spouse or friend, they can join us for meals and drinks for only $25 per day.<br><br>\r\n \r\nAs you can see, this is more than a workshop--it is a retreat.  For five days, you will be surrounded by art, conversation about art, books about art, and art videos!  After class, we will sit at the table and share ideas, ambitions, and of course FOOD! Anyone who has eaten around the Peterson table will attest to Molly\'s culinary skills.  Her artisan bread will tempt you and there will be wine and beer for your enjoyment at the dinner meal.<br><br> \r\n \r\n \r\nWe have given these kind of retreat/workshops for years, but in Mexico.  They have resulted in many lasting friendships among the artists and us.  We have shared our knowledge about marketing art with artists who have gone on to participate in Fine Art Festivals and competitions in their area.<br><br>  \r\n \r\nYou will arrange your own lodging.  We have several fine motels here in Tahlequah.  Our favorite is the Holiday Inn Express.  The rate of $70 for double occupancy is quite fair, but since you know the discounted rate of $70, you can use Priceline to try for a further discount!<br><br>  \r\n \r\nTahlequah is situated in northeastern Oklahoma, in the foothills of the Ozarks.  It is an historic little place.  It was the end of the trail of tears for the Cherokees.    Lake Tenkiller  is nearby for fishing, pontooning, swimming, etc. and the Illinois River  offers float trips and canoeing.<br><br>  \r\n\r\nThe objective of the workshop is that you complete one beautiful painting in five days.  If you have time, you can paint a second one.  Subject matter will be decided by you.  If you have a photograph that you have always thought would make a good painting, or just have an idea in your mind, Jerald will help you transfer it to canvas or watercolor paper.  We have many photos of France and Mexico that you can look through, too, to find a scene you like.<br><br>\r\n \r\nWe require a 25% non-refundable deposit to hold your place, with the balance due upon your arrival.  Jerald will want to talk to you about your participation, your level of expertise, art materials, etc.,  so please call him at 918-810-3615 to ask questions and get more information.  We look forward to welcoming  you at one of these art workshops!<br><br>  \r\n \r\n\r\n \r\n \r\n \r\n ',1,1,'Group_at_table_final.jpg',NULL,NULL,'','',NULL),(32,'',1,1,'Group_at_table_final.jpg',NULL,NULL,'Oklahoma Workshops','',NULL),(35,'Dr. Mike and Rebecca Mcwatters, Dallas, TX:<BR><BR>\"The Petersons provide a 5 star ***** Oil Painting Workshop and Cultural Experience in the beautiful and charming town of San Miguel de Allende.  The old colonial European silver mining town with open air markets, renowned courtyards, and stunning European architecture, provides the perfect backdrop for inspiring the artist within you!  Jerry\'s excellent oil painting instruction and guidance will encourage and prepare you for your next level as an artist.  The guided city outings are as fun and entertaining as the lively dining conversations around Molly\'s delicious meals.  You\'ll come away with beautiful airwork, a great cultural experience, new friends and a desire to come back again to the charming and friendly San Miguel.<BR>Thanks so much for hosting such a fabulous workshop experience like non other!\"',1,1,'Group_at_table_final.jpg',NULL,NULL,'Testimonials...','',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` varchar(255) DEFAULT NULL,
  `list2` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `prices` varchar(255) DEFAULT NULL,
  `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=715 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Product` VALUES (1,'Arches II','0','Arches II',NULL,NULL,1,0,'','',900.00,'','','Arches_II.jpg','',0.0000,1,1,'Arches II is a watercolor of the interior of an old monestary in Tepotzlan, Mexico.  It has been reproduced as a giclee print on canvas which can be framed as an oil painting. The edition is limited to 100.  ',0.00,1,NULL,NULL),(32,'Morning Light','0','giclee print on canvas<BR><BR><form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\" target=\"_top\">\r\n<input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\">\r\n<input type=\"hidden\" name=\"hosted_button_id\" value=\"WY8RJC9KXVN3A\">\r\n<table>\r\n<tr><td><input type=\"hidden\" name=\"on0\" value=\"special instructions\">special instructions</td></tr><tr><td><input type=\"text\" name=\"os0\" maxlength=\"200\"></td></tr>\r\n</table>\r\n<input type=\"image\" src=\"https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif\" border=\"0\" name=\"submit\" alt=\"PayPal - The safer, easier way to pay online!\">\r\n<img alt=\"\" border=\"0\" src=\"https://www.paypalobjects.com/en_US/i/scr/pixel.gif\" width=\"1\" height=\"1\">\r\n</form>\r\n',NULL,NULL,1,1,'','',500.00,'','','Morning_Light_corrected.JPG','',0.0000,1,1,'Giclee print on canvas of interior of 16th century monastery in Mexico. Sold stretched on 30x40 stretcher bars, gallery-wrapped, limited to only 100, signed and numbered on back of canvas. FREE SHIPPING IN CONTINENTAL U.S.<form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\" target=\"_top\">\r\n<input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\">\r\n<input type=\"hidden\" name=\"hosted_button_id\" value=\"WY8RJC9KXVN3A\">\r\n<table>\r\n<tr><td><input type=\"hidden\" name=\"on0\" value=\"special instructions\">special instructions</td></tr><tr><td><input type=\"text\" name=\"os0\" maxlength=\"200\"></td></tr>\r\n</table>\r\n<input type=\"image\" src=\"https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif\" border=\"0\" name=\"submit\" alt=\"PayPal - The safer, easier way to pay online!\">\r\n<img alt=\"\" border=\"0\" src=\"https://www.paypalobjects.com/en_US/i/scr/pixel.gif\" width=\"1\" height=\"1\">\r\n</form>\r\n<BR><BR>',0.00,33,0,0),(33,'Cuernavaca Garden','0','30x40 limited edition Iris print on canvas. Limited to 100.',NULL,NULL,1,1,'','',925.00,'','','Cuernavaca_Garden.jpg','',0.0000,1,1,'Painting of Italian fountain in a garden in Cuernavaca, Mexico. Framed size is 40x50.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,35,0,NULL),(618,'Peace Dove II','0','30x40 of a white dove flying in through the window of a 16th century monastery. Framed size is approx. 39x49.',NULL,NULL,0,1,'','',0.00,'','','Peace_Dove_II.jpg','',0.0000,1,1,'',0.00,618,0,NULL),(3,'\"Arcos II\"','0','',NULL,NULL,1,1,'','',925.00,'','','Arcos_II.jpg','',0.0000,1,1,'This is a giclee print on canvas of an original watercolor.  The edition is limited to 100.  The print depicts a scene from a 16th century monastery in a small village in Mexico. Sold stretched on 30x40 strecher bars and framed. $925 plus $50 shipping.',0.00,20,0,NULL),(401,'Dos Hombres and a Dog','0','30x40 oil',NULL,NULL,0,1,'','',0.00,'','','Dos_Hombres_and_a_Dog.jpg','',0.0000,1,1,'Two ragged soldiers in the Mexican Revolution take a break.  ',0.00,388,0,NULL),(387,'Arched Walkway','0','40x50 framed, this lovely piece draws you right down the hallway!',NULL,NULL,1,1,'','',925.00,'','','Arched_Walkway.jpg','',0.0000,1,1,'Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping. ',0.00,387,0,NULL),(388,'portrait of a couple','0','portrait of a couple',NULL,NULL,1,1,'','',0.00,'','','boyd_final_unframed.jpg','',0.0000,1,1,'This couple wanted a \"remembrance\" painting of a glorious cruise they took to the Greek Islands.  First, they posed for us in our studio in Oklahoma, then Jerald used some of their vacation photos to put the Aegean sea in the background and pose them on the balcony of their hotel. ',0.00,390,NULL,NULL),(6,'\"Monastery Entrance\"','0','Giclee print on canvas of interior of 16th century monastery in Mexico. Sold stretched on 30x40 stretcher bars, gallery-wrapped, limited to only 100, signed and numbered on back of canvas. FREE SHIPPING IN CONTINENTAL U.S.<form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\" target=\"_top\">\r\n<input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\">\r\n<input type=\"hidden\" name=\"hosted_button_id\" value=\"WY8RJC9KXVN3A\">\r\n<table>\r\n<tr><td><input type=\"hidden\" name=\"on0\" value=\"special instructions\">special instructions</td></tr><tr><td><input type=\"text\" name=\"os0\" maxlength=\"200\"></td></tr>\r\n</table>\r\n<input type=\"image\" src=\"https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif\" border=\"0\" name=\"submit\" alt=\"PayPal - The safer, easier way to pay online!\">\r\n<img alt=\"\" border=\"0\" src=\"https://www.paypalobjects.com/en_US/i/scr/pixel.gif\" width=\"1\" height=\"1\">\r\n</form>\r\n<BR><BR>',NULL,NULL,1,1,'','',500.00,'','','Monastery_Entrance.jpg','',0.0000,1,1,'Giclee print on canvas of entrance to a  16th century monastery in Mexico. Sold stretched on 30x40 stretcher bars, gallery-wrapped, limited to only 100, signed and numbered on back of canvas. FREE SHIPPING IN CONTINENTAL U.S.<form action=\"https://www.paypal.com/cgi-bin/webscr\" method=\"post\" target=\"_top\">\r\n<input type=\"hidden\" name=\"cmd\" value=\"_s-xclick\">\r\n<input type=\"hidden\" name=\"hosted_button_id\" value=\"WY8RJC9KXVN3A\">\r\n<table>\r\n<tr><td><input type=\"hidden\" name=\"on0\" value=\"special instructions\">special instructions</td></tr><tr><td><input type=\"text\" name=\"os0\" maxlength=\"200\"></td></tr>\r\n</table>\r\n<input type=\"image\" src=\"https://www.paypalobjects.com/en_US/i/btn/btn_buynowCC_LG.gif\" border=\"0\" name=\"submit\" alt=\"PayPal - The safer, easier way to pay online!\">\r\n<img alt=\"\" border=\"0\" src=\"https://www.paypalobjects.com/en_US/i/scr/pixel.gif\" width=\"1\" height=\"1\">\r\n</form>\r\n<BR><BR>',0.00,3,0,0),(7,'\"Monastery Shadows\"','0','',NULL,NULL,1,1,'','',925.00,'','','Monastery_Shadows.jpg','',0.0000,1,1,'This is a limited edition giclee print on canvas of an original oil painting.  The edition is limited to 100.  The print depicts the interior of a 16th century monastery in a small village in Mexico.  Sold framed for $925 plus $50 shipping.',50.00,6,0,NULL),(37,'Arcos','0','',NULL,NULL,1,1,'','',925.00,'','','Arcos.jpg','',0.0000,1,1,'View from inside a monastery in Mexico.  Original was a watercolor.  Sold stretched on 30x40 strecher bars and framed. $925 plus $50 shipping.',50.00,15,0,NULL),(345,'View of San Miguel de Allende','0','giclee print on canvas 40x50 (framed size)',NULL,NULL,1,1,'','',925.00,'','','View_of_San_Miguel_de_Allende.jpg','',0.0000,1,1,'Great view of the central church of San Miguel.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,345,0,NULL),(642,'Bar San Miguel','0','Watercolor of a San Miguel bar',NULL,NULL,0,1,'','',600.00,'','','Bar_San_Miguel_Watercolor.jpg','',0.0000,1,1,'',0.00,642,0,NULL),(606,'Concepcion\'s Baby','0','30x40 oil',NULL,NULL,0,1,'','',0.00,'','','Concepcion.JPG','',0.0000,1,1,'Mexican lady with typical Indian dress carrying her child on her back, secured with her rebozo.',0.00,606,0,NULL),(342,'Monk\'s Bathtub','0','Large basin in 16th century monastery in Mexico',NULL,NULL,1,1,'','',925.00,'','','Monks___Bathtub.JPG','',0.0000,1,1,'30x40 giclee print.  40x50 framed size.  Limited to 100. Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,342,0,NULL),(270,'Elizabeth\'s first painting','0','Wow! Did she ever capture the drama in this monastery scene!',NULL,NULL,1,1,'','',0.00,'','','eliz_pic_1.jpg','',0.0000,1,1,'',0.00,270,NULL,NULL),(598,'Grandma\'s Salt Shaker','0','',NULL,NULL,1,1,'','',0.00,'','','Grandma\'s_Salt_Shaker.jpg','',0.0000,1,1,'',0.00,598,0,NULL),(643,'Rosa Tiendita','0','Store off a Mexican street',NULL,NULL,1,1,'','',300.00,'','','Rosa_Tienda.jpg','',0.0000,1,1,'',0.00,643,0,NULL),(52,'Pots and Vines','0','30x40 Iris print on canvas.',NULL,NULL,1,1,'','',925.00,'','','Pots_and_Vines.jpg','',0.0000,1,1,'Beautiful still life of Mexican pots.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,47,0,NULL),(76,'Concepcion','0','30x40 oil painting',NULL,NULL,1,0,'','',4800.00,'','','Concepcion_2.JPG','',0.0000,1,1,'This colorful painting of a \"campesina\" from San Miguel de Allende portrays a nobility apparent to the viewer.  The costume is typical, as is the way she carries her baby on her back.',0.00,76,NULL,NULL),(21,'Old Jewish Quarter, Paris','0','original oil painting on canvas',NULL,NULL,1,0,'','',1800.00,'','','JewishQtOF.JPG','',0.0000,1,1,'Painting of one of the streets in the old Jewish quarter in Paris.  Size is 20x24 unframed, 26x30 framed.',0.00,23,NULL,NULL),(89,'Arcos III','0','30x40 Giclee print on canvas',NULL,NULL,1,1,'','',925.00,'','','Arcos_111_Corrected.JPG','',0.0000,1,1,'This is a hallway view of a monastery in Mexico.  Framed size is approx. 40x50. Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,89,0,NULL),(269,'Group Picture','0','What a happy group we are! Seated, Elizabeth and Mike Tashman from Tucson, standing, Judith Rice from Nashville, Jerry and Molly, and Pam North from Dallas',NULL,NULL,1,1,'','',0.00,'','','group_pic.jpg','',0.0000,1,1,'',0.00,269,NULL,NULL),(34,'L\'auberge St Germain, Paris','0','30x40 limited edition Iris print on canvas.',NULL,NULL,1,1,'','',925.00,'','','French_Cafe.jpg','',0.0000,1,1,'A sidewalk cafe in the heart of the St Germain area of Paris.  Size is 40x50 framed.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,34,0,NULL),(465,'San Francisco Church','0','Oil Painting on panel, 16x20',NULL,NULL,0,1,'','',0.00,'','','Around_the_San_Francisco_Church.jpg','',0.0000,1,1,'This is a \"slice of life\" painting of a church in San Miguel de Allende, Mexico Framed size of this piece is 26x30.  ',0.00,465,0,NULL),(35,'Place des Ternes, Paris','0','30x40 limited edition giclee print on canvas.',NULL,NULL,1,0,'','',900.00,'','','Place_des_Ternes.jpg','',0.0000,1,1,'A flower market in the heart of Paris.  This framed 40x50 sells for $1100.  Unframed price is $900.  Edition is limited to 100.',0.00,36,NULL,NULL),(28,'Second Floor','0','',NULL,NULL,1,1,'','',925.00,'','','Second_Floor.jpg','',0.0000,1,1,'This is an interior view of a 16th century monastery in Mexico.  \"Second Floor\" is a print on canvas limited to 100.  Sold stretched on 30x40 strecher bars and framed. $925 plus $50 shipping.',0.00,30,0,NULL),(39,'Pots and Ferns','0','30x40 Iris print on canvas.',NULL,NULL,1,1,'','',925.00,'','','Pots_and_Ferns.jpg','',0.0000,1,1,'Beautiful still life of old earthenware pots arranged in a fern garden.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,39,0,NULL),(40,'South Window','0','30x40 limited edition Iris print on canvas.',NULL,NULL,1,1,'','',925.00,'','','South_Window.jpg','',0.0000,1,1,'Beautiful view from the interior of a monastery in Mexico.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,40,0,NULL),(385,'Paco in Love','0','oil painting',NULL,NULL,1,1,'','',5900.00,'','','Paco_in_Love_absolutely_final.jpg','',0.0000,1,1,'This very appealing cowboy picture tells a story--the very best kind of painting!  Framed size is 46x58.',0.00,385,NULL,NULL),(451,'','0','',NULL,NULL,1,1,'','',0.00,'','','Paco,_corrected.jpg','',0.0000,1,1,'',0.00,451,0,NULL),(452,'','0','',NULL,NULL,1,1,'','',0.00,'','','Parasols_and_Flowers_at_the_Posada_Carmina.jpg','',0.0000,1,1,'',0.00,452,0,NULL),(453,'','0','',NULL,NULL,1,1,'','',0.00,'','','Pastor::s_Study_Correction_2.JPG','',0.0000,1,1,'',0.00,453,0,NULL),(454,'','0','',NULL,NULL,1,1,'','',0.00,'','','Red_Awnings.jpg','',0.0000,1,1,'',0.00,454,0,NULL),(272,'Elizabeth\'s painting in progress','0','Elizabeth\'s final painting (shown here unfinished) will be a gorgeous still life.  Well done, Elizabeth!',NULL,NULL,1,1,'','',0.00,'','','Eliz_pic_3_in_progress.jpg','',0.0000,1,1,'',0.00,272,NULL,NULL),(604,'Le Brazza','0','22x26 framed watercolor by Jerald Peterson is a Paris street scene',NULL,NULL,1,1,'','',0.00,'','','Le_Brazza.jpg','',0.0000,1,1,'',0.00,604,0,NULL),(47,'Flowers on the Square','0','30x40 oil painting',NULL,NULL,0,1,'','',0.00,'','','Flower_Vendor_in_San_Miguel.jpg','',0.0000,1,1,'This is a Mexican woman selling flowers under the portico in San Miguel de Allende. Available.',0.00,53,0,NULL),(343,'El Torero','0','Oil painting 30x40',NULL,NULL,0,1,'','',0.00,'','','El_Torero.jpg','',0.0000,1,1,'This painting of \"El Torero\" is of a Mexican Bull Fighter. It is full of color and emotion. Framed size is 39x49.  ',0.00,343,0,NULL),(438,'Gary','0','A good example of what can be painted from a good quality photo',NULL,NULL,1,1,'','',0.00,'','','Gary.jpg','',0.0000,1,1,'',0.00,438,0,NULL),(437,'Tuscan Monastery','0','6 ft x 4 ft oil painting',NULL,NULL,1,1,'','',8500.00,'','','Tuscan_final.jpg','',0.0000,1,1,'Beautiful interior of a monastery near Tuscany',0.00,437,0,NULL),(92,'W.C.','0','Giclee print on canvas of a French Country Bathroom.',NULL,NULL,1,1,'','',450.00,'','','Wc.jpg','550',0.0000,1,1,'This warm and inviting painting, \"W.C.\", is our latest giclee print on canvas.  The framed size of the print is 26x32 and the edition is limited to only 200.  $450 plus $40 shipping.',0.00,92,0,NULL),(204,'','0','',NULL,NULL,1,1,'','',14000.00,'','','','',0.0000,1,1,'',0.00,204,NULL,NULL),(218,'Rembrandt Room','0','',NULL,NULL,1,1,'','',0.00,'','','Rembrandt_Room.jpg','',0.0000,1,1,'',0.00,218,NULL,NULL),(166,'','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,166,NULL,NULL),(466,'San Miguel Hacienda','0','40x50 (framed size) oil painting',NULL,NULL,0,1,'','',0.00,'','','San_Miguel_Hacienda.jpg','',0.0000,1,1,'Colorful painting of a hacienda outside San Miguel de Allende, Mexico 40x50 framed size.  ',0.00,466,0,NULL),(219,'Vermeer Room','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,219,NULL,NULL),(220,'Rubens Room','0','',NULL,NULL,1,1,'','',0.00,'','','Reubens_Room.jpg','',0.0000,1,1,'',0.00,220,NULL,NULL),(592,'Monks\' Basin','0','30x40 oil, framed size approx. 39x49',NULL,NULL,0,1,'','',0.00,'','','Monks\'_Basin.jpg','',0.0000,1,1,'upstairs of a 17th century monastery in Mexico',0.00,592,0,NULL),(83,'Self-Portrait','0','20x24 oil painting',NULL,NULL,0,1,'','',2500.00,'','','Ellie_Self_Portrait.JPG','',0.0000,1,1,'Self-Portrait of artist.',0.00,83,NULL,NULL),(84,'Tortilleria','0','24x36 oil painting',NULL,NULL,1,0,'','',3000.00,'','','Ellie,_Tortilleria.JPG','',0.0000,1,1,'Painting of an actual tortilleria in San Miguel de Allende.  Framed size is approx 34x46.',0.00,84,NULL,NULL),(286,'','0','',NULL,NULL,1,1,'','',4500.00,'','','','',0.0000,1,1,'',0.00,286,NULL,NULL),(275,'Pam North\'s first picture','0','What a beautiful, soft painting this is!  There is nothing in it to jangle your nerves, only peace and tranquility. Great!',NULL,NULL,1,1,'','',0.00,'','','Pam_pic_1.jpg','',0.0000,1,1,'',0.00,275,NULL,NULL),(120,'Los Portales','0','36x48 oil painting',NULL,NULL,0,1,'','',0.00,'','','Los_Portales_de_San_Miguel,_II.JPG','',0.0000,1,1,'This depiction of a walkway in San Miguel draws you right in.  ',0.00,120,0,NULL),(653,'Barn and Bluebonnets/SOLD','0','18x24 watercolor of a Texas barn.',NULL,NULL,1,1,'','',350.00,'','','Barn_and_Bluebonnets.jpg','',0.0000,1,1,'',0.00,653,0,0),(654,'Young Man','0','16x20 (size including mat) watercolor of a young Mexican man',NULL,NULL,1,1,'','',300.00,'','','Young_Man.jpg','',0.0000,1,1,'',0.00,654,0,NULL),(497,'Chinese Rice Baskets','0','',NULL,NULL,1,1,'','',0.00,'','','Framed_Chinese_Rice_Baskets.jpg','',0.0000,1,1,'23x31 framed',0.00,497,0,NULL),(393,'Doorway and Lavendar','0','Arched Door and Lavendar',NULL,NULL,1,1,'','',0.00,'','','Arched_door_and_lavendar.jpg','',0.0000,1,1,'This client is an avid gardener and wanted a painting of this rustic arched doorway with glorious lavendar in front of it.  The result was stupendous!',0.00,401,NULL,NULL),(392,'Moscow Russian Orthodox Church','0','Russian Church',NULL,NULL,1,1,'','',0.00,'','','harris_final.jpg','',0.0000,1,1,'This client has supported Christian Missions to Russia for many years and has traveled there extensively.  She wanted a painting to remind her of her beloved Russia while living in the states.',0.00,393,NULL,NULL),(390,'Bandito framed','0','Bandito in handmade frame',NULL,NULL,1,1,'','',0.00,'','','bandito_final.jpg','',0.0000,1,1,'This client had seen some of our one-of-a-kind handmade frames and requested that we put on on the commission.  Of course, we aim to please, so you can see the result here!',0.00,392,NULL,NULL),(498,'Workshop \"Rogues Gallery\"','0','',NULL,NULL,1,1,'','',0.00,'','','Barbara,_Diana,_and_Betty_painting_in_garden.jpg','',0.0000,1,1,'',0.00,498,0,NULL),(111,'Street in Tepoztlan','0','18x19 photo print on kodak paper.  Limited edition.',NULL,NULL,1,0,'','',80.00,'','','Tepoztlan_Street.JPG','',0.0000,1,1,'Street scene from a small village in Mexico.  Sold unframed.',0.00,111,NULL,NULL),(232,'Dining Room','0','',NULL,NULL,1,1,'','',0.00,'','','Dining_room.jpg','',0.0000,1,1,'',0.00,231,NULL,NULL),(231,'First Floor Patio','0','',NULL,NULL,1,1,'','',0.00,'','','Patio.jpg','',0.0000,1,1,'',0.00,232,NULL,NULL),(113,'Medieval Church','0','30x40 giclee print on canvas ',NULL,NULL,1,0,'','',925.00,'','','French_Church.JPG','',0.0000,1,1,'Beautiful print on canvas of a Medieval Church interior in France. Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,113,0,NULL),(215,'Second Floor Balcony','0','',NULL,NULL,1,1,'','',0.00,'','','Second_Floor_Balcony.jpg','',0.0000,1,1,'',0.00,215,NULL,NULL),(216,'Third floor studio','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_working_on_Au_Vieux_Paris.jpg','',0.0000,1,1,'',0.00,216,NULL,NULL),(217,'Third floor studio/balcony','0','',NULL,NULL,1,1,'','',0.00,'','','Third_floor_balcony.jpg','',0.0000,1,1,'',0.00,217,NULL,NULL),(455,'','0','',NULL,NULL,1,1,'','',0.00,'','','Red_Chair.JPG','',0.0000,1,1,'',0.00,455,0,NULL),(456,'','0','',NULL,NULL,1,1,'','',0.00,'','','Red_Door_San_Jose_Mission.JPG','',0.0000,1,1,'',0.00,456,0,NULL),(457,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sierra_Nevada_Restaurant.jpg','',0.0000,1,1,'',0.00,457,0,NULL),(225,'','0','',NULL,NULL,1,1,'','',0.00,'','','Dining_room.jpg','',0.0000,1,1,'',0.00,225,NULL,NULL),(223,'','0','',NULL,NULL,1,1,'','',0.00,'','','Garden.jpg','',0.0000,1,1,'',0.00,223,NULL,NULL),(224,'','0','',NULL,NULL,1,1,'','',0.00,'','','Patio.jpg','',0.0000,1,1,'',0.00,224,NULL,NULL),(222,'','0','',NULL,NULL,1,1,'','',0.00,'','','Second_Floor_Balcony.jpg','',0.0000,1,1,'',0.00,222,NULL,NULL),(221,'','0','',NULL,NULL,1,1,'','',0.00,'','','Vermeer_Room.jpg','',0.0000,1,1,'',0.00,221,NULL,NULL),(271,'Elizabeth\'s Second Picture','0','Elizabeth and Mike found this humble little beggar lady on the streets of San Miguel.  After painting her, they went back to show her the painting, and left her with her pockets fuller than they had been in years!',NULL,NULL,1,1,'','',0.00,'','','eliz_pic_2.jpg','',0.0000,1,1,'',0.00,271,NULL,NULL),(161,'','0','',NULL,NULL,1,1,'','',4200.00,'','','','',0.0000,1,1,'',0.00,161,NULL,NULL),(230,'Garden','0','',NULL,NULL,1,1,'','',0.00,'','','Garden.jpg','',0.0000,1,1,'',0.00,230,NULL,NULL),(233,'Vermeer Room','0','',NULL,NULL,1,1,'','',0.00,'','','Vermeer_Room.jpg','',0.0000,1,1,'',0.00,233,NULL,NULL),(344,'Casa Liza, San Miguel de Allende','0','40x50 (framed size) giclee print on canvas',NULL,NULL,1,1,'','',925.00,'','','Casa_Liza,_San_Miguel.jpg','',0.0000,1,1,'This is a colorful and popular B&B in San Miguel.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,344,0,NULL),(499,'','0','',NULL,NULL,1,1,'','',0.00,'','','Barbara,_Jerry,_Diana,_Betty_and_Norm_Peterson.jpg','',0.0000,1,1,'',0.00,499,0,NULL),(500,'','0','',NULL,NULL,1,1,'','',0.00,'','','Barbara,_first_ptg.jpg','',0.0000,1,1,'',0.00,500,0,NULL),(501,'','0','',NULL,NULL,1,1,'','',0.00,'','','Barbara,_second_ptg.jpg','',0.0000,1,1,'',0.00,501,0,NULL),(502,'','0','',NULL,NULL,1,1,'','',0.00,'','','Betty,_first_ptg.jpg','',0.0000,1,1,'',0.00,502,0,NULL),(210,'Foyer','0','',NULL,NULL,1,1,'','',0.00,'','','Foyer.jpg','',0.0000,1,1,'',0.00,210,NULL,NULL),(211,'Living Room','0','',NULL,NULL,1,1,'','',0.00,'','','Living_Room.jpg','',0.0000,1,1,'',0.00,211,NULL,NULL),(155,'The Guardian','0','watercolor painting of doorway in San Miguel de Allende',NULL,NULL,0,1,'','',750.00,'','','The_Guardian.jpg','',0.0000,1,1,'This beautiful monocromatic watercolor shows the deep spirituality ever present in San Miguel architecture.  The Saint keeps watch over the door.  Framed size of this piece is 23x30.',0.00,155,NULL,NULL),(590,'Tumbling Olives','0','Beautiful still life of olives\r\n24x30 unframed, 30x36 framed',NULL,NULL,0,1,'','',0.00,'','','Tumbling_Olives.jpg','',0.0000,1,1,'Still life of olives in antique Greek jugs.',0.00,590,0,NULL),(145,'North Passage','0','Giclee print on canvas',NULL,NULL,0,1,'','',925.00,'','','North_Passage.JPG','',0.0000,1,1,'Dramatic architectural image of a 16th century monastery in Mexico.  Deep, rich color!  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,145,0,NULL),(146,'Ancient Arches','0','30x40 giclee print on canvas',NULL,NULL,0,1,'','',925.00,'','','Ancient_Arches_2.JPG','',0.0000,1,1,'What a fiery image!  It glows with red and gold.  Framed size is 40x50.  Sold stretched on 30x40 stretcher bars and framed. $925 plus $50 shipping.',0.00,146,0,NULL),(408,'Pancho Villa and Zapata','0','36x48 unframed size',NULL,NULL,0,1,'','',0.00,'','','Pancho_Villa_and_Zapata,_Derivative_Painting.jpg','',0.0000,1,1,'A truly historical painting showing two of the Mexican Revolution heroes taking a cigarette break. Derived from an old photo.  46x58 framed size. ',0.00,408,0,NULL),(184,'Rice Baskets & Pots','0','still life of antique Chinese Rice Baskets',NULL,NULL,0,1,'','',0.00,'','','Rice_Baskets_and_Flower_Pots.jpg','',0.0000,1,1,'27x32 framed, this great still life has plenty of color. ',0.00,184,0,NULL),(602,'Barefoot Madonna','0','Great oil painting of Madonna and Child',NULL,NULL,0,1,'','',0.00,'','','Madonna_and_Child.jpg','',0.0000,1,1,'24x36 unframed size of this unusual barefoot Madonna and our Lord.',0.00,602,0,NULL),(196,'Jerald stands under the bougainvilia with Mary and Marianne','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_and_students_in_garden.jpg','',0.0000,1,1,'',0.00,196,NULL,NULL),(213,'First Floor Patio','0','',NULL,NULL,1,1,'','',0.00,'','','Patio.jpg','',0.0000,1,1,'',0.00,213,NULL,NULL),(212,'Dining Room','0','',NULL,NULL,1,1,'','',0.00,'','','Dining_room.jpg','',0.0000,1,1,'',0.00,212,NULL,NULL),(214,'Garden','0','',NULL,NULL,1,1,'','',0.00,'','','Garden.jpg','',0.0000,1,1,'',0.00,214,NULL,NULL),(260,'Workshop Group','0','Sarah, Rebecca, Bob, Molly, Jerald, Sue McCormick',NULL,NULL,1,1,'','',0.00,'','','Workshop_Group,_Aug_15-23.jpg','',0.0000,1,1,'',0.00,260,NULL,NULL),(226,'Second Floor Balcony','0','',NULL,NULL,1,1,'','',0.00,'','','Second_Floor_Balcony.jpg','',0.0000,1,1,'',0.00,226,NULL,NULL),(227,'Vermeer Room','0','',NULL,NULL,1,1,'','',0.00,'','','Vermeer_Room.jpg','',0.0000,1,1,'',0.00,227,NULL,NULL),(191,'Molly and Mary and Marianne','0','',NULL,NULL,1,1,'','',0.00,'','','Cook_with_students.jpg','',0.0000,1,1,'',0.00,191,NULL,NULL),(192,'The workshoppers sunning themselves in our gorgeous garden!','0','',NULL,NULL,1,1,'','',0.00,'','','Students_in_garden.jpg','',0.0000,1,1,'',0.00,192,NULL,NULL),(189,'Mary paints street scenes like a pro!','0','',NULL,NULL,1,1,'','',0.00,'','','Mary_with_Ricardo::s_Cafe.jpg','',0.0000,1,1,'',0.00,189,NULL,NULL),(190,'Jerald standing with workshoppers under the bougainvilia.','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_and_students_in_garden.jpg','',0.0000,1,1,'',0.00,190,NULL,NULL),(187,'Marianne did a great job on this arch painting!','0','',NULL,NULL,1,1,'','',0.00,'','','Marianne_with_Arches.jpg','',0.0000,1,1,'',0.00,187,NULL,NULL),(188,'Mary painted a fantastic still-life!','0','',NULL,NULL,1,1,'','',0.00,'','','Mary_with_Olives.jpg','',0.0000,1,1,'',0.00,188,NULL,NULL),(273,'Judith\'s first picture','0','Here is Judy with her colorful stairway painting!  She perfectly captured the color and perspective.  Good job!',NULL,NULL,1,1,'','',0.00,'','','Judith_pic_1.jpg','',0.0000,1,1,'',0.00,273,NULL,NULL),(407,'Tepoztlan Mercado','0','28x34 framed oil',NULL,NULL,0,1,'','',0.00,'','','Tepoztlan_Mercado.jpg','',0.0000,1,1,'Interior of a market in Mexico. 20x34 framed size. ',0.00,407,0,NULL),(384,'Paco in Love','0','oil painting',NULL,NULL,1,1,'','',5900.00,'','','Paco_in_Love_absolutely_final.jpg','',0.0000,1,1,'This very appealing cowboy picture tells a story--the very best kind of painting!  Framed size is 46x58.',0.00,384,NULL,NULL),(376,'','0','Inside view of barn',NULL,NULL,1,1,'','',0.00,'','','Studio_Barn_2_500_pxls.jpg','',0.0000,1,1,'You can see there is plenty of room to both live and work.  The square footage is 1500 with 12 ft. ceilings.',0.00,380,NULL,NULL),(340,'Gypsy Jazz Trio','0','30x40 oil painting',NULL,NULL,0,1,'','',0.00,'','','Gypsy_Jazz_Trio.jpg','',0.0000,1,1,'This portrait of the Gypsy Jazz Trio in San Miguel, required many pleasant evenings of sipping wine at Finnegan\'s Pub (research!) and listening to their melodius sounds. Great interesting portraits of three musicians. ',0.00,340,0,NULL),(274,'Judith, painting in progress','0','Judith wanted to learn to paint arches from the \"arch master\" himself.  Looks like she was a quick learner, doesn\'t it?  She is almost finished with this piece which is already a fabulous painting!',NULL,NULL,1,1,'','',0.00,'','','Judith_pic_in_grogress.jpg','',0.0000,1,1,'',0.00,274,NULL,NULL),(439,'','0','',NULL,NULL,1,1,'','',0.00,'','','Acolman_Corner_View.jpg','',0.0000,1,1,'',0.00,439,0,NULL),(440,'','0','',NULL,NULL,1,1,'','',0.00,'','','Colonial_Courtyard_corrected.JPG','',0.0000,1,1,'',0.00,440,0,NULL),(276,'Pam\'s Second Painting','0','I love the rustic feel and texture of this painting!  This is pure San Miguel!  Well done, Pam!',NULL,NULL,1,1,'','',0.00,'','','Pam_pic_2.jpg','',0.0000,1,1,'',0.00,276,NULL,NULL),(367,'','0','',NULL,NULL,1,1,'','',0.00,'','','Studio_Barn_1.jpg','',0.0000,1,1,'',0.00,367,NULL,NULL),(379,'','0','View from inside the barn.  ',NULL,NULL,1,1,'','',0.00,'','','Studio_Barn_1_500_pxls.jpg','',0.0000,1,1,'Notice the north light which bathes the entire barn.  There is a fifty foot skylight!',0.00,379,NULL,NULL),(279,'Winter Garden','0','Our garden in the wintertime, featuring the 20 ft tall poinsettias!',NULL,NULL,1,1,'','',0.00,'','','Winter_Garden.jpg','',0.0000,1,1,'',0.00,279,NULL,NULL),(478,'Taxco Overview','0','Original Transparent Watercolor',NULL,NULL,1,1,'','',0.00,'','','Taxco_Overview_Watercolor.jpg','',0.0000,1,1,'Framed size of this original watercolor is 30x36. ',0.00,478,0,NULL),(468,'Our Lady of Guadalupe','0','Beautiful replica of the original',NULL,NULL,1,1,'','',0.00,'','','JPGLUPE.jpg','',0.0000,1,1,'Jerald was commissioned to paint this lovely replica of Our Lady of Guadalupe, patroness of the Americas by St. Brigid\'s Catholic Church in Tahlequah, OK.  The original size is 30x48.',0.00,468,0,NULL),(448,'','0','',NULL,NULL,1,1,'','',0.00,'','','Mexican_Courtyard.jpg','',0.0000,1,1,'',0.00,448,0,NULL),(449,'','0','',NULL,NULL,1,1,'','',0.00,'','','Monk::s_Bathtub,_II.jpg','',0.0000,1,1,'',0.00,449,0,NULL),(450,'','0','',NULL,NULL,1,1,'','',0.00,'','','Meseros.jpg','',0.0000,1,1,'',0.00,450,0,NULL),(491,'Texas Longhorns','0','35x43 is the framed size of this watercolor',NULL,NULL,1,1,'','',0.00,'','','Texas_Longhorns.jpg','',0.0000,1,1,'Longhorns in front of a Texas barn.  ',0.00,491,0,NULL),(480,'Morelia Street','0','Original transparent watercolor',NULL,NULL,1,1,'','',0.00,'','','Morelia_Street_Watercolor.jpg','',0.0000,1,1,'framed size is 30x36. ',0.00,480,0,NULL),(481,'Convent Courtyard','0','signed and numbered limited edition print',NULL,NULL,1,1,'','',120.00,'','','Convent_Courtyard_Watercolor.jpg','',0.0000,1,1,'scene from the monastery entrance in Tepoztlan, Mexico',0.00,481,0,NULL),(409,'Interior of Russian Orthodox Church','0','This client had very specific requisites for her commission.  Jerald complied and the result was breathtaking!',NULL,NULL,1,1,'','',0.00,'','','Lauranne_final_commission.jpg','',0.0000,1,1,'',0.00,409,0,NULL),(410,'Beginning of the Day','0','24x36 oil painting',NULL,NULL,0,1,'','',2800.00,'','','Beginning_of_the_Day.jpg','',0.0000,1,1,'Peaceful painting of a humble life. 24x36 unframed size. ',0.00,410,0,NULL),(504,'','0','',NULL,NULL,1,1,'','',0.00,'','','Betty_Peterson_Third_Painting.jpg','',0.0000,1,1,'',0.00,504,0,NULL),(446,'','0','',NULL,NULL,1,1,'','',0.00,'','','Mexican_Courtyard_Close-up.jpg','',0.0000,1,1,'',0.00,446,0,NULL),(447,'','0','',NULL,NULL,1,1,'','',0.00,'','','Malinalco_Street.jpg','',0.0000,1,1,'',0.00,447,0,NULL),(412,'French Village Church','0','Watercolor print on paper.  Limited to 500.',NULL,NULL,1,1,'','',120.00,'','','French_Village_Church_Watercolor.jpg','',0.0000,1,1,'This is the back of a church in St. Malo, a village on the northwest coast of France.  This is sold unframed, mounted on foamcore and shrunk-wrapped.  Perfect for a gift!  Shipping is $10.',0.00,412,0,NULL),(413,'Convent Courtyard','0','Watercolor print on paper.  Limited to 500.',NULL,NULL,1,1,'','',120.00,'','','Convent_Courtyard_Watercolor.jpg','',0.0000,1,1,'This is the courtyard of an ex-monastery in a small village in Mexico.  The price is $120, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,413,0,NULL),(414,'Twin Deere','0','Watercolor print',NULL,NULL,1,1,'','',40.00,'','','Twin_Deere_Watercolor.jpg','',0.0000,1,1,'This is a painting of an antique John Deere tractor that the artist found in a field near Blackwell, Oklahoma.  The price is $40, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,414,0,NULL),(415,'Meet Me at the Tree','0','Watercolor print',NULL,NULL,1,1,'','',40.00,'','','Meet_Me_at_the_Tree_Watercolor.jpg','',0.0000,1,1,'This tree is found in the courtyard of an old monastery in Mexico.  The price is $40, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,415,0,NULL),(416,'Turkey Hunt','0','Watercolor Print',NULL,NULL,1,1,'','',40.00,'','','Turkey_Hunt_Watercolor.png','',0.0000,1,1,'A familiar scene in Oklahoma during turkey hunting season.  The price is $40, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,416,0,NULL),(417,'Out to Pasture','0','Watercolor print',NULL,NULL,1,1,'','',40.00,'','','Out_to_Pasture_Watercolor.jpg','',0.0000,1,1,'Old tractor in a field.  The price is $40, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,417,0,NULL),(418,'Lobster Pots','0','Watercolor Print',NULL,NULL,1,1,'','',40.00,'','','Lobster_Pots_Watercolor.png','',0.0000,1,1,'A typical scene along the Maine coast.  The price is $40, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,418,0,NULL),(419,'Where\'s That Damn Bull?','0','Watercolor Print',NULL,NULL,1,1,'','',40.00,'','','Copy_of_Watercolor_Fly_Sheet.jpg','',0.0000,1,1,'What cattle man cannot identify with this cowboy?  The price is $40, plus $10 shipping.  The print is unframed, but mounted on foamcore and shrunk-wrapped.  It makes a nicely presented gift!',0.00,419,0,NULL),(420,'Cafe de Flores Diptich','0','Commissioned painting',NULL,NULL,1,1,'','',0.00,'','','Commission_Diptich.jpg','',0.0000,1,1,'This client had a formal living room with two huge built-in niches!  She wanted art, but couldn\'t find anything appropriate.  We went over photos with her that we had shot ourselves in Paris and she chose the \"Cafe des Flores,\" a popular sidewalk restaurant in the St Germaine de Pres area.  We had the stretcher bars built to the exact size of the niches, then Jerald painted two paintings.  The bottom one is the cafe, and the top one is the top of the building!  Notice the tree and balcony flowers continuing into the top painting.  We fastened them into the niches with velcro, so that, if she ever wants to, she can take them out and have a gorgeous original oil painting to put anywhere in her home.',0.00,420,0,NULL),(462,'We added a porch!','0','',NULL,NULL,1,1,'','',0.00,'','','Pic_of_Deck.jpg','',0.0000,1,1,'',0.00,462,0,NULL),(444,'','0','',NULL,NULL,1,1,'','',0.00,'','','Hacienda_Corner.jpg','',0.0000,1,1,'',0.00,444,0,NULL),(445,'','0','',NULL,NULL,1,1,'','',0.00,'','','Hacienda_Stairway_corrected.jpg','',0.0000,1,1,'',0.00,445,0,NULL),(441,'','0','',NULL,NULL,1,1,'','',0.00,'','','Bell_Tower_resized.jpg','',0.0000,1,1,'',0.00,441,0,NULL),(442,'','0','',NULL,NULL,1,1,'','',0.00,'','','Dance_Contest.jpg','',0.0000,1,1,'',0.00,442,0,NULL),(427,'','0','Our mealtime was lively!',NULL,NULL,1,1,'','',0.00,'','','Group_at_table_final.jpg','',0.0000,1,1,'All meals are included in the price of the workshop.  Molly and Jerry have lived in many different countries during his previous career, and her culinary talent shows it!',0.00,427,0,NULL),(428,'','0','Molly with a couple of the workshoppers in the garden.  Does it look like winter?',NULL,NULL,1,1,'','',0.00,'','','Cook_with_students.jpg','',0.0000,1,1,'',0.00,428,0,NULL),(429,'','0','Molly serving Tagine, a Moroccan speciality',NULL,NULL,1,1,'','',0.00,'','','Molly_serving_Tagine.jpg','',0.0000,1,1,'The meals were colorful, flavorful, and delicious!  All meals are accented with fresh fruit and veggies from the open air markets.  Many of the students accompany her on shopping trips.  Good photo ops!',0.00,429,0,NULL),(430,'','0','Three painters in the garden.  Remember, it is wintertime in San Miguel!',NULL,NULL,1,1,'','',0.00,'','','Barbara,_Diana,_and_Betty_painting_in_garden.jpg','',0.0000,1,1,'We will offer 7 day painting workshops in San Miguel during the winter of 2010.  All meals, room, art supplies, and art lessons are included in the price.  Non-painting spouses and friends are welcome.',0.00,430,0,NULL),(431,'','0','One of the spouses spent his time birdwatching.  He documented a record number of birds--just in the garden!',NULL,NULL,1,1,'','',0.00,'','','Bill,_the_birdwatcher.jpg','',0.0000,1,1,'Non-painting spouses are invited to come to San Miguel, too.  There is plenty for them to do, including tennis, golf, hiking, Spanish lessons, or just relaxing.',0.00,431,0,NULL),(432,'','0','Have you always wanted to paint?',NULL,NULL,1,1,'','',0.00,'','','Mary_with_Olives.jpg','',0.0000,1,1,'The desire to paint is all you need to come to a workshop.  The workshops are small in number, from 3-6 painters, so Jerry has plenty of time to spend with each student.  You will be surprised at the beauty you are capable of putting on canvas!',0.00,432,0,NULL),(433,'','0','Here is Jerry inviting you to a drink!  ',NULL,NULL,1,1,'','',0.00,'','','Jerry_in_Garden.jpg','',0.0000,1,1,'The wine and margaritas are included in the price of the workshop!  Ain\'t we got fun?',0.00,433,0,NULL),(434,'','0','Dining al fresco!',NULL,NULL,1,1,'','',0.00,'','','Dining_al_fresco.jpg','',0.0000,1,1,'I hate to keep mentioning those meals..........but we really looked forward to them.  Molly freely shares recipes, so we can repeat some of the dishes at home.',0.00,434,0,NULL),(435,'','0','What a beautiful still life, and the painting is gorgeous, too!',NULL,NULL,1,1,'','',0.00,'','','Lana::s_pots.jpg','',0.0000,1,1,'We set up this still life for the artists to take pictures of.  They all go home with a lifetime\'s worth of painting material, including all the photos they take of life in San Miguel.',0.00,435,0,NULL),(458,'','0','',NULL,NULL,1,1,'','',0.00,'','','The_Blessing_of_the_Animals.jpg','',0.0000,1,1,'',0.00,458,0,NULL),(459,'','0','',NULL,NULL,1,1,'','',0.00,'','','The_Dirt_Seller_Final.JPG','',0.0000,1,1,'',0.00,459,0,NULL),(460,'','0','',NULL,NULL,1,1,'','',0.00,'','','Tuscan_Farm_Scene.jpg','',0.0000,1,1,'',0.00,460,0,NULL),(461,'','0','',NULL,NULL,1,1,'','',0.00,'','','Yellow_flowers_and_jub.jpg','',0.0000,1,1,'',0.00,461,0,NULL),(476,'Plaza 3','0','Three 30x40 canvases painted as one scene--a triptyche.  ',NULL,NULL,1,1,'','',0.00,'','','Copy_of_Steven_commission_final.jpg','',0.0000,1,1,'This great piece was framed separately by our client and hung together on the same wall.  Looks great!',0.00,476,0,NULL),(469,'Our Lady of Guadalupe','0','Giclee print on canvas, available in several sizes. Call for information: 918-810-3615',NULL,NULL,1,1,'','',0.00,'','','JPGLUPE.jpg','',0.0000,1,1,'',0.00,469,0,NULL),(639,'Ready for Action','0','11x14 oil',NULL,NULL,0,1,'','',0.00,'','','Ready_for_Action.jpg','',0.0000,1,1,'Portrait of a bull fighter in Mexico',0.00,639,0,NULL),(477,'Four PotsSOLD','0','Original transparent watercolor',NULL,NULL,1,1,'','',1200.00,'','','Four_Pots_Watercolor.jpg','',0.0000,1,1,'The framed size of this gorgeous painting is 30x36. ',0.00,477,0,0),(473,'Zacateros & Canal','0','40x50 framed size ',NULL,NULL,0,1,'','',0.00,'','','Zacateros___Canal.jpg','',0.0000,1,1,'Street scene of San Miguel de Allende.  40x50. ',0.00,473,0,NULL),(680,'Divine Mercy Image','0','Not for sale. ',NULL,NULL,1,1,'','',0.00,'','','Divine_Mercy.jpg','',0.0000,1,1,'',0.00,680,0,0),(503,'','0','',NULL,NULL,1,1,'','',0.00,'','','Betty,_painting.jpg','',0.0000,1,1,'',0.00,503,0,NULL),(475,'French Country Sink','0','',NULL,NULL,1,1,'','',450.00,'','','french_country_sink.jpg','',0.0000,1,1,'This is a beautiful companion piece to  one of our most beautiful giclee prints, W.C. 18x24 giclee print on canvas.  Sold stretched on 18x24 stretcher bars and framed.  $450, plus $40 shipping.',0.00,475,0,NULL),(482,'','0','s/n limited edition print',NULL,NULL,1,1,'','',120.00,'','','French_Village_Church.JPG','',0.0000,1,1,'Church in St. Malo, Bretagne, France',0.00,482,0,NULL),(483,'','0','s/n limited edition print',NULL,NULL,1,1,'','',120.00,'','','French_Village_Church_Watercolor.jpg','',0.0000,1,1,'Church in St. Malo, Bretagne, France',0.00,483,0,NULL),(484,'Super Mas Tienda','0','Original transparent watercolor',NULL,NULL,1,1,'','',0.00,'','','Super_Mas_Tienda_Watercolor.jpg','',0.0000,1,1,'framed size approx. 24x30. ',0.00,484,0,NULL),(486,'Monastery ChairsSOLD','0','full page watercolor',NULL,NULL,1,1,'','',0.00,'','','Monastery_Chairs.jpg','',0.0000,1,1,'scene from 16th century monastery in Mexico.  ',0.00,486,0,0),(641,'San Miguel Street','0','24x30 oil painting',NULL,NULL,1,1,'','',3900.00,'','','San_Miguel_Street.jpg','',0.0000,1,1,'',0.00,641,0,NULL),(597,'Guadalupe River','0','Plein air painting of the river in Kerrvill, TX',NULL,NULL,1,1,'','',0.00,'','','Guadalupe_River_plein_air.jpg','',0.0000,1,1,'',0.00,597,0,NULL),(488,'Pots and Flowers Still Life','0','',NULL,NULL,1,1,'','',0.00,'','','Pot_and_Flowers_Stillife.jpg','',0.0000,1,1,'framed size is approx 26x33. ',0.00,488,0,NULL),(494,'River FishingSOLD','0','Transparent watercolor',NULL,NULL,1,1,'','',0.00,'','','River_Fishing.jpg','',0.0000,1,1,'framed size is 33x35.  ',0.00,494,0,0),(492,'Posada Carmina Sunday','0','original watercolor of a colorful courtyard restaurant in San Miguel de Allende, Mexico',NULL,NULL,1,1,'','',0.00,'','','Posada_Carmina_Sunday.jpg','',0.0000,1,1,'33x35 is the framed size of this piece. ',0.00,492,0,NULL),(637,'Toro','0','smal 8x10 watercolor',NULL,NULL,1,1,'','',0.00,'','','Toro.jpg','',0.0000,1,1,'',0.00,637,0,NULL),(495,'Domingo II','0','transparent watercolor',NULL,NULL,1,1,'','',0.00,'','','Domingo_II.jpg','',0.0000,1,1,'24x20 framed size of this character! ',0.00,495,0,NULL),(505,'','0','',NULL,NULL,1,1,'','',0.00,'','','Betty_Peterson,_Painting_in_progress.jpg','',0.0000,1,1,'',0.00,505,0,NULL),(506,'','0','',NULL,NULL,1,1,'','',0.00,'','','Bob_McCormick,_Second_Painting.jpg','',0.0000,1,1,'',0.00,506,0,NULL),(507,'','0','',NULL,NULL,1,1,'','',0.00,'','','Cook_with_students.jpg','',0.0000,1,1,'',0.00,507,0,NULL),(508,'','0','',NULL,NULL,1,1,'','',0.00,'','','Copy_of_Joel_painting.jpg','',0.0000,1,1,'',0.00,508,0,NULL),(509,'','0','',NULL,NULL,1,1,'','',0.00,'','','Copy_of_Yvonne::s_second_painting.jpg','',0.0000,1,1,'',0.00,509,0,NULL),(510,'','0','',NULL,NULL,1,1,'','',0.00,'','','Diana,_first_ptg.jpg','',0.0000,1,1,'',0.00,510,0,NULL),(511,'','0','',NULL,NULL,1,1,'','',0.00,'','','Diana,_painting.jpg','',0.0000,1,1,'',0.00,511,0,NULL),(512,'','0','',NULL,NULL,1,1,'','',0.00,'','','Diana_Fry,_Second_Painting.jpg','',0.0000,1,1,'',0.00,512,0,NULL),(513,'','0','',NULL,NULL,1,1,'','',0.00,'','','Dining_al_fresco.jpg','',0.0000,1,1,'',0.00,513,0,NULL),(514,'','0','',NULL,NULL,1,1,'','',0.00,'','','Dining_room.jpg','',0.0000,1,1,'',0.00,514,0,NULL),(515,'','0','',NULL,NULL,1,1,'','',0.00,'','','Earline::s_first_painting.jpg','',0.0000,1,1,'',0.00,515,0,NULL),(516,'','0','',NULL,NULL,1,1,'','',0.00,'','','Earline_and_Bill_Kennedy.jpg','',0.0000,1,1,'',0.00,516,0,NULL),(517,'','0','',NULL,NULL,1,1,'','',0.00,'','','Eliz_pic_3_in_progress.jpg','',0.0000,1,1,'',0.00,517,0,NULL),(518,'','0','',NULL,NULL,1,1,'','',0.00,'','','Gary::s_BLUE_DOOR.jpg','',0.0000,1,1,'',0.00,518,0,NULL),(519,'','0','',NULL,NULL,1,1,'','',0.00,'','','Bob_McCormick,_Second_Painting.jpg','',0.0000,1,1,'',0.00,519,0,NULL),(520,'','0','',NULL,NULL,1,1,'','',0.00,'','','Cook_with_students.jpg','',0.0000,1,1,'',0.00,520,0,NULL),(521,'','0','',NULL,NULL,1,1,'','',0.00,'','','Caresse::s_painting.jpg','',0.0000,1,1,'',0.00,521,0,NULL),(522,'','0','',NULL,NULL,1,1,'','',0.00,'','','Diana,_painting.jpg','',0.0000,1,1,'',0.00,522,0,NULL),(523,'','0','',NULL,NULL,1,1,'','',0.00,'','','Copy_of_Yvonne::s_second_painting.jpg','',0.0000,1,1,'',0.00,523,0,NULL),(524,'','0','',NULL,NULL,1,1,'','',0.00,'','','Diana_Fry,_Second_Painting.jpg','',0.0000,1,1,'',0.00,524,0,NULL),(525,'','0','',NULL,NULL,1,1,'','',0.00,'','','Cropped_Yvonne_painting_1.jpg','',0.0000,1,1,'',0.00,525,0,NULL),(526,'','0','',NULL,NULL,1,1,'','',0.00,'','','Gaye_Elise_Beda,_Consulting_Artist.jpg','',0.0000,1,1,'',0.00,526,0,NULL),(527,'','0','',NULL,NULL,1,1,'','',0.00,'','','Group_Picture,_Aug_15-23_Workshop.jpg','',0.0000,1,1,'',0.00,527,0,NULL),(528,'','0','',NULL,NULL,1,1,'','',0.00,'','','Group_at_table_final.jpg','',0.0000,1,1,'',0.00,528,0,NULL),(529,'','0','',NULL,NULL,1,1,'','',0.00,'','','Group_breakfast.jpg','',0.0000,1,1,'',0.00,529,0,NULL),(530,'','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_and_students_in_garden.jpg','',0.0000,1,1,'',0.00,530,0,NULL),(531,'','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_helping_Jeremy.jpg','',0.0000,1,1,'',0.00,531,0,NULL),(532,'','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_in_Garden.jpg','',0.0000,1,1,'',0.00,532,0,NULL),(533,'','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_looking_on_as_Jackie_paints.jpg','',0.0000,1,1,'',0.00,533,0,NULL),(534,'','0','',NULL,NULL,1,1,'','',0.00,'','','Jerry_painting.jpg','',0.0000,1,1,'',0.00,534,0,NULL),(535,'','0','',NULL,NULL,1,1,'','',0.00,'','','Joel_and_Jackie_Brende_and_Joel::s_two_paintings.jpg','',0.0000,1,1,'',0.00,535,0,NULL),(536,'','0','',NULL,NULL,1,1,'','',0.00,'','','Johanna_and_Keith_Killian_and_Johanna::s_two_paintings.jpg','',0.0000,1,1,'',0.00,536,0,NULL),(537,'','0','',NULL,NULL,1,1,'','',0.00,'','','Johanna_painting.jpg','',0.0000,1,1,'',0.00,537,0,NULL),(538,'','0','',NULL,NULL,1,1,'','',0.00,'','','Judi,_at_her_easel.jpg','',0.0000,1,1,'',0.00,538,0,NULL),(539,'','0','',NULL,NULL,1,1,'','',0.00,'','','Kathy,_second_painting.jpg','',0.0000,1,1,'',0.00,539,0,NULL),(540,'','0','',NULL,NULL,1,1,'','',0.00,'','','Bill,_the_birdwatcher.jpg','',0.0000,1,1,'',0.00,540,0,NULL),(541,'','0','',NULL,NULL,1,1,'','',0.00,'','','Judi_second_final.jpg','',0.0000,1,1,'',0.00,541,0,NULL),(542,'','0','',NULL,NULL,1,1,'','',0.00,'','','Judith_Rice_and_Jack_and_Sue_Woods.jpg','',0.0000,1,1,'',0.00,542,0,NULL),(543,'','0','',NULL,NULL,1,1,'','',0.00,'','','Kathy,_first_painting.jpg','',0.0000,1,1,'',0.00,543,0,NULL),(544,'','0','',NULL,NULL,1,1,'','',0.00,'','','Kathy,_second_painting.jpg','',0.0000,1,1,'',0.00,544,0,NULL),(545,'','0','',NULL,NULL,1,1,'','',0.00,'','','Lana::s_plein_aire_painting.jpg','',0.0000,1,1,'',0.00,545,0,NULL),(546,'','0','',NULL,NULL,1,1,'','',0.00,'','','Lana::s_pots.jpg','',0.0000,1,1,'',0.00,546,0,NULL),(547,'','0','',NULL,NULL,1,1,'','',0.00,'','','Marianne_painting.jpg','',0.0000,1,1,'',0.00,547,0,NULL),(548,'','0','',NULL,NULL,1,1,'','',0.00,'','','Marianne_with_Landscape.jpg','',0.0000,1,1,'',0.00,548,0,NULL),(549,'','0','',NULL,NULL,1,1,'','',0.00,'','','Mary_Jane_at_the_easel.jpg','',0.0000,1,1,'',0.00,549,0,NULL),(550,'','0','',NULL,NULL,1,1,'','',0.00,'','','Mary_with_Ricardo::s_Cafe.jpg','',0.0000,1,1,'',0.00,550,0,NULL),(551,'','0','',NULL,NULL,1,1,'','',0.00,'','','Mealtime,_doodly-ama!.jpg','',0.0000,1,1,'',0.00,551,0,NULL),(552,'','0','',NULL,NULL,1,1,'','',0.00,'','','Molly_serving_Tagine.jpg','',0.0000,1,1,'',0.00,552,0,NULL),(553,'','0','',NULL,NULL,1,1,'','',0.00,'','','Nancy,_first_painting.jpg','',0.0000,1,1,'',0.00,553,0,NULL),(554,'','0','',NULL,NULL,1,1,'','',0.00,'','','Nancy,_second_painting.jpg','',0.0000,1,1,'',0.00,554,0,NULL),(555,'','0','',NULL,NULL,1,1,'','',0.00,'','','Nancy_and_Craig_Elstad.jpg','',0.0000,1,1,'',0.00,555,0,NULL),(556,'','0','',NULL,NULL,1,1,'','',0.00,'','','Nikita::s_painting.jpg','',0.0000,1,1,'',0.00,556,0,NULL),(557,'','0','',NULL,NULL,1,1,'','',0.00,'','','Patrice_painting_portrait_of_Nikita.jpg','',0.0000,1,1,'',0.00,557,0,NULL),(558,'','0','',NULL,NULL,1,1,'','',0.00,'','','Pam_pic_1.jpg','',0.0000,1,1,'',0.00,558,0,NULL),(559,'','0','',NULL,NULL,1,1,'','',0.00,'','','Pam_pic_2.jpg','',0.0000,1,1,'',0.00,559,0,NULL),(560,'','0','',NULL,NULL,1,1,'','',0.00,'','','Rebecca_Martino,_First_Painting.jpg','',0.0000,1,1,'',0.00,560,0,NULL),(561,'','0','',NULL,NULL,1,1,'','',0.00,'','','Rebecca_Martino,_Second_Painting.jpg','',0.0000,1,1,'',0.00,561,0,NULL),(562,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sally::s_GREEN_DOOR.jpg','',0.0000,1,1,'',0.00,562,0,NULL),(563,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sally::s_STILL_LIFE.jpg','',0.0000,1,1,'',0.00,563,0,NULL),(564,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sally_at_the_easel.jpg','',0.0000,1,1,'',0.00,564,0,NULL),(565,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sarah_Martino,_Painting_#1.jpg','',0.0000,1,1,'',0.00,565,0,NULL),(566,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sarah_Taylor,_First_Painting.jpg','',0.0000,1,1,'',0.00,566,0,NULL),(567,'','0','',NULL,NULL,1,1,'','',0.00,'','','Stacey::s_Painting.jpg','',0.0000,1,1,'',0.00,567,0,NULL),(568,'','0','',NULL,NULL,1,1,'','',0.00,'','','Sarah_Taylor,_Painting_in_Progress.jpg','',0.0000,1,1,'',0.00,568,0,NULL),(569,'','0','',NULL,NULL,1,1,'','',0.00,'','','Set_Table_11.jpg','',0.0000,1,1,'',0.00,569,0,NULL),(570,'','0','',NULL,NULL,1,1,'','',0.00,'','','Steve,_the_golfer.jpg','',0.0000,1,1,'',0.00,570,0,NULL),(571,'','0','',NULL,NULL,1,1,'','',0.00,'','','Students_with_cook.jpg','',0.0000,1,1,'',0.00,571,0,NULL),(572,'','0','',NULL,NULL,1,1,'','',0.00,'','','Suzanne::s_Women_and_Flowers.jpg','',0.0000,1,1,'',0.00,572,0,NULL),(573,'','0','',NULL,NULL,1,1,'','',0.00,'','','Suzanne::s_Woman_in_Sombrero.jpg','',0.0000,1,1,'',0.00,573,0,NULL),(574,'','0','',NULL,NULL,1,1,'','',0.00,'','','group_at_table.jpg','',0.0000,1,1,'',0.00,574,0,NULL),(575,'','0','',NULL,NULL,1,1,'','',0.00,'','','group_pic.jpg','',0.0000,1,1,'',0.00,575,0,NULL),(576,'','0','',NULL,NULL,1,1,'','',0.00,'','','eliz_pic_2.jpg','',0.0000,1,1,'',0.00,576,0,NULL),(577,'','0','',NULL,NULL,1,1,'','',0.00,'','','eliz_pic_2.jpg','',0.0000,1,1,'',0.00,577,0,NULL),(626,'El Torero','0','The Bullfighter is an oil painting, 30x36.',NULL,NULL,1,1,'','',3900.00,'','','El_Torero.jpg','',0.0000,1,1,'',0.00,626,0,NULL),(580,'Peace Dove','0','72x48 oil painting--hugh statement!',NULL,NULL,1,1,'','',5000.00,'','','Peace_Dove_Best.jpg','',0.0000,1,1,'Interior of a Tuscan Monastery',0.00,580,0,NULL),(591,'Quiet Walk','0','40x50 framed size oil painting',NULL,NULL,0,1,'','',0.00,'','','Quiet_Walk.jpg','',0.0000,1,1,'Lovely, lazy day in a 16th century monastery in Mexico.  The humble little lady is making her way among the shadows of the arches.',0.00,591,0,NULL),(595,'Flowers Around the Tree','0','Large framed watercolor',NULL,NULL,1,1,'','',0.00,'','','Flowers_around_the_Tree.jpg','',0.0000,1,1,'',0.00,595,0,NULL),(644,'Cows in Front of the Barn','0','Farm scene of cows and delapidated barn',NULL,NULL,1,1,'','',300.00,'','','Cows_in_Front_of_Barn.jpg','',0.0000,1,1,'',0.00,644,0,NULL),(619,'Still Life Pots and Flowers','0','Framed size 16x20. Beautiful still life of a scene on our patio in Mexico',NULL,NULL,1,1,'','',0.00,'','','Still_Life_Pots_and_Flowers.jpg','',0.0000,1,1,'',0.00,619,0,NULL),(608,'Christmas in Mexico','0','11x14 oil',NULL,NULL,0,1,'','',0.00,'','','Merry_Christmas.jpg','',0.0000,1,1,'',0.00,608,0,NULL),(623,'Tahlequah Barn','0','Barn off Hwy 51 outside of Tahlequah, OK',NULL,NULL,1,1,'','',0.00,'','','Tahlequah_Barn.jpg','',0.0000,1,1,'',0.00,623,0,NULL),(638,'Left handed Pass','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','Natural.jpg','',0.0000,1,1,'',0.00,638,0,NULL),(611,'Cactus and Flowers','0','20x24 oil',NULL,NULL,0,1,'','',0.00,'','','Cactus_and_Flowers.JPG','',0.0000,1,1,'',0.00,611,0,NULL),(624,'Ganaderia','0','34x40 framed watercolor of a ranch which breeds and raises bulls destined for the bullring.',NULL,NULL,1,1,'','',1500.00,'','','Ganaderia.jpg','',0.0000,1,1,'',0.00,624,0,NULL),(613,'Tidepools at Pemiquid Point','0','36 x 48 oil',NULL,NULL,1,1,'','',0.00,'','','Tide_Pool_Reflections.jpg','',0.0000,1,1,'',0.00,613,0,NULL),(614,'The Tile Glazer, Mexico','0','',NULL,NULL,1,1,'','',0.00,'','','The_Tile_Glazer.jpg','',0.0000,1,1,'',0.00,614,0,NULL),(615,'Chinese Rice Baskets','0','',NULL,NULL,1,1,'','',0.00,'','','Unframed_Chinese_Rice_Baskets.jpg','',0.0000,1,1,'',0.00,615,0,NULL),(628,'Bulls under a Tree','0','Nice small watercolor--16x20 framed',NULL,NULL,1,1,'','',300.00,'','','Bulls_under_a_Tree.jpg','',0.0000,1,1,'',0.00,628,0,NULL),(629,'Ready for Action','0','Bullfighter--oil 20x24 framed  ',NULL,NULL,1,1,'','',750.00,'','','Ready_for_Action.jpg','',0.0000,1,1,'',0.00,629,0,NULL),(635,'Ganaderia','0','Watercolor of a farm in Spain where they raise bulls for bullfights.',NULL,NULL,1,1,'','',0.00,'','','Ganaderia.jpg','',0.0000,1,1,'',0.00,635,0,NULL),(636,'Bulls under a tree','0','small 16x20 original wc',NULL,NULL,1,1,'','',0.00,'','','Bulls_under_a_Tree.jpg','',0.0000,1,1,'',0.00,636,0,NULL),(631,'Toro','0','This small watercolor is framed beautifully in a plein air gold frame. ',NULL,NULL,1,1,'','',300.00,'','','Toro.jpg','',0.0000,1,1,'',0.00,631,0,NULL),(632,'St. Antonio Abad','0','St. Antonio Abad, one of the patron saints of animals--note the wild boar looking up at him.',NULL,NULL,0,1,'','',0.00,'','','San_Antonio_Abad.jpg','',0.0000,1,1,'St. Antonio Abad was originally from Arabia but served the Catholic Church as a priest in Mexico, where he died.',0.00,632,0,NULL),(634,'Left Handed Pass or \"Natural\"','0','This torero is practicing a left-handed pass, or in Spanish, a Natural.',NULL,NULL,1,1,'','',0.00,'','','Natural.jpg','',0.0000,1,1,'The image is 10x14 and is matted in a 16x20 mat.',0.00,634,0,NULL),(655,'Bar San Miguel IV','0','18x24 (includes mat) watercolor of a popular bar in San Miguel de Allende in Mexico',NULL,NULL,1,1,'','',350.00,'','','Bar_San_Miguel_IV.jpg','',0.0000,1,1,'',0.00,655,0,NULL),(647,'Tiendita by the Church in Malinalco/SOLD','0','Scene in Malinalco, near Mexico City',NULL,NULL,1,1,'','',300.00,'','','Tiendita_by_the_Church_in_Malinalco.jpg','',0.0000,1,1,'',0.00,647,0,0),(648,'Yellow Flowers, Blue Vase','0','16x20 watercolor',NULL,NULL,0,1,'','',300.00,'','','Yellow_Flowers,_Blue_Vase.jpg','',0.0000,1,1,'',0.00,648,0,NULL),(649,'Purple Finch','0','16x20 of purple finch on a log',NULL,NULL,0,1,'','',300.00,'','','Purple_Finch.jpg','',0.0000,1,1,'',0.00,649,0,NULL),(652,'Field Day in San Miguel','0','18x24 watercolor',NULL,NULL,1,1,'','',350.00,'','','Field_Day_in_San_Miguel.jpg','',0.0000,1,1,'',0.00,652,0,NULL),(651,'#11 Canal St.','0','16x20 of Canal St. in San Miguel de Allende',NULL,NULL,0,1,'','',300.00,'','','#11_Canal_St.jpg','',0.0000,1,1,'',0.00,651,0,NULL),(656,'French Village Church','0','print of a watercolor by Jerald Peterson',NULL,NULL,1,1,'','',80.00,'','','French_Village_Church_Watercolor.jpg','',0.0000,1,1,'This piece, \"French Village Church\" depicts a church in \"San Malo,\" a village on the northwest coast of France.',0.00,656,0,NULL),(657,'Twin Deere','0','watercolor print',NULL,NULL,1,1,'','',40.00,'','','Twin_Deere_best.jpg','',0.0000,1,1,'',0.00,657,0,NULL),(658,'Where\'s that Damn Bull?','0','watercolor print',NULL,NULL,1,1,'','',40.00,'','','Where__s_That_Damn_Bull.JPG','',0.0000,1,1,'',0.00,658,0,NULL),(659,'Turkey Hunt','0','watercolor print',NULL,NULL,1,1,'','',40.00,'','','Turkey_Hunt_Watercolor.png','',0.0000,1,1,'',0.00,659,0,NULL),(660,'Out to Pasture','0','watercolor print',NULL,NULL,1,1,'','',40.00,'','','Out_to_Pasture_Watercolor.jpg','',0.0000,1,1,'',0.00,660,0,NULL),(661,'Lobster Pots','0','watercolor print',NULL,NULL,1,1,'','',40.00,'','','Lobster_Pots_Watercolor.png','',0.0000,1,1,'',0.00,661,0,NULL),(662,'Meet Me at the Tree','0','watercolor print',NULL,NULL,1,1,'','',40.00,'','','Meet_Me_at_the_Tree.JPG','',0.0000,1,1,'',0.00,662,0,NULL),(664,'Yellow Field','0','watercolor print',NULL,NULL,1,1,'','',80.00,'','','Yellow_Field.JPG','',0.0000,1,1,'',0.00,664,0,NULL),(665,'Pennsylvania Farm','0','Large watercolor of a farm.  The size is 22x30, unframed.',NULL,NULL,1,1,'','',0.00,'','','Pennsylvania_Farm.jpg','',0.0000,1,1,'',0.00,665,0,NULL),(666,'Harmonica Player','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','Harmonica_Player.jpg','',0.0000,1,1,'',0.00,666,0,0),(667,'French Restaurant','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','French_Restaurant.jpg','',0.0000,1,1,'',0.00,667,0,0),(668,'Whitefaces and Bluebonnets','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','White_faces_and_bluebonnets.jpg','',0.0000,1,1,'',0.00,668,0,0),(673,'Jerald at the Easel','0','',NULL,NULL,1,1,'','',0.00,'','','Jerald_at_easel.jpg','',0.0000,1,1,'',0.00,673,0,0),(670,'Fountain at the End of Aldama','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','Fountain_at_the_End_of_Aldama.jpg','',0.0000,1,1,'',0.00,670,0,0),(671,'Tepoztlan Monastery','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','Tepoztlan_Monastery.jpg','',0.0000,1,1,'',0.00,671,0,0),(674,'Jerald and George ','0','',NULL,NULL,1,1,'','',0.00,'','','Jerald_and_George.jpg','',0.0000,1,1,'',0.00,674,0,0),(675,'Jerald helping artist','0','',NULL,NULL,1,1,'','',0.00,'','','Jerald_helping_artist.jpg','',0.0000,1,1,'',0.00,675,0,0),(676,'Artists at table','0','',NULL,NULL,1,1,'','',0.00,'','','Workshop_participants_at_table.jpg','',0.0000,1,1,'',0.00,676,0,0),(678,'Workshoppers at work','0','',NULL,NULL,1,1,'','',0.00,'','','Workshoppers_at_work.jpg','',0.0000,1,1,'',0.00,678,0,0),(689,'Stairway with Descending Cat','0','30x40 oil painting',NULL,NULL,1,1,'','',0.00,'','','Stairway_with_Descending_Cat.jpg','',0.0000,1,1,'Stunning interior stairway of a Mexican Hacienda',0.00,689,0,0),(681,'The Annunciation','0','sold',NULL,NULL,1,1,'','',0.00,'','','Annunciation.jpg','',0.0000,1,1,'',0.00,681,0,0),(682,'St. Antonio Abad','0','An beloved Arab saint who lived in Mexico for many years and was known as a patron saint of animals 24x36, unframed',NULL,NULL,1,1,'','',4000.00,'','','San_Antonio_Abad.jpg','',0.0000,1,1,'',0.00,682,0,0),(683,'Barefoot Madonna','0','24x36 painting, inspired by Bouguereau, of Mother and Child $4,000, unframed',NULL,NULL,1,1,'','',0.00,'','','Madonna_and_Child.jpg','',0.0000,1,1,'',0.00,683,0,0),(684,'Seed of the woman','0','This painting shows the eventual final destruction of Satan when the \"seed of the woman\" vanquishes Him.  Inspired by Bougeureau 30x40 oil, price $5000, unframed.',NULL,NULL,1,1,'','',0.00,'','','Mother,_child,_snake.jpg','',0.0000,1,1,'',0.00,684,0,0),(685,'Virgin of Guadalupe','0','This piece hangs in our church.  not for sale',NULL,NULL,1,1,'','',0.00,'','','our_lady_in_st_brigids_one.jpg','',0.0000,1,1,'',0.00,685,0,0),(686,'Hacienda Stairway','0','Large framed watercolor, 32x42',NULL,NULL,1,1,'','',0.00,'','','Hacienda_Stairway_II.jpg','',0.0000,1,1,'',0.00,686,0,0),(687,'Jesus loves the children','0','sold',NULL,NULL,1,1,'','',0.00,'','','Jesus_and_Children.jpg','',0.0000,1,1,'',0.00,687,0,0),(688,'Mother and Child','0','sold',NULL,NULL,1,1,'','',0.00,'','','Mother_and_Child.jpg','',0.0000,1,1,'',0.00,688,0,0),(690,'Woman, Sweeping','0','11x14 watercolor, framed size',NULL,NULL,1,1,'','',0.00,'','','Woman_sweeping.jpg','',0.0000,1,1,'',0.00,690,0,0),(691,'Cat in Window','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Cat_in_the_Window.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,691,0,0),(692,'Horses Grazing','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Horses_Grazing.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,692,0,0),(693,'Wheelbarrow and Watering Can','0','watercolor',NULL,NULL,1,1,'','',0.00,'','','wheelbarrow_and_watering_can.jpg','',0.0000,1,1,'',0.00,693,0,0),(694,'Mail Pouch Barn','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Mail_Pouch_Barn.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,694,0,0),(695,'Maine Coast','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Maine_Coast.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,695,0,0),(697,'Gargoyle Guard','0','Plein air watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Gargoyle_Guard.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,697,0,0),(698,'Shepherdess','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Shepherdess.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,698,0,0),(699,'Tres Mariachis','0','Watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Tres_Mariachis.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,699,0,0),(700,'Longhorn Skull','0','Watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Longhorn_Skull.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,700,0,0),(701,'San Miguel Flowers','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','San_Miguel_Flowers.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,701,0,0),(702,'San Miguel Fountain','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','San_Miguel_Fountain.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,702,0,0),(703,'Woman in White','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Woman_in_white.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,703,0,0),(704,'Statue in Church Yard','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Statue_in_Church_Yard.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,704,0,0),(709,'Victorian Woman, after Leighton','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Victorian_Woman_after_Leighton.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,709,0,0),(706,'Blue and Pink','0','watercolor, 9x12, unmatted',NULL,NULL,1,1,'','',0.00,'','','Blue_and_Pink.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,706,0,0),(707,'Yellow Flowers, Blue Vase','0','Oil painting on panel, 12x16',NULL,NULL,1,1,'','',0.00,'','','Yellow_Flowers,_Blue_Vase.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,707,0,0),(708,'Italian Restaurant in Paris','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Italian_Restaurant_in_Paris.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,708,0,0),(711,'Town Square, San Miguel','0','watercolor, 16x20',NULL,NULL,1,1,'','',0.00,'','','Town_Square,_San_MIguel.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,711,0,0),(712,'Wedding at the Crescent Hotel, Eureka Springs, Plein Air','0','16x20 watercolor',NULL,NULL,1,1,'','',0.00,'','','Wedding_at_the_Crescent_Hotel,_Eureka_Springs,_Plein_Air.jpg','',0.0000,1,1,'Every painting in this category is an original, both watercolors and oils.  Most of the watercolors are matted and backed with acid free materials, and are ready to pop into a 16x20 frame with plexiglass.  The oils are also ready to pop into a standard size frame.\r\n\r\nALL SHIPPING IS FREE TO U.S. ADDRESSES!',0.00,712,0,0);

--
-- 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',
  `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',
  `name` varchar(60) DEFAULT NULL,
  `sku` varchar(30) DEFAULT NULL,
  `notax` smallint(6) DEFAULT NULL,
  PRIMARY KEY (`ID`),
  KEY `ID` (`ID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 PACK_KEYS=1;

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


--
-- 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 PACK_KEYS=1;

--
-- 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=10 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Shopping` VALUES (9,32,1446315849,1,'','jeraldpeterson','');

--
-- Dumping events for database 'jeraldpeterson'
--

--
-- Dumping routines for database 'jeraldpeterson'
--


