SELECT lt_id AS 'Template ID',  lt_title AS 'Template Name', cl_to AS 'Template Category'

FROM templatelinks

JOIN linktarget ON lt_id = tl_target_id

JOIN page ON page_namespace = lt_namespace AND page_title = lt_title

JOIN categorylinks ON cl_from = page_id

WHERE tl_from = page_id

    AND page_namespace = 10

    # AND cl_to = 'Templates_that_generate_short_descriptions'

    AND lt_title LIKE "%description%"

LIMIT 200