sql script I use for finding in newest published content...

select b.Id as PropertyDataId, c.path ,
contentNodeId, d.Name, d.Id as PropertyTypeId, c.text as DocumentName, dataNvarchar, dataNtext

--into #temp

from


        cmsDocument AS a       
        INNER JOIN cmsPropertyData AS b ON a.nodeId = b.contentNodeId and a.newest = 1  and a.versionId = b.versionId
        INNER JOIN umbracoNode as c on a.nodeId = c.id
        INNER JOIN cmsPropertyType as  d on b.propertytypeid = d.id 
WHERE
        --n.path LIKE ('-1,%' + @rootNodeId + '%')
        --d.Id = 37
        --AND
        --(
        --       b.dataNvarchar LIKE ('%' + 'XXX' + '%')
        --        OR
        --        b.dataNtext LIKE ('%' + 'XXX' + '%')
        --)  
        --AND
        (
        trashed <> '1'
        )      
;

I've dropped the Where, so you should get all the published content that you had

is working on a reply...