SELECT hold.*
FROM
[dbo].[wcm_holder] hold
join
[wcm_fields_description] holddetails
on hold.id=holddetails.treeno_id
where
hold.ManagemntID in ( select distinct ManagemntID from [dbo].[wcm_holder] h join [dbo].[Allowed Access] a on h.ParentID=a.allowedTo where privilageID=10 )
and holddetails.fielddescription like '%Apple%'