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 '1' group by shop ) tc on find_in_set(id, tc.ids) > 0 LIMIT ' at line 3