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

SELECT sp.sp_id,sp.sp_title ,isnull((select top 1 midtown_pr_id from product where sp_id=sp.sp_id and pr_pub=1 and pr_active=1 and pre_order=0 order by pr_reldate desc ),0) FROM SUBSCRIPTION_PRODUCT sp WHERE SP_ID IN ( )

C:\INETPUB\WWWROOT\MARVELSUBS\STORE\../mb/mb_combo.asp, line 29