update
names l
set
l.link = CONCAT('https://xxx.ru/node/', l.link)
where
l.html_id is not null
and l.link not like 'https://xxx.ru/node/%'
and EXISTS (
SELECT
*
FROM
trades t
where
l.trade_id = t.id
and t.marketplace_id = 8)
LIMIT 200