SQLSTATE[HY000]: General error: 1267 Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,COERCIBLE) for operation 'like'<br>SELECT count(*) FROM (SELECT DISTINCT n.*, etn.entry_id, (SELECT GROUP_CONCAT(meta_data_id ORDER BY mte.sort_order ASC) as meta_data_ids FROM meta_data_to_entry mte WHERE mte.entry_id = e.id) as meta_data_ids, etn.sort_order FROM newsletter n 
                LEFT JOIN entry_to_newsletter etn ON etn.newsletter_id = n.id 
                LEFT JOIN entry e ON e.id = etn.entry_id 
				LEFT JOIN content_to_entry cnte ON cnte.entry_id = e.id 
                LEFT JOIN content cn ON cn.id = cnte.content_id
                LEFT JOIN contributor_to_content ctc ON ctc.content_id = cn.id 
                LEFT JOIN contributor c ON c.id = ctc.contributor_id   
				LEFT JOIN meta_data_to_entry mdte ON mdte.entry_id = e.id  
                LEFT JOIN contributor_to_entry cte ON cte.entry_id = e.id        
                LEFT JOIN contributor c2 ON c2.id = cte.contributor_id                  
                WHERE n.status = 1 AND e.published AND NOT e.private AND                 
                (n.title LIKE CONCAT('%', :search, '%') OR 
                 e.title LIKE CONCAT('%', :search, '%') OR
                 e.summary LIKE CONCAT('%', :search, '%') OR
                 cn.content_text LIKE CONCAT('%', :search, '%') OR 
                 c.first_name LIKE CONCAT('%', :search, '%') OR 
                 c.last_name LIKE CONCAT('%', :search, '%') OR 
                 c2.first_name LIKE CONCAT('%', :search, '%') OR 
                 c2.last_name LIKE CONCAT('%', :search, '%'))
                
                
                
                ORDER BY n.pubDate DESC, etn.sort_order) as r<br>