MySQL Query Error:
INSERT INTO b_posting_email (POSTING_ID, STATUS, EMAIL, SUBSCRIPTION_ID, USER_ID)
SELECT
PG.POSTING_ID, 'Y', U.EMAIL, NULL, MIN(U.ID)
FROM
b_posting_group PG
INNER JOIN b_user_group UG ON UG.GROUP_ID = PG.GROUP_ID
INNER JOIN b_user U ON U.ID = UG.USER_ID
WHERE
PG.POSTING_ID = 10423
and (UG.DATE_ACTIVE_FROM is null or UG.DATE_ACTIVE_FROM <= now())
and (UG.DATE_ACTIVE_TO is null or UG.DATE_ACTIVE_TO >= now())
and U.ACTIVE = 'Y'
and U.EMAIL not in (SELECT EMAIL FROM b_posting_email WHERE POSTING_ID = 10423)
GROUP BY PG.POSTING_ID, U.EMAIL
[Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '=']