select count(generatedAlias0) from ci as generatedAlias0 where exists (select generatedAlias1 from property as generatedAlias1 where ( generatedAlias0.id=generatedAlias1.ciId ) and ( generatedAlias1.className=:param0 ) and ( generatedAlias1.name=:param1 ) and ( generatedAlias1.value like :param2 ))

select count(cientity0_.ci_id) as col_0_0_ from ci cientity0_ where exists (select (ciproperty1_.ci_id, ciproperty1_.class_name, ciproperty1_.name) from property ciproperty1_ where cientity0_.ci_id=ciproperty1_.ci_id and ciproperty1_.class_name=? and ciproperty1_.name=? and (ciproperty1_.value like ?))