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 '%www.jimellishyundaiparts.com%'

--website ukey is 49, ukey_client is 31


The ukey_client column is only really used for P1 sites.