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 ') GROUP BY `dp`.`iDescPhoto` ORDER BY 0' at line 8
SELECT MIN( `p`.`fPrice` ) `fMinPrice`, `pr`.`sName`, `paf`.`sVal18`, `paf`.`iVal7`, `dp`.`sFileName`, COUNT( DISTINCT `c`.`iComment` ) `iCommentQuantity`, AVG( `c`.`iRating` ) `fAvgRating`, `pr`.`iProducer` FROM `ss11_pl_desc_photo` `dp` INNER JOIN `ss11_pl_desc_photo_attribute` `dpa` USING( `iDescPhoto` ) INNER JOIN `opony_sklep`.`ss11_pl_products_attributes_flat` `paf` ON( `dpa`.`iAttributeValue` = `paf`.`iVal18` ) INNER JOIN `ss11_pl_producers` `pr` ON( `pr`.`iProducer` = `dp`.`iProducer` ) INNER JOIN `ss11_pl_products` `p` ON( `p`.`iProduct` = `paf`.`iProduct` AND `p`.`iProducer` = `pr`.`iProducer` AND `p`.`TiStock` >= 4 ) LEFT JOIN `ss11_pl_products_comments` `c` ON( `paf`.`iVal18` = `c`.`iModel` AND `pr`.`iProducer` = `c`.`iProducer` AND `c`.`iStatus` >= 1 ) WHERE `dp`.`iDescPhoto` IN( ) GROUP BY `dp`.`iDescPhoto` ORDER BY 0