Using SQL to output link to a node Does anyone know - using SQL only - how to output the link to a drupal node?

If I was using PHP I think it would be something like this:

print l($node-&gt;title, 'node/' . $node-&gt;nid);


But I'm not using PHP, I need to use SQL only because the report module I'm using requires it.
It's in url_alias table, you'll need concatenate it with your domain name.

SELECT `alias`  FROM `url_alias` WHERE source = "node/XXX";


Note: if you have more than one alias it will return multiple results.