SELECT t.title, t.author, e.id AS element_id, e.name FROM templates t JOIN elements e ON t.id = e.template_id WHERE t.title = 'Template'
