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_' 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 "ÐÑÑведиÑеÑкое мÑло «18 леÑебнÑÑ ÑÑав»%" or w.name_ru LIKE "«ÐбÑолÑÑÐ½Ð°Ñ ÐºÑаÑоÑа», РайÑÑÑ Ð.%" or w.name_ru LIKE ""ÐÐÐÐСТÐРРÐÐ" аÑомаÑиÑеÑкие палоÑки%" or w.name_ru LIKE ""ТУÐСÐ" аÑомаÑиÑеÑкие палоÑки%" or w.name_ru LIKE ""ÐÐÐР ÐУÐ" аÑомаÑиÑеÑкие палоÑки%" or w.name_ru LIKE "«ÐÑÑведа на каждÑй денÑ. СекÑеÑÑ Ð²ÐµÐ»Ð¸ÐºÐ¾Ð³Ð¾ иÑкÑÑÑÑва жизни», ÐеаполиÑанÑкий С.%" or w.name_ru LIKE "ЧÑÑки Ð´Ð»Ñ Ð¼ÐµÐ´Ð¸ÑаÑии из ÑÑдÑакÑи, 6 мм.%" or w.name_ru LIKE "«ÐÐ¸Ñ Ð²Ð¾ÑÑоÑнÑÑ Ð±Ð»Ð°Ð³Ð¾Ð²Ð¾Ð½Ð¸Ð¹. ÐÑе, ÑÑо нÑжно знаÑÑ Ð¾ благовониÑÑ»%" or w.name_ru LIKE "ЧеÑки "Khara" из Ñозового деÑева%") and w.productID != 1139 and w.enabled = 1 ORDER BY RAND()