--
-- Host: localhost    Database: powersstainedglass
-- ------------------------------------------------------


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

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

INSERT INTO `Category` VALUES (1,0,0,0,16,NULL,'Top Level',NULL,1),(2,0,6,13,0,'','Southwestern','',2),(24,0,4,26,0,'Owners Tony Powers, Chris Powers and John Powers','About Us','DSC00409_(2).jpg',0),(7,0,6,9,0,'','Commercial','',7),(9,0,6,2,0,'abstact front entry','Residences','laskowski_front_entry_2.jpg',0),(16,0,6,7,0,'','Religious ','',0),(13,0,6,24,0,'','Art Glass','sailboat1.jpg',0),(26,0,4,0,0,'Specializing in restoration of old and new stained glass windows. We also can repair a broken stained glass window. More than 30 years in the stained glass business. Residential and commercial contractor license (glazing). Call us at 480-941-8272 or email us at info@powersstainedglass.com for a quote.','Repair/Restoration','creation.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=657 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Inventory` VALUES (436,298,13),(655,2,2),(221,3,2),(445,299,7),(98,95,3),(172,137,12),(352,282,9),(169,134,12),(89,86,12),(60,60,3),(125,102,3),(326,256,16),(407,314,16),(430,14,2),(387,15,2),(388,16,2),(647,419,13),(39,37,9),(19,19,6),(20,20,6),(21,21,6),(425,292,2),(115,23,7),(331,261,13),(117,25,7),(396,35,7),(480,291,16),(361,290,13),(40,38,9),(543,365,2),(545,367,13),(43,42,9),(128,104,3),(106,45,3),(546,368,13),(47,47,9),(631,105,9),(510,343,23),(456,258,7),(171,136,12),(159,128,15),(524,352,23),(170,135,12),(145,107,3),(505,338,21),(61,61,3),(107,58,3),(59,59,3),(167,132,15),(102,99,3),(64,64,3),(91,88,12),(421,259,9),(654,97,13),(433,179,13),(157,125,14),(85,72,11),(86,73,11),(74,74,11),(75,75,11),(76,76,11),(77,77,11),(78,78,11),(79,79,11),(80,80,11),(81,81,11),(82,82,11),(83,83,11),(160,127,14),(283,226,16),(556,377,16),(277,228,16),(168,133,13),(478,263,16),(166,131,15),(143,118,12),(423,302,2),(552,373,16),(394,150,19),(395,151,19),(544,366,2),(367,297,9),(519,339,23),(656,406,26),(490,330,7),(446,296,13),(489,329,7),(488,328,9),(487,327,7),(577,398,7),(617,400,25),(550,369,7),(571,392,7),(473,165,16),(474,166,16),(424,295,2),(513,346,23),(330,260,7),(458,246,7),(553,374,13),(518,342,23),(549,371,7),(435,242,13),(450,281,7),(278,178,16),(229,181,9),(476,255,16),(475,253,16),(273,224,13),(279,185,16),(234,186,16),(235,187,16),(477,257,16),(629,402,25),(554,375,13),(452,277,7),(540,362,9),(453,275,7),(344,274,9),(428,232,2),(280,196,16),(434,197,13),(460,268,9),(429,200,2),(461,269,7),(282,203,16),(517,348,23),(286,230,16),(528,355,23),(254,207,16),(653,208,16),(427,273,2),(257,210,16),(258,211,16),(287,231,16),(285,229,16),(261,214,16),(457,248,7),(548,370,7),(399,266,7),(512,345,23),(266,219,16),(529,356,23),(494,270,7),(368,222,16),(578,399,7),(479,284,16),(448,285,7),(542,364,2),(514,347,23),(447,288,7),(638,412,16),(437,303,13),(404,304,2),(633,350,24),(551,372,16),(634,351,24),(525,353,23),(408,315,16),(575,396,16),(541,363,2),(411,318,16),(412,319,16),(555,376,2),(534,358,2),(535,357,2),(536,359,2),(537,360,2),(538,361,2),(618,401,25),(559,380,16),(560,381,7),(561,382,7),(574,395,7),(573,394,7),(572,393,2),(565,386,16),(566,387,16),(567,388,16),(568,389,16),(569,390,13),(570,391,2),(619,403,25),(616,404,25),(620,405,25),(609,407,27),(621,409,25),(622,410,25),(639,413,16),(644,416,7),(651,418,13),(645,417,16),(648,420,16),(649,421,2),(650,422,2);

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

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

INSERT INTO `Invoice` VALUES (78,'2016-01-15 08:47:11',676,676,1,'Shipping',0.00,'',0.00,0.00);

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

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

INSERT INTO `Page` VALUES (1,'<P>Powers Stained Glass<BR>7124 E. Thomas Rd.<BR>Scottsdale, AZ 85251<P>480-941-8272<BR>info@powersstainedglass.com <HR>www.powersstainedglass.com',4,1,'data=Ay5GWBeob_WIPLDYoIWcfVXxvZu9XwJ55OX7Ag,3ra06Z-qBqSR1_55IFpLshvG7qA0GOGGLQEKUF2082lCm2VHZUM2QndtO5kyk6wB8dMokZSl5F0HU6j1G28EHkuXF-Fg3gaDIDtGBz-w.gif',NULL,NULL,'Location','Location',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,'',''),(20,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(21,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(22,NULL,0,2,NULL,NULL,NULL,NULL,'',''),(34,'<p> \r\n<h2>Brophy  College Preparatory Fashion Show Luminaries</h2>Phoenix,AZ\r\n\r\n<h2>Xavier College Preparatory  Chapel</h2> Phoenix, AZ\r\n\r\n\r\n<h2>Our Lady of the Blessed Sacrament</h2>Miami, AZ\r\n\r\n<h2>Immaculate Heart Church</h2> Phoenix, AZ\r\n\r\n\r\n<h2>Scottsdale Presbyterian Church </h2>Scottsdale, AZ\r\n\r\n<h2>Ascension Lutheran Church</h2> Paradise Valley, AZ\r\n\r\n<h2>Nazarene Chandler First Church</h2>Chandler, AZ\r\n\r\n<h2>Redeemer Lutheran Church</h2> Phoenix,AZ\r\n\r\n<h2>The Fountains A United Methodist Church</h2>Fountain Hills, AZ\r\n \r\n<h2>Living Water Lutheran Church</h2>Scottsdale, AZ\r\n \r\n<h2>Desert Cross Lutheran Church </h2>Tempe, AZ\r\n\r\n<h2>Saint George\'s Catholic Church</h2>Apache Junction, AZ\r\n\r\n<h2>Sacred Heart Parish</h2> \r\nClifton, AZ \r\n<h2>Dayspring United Methodist Church</h2> \r\nTempe, AZ\r\n<h2>Gethsemane Lutheran Church</h2>\r\nTempe, AZ\r\n<h2>Camelback Seventh Day Adventist Church</h2>\r\nPhoenix, AZ\r\n<h2>Christ Episcopal Church </h2>\r\nCarefree, AZ \r\n<h2>Crown of Life Lutheran Church </h2>\r\nSun City West, AZ\r\n<h2>St. Isabella Church </h2>\r\nSan Rafael, CA \r\n<h2>XavierBVM Convent</h2>\r\nPhoenix, AZ \r\n<h2>Saints Simon and Jude Church</h2> \r\nPhoenix, AZ\r\n<h2>St. Charles Borromeo </h2>\r\nPeoria, AZ \r\n<h2>Immaculate Conception Parish and Chapel </h2>\r\nYuma, AZ\r\n<h2>Franciscan Renewal Center</h2> \r\nScottsdale, AZ\r\n<h2>Bourgade Catholic High School </h2>\r\nPhoenix, AZ</p>\r\n<p><h2>Musical Instrument Museum (MIM)</h2>Scottsdale, AZ \r\n<h2>Omni Hotel</h2> Kansas City, MO\r\n<h2>Scottsdale Shea Plaza</h2>Scottsdale, AZ\r\n<h2>Planet Hollywood</h2>Las Vegas, NV\r\n<h2>The Forum</h2>Scottsdale, AZ\r\n<h2>Macayo\'s Restaurant</h2> Scottsdale, AZ\r\n<h2>Molly Gibson Lodge</h2> Aspen, CO\r\n<h2>Scottsdale Galleri</h2>Scottsdale, AZ\r\n<h2>Westward Ho</h2> Phoenix, AZ\r\n<h2>Anthem Clubhouse</h2> Anthem, AZ\r\n<h2>Tomaso\'s Restaurant</h2> Phoenix, AZ\r\n<h2>Christopher Creek Lodge</h2> Christopher Creek, AZ\r\n<h2>Arroyo Robles Resort</h3> Sedona, AZ\r\n<h2>Red Robin Restaurant </h2>Scottsdale, AZ\r\n<h2>Good Egg Restaurant </h2>AZ/CA\r\n<h2>Crystal Palace </h2>Prescott, AZ\r\n<h2>Cine Capri Original Theater </h2>Phoenix, AZ\r\n<h2>Paul Harvey </h2>Radio Host\r\n<h2>Dan Majerle</h2> Phoenix Suns\r\n<h2>Mark Grace </h2>Diamondbacks\r\n<h2>Hale Irwin</h2> Golfer\r\n<h2>Joe Beeler</h2> Western Artist\r\n<h2>Cotton Fitzsimmons </h2>Phoenix Suns\r\n<h2>Harmon Killebrew </h2>MLB\r\n<h2>Paul Konerko </h2>MLB </p>\r\n',2,1,'DBM_DeMark_PignPantry_aa.jpg',NULL,NULL,'Projects','Projects',NULL),(10,'',1,1,'lake_res_bathroom.jpg',NULL,NULL,'','',NULL),(5,'DALLE DE VERE Entry to a residential home',1,1,'DalleEntry.JPG',NULL,NULL,'HomeFrontEntry','',NULL),(6,'<img src=\"http://www.powersstainedglass.com/Images/powerslogo24.jpg\" style=\"max-width:100%\"\r\n<center><br>7124 E Thomas Rd Scottsdale, AZ 85251  </br>info@powersstainedglass.com    480-941-8272</center><p>For the past 30 years we have been designing custom glass for religious, commercial, and residential projects in Arizona and the U.S. We are also masters in restoration and repair.</p>   <p>Chris Powers -John Powers -Tony Powers </p>\r\n\r\n<a href=\"https://www.facebook.com/pages/Powers-Stained-Glass/465606606865825?ref=ts&fref=ts\" target=\"_blank\"><img title=\"Like us on Facebook (by niftybuttons.com)\" src=\"http://www.niftybuttons.com/facebook/like-us-on-facebook-button.png\"></a> \r\n<p>  Chris Powers was chosen as 2013 Phoenix Home & Garden Master Artist of the Southwest.   <A href=\"http://www.phgmag.com/resources/southwest/201303/2013-master-of-the-southwest-chris-powers---staine/\">Phoenix Home & Garden.</A>\r\n   <img src=\"http://www.powersstainedglass.com/Images/grand_canyon_1.png\" style=\"max-width:100%\"\r\n              ',4,0,'gethsemeni_our_lady_of_the_blessed_sacrament.jpg','Beautiful Creations- More on Facebook','97,105,270,208,2','',NULL,NULL),(9,'',1,1,'bisgrove-1.jpg',NULL,NULL,'','',NULL),(11,' carefree arizona front entryway constructed\r\nwith 1\" thick melted glass',1,1,'Rusticentryway.JPG',NULL,NULL,'front entry','',NULL),(31,'',1,1,'100_0251.JPG',NULL,NULL,'Jesus on the cross(fused glass','',NULL),(32,'',1,1,'',NULL,NULL,'','',NULL),(33,'',1,1,'',NULL,NULL,'','',NULL);

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

CREATE TABLE `Product` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(60) 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=423 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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

INSERT INTO `Product` VALUES (298,'shark','0','',NULL,NULL,0,0,'','',0.00,'','','100_1180.JPG','',0.0000,1,1,'',0.00,298,0,NULL),(299,'Business Horse','0','',NULL,NULL,0,0,'','',0.00,'','','100_1093.JPG','',0.0000,1,1,'',0.00,299,0,NULL),(375,'1065','0','',NULL,NULL,0,1,'','',0.00,'','','101_0065.JPG','',0.0000,1,1,'',0.00,375,0,NULL),(2,'Southwestern','0','1004 Shoot Out',NULL,NULL,0,1,'','',0.00,'','','picshootout.jpg','',0.0000,1,1,'\"The Shootout\" ',0.00,2,0,0),(295,'Boys with Joe Beeler','0','Joe Beeler worked side by side with the Powers on several projects',NULL,NULL,0,0,'','',0.00,'','','joe_beeler_and_the_powers_brothers.jpg','',0.0000,1,1,'Joe Beeler designed several stained glass art pieces that the Powers produced. \"The Seat with a View\" and \"The  Cowboy\" are the two remaining pieces left. We will remember Joe fondly and his love of the arts.',0.00,295,0,NULL),(150,'','0','',NULL,NULL,0,1,'','',0.00,'','','Miami_church_pictures_doug_007.JPG','',0.0000,1,1,'',0.00,150,0,NULL),(3,'John Wayne','0','The \"John Wayne\" stained glass window is approximately 4\' by 5\'.  ',NULL,NULL,0,1,'','',0.00,'','','picjohnwayne.jpg','',0.0000,1,1,'The \"John Wayne\" stained glass window is approximately 4\' by 5\'.  ',0.00,3,NULL,NULL),(136,'','0','',NULL,NULL,0,1,'','',0.00,'','','pope_adjusted.jpg','',0.0000,1,1,'',0.00,136,NULL,NULL),(137,'pope bright','0','',NULL,NULL,1,0,'','',0.00,'','','pope_bright.jpg','',0.0000,1,1,'',0.00,139,NULL,NULL),(102,'','0','Living Waters Lutheran Church\r\nScottsdale, AZ',NULL,NULL,0,1,'','',0.00,'','','full_view_outlined.JPG','',0.0000,1,1,'',0.00,102,NULL,NULL),(104,'','0','The Last Supper ',NULL,NULL,0,1,'','',0.00,'','','last_supper_web.jpg','',0.0000,1,1,'',0.00,105,NULL,NULL),(105,'Front Entry ','0','',NULL,NULL,0,0,'','',0.00,'','','bevel_door.JPG','',0.0000,1,1,'',0.00,106,0,NULL),(95,'The Fountains','0','The Fountains- A United Methodist Church, Fountain Hills, AZ',NULL,NULL,0,1,'','',0.00,'','','0F::tains_wind.jpg','',0.0000,1,1,'',0.00,90,NULL,NULL),(255,'charles barromeo windows','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1029.JPG','',0.0000,1,1,'',0.00,255,0,NULL),(97,'Art Glass','0','1003 Van Gogh Chair 1',NULL,NULL,0,1,'','',0.00,'','','Van_Gogh_1.jpg','',0.0000,1,1,'',0.00,96,0,0),(135,'The Pope 2005','0','',NULL,NULL,0,1,'','',0.00,'','','the_pope_perfect.jpg','',0.0000,1,1,'',0.00,135,NULL,NULL),(260,'planet hollwood lampshades las vegas','0','fused lampshades for planet hollywood las vegas suites',NULL,NULL,0,1,'','',0.00,'','','Panorama_3801_planet_hollywood.JPG','',0.0000,1,1,'',0.00,260,NULL,NULL),(263,'our lady of guadalupe mosaic','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM0032.JPG','',0.0000,1,1,'',0.00,263,0,NULL),(258,'Golden window','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1057.JPG','',0.0000,1,1,'',0.00,258,0,NULL),(128,'Dog','0','',NULL,NULL,0,1,'','',0.00,'','','web.jpg','',0.0000,1,1,'',0.00,128,NULL,NULL),(107,'Living Waters Lutheran Church, Scottsdale','0','',NULL,NULL,0,1,'','',0.00,'','','Living_Waters_scan_photo.JPG','',0.0000,1,1,'',0.00,107,NULL,NULL),(228,'Living Water','0','',NULL,NULL,0,0,'','',0.00,'','','Living_Waters_scan_photo.JPG','',0.0000,1,1,'',0.00,186,NULL,NULL),(224,'Large Santa','0','',NULL,NULL,0,1,'','',0.00,'','','patterson_santa_claus.jpg','',0.0000,1,1,'',0.00,226,NULL,NULL),(232,'Geronimo','0','',NULL,NULL,0,0,'','',0.00,'','','geronimo.jpg','',0.0000,1,1,'',0.00,231,0,NULL),(196,'Our Lady of the Blessed Sacrament','0','',NULL,NULL,0,0,'','',0.00,'','','Miami_church_pictures_doug_022.JPG','',0.0000,1,1,'',0.00,199,NULL,NULL),(151,'','0','',NULL,NULL,0,1,'','',0.00,'','','Miami_church_pictures_doug_008.JPG','',0.0000,1,1,'',0.00,151,0,NULL),(338,'Chris Powers Paintings','0','',NULL,NULL,0,1,'','',0.00,'','','cmp.1.JPG','',0.0000,1,1,'',0.00,338,0,NULL),(88,'','0','',NULL,NULL,0,1,'','',0.00,'','','WINDOW_SECTION_14-WEB.jpg','',0.0000,1,1,'',0.00,88,NULL,NULL),(60,'Divine Mercy','NONE','Divine Mercy',NULL,NULL,0,0,'','',0.00,'','','divine_mercy.jpg','',5.0000,1,1,'Divine Mercy can be viewed in Miami Arizona, at OUR LADY OF THE BLESSED SACRAMENT Catholic Church.',0.00,62,NULL,NULL),(330,'','0','',NULL,NULL,0,0,'','',0.00,'','','DSCN1889.JPG','',0.0000,1,1,'',0.00,330,0,NULL),(72,'','0','',NULL,NULL,0,1,'','',0.00,'','','PSG_001.jpg','',0.0000,1,1,'',0.00,70,NULL,NULL),(73,'','0','',NULL,NULL,0,1,'','',0.00,'','','PSG_002.jpg','',0.0000,1,1,'',0.00,72,NULL,NULL),(313,'Cowboy fused','0','',NULL,NULL,0,1,'','',0.00,'','','DSCN1238.JPG','',0.0000,1,1,'',0.00,314,0,NULL),(256,'living water window panels','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM0530.JPG','',0.0000,1,1,'',0.00,257,NULL,NULL),(14,'Geronimo Complete','0','\"Geronimo\"  This piece is approximately 3\' by 5\'.',NULL,NULL,0,1,'','',0.00,'','','picgeronimo.jpg','',0.0000,1,1,'',0.00,14,0,NULL),(254,'xavior window with sisters','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1172.JPG','',0.0000,1,1,'',0.00,254,NULL,NULL),(15,'Manyhorns','0','\"Manyhorns\" has been a popular window since the time we finished creating this piece in 1989. ',NULL,NULL,0,1,'','',0.00,'','','picmanyhorns.jpg','',0.0000,1,1,'',0.00,12,0,NULL),(185,'Our Lady of the Blessed Sacrament','0','',NULL,NULL,0,0,'','',0.00,'','','Miami_church_pictures_doug_001.JPG','',0.0000,1,1,'',0.00,187,NULL,NULL),(186,'','0','',NULL,NULL,0,0,'','',0.00,'','','Miami_church_pictures_doug_006.JPG','',0.0000,1,1,'',0.00,188,NULL,NULL),(187,'','0','',NULL,NULL,0,0,'','',0.00,'','','Miami_church_pictures_doug_010.JPG','',0.0000,1,1,'',0.00,195,NULL,NULL),(16,'Phoenixbird','0','\"Phoenixbird\"  The window is approximately 4\' by 5\'.',NULL,NULL,0,1,'','',0.00,'','','picphoenixbird.jpg','',0.0000,1,1,'',0.00,17,0,NULL),(178,'The Fountains','0','',NULL,NULL,0,0,'','',0.00,'','','0F::tains_wind.jpg','',0.0000,1,1,'',0.00,181,NULL,NULL),(181,'','0','',NULL,NULL,0,0,'','',0.00,'','','IM000141.JPG','',0.0000,1,1,'',0.00,182,NULL,NULL),(420,'crucified','0','',NULL,NULL,0,0,'','',0.00,'','','crucified.jpg','',0.0000,1,1,'',0.00,420,0,0),(421,'','0','',NULL,NULL,0,0,'','',0.00,'','','monon_train.jpg','',0.0000,1,1,'',0.00,421,0,0),(422,'1001  Grand Canyon','0','',NULL,NULL,1,1,'','',0.00,'','','grand_canyon_1.png','',0.0000,1,1,'',0.00,422,0,0),(364,'110','110','',NULL,NULL,0,1,'','',0.00,'','','110.jpg','',0.0000,1,1,'',0.00,364,0,NULL),(290,'fused glass flower panel','0','fused glass flower panel',NULL,NULL,0,0,'','',0.00,'','','DSC00085.JPG','',0.0000,1,1,'',0.00,290,0,NULL),(37,'rustic entry','0','rustic entry',NULL,NULL,0,0,'','',0.00,'','','Rusticentryway.JPG','',0.0000,1,1,'1\" thick melted glass in front entry of Boulders residence',0.00,34,NULL,NULL),(19,'Rustic Entry','0','<CENTER>Rustic home entry at the Boulders in Carefree, AZ<BR><I>Front door size: 4\' x 8\'</I><BR><I>Click on image to enlarge.</I>',NULL,NULL,1,1,'','',0.00,'','','Rusticentryway.JPG','',0.0000,1,1,'<CENTER>Rustic home entry at the Boulders in Carefree, AZ<BR><I>Front door size: 4\' x 8\'</I><BR><I>Click on image to enlarge.</I>',0.00,15,NULL,NULL),(20,'Dalle De Verre Entry','0','<CENTER>Dalle De Verre entry in Scottsdale, AZ, home<BR><I>Door panels size: 4\' x 8\'</I><BR><I>Inner panels size: 3\' x 10\'</I><BR><I>Click on image to enlarge.</I>',NULL,NULL,1,1,'','',0.00,'','','DalleEntry.JPG','',0.0000,1,1,'<CENTER>Dalle De Verre entry in Scottsdale, AZ, home<BR><I>Door panels size: 4\' x 8\'</I><BR><I>Inner panels size: 3\' x 10\'</I><BR><I>Click on image to enlarge.</I>',0.00,16,NULL,NULL),(21,'Beveled Entry','0','<CENTER>Beveled home entry in Rio Verde, AZ<BR><I>Overall size: 10\' x 12\'</I><BR><I>Click on image to enlarge.</I>',NULL,NULL,1,1,'','',0.00,'','','Beveledentry.JPG','',0.0000,1,1,'<CENTER>Beveled home entry in Rio Verde, AZ<BR><I>Overall size: 10\' x 12\'</I><BR><I>Click on image to enlarge.</I>',0.00,20,NULL,NULL),(22,'Front Entry','0','<CENTER><I>Complete Glass Entry approx. 15\'by 15\'</I>',NULL,NULL,1,1,'','',0.00,'','','leesentry.JPG','',0.0000,1,1,'<CENTER><I>Complete Glass Entry approx. 15\'by 15\'</I>',0.00,21,0,NULL),(23,'Restaurant Interior','0','<CENTER>Copper geometric contemporary design<BR>Restaurant interior in Kansas City, KS<BR><I>Overall size: 6\' x 6\'</I><BR><I>Click on image to enlarge.</I>',NULL,NULL,0,1,'','',0.00,'','','Omniinterior.JPG','',0.0000,1,1,'<CENTER>Copper geometric contemporary design<BR>Restaurant interior in Kansas City, KS<BR><I>Overall size: 6\' x 6\'</I><BR><I>Click on image to enlarge.</I>',0.00,28,NULL,NULL),(368,'mim','0','',NULL,NULL,0,1,'','',0.00,'','','mim_close_up.jpg','',0.0000,1,1,'',0.00,369,0,NULL),(266,'melted glass and leaded bathroom window','0','',NULL,NULL,0,1,'','',0.00,'','','DSC00033.JPG','',0.0000,1,1,'',0.00,266,0,NULL),(25,'Golf Resort','0','<CENTER><I>FireSreen  3\' by 4\'</I><BR><I>Table Lamp&Lampshade approx.30\"tall</I><BR><I>Floor Lamp& Lampshade 5\' tall</I><BR><I>Small Lamp&Lampshade approx.20\" tall<BR><I>Solder &Melted Glass Sculpture of Elk approx. 27\" tall</I>',NULL,NULL,0,1,'','',0.00,'','','golfresort2.JPG','',0.0000,1,1,'<CENTER><I>FireSreen  3\' by 4\'</I><BR><I>Table Lamp&Lampshade approx.30\"tall</I><BR><I>Floor Lamp& Lampshade 5\' tall</I><BR><I>Small Lamp&Lampshade approx.20\" tall<BR><I>Solder &Melted Glass Sculpture of Elk approx. 27\" tall</I>',0.00,23,NULL,NULL),(35,'etched mirror','0','etched mirror ',NULL,NULL,0,0,'','',0.00,'','','etchedbath.JPG','',0.0000,1,1,'etched mirror floating in middle of \r\nbathroom with both sides usable.',0.00,33,0,NULL),(291,'','0','jesus taken down from cross',NULL,NULL,0,0,'','',0.00,'','','PSG_013.jpg','',0.0000,1,1,'',0.00,291,0,NULL),(38,'dalle glass entry','0','1\" thick glass set in epoxy',NULL,NULL,0,0,'','',0.00,'','','DalleEntry.JPG','',0.0000,1,1,'Dalle glass entry at Scottsdale Ranch.\r\nDouble entry',0.00,35,NULL,NULL),(27,'bathroom windows','0','approx. size 7\'x8\'',NULL,NULL,1,1,'','',0.00,'','','bisgrove-1.jpg','',0.0000,1,1,'melted glass 3/8\" thick combined\r\nwith copper',0.00,25,NULL,NULL),(28,'bathroom windows','0','',NULL,NULL,1,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,27,NULL,NULL),(32,'bathroom windows','0','bevel design',NULL,NULL,0,0,'','',0.00,'','','lake_res_bathroom.jpg','',0.0000,1,1,'',0.00,32,NULL,NULL),(39,'bevel entry','0','Gluechip bevel entry',NULL,NULL,0,0,'','',0.00,'','','Beveledentry.JPG','',0.0000,1,1,'Rio Verde bevel entry ',0.00,38,NULL,NULL),(366,'113','113','',NULL,NULL,0,1,'','',0.00,'','','113.jpg','',0.0000,1,1,'',0.00,366,0,NULL),(127,'','0','Pattern from Western Design Book 1984. Click on Books and Merchandise for more infomation.',NULL,NULL,0,1,'','',0.00,'','','cowboy_n118.JPG','',0.0000,1,1,'',0.00,127,NULL,NULL),(42,'abstract design Desert mtn.','0','abstract design',NULL,NULL,0,0,'','',0.00,'','','Desert_Mountain_Scottsdale,_AZ.JPG','',0.0000,1,1,'An extra large panel in the entry of \r\na Desert mtn. home.',0.00,45,NULL,NULL),(58,'Gabriel the ArcAngel','none','Gabriel the ArcAngel',NULL,NULL,0,1,'','',0.00,'','','gabriel_the_arcangel.jpg','',5.0000,1,1,'Gabriel the ArcAngel',0.00,60,NULL,NULL),(125,'','0','Pattern from original Western Design Book.  If you would like to purchase 8x11 copies of the original 23 patterns from this book, click on Books and Merchandise.',NULL,NULL,0,1,'','',0.00,'','','desert_fox_n106.JPG','',0.0000,1,1,'',0.00,126,NULL,NULL),(45,'michael the Arcangel','0','Michael The Arcangel',NULL,NULL,0,0,'','',0.00,'','','micheal_the_arcangel.jpg','',0.0000,1,1,'Michael The Arcangel',0.00,39,NULL,NULL),(370,'Photography by David B. Moore','0','',NULL,NULL,0,1,'','',0.00,'','','DBM_Power__nfl_nba_door_aa.jpg','',0.0000,1,1,'',0.00,370,0,NULL),(47,'','0','12\' entry panels',NULL,NULL,0,0,'','',0.00,'','','hambicki_front_door.jpg','',0.0000,1,1,'12\' tall entry panels with melted 1/2\"\r\nglass',0.00,51,NULL,NULL),(179,'Bob Marley','0','',NULL,NULL,0,0,'','',0.00,'','','Bob_Marley.jpg','',0.0000,1,1,'',0.00,165,0,NULL),(134,'The Pope','0','',NULL,NULL,0,1,'','',0.00,'','','the_pope.JPG','',0.0000,1,1,'',0.00,134,NULL,NULL),(132,'Rainbow Bridge','0','',NULL,NULL,0,1,'','',0.00,'','','Rainbow_Bridge.jpg','',0.0000,1,1,'',0.00,132,NULL,NULL),(131,'Bob Marley','0','',NULL,NULL,0,1,'','',0.00,'','','Bob_Marley.jpg','',0.0000,1,1,'',0.00,131,NULL,NULL),(118,'','0','',NULL,NULL,0,1,'','',0.00,'','','LAST_SUPPER_TABLEAU.JPG','',0.0000,1,1,'',0.00,108,NULL,NULL),(133,'Grand Canyon','0','',NULL,NULL,0,1,'','',0.00,'','','Grand_CanyonWeb.jpg','',0.0000,1,1,'',0.00,133,NULL,NULL),(86,'','0','',NULL,NULL,0,1,'','',0.00,'','','WINDOW_SECTION_11-WEB.jpg','',0.0000,1,1,'',0.00,86,NULL,NULL),(339,'Chris Powers Paintings','101','101',NULL,NULL,0,1,'','',0.00,'','','cmp.1.JPG','',0.0000,1,1,'',0.00,339,0,NULL),(376,'1001','0','',NULL,NULL,0,1,'','',0.00,'','','Coors_Cowboy2.JPG','',0.0000,1,1,'',0.00,376,0,NULL),(377,'Fountains','0','',NULL,NULL,0,1,'','',0.00,'','','The_fountains_scan_photo.JPG','',0.0000,1,1,'',0.00,377,0,NULL),(417,'','0','',NULL,NULL,0,1,'','',0.00,'','','john_the_baptist.jpg','',0.0000,1,1,'',0.00,417,0,NULL),(418,'1002 Sailboat','0','',NULL,NULL,0,1,'','',0.00,'','','sailboat1.jpg','',0.0000,1,1,'',0.00,418,0,0),(419,'monon train','0','',NULL,NULL,0,0,'','',0.00,'','','monon_train.jpg','',0.0000,1,1,'',0.00,419,0,0),(257,'charles barrameo windows','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1028.JPG','',0.0000,1,1,'',0.00,256,0,NULL),(259,'front entry','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1000.JPG','',0.0000,1,1,'',0.00,259,0,NULL),(226,'Dayspring','0','',NULL,NULL,0,0,'','',0.00,'','','dayspring.JPG','',0.0000,1,1,'',0.00,228,NULL,NULL),(61,'Divine mercy','none','Divine Mercy',NULL,NULL,0,0,'','',0.00,'','','divine_mercy(duncan).jpg','',5.0000,1,1,'Divine Mercy made in the likeness of \r\nthe old time frescos that were found\r\nin New Mexico. This window can be viewed in Duncan ,Arizona.The size of the window is approx. 50\"x72\".',0.00,64,NULL,NULL),(59,'Juan Diego','none','Juan Diego',NULL,NULL,0,0,'','',0.00,'','','juan_diego.jpg','',5.0000,1,1,'Juan Diego can be viewed in Miami, Arizona at OUR LADY OF THE BLESSED SACRAMENT.',0.00,61,NULL,NULL),(329,'','0','',NULL,NULL,0,0,'','',0.00,'','','HPIM1264.JPG','',0.0000,1,1,'',0.00,329,0,NULL),(327,'','0','',NULL,NULL,1,1,'','',0.00,'','','HPIM1066.JPG','',0.0000,1,1,'',0.00,327,0,NULL),(328,'','0','',NULL,NULL,0,0,'','',0.00,'','','HPIM1253.JPG','',0.0000,1,1,'',0.00,328,0,NULL),(64,'ST.George Slaying the Dragon','0','St. George Slaying the Dragon',NULL,NULL,0,0,'','',0.00,'','','st_._george.jpg','',0.0000,1,1,'St. George Slaying the Dragon approx.\r\nsize 6\'x12\'. Located at St. George\r\nCatholic Church in Apache Junction Arizona',0.00,47,NULL,NULL),(392,'Photography by David B. Moore','0','',NULL,NULL,0,1,'','',0.00,'','','_MG_2993.jpg','',0.0000,1,1,'',0.00,392,0,NULL),(99,'Gethsemeni','0','',NULL,NULL,0,1,'','',0.00,'','','gethsemeni_our_lady_of_the_blessed_sacrament.jpg','',0.0000,1,1,'',0.00,99,NULL,NULL),(248,'Grapes','0','',NULL,NULL,0,0,'','',0.00,'','','MG_Grapes_web.jpg','',0.0000,1,1,'',0.00,248,0,NULL),(369,'Photography by David B. Moore','0','',NULL,NULL,0,1,'','',0.00,'','','DBM_DeMarkBar_aa.jpg','',0.0000,1,1,'',0.00,368,0,NULL),(74,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_003.jpg','',0.0000,1,1,'',0.00,73,NULL,NULL),(75,'','0','',NULL,NULL,1,1,'','',0.00,'','','test_1.jpg','',0.0000,1,1,'',0.00,75,NULL,NULL),(76,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_005.jpg','',0.0000,1,1,'',0.00,76,NULL,NULL),(77,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_006.jpg','',0.0000,1,1,'',0.00,77,NULL,NULL),(78,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_007.jpg','',0.0000,1,1,'',0.00,78,NULL,NULL),(79,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_008.jpg','',0.0000,1,1,'',0.00,79,NULL,NULL),(80,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_009.jpg','',0.0000,1,1,'',0.00,80,NULL,NULL),(81,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_010.jpg','',0.0000,1,1,'',0.00,81,NULL,NULL),(82,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_011.jpg','',0.0000,1,1,'',0.00,82,NULL,NULL),(83,'','0','',NULL,NULL,1,1,'','',0.00,'','','PSG_012.jpg','',0.0000,1,1,'',0.00,83,NULL,NULL),(165,'','0','',NULL,NULL,0,1,'','',0.00,'','','Miami_church_pictures_doug_021.JPG','',0.0000,1,1,'',0.00,178,0,NULL),(166,'','0','',NULL,NULL,0,1,'','',0.00,'','','Miami_church_pictures_doug_023.JPG','',0.0000,1,1,'',0.00,180,0,NULL),(293,'','0','Joe Beeler signed window  produced by the Powers Bros',NULL,NULL,1,1,'','',0.00,'','','HPIM1853.JPG','',0.0000,1,1,'',0.00,293,0,NULL),(373,'251','0','',NULL,NULL,0,1,'','',0.00,'','','100_0251.JPG','',0.0000,1,1,'',0.00,373,0,NULL),(374,'1064','0','',NULL,NULL,0,1,'','',0.00,'','','101_0064.JPG','',0.0000,1,1,'',0.00,374,0,NULL),(246,'arabesque','0','',NULL,NULL,0,0,'','',0.00,'','','MG_Arabesque_web.jpg','',0.0000,1,1,'',0.00,246,0,NULL),(253,'xavior convent window','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1164.JPG','',0.0000,1,1,'',0.00,250,0,NULL),(367,'mim museum','0','',NULL,NULL,0,1,'','',0.00,'','','mim_museum.jpg','',0.0000,1,1,'',0.00,367,0,NULL),(261,'mexican market scene','0','mexican market scene',NULL,NULL,0,1,'','',0.00,'mexican market scene','','mexican_market_scene.jpg','',0.0000,1,1,'',0.00,261,NULL,NULL),(242,'Dog','0','',NULL,NULL,0,0,'','',0.00,'','','web.jpg','',0.0000,1,1,'',0.00,235,0,NULL),(197,'Rainbow Bridge','0','',NULL,NULL,0,0,'','',0.00,'','','Rainbow_Bridge.jpg','',0.0000,1,1,'',0.00,200,0,NULL),(199,'','0','',NULL,NULL,0,0,'','',0.00,'','','fishermen_at_st_isabella.jpg','',0.0000,1,1,'',0.00,205,NULL,NULL),(200,'White Buffalo','0','',NULL,NULL,0,0,'','',0.00,'','','full_scene_of_white_buffalo.JPG','',0.0000,1,1,'',0.00,206,0,NULL),(203,'St. Mary\'s Mission','0','',NULL,NULL,0,1,'','',0.00,'','','Lady_morenci.JPG','',0.0000,1,1,'',0.00,225,NULL,NULL),(230,'','0','',NULL,NULL,0,0,'','',0.00,'','','gethsemeni_our_lady_of_the_blessed_sacrament.jpg','',0.0000,1,1,'',0.00,222,NULL,NULL),(207,'','0','',NULL,NULL,0,1,'','',0.00,'','','cactus_lamb_church.JPG','',0.0000,1,1,'',0.00,224,NULL,NULL),(208,'Religious','0','1005 Religious',NULL,NULL,0,1,'','',0.00,'','','st_._george.jpg','',0.0000,1,1,'',0.00,196,0,0),(210,'','0','',NULL,NULL,0,1,'','',0.00,'','','PSG_003.jpg','',0.0000,1,1,'',0.00,210,NULL,NULL),(211,'','0','',NULL,NULL,0,1,'','',0.00,'','','PSG_001.jpg','',0.0000,1,1,'',0.00,211,NULL,NULL),(231,'','0','',NULL,NULL,0,0,'','',0.00,'','','picguardianangel.jpg','',0.0000,1,1,'',0.00,232,NULL,NULL),(229,'Sun City West Christian Church','0','',NULL,NULL,0,0,'','',0.00,'','','Sun_City_West_Christian_Church_Web.jpg','',0.0000,1,1,'',0.00,230,NULL,NULL),(214,'','0','',NULL,NULL,0,1,'','',0.00,'','','PSG_007.jpg','',0.0000,1,1,'',0.00,212,NULL,NULL),(219,'','0','',NULL,NULL,0,1,'','',0.00,'','','PSG_012.jpg','',0.0000,1,1,'',0.00,219,NULL,NULL),(222,'St. Isabella (scroll right to view entire window)','0','',NULL,NULL,0,1,'','',0.00,'','','LAST_SUPPER_TABLEAU.JPG','',0.0000,1,1,'',0.00,166,0,NULL),(268,'mexican entry','0','',NULL,NULL,0,1,'','',0.00,'','','100_0022.JPG','',0.0000,1,1,'',0.00,268,0,NULL),(269,'','0','',NULL,NULL,0,1,'','',0.00,'','','6-14-2007-10.jpg','',0.0000,1,1,'',0.00,269,0,NULL),(270,'Interiors','0','',NULL,NULL,0,1,'','',0.00,'','','6-14-2007-15.jpg','',0.0000,1,1,'',0.00,270,0,NULL),(333,'Powerslogox','0','',NULL,NULL,1,1,'','',0.00,'','','powerslogo24.jpg','',0.0000,1,1,'',0.00,333,0,NULL),(273,'Southwest Collage','0','',NULL,NULL,0,1,'','',0.00,'','','Arizona_Highways_Rec_(2_of_2).JPG','',0.0000,1,1,'',0.00,273,0,NULL),(274,'','0','',NULL,NULL,0,1,'','',0.00,'','','Beveledentry.JPG','',0.0000,1,1,'',0.00,274,0,NULL),(275,'Clear and Metal','0','',NULL,NULL,0,1,'','',0.00,'','','DSC00033.JPG','',0.0000,1,1,'',0.00,275,0,NULL),(362,'Front Entry','0','',NULL,NULL,0,1,'','',0.00,'','','leesentry.JPG','',0.0000,1,1,'',0.00,362,0,NULL),(277,'Kitchen windows','0','',NULL,NULL,0,1,'','',0.00,'','','DSC00117.JPG','',0.0000,1,1,'',0.00,278,0,NULL),(292,'Brown fused Cowboy','0','Joe Beeler cowboy',NULL,NULL,0,0,'','',0.00,'','','101_0187.JPG','',0.0000,1,1,'',0.00,292,0,NULL),(334,'Front Entry','0','',NULL,NULL,1,1,'','',0.00,'','','leesentry.JPG','',0.0000,1,1,'',0.00,334,0,NULL),(281,'Antique Window','0','',NULL,NULL,0,1,'','',0.00,'','','HPIM1064.JPG','',0.0000,1,1,'',0.00,281,0,NULL),(282,'','0','',NULL,NULL,0,1,'','',0.00,'','','MG_door.jpg','',0.0000,1,1,'',0.00,283,0,NULL),(398,'Parrot','0','',NULL,NULL,0,1,'','',0.00,'','','mexico_parrot1.jpg','',0.0000,1,1,'',0.00,398,0,NULL),(284,'','0','',NULL,NULL,0,1,'','',0.00,'','','dinner.jpg','',0.0000,1,1,'',0.00,282,0,NULL),(285,'Staircase windows','0','',NULL,NULL,0,1,'','',0.00,'','','irwin.JPG','',0.0000,1,1,'',0.00,285,0,NULL),(288,'Small Bevel','0','',NULL,NULL,0,1,'','',0.00,'','','small_bevel.JPG','',0.0000,1,1,'',0.00,288,0,NULL),(296,'Fish','0','these windows were made to feel like you are in an aquarium',NULL,NULL,0,0,'','',0.00,'','','HPIM2006.JPG','',0.0000,1,1,'',0.00,296,0,NULL),(297,'','0','',NULL,NULL,0,0,'','',0.00,'','','101_0268.JPG','',0.0000,1,1,'',0.00,297,0,NULL),(302,'yellow cowboy fused','0','',NULL,NULL,0,0,'','',0.00,'','','100_1136.JPG','',0.0000,1,1,'',0.00,303,0,NULL),(303,'blue fused flowers','0','',NULL,NULL,0,0,'','',0.00,'','','100_1128.JPG','',0.0000,1,1,'',0.00,302,0,NULL),(304,'red indian head','0','',NULL,NULL,0,0,'','',0.00,'','','100_1369.JPG','',0.0000,1,1,'',0.00,306,0,NULL),(372,'1000','0','',NULL,NULL,0,1,'','',0.00,'','','0F__tains_wind.jpg','',0.0000,1,1,'',0.00,372,0,NULL),(314,'','0','',NULL,NULL,0,1,'','',0.00,'','','DSCN1266.JPG','',0.0000,1,1,'',0.00,315,0,NULL),(315,'shroud','0','',NULL,NULL,0,1,'','',0.00,'','','DSCN1321_(2).jpg','',0.0000,1,1,'',0.00,316,0,NULL),(365,'111','111','',NULL,NULL,0,1,'','',0.00,'','','111.jpg','',0.0000,1,1,'',0.00,365,0,NULL),(318,'','0','',NULL,NULL,0,0,'','',0.00,'','','xavier4_(2).jpg','',0.0000,1,1,'',0.00,323,0,NULL),(319,'','0','',NULL,NULL,0,0,'','',0.00,'','','xavier5_(2).jpg','',0.0000,1,1,'',0.00,319,0,NULL),(396,'Xavier','0','',NULL,NULL,0,1,'','',0.00,'','','Xavier2013.jpg','',0.0000,1,1,'',0.00,396,0,NULL),(371,'Photography by David B. Moore','0','',NULL,NULL,0,1,'','',0.00,'','','DBM_DeMark_PignPantry_aa.jpg','',0.0000,1,1,'',0.00,371,0,NULL),(355,'205 Photography by David B. Moore','205','Photography by David B. Moore',NULL,NULL,0,1,'','',0.00,'','','DBM_Chris_cowboy93_aa.jpg','',0.0000,1,1,'',0.00,356,0,NULL),(342,'204','204','',NULL,NULL,0,1,'','',0.00,'','','104.JPG','',0.0000,1,1,'',0.00,342,0,NULL),(343,'105','105','',NULL,NULL,0,1,'','',0.00,'','','105.JPG','',0.0000,1,1,'',0.00,343,0,NULL),(345,'201','201','',NULL,NULL,0,1,'','',0.00,'','','201.JPG','',0.0000,1,1,'',0.00,345,0,NULL),(346,'202','202','',NULL,NULL,0,1,'','',0.00,'','','202.JPG','',0.0000,1,1,'',0.00,346,0,NULL),(347,'203','203','',NULL,NULL,0,1,'','',0.00,'','','203.JPG','',0.0000,1,1,'',0.00,347,0,NULL),(348,'103','103','',NULL,NULL,0,1,'','',0.00,'','','204.JPG','',0.0000,1,1,'',0.00,348,0,NULL),(363,'111','0','',NULL,NULL,0,1,'','',0.00,'','','','',0.0000,1,1,'',0.00,363,0,NULL),(350,'','0','Owners Tony Powers, Chris Powers and John Powers at their shop in Scottsdale, Arizona.<P>We have been at this location for over 30 years and we thank all of our customers who we call friends. We believe in customer service, being on time, and making creative and quality products.<BR> We make stained glass windows, repair windows that have been damaged, use clear glass or bevels, work with metals, lamps, create large public  art, church windows, and fused glass.     <BR> We work with designers, architects, builders, church congregations,schools, business owners  and homeowners. <BR>We teach stained glass classes at our shop during the year and have taught through local colleges in the past.<P> Residential and Commercial License (Glazing)  ',NULL,NULL,0,0,'','',0.00,'','','','',0.0000,1,1,'',0.00,350,0,NULL),(351,'About Us','0','',NULL,NULL,0,0,'','',0.00,'','','boys_shop_psg.jpg','',0.0000,1,1,'',0.00,352,0,NULL),(353,'106a','106a','',NULL,NULL,0,1,'','',0.00,'','','DSC00437.JPG','',0.0000,1,1,'',0.00,355,0,NULL),(352,'102a','102a','',NULL,NULL,0,1,'','',0.00,'','','DSC00433.JPG','',0.0000,1,1,'',0.00,353,0,NULL),(356,'206 Photography by David B. Moore','206','',NULL,NULL,0,1,'','',0.00,'','','DBM_Chris_TomMix_aa.jpg','',0.0000,1,1,'',0.00,357,0,NULL),(357,'Apache Moon  Photography by David B. Moore','0','Painted by Joe Beeler and recreated in stained glass by Powers. Featured in Phoenix Home & Garden Magazine March 2013.',NULL,NULL,0,1,'','',0.00,'','','DBM_ChrisPower_Indian_aa.jpg','',0.0000,1,1,'',0.00,358,0,NULL),(358,'Seat with a View Photography by David B. Moore','0','Painted by Joe Beeler and recreated in stained glass by Powers. Featured in Phoenix Home & Garden Magazine March 2013.',NULL,NULL,0,1,'','',0.00,'','','DBM_Chris_JoeS_aa.jpg','',0.0000,1,1,'',0.00,351,0,NULL),(359,'Gunfighter  Photography by David B. Moore','0','Featured in Phoenix Home & Garden online March 2013.',NULL,NULL,0,1,'','',0.00,'','','DBM_ChrisPower_gunfighter_aa.jpg','',0.0000,1,1,'',0.00,359,0,NULL),(360,'Wildbunch Photography by David B. Moore','0','Featured in Phoenix Home & Garden online March 2013.',NULL,NULL,0,1,'','',0.00,'','','DBM_ChrisPower_Wildbunch_aa.jpg','',0.0000,1,1,'',0.00,360,0,NULL),(361,'Leaning Cowboy Photography by David B. Moore','0','Featured in Phoenix Home & Garden Magazine March 2013.',NULL,NULL,0,1,'','',0.00,'','','DBM_ChrisPower_12_aa.jpg','',0.0000,1,1,'',0.00,361,0,NULL),(400,'Beginning Stained Glass Class 101','101','Wednesday 9:00AM-12 noon\r\n<BR>4 weeks<BR>September 4,11,18.25<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,400,1,NULL),(395,'lampshade','0','',NULL,NULL,0,1,'','',0.00,'','','mexico_lampshade_21.jpg','',0.0000,1,1,'',0.00,395,0,NULL),(380,'church','0','',NULL,NULL,0,1,'','',0.00,'','','full_view_outlined.JPG','',0.0000,1,1,'',0.00,380,0,NULL),(381,'Tomaso\'s','0','',NULL,NULL,0,1,'','',0.00,'','','god.JPG','',0.0000,1,1,'',0.00,381,0,NULL),(382,'golf','0','',NULL,NULL,0,1,'','',0.00,'','','golfresort.JPG','',0.0000,1,1,'',0.00,382,0,NULL),(394,'bathroom','0','',NULL,NULL,0,1,'','',0.00,'','','lake_res_bathroom1.jpg','',0.0000,1,1,'',0.00,394,0,NULL),(393,'kachina','0','',NULL,NULL,0,1,'','',0.00,'','','bisgrove-12.jpg','',0.0000,1,1,'',0.00,393,0,NULL),(386,'miami','0','',NULL,NULL,0,1,'','',0.00,'','','miami_church_west_wall.jpg','',0.0000,1,1,'',0.00,386,0,NULL),(387,'Our Lady','0','',NULL,NULL,0,1,'','',0.00,'','','ourlady.JPG','',0.0000,1,1,'',0.00,387,0,NULL),(388,'church1','0','',NULL,NULL,0,1,'','',0.00,'','','room_view_composite-res.jpg','',0.0000,1,1,'',0.00,388,0,NULL),(389,'church view','0','',NULL,NULL,0,1,'','',0.00,'','','scan0007.jpg','',0.0000,1,1,'',0.00,389,0,NULL),(390,'Duke','0','',NULL,NULL,0,1,'','',0.00,'','','warren_powers_res.The__Duke.jpg','',0.0000,1,1,'',0.00,390,0,NULL),(391,'Hart','0','',NULL,NULL,0,1,'','',0.00,'','','william_s._hart.JPG','',0.0000,1,1,'',0.00,391,0,NULL),(399,'Mexico bathroom','0','',NULL,NULL,0,1,'','',0.00,'','','mexico_bathroom_window1.jpg','',0.0000,1,1,'',0.00,399,0,NULL),(401,'Beginning Stained Glass Class 102','102','Saturday 9:00AM-12 noon\r\n<BR>4 weeks<BR>September 7,14,21.28<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,401,1,NULL),(402,'Beginning Stained Glass Class 103','103','Wednesday 9:00AM-12 noon\r\n<BR>4 weeks<BR>October 2,9,16,23<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'Each student will take home a project.\r\nNo experience necessary.\r\nSupplies will be provided to create class project.',0.00,402,1,NULL),(403,'Beginning Stained Glass Class 104','104','Saturday 9:00AM-12 noon\r\n<BR>4 weeks<BR>October 5,12,19,26<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,403,1,NULL),(416,'','0','',NULL,NULL,0,1,'','',0.00,'','','bisgrove-1.jpg','',0.0000,1,1,'',0.00,416,0,NULL),(404,'Beginning Stained Glass Class 105','105','Wednesday 9:00AM-12 noon\r\n<BR>4 weeks<BR>October 30. November 6,13,20<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,404,1,NULL),(405,'Beginning Stained Glass Class 106','106','Saturday 9:00AM-12 noon\r\n<BR>4 weeks<BR>November 2,9,16,23<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,405,1,NULL),(412,'','0','',NULL,NULL,0,1,'','',0.00,'','','xavier3_(2).jpg','',0.0000,1,1,'',0.00,412,0,NULL),(413,'','0','',NULL,NULL,0,1,'','',0.00,'','','adam.JPG','',0.0000,1,1,'',0.00,413,0,NULL),(406,'','0','Specializing in repair of old and new stained glass windows. More than 30 years in the stained glass business. Residential and commercial contractor license (glazing). Call us at 480-941-8272 or email us at info@powersstainedglass.com for a quote.\r\n',NULL,NULL,0,0,'','',0.00,'','','2windows_at_st_isabella.jpg','',0.0000,1,1,'',0.00,406,0,0),(407,'Like us on Facebook!','0','',NULL,NULL,0,0,'','',0.00,'','','facebook-logo.jpg','',0.0000,1,1,'',0.00,407,0,NULL),(408,'logopsg1','0','',NULL,NULL,1,1,'','',0.00,'','','logopsg1.jpg','',0.0000,1,1,'',0.00,408,0,NULL),(409,'December Holiday Class 201','201','Wednesday 9:00AM-12 noon\r\n<BR>3 weeks<BR>December 4,11,18<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,409,1,NULL),(410,'December Holiday Class 202','202','Saturday 9:00AM-12 noon\r\n<BR>3 weeks<BR>December 7,14,21<BR>Cost $100- place a $20 non refundable deposit to hold spot. Balance due at class start.',NULL,NULL,1,1,'','',20.00,'','','','',0.0000,1,1,'',0.00,410,1,NULL);

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

CREATE TABLE `Sale` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `productID` int(11) NOT NULL DEFAULT '0',
  `quantity` int(11) NOT NULL DEFAULT '0',
  `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 AUTO_INCREMENT=81 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=40 DEFAULT CHARSET=latin1 PACK_KEYS=1;

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


--
-- Dumping events for database 'powersstainedglass'
--

--
-- Dumping routines for database 'powersstainedglass'
--


