Error getting search results

Error 424: Object required
SQL: SELECT sfProducts.prodID, sfProducts.prodName, sfProducts.prodImageSmallPath, sfProducts.prodLink, sfProducts.prodPrice, sfProducts.prodSaleIsActive, sfProducts.prodSalePrice, sfProducts.prodDescription, sfProducts.prodAttrNum, sfProducts.prodCategoryId, sfProducts.prodShortDescription, sfProducts.prodPLPrice, sfProducts.prodPLSalePrice, sfVendors.vendName, sfManufacturers.mfgName FROM sfVendors RIGHT JOIN (sfManufacturers RIGHT JOIN sfProducts ON sfManufacturers.mfgID = sfProducts.prodManufacturerId) ON sfVendors.vendID = sfProducts.prodVendorId WHERE (sfProducts.prodEnabledIsActive=1) AND (sfProducts.prodEnabledIsActive=0)