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 'oréal' IN BOOLEAN MODE) and  act='1' 
      group by shop
     ) tc
     on fin' at line 3