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 P.`id` ORDER BY FIELD( P.`id`, ), (P.`pic` <> 0) DESC, P.`' at line 5
SELECT P.`id`, P.`title`, P.`name`, P.`price_min`, P.`price_max`, P.`address`, P.`pic`, P.`geox`, P.`geoy`, PA.`show` AS menu FROM `gurman__place` AS P LEFT JOIN `gurman__place_access` AS PA ON (P.id = PA.place AND PA.name = 'menu' AND PA.show = 1) INNER JOIN `gurman__relation_top` AS RTP ON ( P.`id` = RTP.`place` ) WHERE P.`id` IN() GROUP BY P.`id` ORDER BY FIELD( P.`id`, ), (P.`pic` <> 0) DESC, P.`title` ASC LIMIT 10