Check if a website is a P1 site/client

To check if a website is a P1 site, check the siteType column in Simplepart_Master.dbo.websites for that ukey_website.

SELECT ukey, websiteURL, ukey_client

FROM Simplepart_master.dbo.websites as w

WHERE w.websiteUrl LIKE ''

--website ukey is 49, ukey_client is 31

The ukey_client column is only really used for P1 sites.