SELECT * FROM Resourcecategories where ResourceCategoryID = 9 SELECT Resources.ResourceID, CategoryQuery.ResourceCategoryName, SubCategoryQuery.ResourceCategoryID, SubCategoryQuery.ResourceSubCategoryName, SubCategoryQuery.ResourceSubCategoryURL, SubCategoryQuery.ResourceSubCategoryimage, ThirdLevelQuery.ResourceThirdLevelName, ThirdLevelQuery.ResourceThirdLevelurl,ThirdLevelQuery.ResourceThirdLevelimage,FourthLevelQuery.ResourceFourthLevelName FROM (((Resources LEFT JOIN CategoryQuery ON Resources.ResourceID = CategoryQuery.ResourceID) LEFT JOIN SubCategoryQuery ON (CategoryQuery.ResourceID = SubCategoryQuery.ResourceID) AND (CategoryQuery.ResourceCategoryID = SubCategoryQuery.ResourceCategoryID)) LEFT JOIN ThirdLevelQuery ON (SubCategoryQuery.ResourceCategoryID = ThirdLevelQuery.ResourceCategoryID) AND (SubCategoryQuery.ResourceID = ThirdLevelQuery.ResourceID) AND (SubCategoryQuery.ResourceSubCategoryID = ThirdLevelQuery.ResourceSubCategoryID)) LEFT JOIN FourthLevelQuery ON (ThirdLevelQuery.ResourceSubCategoryID = FourthLevelQuery.ResourceSubCategoryID) AND (ThirdLevelQuery.ResourceCategoryID = FourthLevelQuery.ResourceCategoryID) AND (ThirdLevelQuery.ResourceID = FourthLevelQuery.ResourceID) AND (ThirdLevelQuery.ResourceThirdLevelID = FourthLevelQuery.ResourceThirdLevelID) where SubCategoryQuery.ResourceCategoryID = 9 and ThirdLevelQuery.ResourceSubCategoryID = 70 ORDER BY Resources.ResourceOrder, CategoryQuery.ResourceCategoryOrder, SubCategoryQuery.ResourceSubCategoryOrder, ThirdLevelQuery.ResourceThirdLevelOrder, FourthLevelQuery.ResourceFourthLevelOrder; SELECT [Resources].[ResourceID], [Resources].[Title], [Resources].[Description], [Resources].[Hits], [Resources].[CreateDateTime], [Resources].[LastModifyDateTime], [Resources].[Visible], [ResourceLink].[ResourceLinkID], [ResourceLink].[ResourceID], [ResourceLink].[Label], [ResourceLink].[URL], [ResourceLink].[ResourceLinkOrder], [ResourceCategoryLink].[ResourceCategoryLinkID], [ResourceCategoryLink].[ResourceID], [ResourceCategoryLink].[ResourceCategoryID], [ResourceSubcategories].[ResourceSubCategoryID], [ResourceSubcategories].[ResourceSubCategoryName], [ResourceSubcategories].[ResourceSubCategoryURL], [ResourceSubcategories].[ResourceSubCategoryImage], [ResourceSubcategories].[ResourceSubCategoryOrder], [ResourceSubCategoryLink].[ResourceSubCategoryLinkID], [ResourceSubCategoryLink].[ResourceID], [ResourceSubCategoryLink].[ResourceCategoryID], [ResourceSubCategoryLink].[ResourceSubCategoryID], [ResourceThirdLevel].[ResourceThirdLevelID], [ResourceThirdLevel].[ResourceThirdLevelName], [ResourceThirdLevel].[ResourceThirdLevelURL], [ResourceThirdLevel].[ResourceThirdLevelImage], [ResourceThirdLevel].[ResourceThirdLevelOrder], [ResourceThirdLevelLink].[ResourceThirdLevelLinkID], [ResourceThirdLevelLink].[ResourceID], [ResourceThirdLevelLink].[ResourceCategoryID], [ResourceThirdLevelLink].[ResourceSubCategoryID], [ResourceThirdLevelLink].[ResourceThirdLevelID] FROM (ResourceThirdLevel INNER JOIN ((ResourceSubcategories INNER JOIN ((ResourceCategoryLink INNER JOIN Resources ON [ResourceCategoryLink].[ResourceID]=[Resources].[ResourceID]) INNER JOIN ResourceSubCategoryLink ON [Resources].[ResourceID]=[ResourceSubCategoryLink].[ResourceID]) ON [ResourceSubcategories].[ResourceSubCategoryID]=[ResourceSubCategoryLink].[ResourceSubCategoryID]) INNER JOIN ResourceThirdLevelLink ON ([Resources].[ResourceID]=[ResourceThirdLevelLink].[ResourceID]) AND ([ResourceSubcategories].[ResourceSubCategoryID]=[ResourceThirdLevelLink].[ResourceSubCategoryID])) ON [ResourceThirdLevel].[ResourceThirdLevelID]=[ResourceThirdLevelLink].[ResourceThirdLevelID]) INNER JOIN ResourceLink ON [Resources].[ResourceID]=[ResourceLink].[ResourceID] WHERE ResourceCategoryLink.ResourceCategoryID = 9 and ResourceSubCategoryLink.ResourceSubCategoryID = 70 and ResourceThirdLevel.ResourceThirdLevelID <> 50 and Resources.Visible = 1 ORDER BY ResourceThirdLevel.ResourceThirdLevelOrder, (Resources.Hits/(NOW()-Resources.CreateDateTime)) DESC, Resources.ResourceID, ResourceLink.ResourceLinkOrder; CLU-IN.ORG | <cfoutput query="pageheader">#ResourceCategoryName#</cfoutput> > <cfoutput query="subcategories" maxrows="1">#ResourceSubCategoryName#</cfoutput>

Roadside Use of Native Plants

US Map

Map of the US, split into EPA regions Region 1: Connecticut, Maine, Massachusetts, New Hampshire, Rhode Island, Vermont Region 2: New Jersey, New York, Puerto Rico, US Virgin Islands Region 3: Delaware, District of Columbia, Maryland, Pennsylvania, Virginia, West Virginia Region 4: Alabama, Florida, Georgia, Kentucky, Mississippi, North Carolina, South Carolina, Tennessee Region 5: Illinois, Indiana, Michigan, Minnesota, Ohio, Wisconsin Region 6: Arkansas, Louisiana, New Mexico, Oklahoma, Texas Region 7: Iowa, Kansas, Missouri, Nebraska Region 8: Colorado, Montana, North Dakota, South Dakaota, Utah, Wyoming Region 9: Arizona, California, Hawaii, Nevada, Pacific Islands Region 10: Alaska, Idaho, Oregon, Washington

purple divider

http://#cgi.server_name##cgi.script_name#
Page Last Modified: #DateFormat(pagelastmodified, "mmmm d, yyyy")#