Meta Use Question

I’m trying to create a feature on my site that uses the custom fields. Each of my entries has a “cite” custom field with the name of a media outlet in it. On a separate page, I’d like to have a listing of a certain type of custom field (that part of the sql works, see http://www.thescoop.org/meta.php) and have WP dynamically generate “archives” based on the link (again, see the page, it makes more sense there). The SQL I have now does a nice group by query and generates the links, but I’m not sure what to do to enable WP to actually fetch the corresponding posts that I want to appear when you click on a link. Any advice would be appreciated.
Derek