Query to select attributes common to all configurations failed: Expression #2 of ORDER BY clause is not in SELECT list, references column 'www_productdb.N.DisplayOrder' which is not in SELECT list; this is incompatible with DISTINCT
SELECT DISTINCT G.AttributeNVID, NV.AttributeNameID, N.AttributeName, V.AttributeValue, V.AttributeFloat, V.AttributeUnits, N.Dimension, N.DisplayHeading, N.GetLink, SV.AttributeValue AS SubPart FROM AttributeGroup G INNER JOIN AttributeNV NV USING (AttributeNVID) INNER JOIN AttributeName N USING (AttributeNameID) INNER JOIN AttributeValue V USING (AttributeValueID) LEFT JOIN AttributeValue SV ON NV.SubPartID = SV.AttributeValueID WHERE ProductID = 51550 && G.DropDown=0 && G.ComponentQuantity=0 && N.DisplayOrder!=0 ORDER BY SubPart, N.DisplayOrder, G.SortOrder, N.Dimension, N.AttributeName, V.SortOrder, V.AttributeValue