System Error

Module : scripts/_INCappDBConn_.asp : openRSopen(dbSource,dbCursorLoc,dbCursorType,dbLockType,dbOptions,dbCache)

Number : -2147217900

Page : /prodlist.asp

Desc : Incorrect syntax near the keyword 'FROM'.

SQL : SELECT distinct a.idproduct,a.idType,a.idParentProduct,a.SKU,a.Description,a.filter,a.dimensions,max(c.idCategory), a.DescriptionLong,a.ListPrice,a.wholesaleprice,a.P2, a.Price,a.ImageUrl,a.Stock,a.discount,a.homepage, a.fileName,a.noShipCharge,a.handlingfee, a.minorder, a.iduom, easternaccents,demedici,niche,s773,essentials,marquise,leylas,fortywinks,barclaybutera, thomasville,scalamandre,thomfilicia,celerie,alexa,c.quickship,qp.quickship,a.quickship, case when c.isnew IS NULL or c.isnew = '' then '2' else '1' end as newcol, FROM CP_products a, CP_categories_products cp, CP_categories c, CP_qpicks qp WHERE c.categoryFeatured = 'Y' and cp.idproduct=a.idproduct and c.idcategory=cp.idcategory and a.idType=q.idPick and a.idParentProduct is Null AND easternaccents=1 AND c.idcategory = 63 AND a.idType not in(168,280,281,282,283,284,285,286,287,730,288,367,368,377,578) AND a.active = -1 AND a.filter like '%,green,%' AND a.filter like '%,prints,%' ORDER BY newcol,a.idType,sku