Сортировать: по наименованию по цене

Результаты поиска Экзодерил крем д/наруж. прим. 1 туба 15г

2019-08-24 08:12:25 mysqli error:
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 'rpjlthbk%' and c.name like '%rhtv%' and c.name like '%l.yfhe;Ю%' and c.name lik' at line 2

Query:
select c.code, c.name, pr.article_id, c.recipe, pr.amount from catalog c, price pr where c.code=pr.code and 
c.status='1' and ((c.name like '%'rpjlthbk%' and c.name like '%rhtv%' and c.name like '%l.yfhe;Ю%' and c.name like '%ghbvЮ%' and c.name like '%1%' and c.name like '%ne,f%' and c.name like '%15u%') or (c.mnn like '%'rpjlthbk%' and c.mnn like '%rhtv%' and c.mnn like '%l.yfhe;Ю%' and c.mnn like '%ghbvЮ%' and c.mnn like '%1%' and c.mnn like '%ne,f%' and c.mnn like '%15u%') or (pr.producer like '%'rpjlthbk%' and pr.producer like '%rhtv%' and pr.producer like '%l.yfhe;Ю%' and pr.producer like '%ghbvЮ%' and pr.producer like '%1%' and pr.producer like '%ne,f%' and pr.producer like '%15u%'))  group by pr.code, pr.article_id order by c.name


File: /var/www/neonfarm.ru/data/www/neonfarm.ru/sites/neon/inc/search_result.php
Line: 24