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 w.name_ru LIK' at line 1
SELECT * FROM `SC_products` as w, SC_product_pictures as p where w.default_picture = p.photoID and ( w.name_ru LIKE "ШампÑÐ½Ñ Ðмла%" or w.name_ru LIKE ""ÐÐРЧÐÐÐÐ" аÑомаÑиÑеÑкие палоÑки%" or w.name_ru LIKE " "ÐÐТÐС" аÑомаÑиÑеÑкие палоÑки%" or w.name_ru LIKE "«ÐÑÑведа и Ñм: аÑÑведиÑеÑÐºÐ°Ñ Ð¿ÑиÑоÑеÑапиÑ», ФÑоÑли Ð.%" or w.name_ru LIKE "ÐаÑло ÑÑиÑное «Чайное деÑево», 10 мл.%" or w.name_ru LIKE "«ÐÑакÑиÑи. ÐаÑа аÑÑведиÑеÑÐºÐ°Ñ ÐºÐ¾Ð½ÑÑиÑÑÑиÑ», Свобода Р.%" or w.name_ru LIKE "ÐÑбной поÑоÑок «ÐиобÑÑÑи» - 2, ÑкÑеплÑÑÑий, 70 г.%" or w.name_ru LIKE "«ÐÑÑведа. ÐаÑка о здоÑовÑе», ÐÑиÑнамаÑаÑÑÑ Ð­.%") and w.productID != 1047 and w.enabled = 1 ORDER BY RAND()