USE commonswiki_p;

select concat("Template:",page_title) as pagename, rev_user_text as username

from page 

join templatelinks on page_id = tl_from  and tl_namespace = 10  AND tl_title="License_template_tag"

join revision on page_id = rev_page and rev_parent_id = 0

where page_title not like "%/%"  -- no subtemplates

AND page_namespace = 10 

AND not exists (

    select * from templatelinks t1  where page_title = t1.tl_title and t1.tl_namespace = 10 

    limit 1 

  )