Query to get qualifying ProductIDs failed: Expression #1 of ORDER BY clause is not in SELECT list, references column 'www_productdb.F.Sort' which is not in SELECT list; this is incompatible with DISTINCT
. SELECT DISTINCT P.ProductID FROM Product P INNER JOIN Make M USING (MakeCode) INNER JOIN FeaturedStatic F ON M.AMakeCode = F.AMakeCode && P.ItemN0 = F.ItemN0 WHERE F.Site = "BVN"&& ((M.AMakeCode = 'DL' && P.ItemN0 = 'DLVG-204-MP') || (M.AMakeCode = 'EH' && P.ItemN0 = '6001') || (M.AMakeCode = 'EH' && P.ItemN0 = '7473')) ORDER BY F.Sort