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 LIKE "П' 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 "ÐÑвагандÑа в поÑоÑке, 100 г. / 200 г.%" or w.name_ru LIKE "СÑÑÑма в каÑандаÑе Ðаджал%" or w.name_ru LIKE "ÐÑÐ±Ð½Ð°Ñ Ð¿Ð°ÑÑа Himalaya, 100 г.%" or w.name_ru LIKE "ÐлоÑÑом Ð³ÐµÐ»Ñ Ð´Ð»Ñ Ð¶ÐµÐ½Ñкой гÑÑди%" or w.name_ru LIKE "ÐиÑаÑелÑнÑй балÑзам Ð´Ð»Ñ ÑÑÑой и поÑÑеÑкавÑейÑÑ ÐºÐ¾Ð¶Ð¸ «СоÑÑ», 20 г.%" 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 ""ÐÐÐÐ ÐУÐ" аÑомаÑиÑеÑкие палоÑки%" or w.name_ru LIKE "ÐаÑло ÑÑиÑное «ÐÑÑа», 10 мл.%" or w.name_ru LIKE "Yogi Tea «Pure»%" or w.name_ru LIKE "ÐиомаÑка «ÐокÑÑг глаз», ФоÑмÑла 2, 50 г.%") and w.productID != 2053 and w.enabled = 1 ORDER BY RAND()