WordPress adatbázis hiba: [Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation '=']SELECT r.*, COALESCE(tl0.text, t0.text) AS lang_text
FROM wp8p_grp_google_review r
JOIN wp8p_grp_google_place p ON p.id = r.google_place_id
LEFT JOIN wp8p_grp_google_review_text tl0 ON tl0.review_id = r.review_id AND tl0.lang IN ('hu')
LEFT JOIN wp8p_grp_google_review_text t0
ON t0.review_id = r.review_id AND t0.lang = r.language
WHERE r.google_place_id IN (1) AND r.hide = ''
AND r.author_url IS NOT NULL
AND (1 = 1 OR tl0.text IS NOT NULL OR r.language IN ('hu') OR r.language IS NULL OR r.language = '')
AND NOT EXISTS (
SELECT 1 FROM wp8p_grp_google_review r2
WHERE r2.google_place_id = r.google_place_id AND r2.author_url = r.author_url
AND (r2.time > r.time OR (r2.time = r.time AND r2.id > r.id))
)
ORDER BY r.time DESC, r.id DESC
