A Database Error Occurred

Error Number: 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 ') GROUP BY `idpack` ORDER BY `c` DESC ) temp L' at line 21

SELECT SQL_CALC_FOUND_ROWS `temp`.`idpack`, `name`, `description`, `c`, `agencyname`, `idfile`, `extension` FROM ( SELECT `pack_properties`.`idpack`, `pack`.`name`, `f2`.`name` as `agencyname`, `pack`.`description`, `value`, COUNT(`pack_properties`.`idpack`) AS c FROM (`pack_properties`) JOIN `property` ON `pack_properties`.`idproperty`=`property`.`idproperty` JOIN `pack` ON `pack_properties`.`idpack`=`pack`.`idpack` LEFT JOIN `firm` f2 ON `pack`.`idagency`=`f2`.`idfirm` WHERE `pack_properties`.`idpack`!=1644 AND `property`.`show` = 1 AND ( ) GROUP BY `idpack` ORDER BY `c` DESC ) temp LEFT JOIN `file` ON `temp`.`idpack`=`file`.`idpack` WHERE `c`>0 GROUP BY `idpack` ORDER BY `c` DESC LIMIT 0, 42