System Error

Number : -2147467259

Page : /shop/products-list.asp

Desc : Query is too complex.

SQL : SELECT a.idProduct,a.SKU,a.description,a.hotDeal, a.descriptionLong,a.listPrice,a.Price, a.SmallImageUrl,a.Stock,a.fileName,a.itemManufacturer,a.itemModel, a.noShipCharge,a.saleType,a.ProdURL FROM products a WHERE a.active = -1 AND ((a.details LIKE '%תיקון%' OR a.details LIKE '%מכשיר%' OR a.details LIKE '%HTC%' OR a.details LIKE '%M9%' OR a.details LIKE '%תיקון%' OR a.details LIKE '%מכשיר%' OR a.details LIKE '%HTC%' OR a.details LIKE '%M8%' OR a.details LIKE '%תיקון%' OR a.details LIKE '%מכשיר%' OR a.details LIKE '%HTC%' OR a.details LIKE '%M10%' OR a.details LIKE '%תיקון%' OR a.details LIKE '%מכשיר%' OR a.details LIKE '%HTC%' OR a.details LIKE '%U11%' OR a.details LIKE '%תיקון%' OR a.details LIKE '%מכשיר%' OR a.details LIKE '%HTC%' OR a.details LIKE '%U12%' OR a.details LIKE '%תיקון%' OR a.details LIKE '%מכשיר%' OR a.details LIKE '%HTC%' OR a.details LIKE '%A9S%') OR (a.description LIKE '%תיקון%' OR a.description LIKE '%מכשיר%' OR a.description LIKE '%HTC%' OR a.description LIKE '%M9%' OR a.description LIKE '%תיקון%' OR a.description LIKE '%מכשיר%' OR a.description LIKE '%HTC%' OR a.description LIKE '%M8%' OR a.description LIKE '%תיקון%' OR a.description LIKE '%מכשיר%' OR a.description LIKE '%HTC%' OR a.description LIKE '%M10%' OR a.description LIKE '%תיקון%' OR a.description LIKE '%מכשיר%' OR a.description LIKE '%HTC%' OR a.description LIKE '%U11%' OR a.description LIKE '%תיקון%' OR a.description LIKE '%מכשיר%' OR a.description LIKE '%HTC%' OR a.description LIKE '%U12%' OR a.description LIKE '%תיקון%' OR a.description LIKE '%מכשיר%' OR a.description LIKE '%HTC%' OR a.description LIKE '%A9S%') OR (a.descriptionLong LIKE '%תיקון%' OR a.descriptionLong LIKE '%מכשיר%' OR a.descriptionLong LIKE '%HTC%' OR a.descriptionLong LIKE '%M9%' OR a.descriptionLong LIKE '%תיקון%' OR a.descriptionLong LIKE '%מכשיר%' OR a.descriptionLong LIKE '%HTC%' OR a.descriptionLong LIKE '%M8%' OR a.descriptionLong LIKE '%תיקון%' OR a.descriptionLong LIKE '%מכשיר%' OR a.descriptionLong LIKE '%HTC%' OR a.descriptionLong LIKE '%M10%' OR a.descriptionLong LIKE '%תיקון%' OR a.descriptionLong LIKE '%מכשיר%' OR a.descriptionLong LIKE '%HTC%' OR a.descriptionLong LIKE '%U11%' OR a.descriptionLong LIKE '%תיקון%' OR a.descriptionLong LIKE '%מכשיר%' OR a.descriptionLong LIKE '%HTC%' OR a.descriptionLong LIKE '%U12%' OR a.descriptionLong LIKE '%תיקון%' OR a.descriptionLong LIKE '%מכשיר%' OR a.descriptionLong LIKE '%HTC%' OR a.descriptionLong LIKE '%A9S%') OR (a.SKU LIKE '%תיקון%' OR a.SKU LIKE '%מכשיר%' OR a.SKU LIKE '%HTC%' OR a.SKU LIKE '%M9%' OR a.SKU LIKE '%תיקון%' OR a.SKU LIKE '%מכשיר%' OR a.SKU LIKE '%HTC%' OR a.SKU LIKE '%M8%' OR a.SKU LIKE '%תיקון%' OR a.SKU LIKE '%מכשיר%' OR a.SKU LIKE '%HTC%' OR a.SKU LIKE '%M10%' OR a.SKU LIKE '%תיקון%' OR a.SKU LIKE '%מכשיר%' OR a.SKU LIKE '%HTC%' OR a.SKU LIKE '%U11%' OR a.SKU LIKE '%תיקון%' OR a.SKU LIKE '%מכשיר%' OR a.SKU LIKE '%HTC%' OR a.SKU LIKE '%U12%' OR a.SKU LIKE '%תיקון%' OR a.SKU LIKE '%מכשיר%' OR a.SKU LIKE '%HTC%' OR a.SKU LIKE '%A9S%') OR (a.itemManufacturer LIKE '%תיקון%' OR a.itemManufacturer LIKE '%מכשיר%' OR a.itemManufacturer LIKE '%HTC%' OR a.itemManufacturer LIKE '%M9%' OR a.itemManufacturer LIKE '%תיקון%' OR a.itemManufacturer LIKE '%מכשיר%' OR a.itemManufacturer LIKE '%HTC%' OR a.itemManufacturer LIKE '%M8%' OR a.itemManufacturer LIKE '%תיקון%' OR a.itemManufacturer LIKE '%מכשיר%' OR a.itemManufacturer LIKE '%HTC%' OR a.itemManufacturer LIKE '%M10%' OR a.itemManufacturer LIKE '%תיקון%' OR a.itemManufacturer LIKE '%מכשיר%' OR a.itemManufacturer LIKE '%HTC%' OR a.itemManufacturer LIKE '%U11%' OR a.itemManufacturer LIKE '%תיקון%' OR a.itemManufacturer LIKE '%מכשיר%' OR a.itemManufacturer LIKE '%HTC%' OR a.itemManufacturer LIKE '%U12%' OR a.itemManufacturer LIKE '%תיקון%' OR a.itemManufacturer LIKE '%מכשיר%' OR a.itemManufacturer LIKE '%HTC%' OR a.itemManufacturer LIKE '%A9S%') OR (a.itemModel LIKE '%תיקון%' OR a.itemModel LIKE '%מכשיר%' OR a.itemModel LIKE '%HTC%' OR a.itemModel LIKE '%M9%' OR a.itemModel LIKE '%תיקון%' OR a.itemModel LIKE '%מכשיר%' OR a.itemModel LIKE '%HTC%' OR a.itemModel LIKE '%M8%' OR a.itemModel LIKE '%תיקון%' OR a.itemModel LIKE '%מכשיר%' OR a.itemModel LIKE '%HTC%' OR a.itemModel LIKE '%M10%' OR a.itemModel LIKE '%תיקון%' OR a.itemModel LIKE '%מכשיר%' OR a.itemModel LIKE '%HTC%' OR a.itemModel LIKE '%U11%' OR a.itemModel LIKE '%תיקון%' OR a.itemModel LIKE '%מכשיר%' OR a.itemModel LIKE '%HTC%' OR a.itemModel LIKE '%U12%' OR a.itemModel LIKE '%תיקון%' OR a.itemModel LIKE '%מכשיר%' OR a.itemModel LIKE '%HTC%' OR a.itemModel LIKE '%A9S%')) ORDER BY a.sortorder