paip2/sql/s4.sql
2025-09-11 09:29:08 +00:00

2 lines
137 B
SQL

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'