Try this select:
select concat('http://www.mydomain.com/', j.path, '/editor/submission/', a.article_id) as link
from articles a
join journals j on (a.journal_id = j.journal_id)
where section_id is null;
You can use the result set to view, access and set a section to each article.
Regards,
Tarcisio Pereira.