
<p>
<a name="36"></a></p>


<script language="javascript" src="/images/include_commonElements/css.js"></script>
<hr><font color=red>Error -2147217871: [Microsoft][ODBC SQL Server Driver]Timeout expired</font><BR>SQL: SELECT sfProducts.prodID, sfProducts.prodName, sfProducts.prodImageSmallPath, sfProducts.prodLink, sfProducts.prodPrice,  sfProducts.prodSaleIsActive, sfProducts.prodSalePrice, isNull(sfSub_Categories.CatHierarchy,''), sfProducts.prodDescription,  sfProducts.prodAttrNum, sfProducts.prodCategoryId, sfProducts.prodShortDescription, sfProducts.prodPLPrice,sfProducts.prodPLSalePrice , subcatDescription As catDescription,  subcatImage As catImage, sfVendors.vendName, sfManufacturers.mfgName, isnull(sfinventory.invenInStock,0) as InStock,  isnull(sfinventory.invenReorderLevel,0) as Reorder, isnull(sfProducts.prodAllowBackOrder,0) as allowBackorder, isnull(sfinventoryinfo.invenbtracked,0) as invenbtracked ,  sfinventoryinfo.invenbStatus, sfproducts.prodweight, sfproducts.prodlength, sfproducts.prodwidth, sfproducts.prodheight,  sfProducts.prodMessage, count(PartNumber), prodsaleType, prodDateAdded, subcatname, sfProducts.prodType,  isnull(invenOnOrder,0) as invenOnOrder, isnull(invenStockAge,0) as  invenStockAge FROM((((sfVendors RIGHT JOIN (sfManufacturers RIGHT JOIN (((sfProducts left JOIN sfSubCatDetail ON sfProducts.prodID = sfSubCatDetail.ProdID) left join ymmproducts on sfProducts.prodID=ymmproducts.PartNumber) left JOIN sfSub_Categories ON sfSubCatDetail.subcatCategoryId = sfSub_Categories.subcatID) ON sfManufacturers.mfgID = sfProducts.prodManufacturerId) ON sfVendors.vendID = sfProducts.prodVendorId) LEFT JOIN sfAttributes ON sfProducts.prodID = sfAttributes.attrProdId)  LEFT JOIN sfinventory ON sfProducts.prodID = sfinventory.invenProdId) LEFT JOIN sfinventoryinfo ON sfProducts.prodID = sfinventoryinfo.invenProdId) LEFT JOIN  sfAttributeDetail ON sfAttributes.attrID = sfAttributeDetail.attrdtAttributeId WHERE   sfProducts.prodManufacturerId > 0 AND sfProducts.prodVendorId > 0 AND ((sfProducts.prodSaleIsActive = 1 And ProdSaleType = 1) or  invenstockAge > 0)  AND sfProducts.prodEnabledIsActive = 1  and lower(sfManufacturers.mfgName) not in ('Flowmaster','K&N','Eibach','Cherry Bomb','WBI','Maremont','Cragar','Jones','Bassani','Borla','KYBTokico','UBP','Hawk','Autospecialty','Red Deer','Power Slot','AXXIS','Thunderbolt','Arvin Supreme','GEN','Vibrant','IMCO','Denso','UPS','Quadzilla','Powert Stop','USA','Ultrafit','Goodridge','Eastern','Power Stop')  GROUP BY  sfProducts.prodType,sfProducts.prodID, sfProducts.prodName,subcatname, sfProducts.prodNamePlural, sfProducts.prodImageSmallPath, sfProducts.prodLink, sfProducts.prodPrice, prodPLPrice, prodPLSalePrice, sfProducts.prodSaleIsActive, sfProducts.prodSalePrice, sfSub_Categories.CatHierarchy, sfProducts.prodDescription, sfProducts.prodAttrNum, sfProducts.prodCategoryId, sfProducts.prodShortDescription, sfVendors.vendName, sfManufacturers.mfgName, subcatDescription,subcatImage,sfinventory.invenInStock,sfinventory.invenReorderLevel,sfProducts.prodAllowBackOrder,sfinventoryinfo.invenbtracked,sfinventoryinfo.invenbStatus,sfproducts.prodweight,sfproducts.prodlength,sfproducts.prodwidth,sfproducts.prodheight,sfProducts.prodMessage,PartNumber,prodsaleType,prodDateAdded,invenOnOrder, invenStockAge order by sfinventory.invenInStock DESC<BR><hr> <font face="Arial" size=2>
<p>ADODB.Recordset</font> <font face="Arial" size=2>error '800a0e78'</font>
<p>
<font face="Arial" size=2>Operation is not allowed when the object is closed.</font>
<p>
<font face="Arial" size=2>/salespage.asp</font><font face="Arial" size=2>, line 132</font>