SELECT
                        count( DISTINCT ezcontentobject_tree.node_id ) as count
                  FROM
                       ezcontentobject_tree,
                       ezcontentobject,ezcontentclass
                       , ezcontentobject_name

                       , ezcobj_state_link ezcobj_state_link_ez_lock_perm
, ezcobj_state_group ezcobj_state_group_ez_lock_perm
, ezcobj_state ezcobj_state_ez_lock_perm

                  WHERE  ezcontentobject_tree.path_string like
'/1/2/195/255/395/%' and

                        ezcontentclass.version=0 AND
                        ezcontentobject_tree.node_id != 395 AND
                        ezcontentobject_tree.contentobject_id =
ezcontentobject.id  AND
                        ezcontentclass.id = ezcontentobject.contentclass_id AND
                         ezcontentobject_tree.contentobject_id =
ezcontentobject_name.contentobject_id and

ezcontentobject_tree.contentobject_version =
ezcontentobject_name.content_version and
 ( bitand( ezcontentobject_name.language_id,
ezcontentobject.language_mask ) > 0 AND
 bitand( ezcontentobject.language_mask - bitand(
ezcontentobject.language_mask, ezcontentobject_name.language_id ), 1 )
   + bitand( ezcontentobject.language_mask - bitand(
ezcontentobject.language_mask, ezcontentobject_name.language_id ), 2 )
  <
   bitand( ezcontentobject_name.language_id, 1 )
   + bitand( ezcontentobject_name.language_id, 2 ) )

                        AND
ezcobj_state_link_ez_lock_perm.contentobject_id = ezcontentobject.id
AND ezcobj_state_ez_lock_perm.id =
ezcobj_state_link_ez_lock_perm.contentobject_state_id
AND ezcobj_state_ez_lock_perm.group_id = ezcobj_state_group_ez_lock_perm.id
AND ezcobj_state_group_ez_lock_perm.identifier='ez_lock'

 AND ((ezcobj_state_ez_lock_perm.id = 1))

                         AND
 bitand( ezcontentobject.language_mask, 3 ) > 0