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 '), 1, 0 ) DESC, IF( `products`.`iProducer` IN( ), 1, 0 ) DESC, ' at line 2
SELECT SQL_CALC_FOUND_ROWS `products`.*, `products`.`TiAvailable` AS `iAvailable`, `products`.`fPrice` AS `fCatalogPrice`, `vat`.`fVatValue`, LEAST( ss11_pl_calculateProductPriceForUser( NULL, `products`.`iProduct`, 0 ), `products`.`fPrice` ) AS `fPrice`, `products`.`TiCanBuy` AS `iCanBuy`, `products`.`TiVariantsCount` AS `iVariantCount`, 1 AS `iVisiblePrice`, `producers`.`sName` AS `prodsName`, `producers`.`sLogoUrl` AS `prodsLogoUrl`, `prodgroups`.`sName` AS `prodsGroupName`, `prodgroups`.`sLogoUrl` AS `prodsGroupLogoUrl`, `producers`.`sType` AS `sProducersClass`, ( SELECT `iPromoted` FROM `ss11_pl_products_promoted` `promoted` WHERE `promoted`.`iProduct` = `products`.`iProduct` ORDER BY `iPromoted` ASC LIMIT 1 ) `iPromotedMin`, `ai`.*, `ai`.`iVal7` `iSezon`, `rating`.`fRatingAvg`, `rating`.`iCommentsCount` FROM `ss11_pl_products` AS `products` INNER JOIN `ss11_vat` AS `vat` USING( `iVat` ) LEFT JOIN `opony_sklep`.`ss11_pl_products_attributes_flat` AS `ai` ON( `ai`.`iProduct` = `products`.`iProduct` ) LEFT JOIN `ss11_pl_producers` AS `producers` USING( `iProducer` ) LEFT JOIN `ss11_pl_producers` AS `prodgroups` ON( prodgroups.`iProducer` = `producers`.`iProducersGroup` ) LEFT JOIN `rating` ON( `rating`.`iProducer` = `products`.`iProducer` AND `rating`.`iModel` = `iVal18` ) WHERE `products`.`iProduct` IN ( 104605,104614,104603,104615,104618,104621,104627,104632,104661,104658,104638,104643,104672,104666,104673,104689,104676,104678,104733,104683,104723,104737,158404,158405,104787,104754,104748,104767,160301,160302 ) ORDER BY IF( `products`.`sName` LIKE 'RXMOTION 4S%', 2, IF( `products`.`sName` LIKE '%RXMOTION 4S%', 1, 0 ) ) DESC, IF( `products`.`TiStock` >= 1, 2, IF( `products`.`TiCanBuy`, 1, 0 ) ) DESC, IF( `products`.`iProducer` IN( ), 1, 0 ) DESC, IF( `products`.`iProducer` IN( ), 1, 0 ) DESC, `products`.`fPrice` ASC, `products`.`sName` ASC, `products`.`iTime` ASC