Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation '=' SQL=SELECT DISTINCT cfp.customfield_value AS id,cfp.customfield_value AS name FROM #__virtuemart_product_customfields AS cfp INNER JOIN `#__virtuemart_products` AS p ON cfp.virtuemart_product_id = p.`virtuemart_product_id` INNER JOIN #__virtuemart_product_categories ON p.product_parent_id=#__virtuemart_product_categories.virtuemart_product_id INNER JOIN #__virtuemart_product_customfields AS custom_f_82 ON custom_f_82.virtuemart_product_id=p.virtuemart_product_id WHERE p.published=1 AND (cfp.customfield_value IS NOT NULL AND cfp.customfield_value !='') AND #__virtuemart_product_categories.virtuemart_category_id IN (13) AND ((custom_f_82.customfield_value ='Nike\n') AND custom_f_82.virtuemart_custom_id=82) AND cfp.virtuemart_custom_id=74 GROUP BY cfp.customfield_value ORDER BY `name` ASC