core_mysql (error no: 1064) : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AS `intersection`
							
							
						)
				 ORDER BY `price` ASC LIMIT 0, 2' at line 18
SELECT SQL_CALC_FOUND_ROWS *, `price` AS `basePrice`, `promoPrice` AS `basePromoPrice`, ROUND((IF(`priceVisibility` = "1", (IF(NOW() >= `promoStart` AND NOW() <= `promoStop`, `promoPrice`, `price`)), -1)) * 1.00 *1, 2) AS `price`, DATE_FORMAT(`promoStart`, "%d-%m-%Y %H:%i") AS `promoStartF`, DATE_FORMAT(`promoStop`, "%d-%m-%Y %H:%i") AS `promoStopF`, IF(NOW() >= `promoStart` AND NOW() <= `promoStop`, 1, 0) AS `promoActive`, (SELECT `accesories` FROM `accesories` WHERE `productId` = `id`) AS `accesories`, (SELECT COUNT(`id`) FROM `comments` WHERE `productId` = `tblProducts`.`id`) AS `numberOfComments`, (SELECT `url` FROM `urls` WHERE `id` = `urlId`) AS `url` FROM `products` AS `tblProducts` WHERE (`categoryId` = "26" OR `categoryId` IN (SELECT `id` FROM `categories` WHERE `linked` = "26")) AND (`visible` = "1") AND `id` IN ( SELECT `productId` FROM ( ) AS `intersection` ) ORDER BY `price` ASC LIMIT 0, 20