How to get SELECT results into Placeholders?

I want to get the id and pagetitle from the modx_site_content table based on a SELECT -- like this:

And I want to display the result with placeholders -- like this:

I’ve never created a TV but when I put the SELECT above into the default value of a TV, it seems to work. Only how the heck do I get the plain text result into a placeholder? If someone would take a moment to explain, I and all non-programmers reading these forums in the future would be very grateful. Thanks.

Why not just use the built-in document object:

Quote from: rthrash at Sep 26, 2006, 09:55 AM

Why not just use the built-in document object:

<a href="[~[*id*]~]" title="[*pagetitle*]">[*pagetitle*]</a>

Yes, but WHERE do you add this placeholder text? How do you get the results to display using the placeholder?