select content_type from cr_items i, cr_revisions r
where r.item_id = i.item_id
and r.revision_id = :revision_id
$attribute_name
select $what from ${table_name}x where revision_id = :revision_id
insert into $last_table (
[join $columns ", "]
) values (
[join $values ", "]
)"
and $extra_where
order by
types.inherit_level desc
insert into $last_table (
[join $columns ", "]
) values (
[join $values ", "]
)"
select object_type content_type, table_name
from acs_object_types
where object_type = (select content_type from cr_items
where item_id = :item_id)
update cr_revisions
set mime_type = :mime_type
where revision_id = :revision_id
select
label, map.mime_type as value
from
cr_mime_types types, cr_content_mime_type_map map
where
types.mime_type = map.mime_type
and
map.content_type = :content_type
and
lower(types.mime_type) like ('text/%')
order by
label
select content_type from cr_items
where item_id = :parent_id
$param(value)
select
[join $columns ","]
from
cm_attribute_widget_param_ext x
where
object_type in ( [join $in_list ","] )
select
[join $columns ","]
from
cm_attribute_widget_param_ext
where
object_type = :content_type
and
attribute_name = :attribute_name
select
[join $columns ", "]
from
[get_type_info $content_type table_name]x
where
revision_id = :revision_id
select count(*) from cr_content_mime_type_map
where content_type = :content_type and mime_type like 'text/%'
select
$ref
from
acs_object_types
where
object_type = :object_type
select
[join $args ","]
from
acs_object_types
where
object_type = :object_type