Table Bases & Tops

{"__type":"Lighthouse.Lh3.FrontEnd.Root.Model.AdapterParameters, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","LoaderOptions":{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Builtin.ProductListLoaderOptions, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Parents":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.ParentQueryData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Id":88747,"Path":1128411516}],"Products":[],"FetchCascade":true,"ImageTypeCodeArray":["list"],"SkuImageTypeCodeArray":["photoGalleryList"],"EnableNoImage":true,"SearchTerm":"","ExcludeItemIds":[],"IncludeBreadcrumb":false,"ItemAttributes":[],"FetchMaterializedData":true,"IgnoreFilterQueryString":false,"DefaultDetailsPageTemplate":"productDetails","ProductListAdditionalColumns":null,"ProductTypeCodes":[],"CustomJoinFromClause":null,"ProductsState":[],"AllProductsEnabled":false,"SortGroup":0,"SkuPhotogalleryImageTypeCodeArray":["photoGalleryList"],"PageNumber":1,"PageSize":24,"SortKey":"Stock Price-Descending","SortOptions":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"default","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"SortTypeValues","Direction":1},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"DisplayOrder","Direction":0}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Stock Price-Descending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"mp.MaxPVStock * mp.UnitPrice","Direction":1}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Product Code-Descending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"SUBSTRING(mp.ERPCODE,3,LEN(mp.ERPCODE))","Direction":1}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Product Code-Ascending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"SUBSTRING(mp.ERPCODE,3,LEN(mp.ERPCODE))","Direction":0}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Name-Ascending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"Name","Direction":0}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Name-Descending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"Name","Direction":1}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Price-Ascending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"Price","Direction":0}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Price-Descending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"Price","Direction":1}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Availability-Ascending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"atypes.DisplayOrder","Direction":0}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Availability-Descending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"atypes.DisplayOrder","Direction":1}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Discount-Ascending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"mp.UnitPrice/mp.DeletedPrice","Direction":0}],"Properties":{}},{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SortData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Key":"Discount-Descending","Sorters":[{"__type":"Lighthouse.Lh3.FrontEnd.Controls.Data.SorterData, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Field":"mp.UnitPrice/mp.DeletedPrice","Direction":1}],"Properties":{}}],"Filters":[],"FullPath":null,"AdditionalSelectClause":"COALESCE(CONVERT(nvarchar(10),w.ValueDatetime,104),\u0027\u0027) AS estdate, d.SKU AS skucode ,ISNULL(q.Stock,0) AS Stock_Sku","AdditionalJoinClause":" LEFT JOIN cms_ItemAttributes w ON w.ItemId=mp.SKUParentId AND w.AttributeId=4589 INNER JOIN Ecom_Products q on mp.VariantId=q.ProductItemId Left JOIN Ecom_Products d on d.ProductItemId=mp.skuparentid","AdditionalWhereClause":"","InnerAdditionalWhereClause":"","XRelatedProducts":0,"IsLazyLoadEnabled":true,"LazyLoadImagePath":null,"PartnerId":null,"LanguageCode":"en","CurrencyCode":"EUR","SiteCode":"woodwell","Cacher":null},"AdapterOptions":{"__type":"Lighthouse.Lh3.FrontEnd.Root.Model.ProductListBaseAdapter+ProductsAdapterParams, Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","Title":"Table Bases \u0026 Tops","SeoTitle":"Table Bases \u0026 Tops","Grouping":-1,"RowSize":-1,"LazyLoadEnabled":true,"Scrolled":true,"LazyLoadPrices":false,"HasMultipleAdd":false,"UseColorImages":false,"HasQuickView":true,"HasQuickBuy":false,"HasDetailedView":false,"RandomMaxSize":-1,"ShowTitle":true,"ShowDescription":true,"ShowPrice":true,"ShowDeletedPrice":true,"ShowManufacturer":true,"ShowCode":true,"ShowTags":true,"ShowAddToCartButton":true,"ShowAddToWishListButton":false,"ShowAddToCompareListButton":false,"ShowIncrementalButtons":false,"ShowFromToPriceText":false,"ShowDiscount":false,"ShowDiscountValue":false,"AlreadyInCartEnabled":false,"AlreadyInWishlistEnabled":false,"AlreadyInCompareListEnabled":false,"ShowDeliveryPointWithPricingRules":false,"RefreshInterval":0},"LoaderAssemblyName":"Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","LoaderClassName":"Lighthouse.Lh3.FrontEnd.Controls.Builtin.ProductListLoader","AdapterAssemblyName":"Lighthouse.Lh3.FrontEnd, Version=0.0.46.10, Culture=neutral, PublicKeyToken=null","AdapterClassName":"Lighthouse.Lh3.FrontEnd.Root.Model.ProductListAdapter"}