SET @domain_id = (SELECT id FROM stop_domain LIMIT 1);
SELECT
  IFNULL(MAX(duid), 0) + 1 AS duid
  , @domain_id
FROM
  stop_link
WHERE domain_id = @domain_id;

id | url

id | duid | domain_id