There is no row at position 0.
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED SELECT * FROM ( SELECT ROW_NUMBER() OVER ( ORDER BY T1.StyleId DESC ) AS RowNum , COUNT(*) OVER () cnt , T1.StyleId, T1.Price AS SalePrice, T1.MkChk , T1.MkPrice, T1.WebType, T1.RetailPrice, T1.Price , T1.StyleId AS StyleId_V , ISNULL(StockCheck.CheckQty, 0) AS CheckQty FROM TblStyle T1 LEFT JOIN ( SELECT INV.StyleId, COUNT(*) AS CheckQty FROM TblInventory INV WITH(NOLOCK) INNER JOIN TblStyle STY WITH(NOLOCK) ON INV.StyleId = STY.StyleId LEFT JOIN VGN_CODE VGN WITH(NOLOCK) ON VGN.idCode = ISNULL(STY.StyleType, 26774) WHERE (CASE WHEN INV.VD_Unlimited = 1 THEN 1 ELSE INV.ColorShow END = 1) AND (CASE WHEN INV.VD_Unlimited = 1 THEN 1 ELSE CASE WHEN ISNULL(VGN.codeNm, 'DEFAULT') IN ('SHOES', 'SHOES1') THEN INV.InventoryQty WHEN ISNULL(VGN.codeNm, 'DEFAULT') = 'BAG PC' THEN INV.InventoryQty - 3 ELSE INV.InventoryQty - 5 END END) > 0 GROUP BY INV.StyleId ) StockCheck ON StockCheck.StyleId = T1.StyleId WHERE T1.ActOut = 0 AND T1.Price > 0 AND ISNULL(StockCheck.CheckQty, 0) > 0 AND ( (T1.StyleId Like '%WESTERN%' OR T1.WebType Like '%WESTERN%' OR T1.StyleNo Like '%WESTERN%') ) ) AS RowConstrainedResult WHERE RowNum >= 1601 AND RowNum < 1701 ORDER BY StyleId DESC
at System.Data.RBTree`1.GetNodeByIndex(Int32 userIndex) at System.Data.DataRowCollection.get_Item(Int32 index) at Products_Search.ProductList() in http://server/Products/Search.aspx.cs:line 627 at Products_Search.Page_Load(Object sender, EventArgs e) in http://server/Products/Search.aspx.cs:line 79

EXPLORE

Website Operation Hours

Mon 9:00 AM - 06:00 PM
Tue    9:00 AM - 06:00 PM
Wed 9:00 AM - 06:00 PM
Thu    9:00 AM - 06:00 PM
Fri       9:00 AM - 06:00 PM
Sat     Closed
Sun    Closed

Get in touch with us

Online +1 (213) 222-9590

Store +1 (213) 747-7875

Whatsapp +1 (323) 504-0459

support@joiaaccessory.com

CONNECT

Join our mailing list for updates
Sign up & Receive a Free gift with all your orders

Complying with ADA Web Content Accessibility Guidelines (WCAG) 2.1

We are in the process of complying with ADA (Americans with Disabilities Act) W3CWeb Content Accessibility Guidelines (WCAG) 2.1. If you are having a difficult time to access our website contents.
Please give us a call at 1-213-222-9590 to help you to process your order or email us support@joiaaccessory.com to schedule an appointment for us to call you to process your request.