If I run the following query on the WordPress database, I get a list of templates:
select distinct(meta_value) from wp_postmeta where meta_key='_wp_page_template';
The templates that come back are things like
my-template.php. With the exception of
default which I assume is a special case, these are clearly relative filenames. The trouble is, I know they're not all relative to the same directory!
So how can I find out where exactly where each template exists in the filing system?