Collation error when re-queueing scraped items

Need to fix table so it uses same collation as database – should be by default but something going wrong with customers site.

[26-Mar-2019 14:54:11 UTC] WordPress database error Illegal mix of collations (utf8mb4_unicode_520_ci,IMPLICIT) and (utf8mb4_unicode_ci,IMPLICIT) for operation ‘=’ for query insert into wp_pcpro_scrape_queue (scrapeurl, productid, domain)
select meta_value, post_id, SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(SUBSTRING_INDEX(meta_value, ‘/’, 3), ‘://’, -1), ‘/’, 1), ‘?’, 1) AS domain
from wp_postmeta pm1 where meta_key like ‘producturl%’
and not exists (select * from wp_pcpro_urls u where imageslastscraped > DATE_SUB(NOW(), INTERVAL 30 DAY) and u.url = meta_value)
and meta_value like ‘’ made by do_action(‘wp_ajax_pcpro_addeverythingtoqueue’), WP_Hook->do_action, WP_Hook->apply_filters, call_user_func_array, pcpro_addeverythingtoqueue