Для поиска товара укажите его наименование или артикул:
Товары
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 tovar.manufacture_id ORDER BY manufacture.header' at line 1