SQL Query To Find out which site template had been used to create a site

Another SQL Query for WSS_Content / sharepoint / Moss database
Find out which site template had been used to create a site entitled

SELECT Title, WebTemplate, ProvisionConfig
FROM dbo.Webs
WHERE Title='Give your siteName'

Enjoy Green coding....
Keep looking for the Free Sharepoint SQL eBook on code4green.com