Find pages using a template

count-number-of-pages.sql

SELECT
	COUNT(*) as total
FROM
	wp_posts as p
	JOIN wp_postmeta as m ON p.ID = m.post_id
WHERE
	p.`post_type` = 'page'
	AND p.`post_status` = 'publish'
	AND m.`meta_key` = '_wp_page_template'
	AND m.`meta_value` = 'page-your-template-name.php'