Query to select count of qualifying products failed: Table 'www_siteproductdb.SiteProductKCH' doesn't exist
SELECT COUNT(DISTINCT P.ProductID) AS NProds FROM Product P INNER JOIN www_siteproductdb.SiteProductKCH SP ON P.ProductID = SP.ProductID INNER JOIN AttributeGroupSearch GS0 ON P.ProductID = GS0.ProductID INNER JOIN AttributeGroupSearch GS1 ON P.ProductID = GS1.ProductID INNER JOIN AttributeGroupSearch GS2 ON P.ProductID = GS2.ProductID INNER JOIN AttributeGroupSearch GS3 ON P.ProductID = GS3.ProductID INNER JOIN AttributeGroupSearch GS4 ON P.ProductID = GS4.ProductID WHERE P.Discontinue=0 && GS0.AttributeNVID =2003 && GS1.AttributeNVID IN (6019,6051) && GS2.AttributeNVID =3018 && GS3.AttributeNVID =5924 && GS4.AttributeNVID =20714