Get Team Site List by Title

It’s very simple tip but it helped me a lot cause the Korean Air has lots of sites.

SELECT TOP 20 * FROM Webs WITH (NOLOCK)
WHERE Title LIKE N'{TeamSiteName}%'