SQL-Fejl: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'like'
SQL:
SELECT
cms_elements_elements.id AS id,
cms_elements_elements.parentid AS parentid,
cms_elements_elements.typeid AS typeid,
cms_elements_elements.name AS name,
cms_elements_elements.precedence AS precedence,
cms_elements_elements.isVariant AS isVariant,
cms_elements_elements.variantInfo AS variantInfo,
cms_elements_element_content.langid AS langid,
cms_elements_element_content.version AS version,
cms_elements_element_content.versionactive AS versionactive,
cms_elements_element_content.createdbyuserid AS createdbyuserid,
cms_elements_element_content.createddate AS createddate
, cms_elements_element_content.type as type,cms_elements_element_content.gallery as gallery,cms_elements_element_content.publishDate as publishDate,cms_elements_element_content.removeDate as removeDate,cms_elements_element_content.youtubeVideo as youtubeVideo,cms_elements_element_content.numberOfReads as numberOfReads,cms_elements_element_content.image as image,cms_elements_element_content.photographer as photographer,cms_elements_element_content.headline_dk as headline_dk,cms_elements_element_content.show_headline as show_headline,cms_elements_element_content.text_dk as text_dk,cms_elements_element_content.url_dk as url_dk,cms_elements_element_content.tags as tags
FROM
cms_elements_elements, cms_elements_element_content
WHERE
cms_elements_elements.id = cms_elements_element_content.id
AND
cms_elements_elements.deleted = 'false'
AND
(
cms_elements_element_content.langid = '2'
OR
cms_elements_element_content.langid = '0'
)
AND
cms_elements_element_content.versionactive = 'true'
AND ( url_dk LIKE '%2020/02/17/Selskabsmeddelelse-nr-06-2020-Gennemf��relse-af-emissionen%' AND active = 'true' ) ORDER BY cms_elements_elements.precedence ASC