An error occurred executing the following query, and page execution has been terminated.

SELECT DISTINCT P_ID, CAT_ID, CAT_Name1, P_OrderVersionsBy, P_StrapLine1, cast(P_Desc1 as nvarchar(4000)) as P_Desc1, P_Name1, P_VersionDisplayType, P_Popular, P_Type FROM ((((tblCactuShop1Versions INNER JOIN tblCactuShop1Products ON tblCactuShop1Versions.V_ProductID = tblCactuShop1Products.P_ID) INNER JOIN tblCactuShop1ProductCategoryLink ON tblCactuShop1Products.P_ID = tblCactuShop1ProductCategoryLink.PCAT_ProductID) INNER JOIN tblCactuShop1Categories ON tblCactuShop1ProductCategoryLink.PCAT_CategoryID = tblCactuShop1Categories.CAT_ID) INNER JOIN tblCactuShop1TaxRates ON tblCactuShop1Versions.V_Tax = tblCactuShop1TaxRates.T_ID) LEFT OUTER JOIN tblCactuShop1Suppliers ON tblCactuShop1Products.P_SupplierID = tblCactuShop1Suppliers.SUP_ID WHERE P_Name1 <> '' AND V_Live ='y' AND P_Live = 'y' AND CAT_Live = 'y' AND V_CustomerGroupID IN (0,) AND P_CustomerGroupID IN (0,) AND CAT_CustomerGroupID IN (0,) AND P_Popular>0 AND (SUP_Live <> 'n' OR SUP_Live IS NULL) ORDER BY P_Popular, P_ID DESC

Error Description : Line 1: Incorrect syntax near ')'.

Page of error : /customer_modifycode.asp

Query String :

strCallMode=new&