paip2/sql/s4.sql

2 lines
137 B
MySQL
Raw Permalink Normal View History

2025-09-11 09:29:08 +00:00
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'