mysql_error on line

SELECT *,, accounts.url, AS image_id , accounts.content AS accountContent FROM accounts LEFT JOIN designers ON accounts.designer_id = AND accounts.type = 0 LEFT JOIN projectteams ON accounts.projectteam_id = AND accounts.type = 1 LEFT JOIN logos ON logos.account_id = WHERE ( LIKE 'BIG Bjarke Ingels Group' OR LIKE 'BIG Bjarke Ingels Group' OR accounts.url = 'BIG Bjarke Ingels Group') AND accounts.status = 1 LIMIT 1

Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_general_ci,COERCIBLE) for operation 'like'