SELECT ItemID,Items.ItemPageID,oip.idproduct as idp,ItemName,ItemIsDefault,ItemStatus,ItemWidth,ItemHeight,ItemDepth,ItemDiameter,ItemWeight,ItemPriceSAS,ItemSalePriceSAS,ItemSaleDateBegin,ItemSaleDateEnd,ItemIsCollection,ItemVendorID,ItemVendorPartNo,ItemMfgID,ItemBrandID,ItemVendProdID,ItemShippingRestrict,ItemShipWidth,ItemShipHeight,ItemShipDepth,ItemOrigin,ItemNonTaxable,ItemPageName,ItemPageDisplayName,ItemPageDescription,ItemPageRelatedItems,ItemPagePrimaryCategory,ItemPageImageFiles,ItemPageQtyDiscount,ItemPageSpecial,ItemPageSeasonalMonth,ItemPageSoldAsQty,ItemPageOptionTypes,ItemPageSoldAsSet,ItemPageKeywords,ItemPageCatalogName,ItemPageSpecialDate,ItemPagesMetaDescriptionMain,ItemPageAltImg1,ItemPageAltImg2,ItemPageAltImg3,LTL,ItemNameSAS,ItemPageImagesSNS,ItemImageSAS,ItemPageDescriptionSNS,ItemPageDisplayNameSNS, ItemPageDescription2SNS,ItemFreeShipSAS, ItemPageNameSNS, ItemDimensionSAS FROM Items INNER JOIN ItemPages ON Items.ItemPageID=ItemPages.ItemPageID LEFT OUTER JOIN sascart.dbo.products as oip on items.itemid = oip.sku WHERE ItemPages.ItemPageID=19845 ORDER BY ItemName, ItemPriceSAS, ItemID Asc