Hi, Guest !

 for example: Batman #1, X-Men, Frank Miller, Action Comics, Spider-Man
Submit button
Home >  Search
Search Search Results for: Batwoman #15
Top Selling Series Results
Select to filter by Issue #

Search Summary
Batwoman #15
Narrow Your Search
By Category : 

By Date : 

By Price : 

Limit Search To 
Release Status
Advance Order
Released

Microsoft OLE DB Provider for SQL Server error '80040e14'

SELECT * FROM ( SELECT ROW_NUMBER() OVER (ORDER BY PR.PR_STITLE ASC,PR.PR_SERIES ASC,PR.PR_TTLE ASC ) AS ROWNUM, COUNT(PRODUCT.PR_ID)OVER() AS TOTALRECORDS, ISNULL(PR.PR_RELDT,'') AS PR_RELDT, PRODUCT.PR_ID,PR.PR_SIMG,PR.PR_BIMG,PR.PR_PARENTID,PR.PR_REGISTER, PR.PR_IS_BACKISSUE,PRODUCT.PR_QTY,PR.PR_ADVORD,PR.CG_ID, CASE WHEN (PR.PR_CLEAR=1) THEN PRODUCT.PR_TTLE + ' <font color="#FF0000" style="font-weight:BOLD">(CLEARANCE)</FONT>' ELSE PRODUCT.PR_TTLE END AS PR_TTLE,PR.PR_STITLE AS PR_STITLE,PR.SU_ID,PR.SU_ACTIVE,PR.PR_SDESC, PRODUCT.PR_PRICE,PRODUCT.PR_LPRICE, ISNULL(PR.PR_CONDITIONFLAG ,0) AS PR_CONDITIONFLAG, ISNULL ((SELECT PR.PR_PARENTID FROM CART CR WITH (NOLOCK) WHERE PR.PR_PARENTID = CR.PR_ID AND CR.SH_ID = 776508998), 0) AS CART, PR.SCG_ID,ISNULL(PR.INCENTIVE_ID,0) AS INCENTIVE_ID ,ISNULL(0,0) AS INCENTIVEUSAGE_ID,PR.PR_SERIES --,(CASE WHEN(ISNULL(VW_RATING.TOTALRATING,0)=0 AND ISNULL(VW_RATING.RATING,0)=0) THEN 0 ELSE ROUND(VW_RATING.RATING/VW_RATING.TOTALRATING,0) END) AS AVGRATING ,(0) AS AVGRATING ,ISNULL((SELECT SU_ID FROM SUBSCRIP_DETAILS WITH (NOLOCK) WHERE SUBSCRIP_DETAILS.SH_ID=776508998 AND SUBSCRIP_DETAILS.SU_ID=PR.SU_ID ),0) AS ISSUBSCRIBE ,PR.PR_CLEAR, ISNULL((SELECT TOP 1 WISHLIST.PR_PARENTID FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PR.PR_PARENTID),0) AS ADDEDTOWL ,ISNULL((SELECT TOP 1 WISHLIST.QTY FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PR.PR_PARENTID),0) AS ADDEDQTYTOWL ,PRODUCT.DISPLAY_LPRICE /*,ISNULL(( SELECT PRGRADES.PR_ID,BI_CONDITION.Name AS CONDITION, BI_CONDITION.ConditionID, PRGRADES.PR_QTY, ISNULL(PRGRADES.PR_ACTIVE,'0') AS PR_ACTIVE,PRGRADES.SU_ID, PRGRADES.SU_ACTIVE ,PRGRADES.CG_ID,PRGRADES.PR_PRICE,PRGRADES.PR_LPRICE,PRGRADES.PR_ADVORD, ISNULL ((SELECT PRGRADES.PR_ID FROM CART CR WITH (NOLOCK) WHERE PRGRADES.PR_ID = CR.PR_ID AND CR.SH_ID = 776508998), 0) AS CART ,ISNULL((SELECT TOP 1 WISHLIST.PR_PARENTID FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDTOWL ,ISNULL((SELECT TOP 1 WISHLIST.QTY FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDQTYTOWL ,PRGRADES.DISPLAY_LPRICE FROM PRODUCT PRGRADES WITH (NOLOCK) INNER JOIN BI_CONDITION WITH (NOLOCK) ON PRGRADES.PR_CONDITIONFLAG = BI_CONDITION.ConditionID WHERE (PRGRADES.PR_PARENTID = PR.PR_PARENTID) AND PR.PR_PUB=1 AND PRGRADES.PR_QTY>0 ORDER BY BI_CONDITION.SORTORDER ASC FOR XML PATH('PRGRADES'),ROOT('PRODUCTS') ),0) AS GRADES*/ ,(CASE PR.CG_ID WHEN 66 THEN ISNULL(( SELECT PRGRADES.PR_ID ,PRGRADES.PR_QTY ,isnull(PRGRADES.PR_ACTIVE,0) as pr_active ,PRGRADES.SU_ID ,PRGRADES.SU_ACTIVE ,PRGRADES.CG_ID ,PRGRADES.PR_PRICE ,PRGRADES.PR_LPRICE ,PRGRADES.PR_ADVORD ,ISNULL ((SELECT PRGRADES.PR_ID FROM CART CR WITH (NOLOCK) WHERE PRGRADES.PR_ID = CR.PR_ID AND CR.SH_ID = 776508998), 0) AS CART ,ISNULL((SELECT TOP 1 WISHLIST.PR_PARENTID FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDTOWL ,ISNULL((SELECT TOP 1 WISHLIST.QTY FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDQTYTOWL ,PRGRADES.DISPLAY_LPRICE ,PRGRADES.PR_TTLE FROM PRODUCT PRGRADES WITH (NOLOCK) WHERE (PRGRADES.PR_PARENTID = PR.PR_PARENTID) /*and PRGRADES.PR_PARENTID<>PRGRADES.PR_ID*/ AND PR.PR_PUB=1 AND PRGRADES.PR_QTY>0 order by PR_STITLE, case when rtrim(ltrim(replace(PRGRADES.pr_ttle,PRGRADES.pr_stitle,'')))='Small' then 1 when rtrim(ltrim(replace(PRGRADES.pr_ttle,PRGRADES.pr_stitle,'')))='Medium' then 2 when rtrim(ltrim(replace(PRGRADES.pr_ttle,PRGRADES.pr_stitle,'')))='Large' then 3 when rtrim(ltrim(replace(PRGRADES.pr_ttle,PRGRADES.pr_stitle,'')))='X-Large' then 4 when rtrim(ltrim(replace(PRGRADES.pr_ttle,PRGRADES.pr_stitle,'')))='XX-Large' then 5 else 0 end FOR XML PATH('PRGRADES'),ROOT('PRODUCTS') ),'') /*WHEN 142 THEN ISNULL(( SELECT PRGRADES.PR_ID,BI_CONDITION.Name AS CONDITION, BI_CONDITION.ConditionID, PRGRADES.PR_QTY, ISNULL(PRGRADES.PR_ACTIVE,'0') AS PR_ACTIVE,PRGRADES.SU_ID, PRGRADES.SU_ACTIVE ,PRGRADES.CG_ID,PRGRADES.PR_PRICE,PRGRADES.PR_LPRICE,PRGRADES.PR_ADVORD, ISNULL ((SELECT PRGRADES.PR_ID FROM CART CR WITH (NOLOCK) WHERE PRGRADES.PR_ID = CR.PR_ID AND CR.SH_ID = 776508998), 0) AS CART ,ISNULL((SELECT TOP 1 WISHLIST.PR_PARENTID FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDTOWL ,ISNULL((SELECT TOP 1 WISHLIST.QTY FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDQTYTOWL ,PRGRADES.DISPLAY_LPRICE FROM PRODUCT PRGRADES WITH (NOLOCK) INNER JOIN BI_CONDITION WITH (NOLOCK) ON PRGRADES.PR_CONDITIONFLAG = BI_CONDITION.ConditionID WHERE (PRGRADES.PR_PARENTID = PR.PR_PARENTID) AND PR.PR_PUB=1 AND PRGRADES.PR_QTY>0 ORDER BY BI_CONDITION.SORTORDER ASC FOR XML PATH('PRGRADES'),ROOT('PRODUCTS') ),'')*/ ELSE ISNULL(( SELECT PRGRADES.PR_ID,BI_CONDITION.Name AS CONDITION, BI_CONDITION.ConditionID, PRGRADES.PR_QTY, ISNULL(PRGRADES.PR_ACTIVE,'0') AS PR_ACTIVE,PRGRADES.SU_ID, PRGRADES.SU_ACTIVE ,PRGRADES.CG_ID,PRGRADES.PR_PRICE,PRGRADES.PR_LPRICE,PRGRADES.PR_ADVORD, ISNULL ((SELECT PRGRADES.PR_ID FROM CART CR WITH (NOLOCK) WHERE PRGRADES.PR_ID = CR.PR_ID AND CR.SH_ID = 776508998), 0) AS CART ,ISNULL((SELECT TOP 1 WISHLIST.PR_PARENTID FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDTOWL ,ISNULL((SELECT TOP 1 WISHLIST.QTY FROM WISHLIST WITH (NOLOCK) WHERE WISHLIST.SH_ID=776508998 AND WISHLIST.PR_PARENTID=PRGRADES.PR_PARENTID),0) AS ADDEDQTYTOWL ,PRGRADES.DISPLAY_LPRICE FROM PRODUCT PRGRADES WITH (NOLOCK) INNER JOIN BI_CONDITION WITH (NOLOCK) ON PRGRADES.PR_CONDITIONFLAG = BI_CONDITION.ConditionID WHERE (PRGRADES.PR_PARENTID = PR.PR_PARENTID) AND PR.PR_PUB=1 AND PRGRADES.PR_QTY>0 ORDER BY BI_CONDITION.SORTORDER ASC FOR XML PATH('PRGRADES'),ROOT('PRODUCTS') ),'') END ) AS GRADES FROM PRODUCTQTY PR WITH (NOLOCK) INNER JOIN PRODUCT WITH (NOLOCK) ON PR.PR_PARENTID=PRODUCT.PR_ID INNER JOIN CATEGORY WITH (NOLOCK) ON PR.CG_ID=CATEGORY.CG_ID LEFT OUTER JOIN VW_RATING WITH (NOLOCK) ON PR.PR_PARENTID=VW_RATING.PR_ID WHERE PR.PR_PUB=1 AND PR.CG_ID<>153 AND PR.PR_RELDT >= 'Dec 19 2012 12:00AM' AND PR.PR_RELDT <= 'Dec 19 2012 11:59PM' AND (( (PR.SEARCH LIKE '% Batwoman %' OR PR.SEARCH LIKE '% Batwoman' OR PR.SEARCH LIKE 'Batwoman %') AND (PR.SEARCH LIKE '% 15 %' OR PR.SEARCH LIKE '% 15' OR PR.SEARCH LIKE '15 %'))) AND PR.QTY>0 ) AS PRODUCT WHERE ROWNUM between ((1 - 1) * 25 + 1) AND (1 * 25) ORDER BY ROWNUM

C:\INETPUB\WWWROOT\MIDTOWN\STORE\../includes/list_view.asp, line 670