Load all submissions in one query for efficience. Use sub instead of replace so not replacing #1234 with #123 links. Catch short codes on end and start of line.