SELECT id, MATCH(ft) AGAINST( "Aubepierre" IN BOOLEAN MODE) AS q FROM (
SELECT
  i.id, CAST( CONCAT_WS(" ",
    IFNULL(i.name,""),
    IFNULL(i.comment,""),
    IFNULL(GROUP_CONCAT(DISTINCT co.content),""),
    IFNULL(GROUP_CONCAT(DISTINCT c.dir),""),
    IFNULL(GROUP_CONCAT(DISTINCT c.name),""),
    IFNULL(GROUP_CONCAT(DISTINCT c.comment),"") ) AS CHAR) AS ft
FROM (
  (
    pwg_images i LEFT JOIN pwg_comments co on i.id=co.image_id
  )
    INNER JOIN
  pwg_image_category ic on ic.image_id=i.id
  )
    INNER JOIN
  pwg_categories c on c.id=ic.category_id
WHERE (category_id NOT IN (235))
GROUP BY i.id) AS Y
WHERE MATCH(ft) AGAINST( "Aubepierre" IN BOOLEAN MODE)
[mysql error 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 'SELECT
  i.id, CAST( CONCAT_WS(" ",
    IFNULL(i.name,""),