SELECT ProductVariant.ImageFile, Product.ImageAltText, ProductVariant.ImageWidth, ProductVariant.ImageHeight, XrefGroupProduct.Value1, XrefGroupProduct.Value2, Product.ID FROM (XrefGroupProduct INNER JOIN Product ON XrefGroupProduct.ProductID = Product.ID) INNER JOIN ProductVariant on Product.ID = ProductVariant.ProductID WHERE XrefGroupProduct.ProductGroupID = 126 ORDER BY XrefGroupProduct.DisplayOrder, ProductVariant.ListOrder