System Error

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

Number : -2147467259

Page : /Scripts/prodList.asp

Desc : Query is too complex.

SQL : SELECT a.idProduct,a.SKU,a.description, a.descriptionLong,a.listPrice,a.Price, a.SmallImageUrl,a.Stock,a.fileName, a.noShipCharge, a.handlingFee FROM products a WHERE a.active = -1 AND ((a.details LIKE '%arlene''s%' OR a.details LIKE '%paper%' OR a.details LIKE '%dolls,%' OR a.details LIKE '%arlenes%' OR a.details LIKE '%vintage%' OR a.details LIKE '%paper%' OR a.details LIKE '%dolls,%' OR a.details LIKE '%arlene''s%' OR a.details LIKE '%vintage%' OR a.details LIKE '%paper%' OR a.details LIKE '%dolls,%' OR a.details LIKE '%uncut%' OR a.details LIKE '%paperdolls,%' OR a.details LIKE '%celebrity%' OR a.details LIKE '%paper%' OR a.details LIKE '%dolls,%' OR a.details LIKE '%mint%' OR a.details LIKE '%paper%' OR a.details LIKE '%doll,%' OR a.details LIKE '%movie%' OR a.details LIKE '%star%' OR a.details LIKE '%paper%' OR a.details LIKE '%dolls,%' OR a.details LIKE '%nuts4paperdolls,%' OR a.details LIKE '%vintage%' OR a.details LIKE '%paper%' OR a.details LIKE '%dolls,%' OR a.details LIKE '%cut%' OR a.details LIKE '%out%' OR a.details LIKE '%dolls,cut-outs,%' OR a.details LIKE '%cutouts,%' OR a.details LIKE '%cut%' OR a.details LIKE '%paper%' OR a.details LIKE '%doll,%') OR (a.description LIKE '%arlene''s%' OR a.description LIKE '%paper%' OR a.description LIKE '%dolls,%' OR a.description LIKE '%arlenes%' OR a.description LIKE '%vintage%' OR a.description LIKE '%paper%' OR a.description LIKE '%dolls,%' OR a.description LIKE '%arlene''s%' OR a.description LIKE '%vintage%' OR a.description LIKE '%paper%' OR a.description LIKE '%dolls,%' OR a.description LIKE '%uncut%' OR a.description LIKE '%paperdolls,%' OR a.description LIKE '%celebrity%' OR a.description LIKE '%paper%' OR a.description LIKE '%dolls,%' OR a.description LIKE '%mint%' OR a.description LIKE '%paper%' OR a.description LIKE '%doll,%' OR a.description LIKE '%movie%' OR a.description LIKE '%star%' OR a.description LIKE '%paper%' OR a.description LIKE '%dolls,%' OR a.description LIKE '%nuts4paperdolls,%' OR a.description LIKE '%vintage%' OR a.description LIKE '%paper%' OR a.description LIKE '%dolls,%' OR a.description LIKE '%cut%' OR a.description LIKE '%out%' OR a.description LIKE '%dolls,cut-outs,%' OR a.description LIKE '%cutouts,%' OR a.description LIKE '%cut%' OR a.description LIKE '%paper%' OR a.description LIKE '%doll,%') OR (a.descriptionLong LIKE '%arlene''s%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%dolls,%' OR a.descriptionLong LIKE '%arlenes%' OR a.descriptionLong LIKE '%vintage%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%dolls,%' OR a.descriptionLong LIKE '%arlene''s%' OR a.descriptionLong LIKE '%vintage%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%dolls,%' OR a.descriptionLong LIKE '%uncut%' OR a.descriptionLong LIKE '%paperdolls,%' OR a.descriptionLong LIKE '%celebrity%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%dolls,%' OR a.descriptionLong LIKE '%mint%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%doll,%' OR a.descriptionLong LIKE '%movie%' OR a.descriptionLong LIKE '%star%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%dolls,%' OR a.descriptionLong LIKE '%nuts4paperdolls,%' OR a.descriptionLong LIKE '%vintage%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%dolls,%' OR a.descriptionLong LIKE '%cut%' OR a.descriptionLong LIKE '%out%' OR a.descriptionLong LIKE '%dolls,cut-outs,%' OR a.descriptionLong LIKE '%cutouts,%' OR a.descriptionLong LIKE '%cut%' OR a.descriptionLong LIKE '%paper%' OR a.descriptionLong LIKE '%doll,%') OR (a.SKU LIKE '%arlene''s%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%dolls,%' OR a.SKU LIKE '%arlenes%' OR a.SKU LIKE '%vintage%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%dolls,%' OR a.SKU LIKE '%arlene''s%' OR a.SKU LIKE '%vintage%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%dolls,%' OR a.SKU LIKE '%uncut%' OR a.SKU LIKE '%paperdolls,%' OR a.SKU LIKE '%celebrity%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%dolls,%' OR a.SKU LIKE '%mint%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%doll,%' OR a.SKU LIKE '%movie%' OR a.SKU LIKE '%star%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%dolls,%' OR a.SKU LIKE '%nuts4paperdolls,%' OR a.SKU LIKE '%vintage%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%dolls,%' OR a.SKU LIKE '%cut%' OR a.SKU LIKE '%out%' OR a.SKU LIKE '%dolls,cut-outs,%' OR a.SKU LIKE '%cutouts,%' OR a.SKU LIKE '%cut%' OR a.SKU LIKE '%paper%' OR a.SKU LIKE '%doll,%')) ORDER BY a.sku