Wordpress articles imported into Joomla were pointing back to their original WP links, which displayed fine, however were pointing to firearms.fortreg.com domain. This will break when the domain is pointed to the new r3 site.
introtext = replace(introtext, 'firearms.fortreg.com', 'fortreg.com/firearms')
-- test with one record
--WHERE id = 521