----------->SELECT CategoryID, CategoryName, CategoryParentID, CompanyID, MetaTitle, MetaKeywords, MetaDescription, URLKey, HtmlH1, HtmlH2, HtmlContent FROM tWebCategories WHERE CategoryID = '{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}' AND CompanyID = '00000000-0000-0000-0000-000000000005'<----------------------->SELECT * FROM tConfiguration WHERE CompanyID = '00000000-0000-0000-0000-000000000005' OR CompanyID = '{00000000-0000-0000-0000-000000000000}'<----------------------->SELECT * FROM tCompanyInfo WHERE CompanyID = '00000000-0000-0000-0000-000000000005'<----------------------->SELECT PaymentOptionID, OptionName, SurchargeType, Surcharge, IsDefault FROM tCTRL_PaymentOptions WHERE CompanyID = '00000000-0000-0000-0000-000000000005' AND IsActiveOnWeb = 1 Order By SortOrder<----------------------->SELECT CategoryID, CategoryName, CategoryParentID, CompanyID, MetaTitle, MetaKeywords, MetaDescription, URLKey, HtmlH1, HtmlH2, HtmlContent FROM tWebCategories WHERE CategoryID = '{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}' AND CompanyID = '00000000-0000-0000-0000-000000000005'<----------------------->SELECT CategoryID, CategoryName, CategoryParentID, CompanyID, MetaTitle, MetaKeywords, MetaDescription, URLKey, HtmlH1, HtmlH2, HtmlContent FROM tWebCategories WHERE CategoryID = '{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}' AND CompanyID = '00000000-0000-0000-0000-000000000005'<----------------------->SELECT CategoryID, CategoryName, CategoryParentID, CompanyID, MetaTitle, MetaKeywords, MetaDescription, URLKey, HtmlH1, HtmlH2, HtmlContent FROM tWebCategories WHERE CategoryID = '{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}' AND CompanyID = '00000000-0000-0000-0000-000000000005'<------------ - In Stock at products.mictongroup.com
 
 
Search        
Loading TreeView Menu

----------->SELECT CategoryID, CategoryName, CategoryParentID, CompanyID, MetaTitle, MetaKeywords, MetaDescription, URLKey, HtmlH1, HtmlH2, HtmlContent FROM tWebCategories WHERE CategoryID = '{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}' AND CompanyID = '00000000-0000-0000-0000-000000000005'<----------------------->SELECT CategoryID FROM tWebCategories WHERE CategoryParentID = '{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}'<----------------------->SELECT Count(*) As TotalRecords FROM tInventoryWebData INNER JOIN tInventory ON tInventoryWebData.InventoryID = tInventory.InventoryID AND tInventoryWebData.CompanyID = '00000000-0000-0000-0000-000000000005' INNER JOIN tInventoryWebCategories on tInventory.InventoryID = tInventoryWebCategories.InventoryID AND tInventoryWebCategories.IsDefaultWebCategory = 1 AND tInventoryWebCategories.CompanyID = '00000000-0000-0000-0000-000000000005' LEFT JOIN tWebCategories ON tInventoryWebCategories.CategoryID = tWebCategories.CategoryID AND tWebCategories.CompanyID = tInventoryWebCategories.CompanyID WHERE (tInventoryWebData.InventoryID IN (Select InventoryID From tInventoryWebCategories Where tInventoryWebCategories.CategoryID IN ('{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}')) AND tInventoryWebCategories.CompanyID = '00000000-0000-0000-0000-000000000005') AND DisplayOnWebSite = 1 <----------------------->SET NOCOUNT ON ;WITH InventoryData AS ( SELECT ROW_NUMBER() OVER (ORDER BY WebTitle) AS 'RowNumber', tInventoryWebData.InventoryID FROM tInventoryWebData INNER JOIN tInventory ON tInventoryWebData.InventoryID = tInventory.InventoryID AND tInventoryWebData.CompanyID = '00000000-0000-0000-0000-000000000005' INNER JOIN tInventoryWebCategories on tInventory.InventoryID = tInventoryWebCategories.InventoryID AND tInventoryWebCategories.IsDefaultWebCategory = 1 AND tInventoryWebCategories.CompanyID = '00000000-0000-0000-0000-000000000005' LEFT JOIN tWebCategories ON tInventoryWebCategories.CategoryID = tWebCategories.CategoryID AND tWebCategories.CompanyID = tInventoryWebCategories.CompanyID WHERE (tInventoryWebData.InventoryID IN (Select InventoryID From tInventoryWebCategories Where tInventoryWebCategories.CategoryID IN ('{ff3b9b1d-2000-4e56-af8b-6b9882e39cb3}')) AND tInventoryWebCategories.CompanyID = '00000000-0000-0000-0000-000000000005') AND DisplayOnWebSite = 1 ) SELECT InventoryID INTO #Temp FROM InventoryData WHERE RowNumber BETWEEN 1 AND 20 SELECT tInventoryWebData.InventoryID, tInventoryWebData.WebFeaturedItem, tInventoryWebData.DisplayOnWebSite, tInventoryWebCategories.CategoryID As WebCategoryID, tInventoryWebData.IncRRP, tInventory.Warranty, tInventoryWebData.CompanyID, tInventory.Condition, tInventory.ItemTitle, tInventory.DescriptionHTML, tInventory.DescriptionText, tInventory.Weight, tInventory.QtyInStock, tInventory.MinimumOrderQty, tInventory.BarcodeID, tInventory.AlwaysInStock, ISNULL(C.RRP, 0) AS RRP, tInventory.OutOfStockQTYRetail, ISNULL(A.QtyFrom, 0) AS MinQTY, ISNULL(B.QtyTo, 0) AS MaxQTY, ISNULL(AA.Price,0) AS MinPrice, tInventoryWebData.PostageCostMethodDom, tInventoryWebData.PostageCostMethodInt, tInventoryWebData.ApplyFPRange, tInventoryWebData.ApplyWSFPRange, tInventoryWebData.WebTitle, tInventoryWebData.DisableCheckout, ISNULL(AA.VariationKeyID, '{00000000-0000-0000-0000-000000000000}') AS VariationID, tInventoryWebData.URLKey FROM tInventoryWebData INNER JOIN tInventory ON tInventoryWebData.InventoryID = tInventory.InventoryID AND tInventoryWebData.CompanyID = '00000000-0000-0000-0000-000000000005' INNER JOIN tInventoryWebCategories on tInventory.InventoryID = tInventoryWebCategories.InventoryID AND tInventoryWebCategories.IsDefaultWebCategory = 1 AND tInventoryWebCategories.CompanyID = '00000000-0000-0000-0000-000000000005' LEFT JOIN tWebCategories ON tInventoryWebCategories.CategoryID = tWebCategories.CategoryID AND tWebCategories.CompanyID = tInventoryWebCategories.CompanyID LEFT JOIN tInventoryWebPrices A ON A.PriceID = ( SELECT Top 1 tInventoryWebPrices.PriceID FROM tInventoryWebPrices JOIN tInventoryWebPriceVariations on tInventoryWebPrices.PriceID = tInventoryWebPriceVariations.PriceID WHERE tInventoryWebPrices.InventoryID = tInventoryWebData.InventoryID AND tInventoryWebPrices.CompanyID = tInventoryWebData.CompanyID AND tInventoryWebPrices.IsWholesale = 0 ORDER BY QtyFrom ASC, tInventoryWebPriceVariations.Price ASC ) LEFT JOIN tInventoryWebPrices B ON B.PriceID = ( SELECT Top 1 PriceID FROM tInventoryWebPrices WHERE tInventoryWebPrices.InventoryID = tInventoryWebData.InventoryID AND tInventoryWebPrices.CompanyID = tInventoryWebData.CompanyID AND tInventoryWebPrices.IsWholesale = 0 ORDER BY QtyTo DESC ) LEFT JOIN tInventoryWebPriceVariations AA ON A.InventoryID = AA.InventoryID AND A.PriceID = AA.PriceID AND AA.VariationKeyID = (Select Top 1 VariationKeyID from tInventoryWebPriceVariations where PriceID = A.PriceID ORDER BY price ASC) LEFT JOIN tInventoryWebPriceVariations BB ON B.InventoryID = BB.InventoryID AND B.PriceID = BB.PriceID AND BB.VariationKeyID = (Select Top 1 VariationKeyID from tInventoryWebPriceVariations where InventoryID = B.InventoryID ORDER BY price ASC) LEFT JOIN tInventory C on C.InventoryID = AA.VariationKeyID WHERE tInventory.InventoryID IN (Select InventoryID from #Temp) Order By WebTitle Drop Table #Temp<------------
CATEGORY:

( Matches Found)
   


No Products Found
 
Copyright © 2007 - 2026 Micton Group Pty Ltd