We know how to add a link field to a table, using:
Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link.
instead of
CONCAT('<a href="', `Card Link`, '" target="_blank">',`Title`,'</a>')
Use
CONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')
Then the column will be sortable by the displayed text.