select
name,
description,
exportable_p,
datasource_id,
template_id,
config_id,
default_config_id
from portal_elements
where element_id = :element_id
select
datasource_id,
data_type,
mime_type,
name,
description,
package_key
from portal_datasources
order by name
select template_id,name,description,filename,resource_dir
from portal_templates
where type = 'theme'
order by name