INSERT IGNORE INTO opportunity_channels (opportunity_id,channel,remote_id,origin_url,payload)
SELECT opportunity_id,'BB via PNCP',external_id,
LEFT(JSON_UNQUOTE(JSON_EXTRACT(payload,'$.linkSistemaOrigem')),500),
JSON_OBJECT('linkSistemaOrigem',JSON_UNQUOTE(JSON_EXTRACT(payload,'$.linkSistemaOrigem')))
FROM opportunity_sources
WHERE JSON_UNQUOTE(JSON_EXTRACT(payload,'$.linkSistemaOrigem')) REGEXP '^https://licitacoes-e[a-z0-9.-]*[.]bb[.]com[.]br(/|$)'
OR JSON_UNQUOTE(JSON_EXTRACT(payload,'$.linkSistemaOrigem')) REGEXP '^https://([a-z0-9-]+[.])*licitacoes-e[.]com[.]br(/|$)';