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