SELECT s.spacekey, s.spacename, p.templatename AS "Template Title", um.username
FROM pagetemplates p
LEFT JOIN spaces s ON p.spaceid = s.spaceid
LEFT JOIN user_mapping um ON p.creator = um.user_key
WHERE p.prevver IS null
AND p.content LIKE '%ac:name="live-template"%'
OR p.content LIKE '%ac:name="text-data"%'
OR p.content LIKE '%ac:name="list-data"%'
OR p.content LIKE '%ac:name="table-data"%'
OR p.content LIKE '%ac:name="user-options"%'
OR p.content LIKE '%ac:name="date-data"%'
OR p.content LIKE '%ac:name="hidden-data"%'
OR p.content LIKE '%ac:name="list-option"%'
OR p.content LIKE '%ac:name="repeating-data"%'
OR p.content LIKE '%ac:name="number-data"%'
OR p.content LIKE '%ac:name="content-options"%'
OR p.content LIKE '%ac:name="get-data"%'
OR p.content LIKE '%ac:name="excerpt-data"%'
OR p.content LIKE '%ac:name="eval-data"%'
OR p.content LIKE '%ac:name="set-data"%'
OR p.content LIKE '%ac:name="attachment-options"%'
OR p.content LIKE '%ac:name="label-options"%'
OR p.content LIKE '%ac:name="group-data"%'
ORDER BY s.spacekey, p.templatename; |