Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like' SQL query : select made from SS_products where ( ( 
   LOWER(name) LIKE '%столешница%' OR LOWER(name) LIKE '%столешница%' OR LOWER(name) LIKE '%столешница%' OR LOWER(name) LIKE '%столешница%' OR LOWER(name) LIKE '%столешница%' OR LOWER(name) LIKE '%столешница%' OR LOWER(name) LIKE '%столешница%'
OR LOWER(name_ukr) LIKE '%столешница%'  OR LOWER(name_ukr) LIKE '%столешница%' OR LOWER(name_ukr) LIKE '%столешница%' OR LOWER(name_ukr) LIKE '%столешница%' OR LOWER(name_ukr) LIKE '%столешница%' OR LOWER(name_ukr) LIKE '%столешница%' OR LOWER(name_ukr) LIKE '%столешница%'
OR LOWER(productID) LIKE 'столешница' 
OR LOWER(product_code) LIKE 'столешница' 
OR LOWER(made) LIKE '%столешница%' OR LOWER(made) LIKE '%столешница%' OR LOWER(made) LIKE '%столешница%' OR LOWER(made) LIKE '%столешница%' OR LOWER(made) LIKE '%столешница%' OR LOWER(made) LIKE '%столешница%' OR LOWER(made) LIKE '%столешница%'
OR LOWER(mtype) LIKE '%столешница%'  OR LOWER(mtype) LIKE '%столешница%' OR LOWER(mtype) LIKE '%столешница%' OR LOWER(mtype) LIKE '%столешница%' OR LOWER(mtype) LIKE '%столешница%' OR LOWER(mtype) LIKE '%столешница%' OR LOWER(mtype) LIKE '%столешница%'
OR LOWER(ptype) LIKE '%столешница%' OR LOWER(ptype) LIKE '%столешница%' OR LOWER(ptype) LIKE '%столешница%' OR LOWER(ptype) LIKE '%столешница%' OR LOWER(ptype) LIKE '%столешница%' OR LOWER(ptype) LIKE '%столешница%' OR LOWER(ptype) LIKE '%столешница%'
				) ) AND  store !="Знято"  AND store!="Нема"  GROUP BY made