I am using this code, posted here to lookup the last-edited-by user. And am trying to modify the code to return {author} when it has not been edited by anyone since it was posted.
{exp:query sql="SELECT exp_entry_versioning.entry_id, exp_entry_versioning.author_id, exp_entry_versioning.version_date, exp_members.screen_name
AS last_edit_by FROM exp_entry_versioning
INNER JOIN exp_members
ON exp_entry_versioning.author_id = exp_members.member_id
WHERE exp_entry_versioning.entry_id = {entry_id}
ORDER BY exp_entry_versioning.version_date DESC
LIMIT 1"}
{last_edit_by}
{if no_results}{author}{/if}{/exp:query}But instead of returning {author} it does not return anything.